1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Best Database for High-Traffic Site - MySQL? Oracle? Uptime/Speed is Important

Discussion in 'MySQL' started by Nathan Malone, Apr 13, 2006.

0
  1. #1
    The title pretty much says it.

    Basically, do you all think that MySQL will work for a high traffic site where uptime, speed, and reliability are extremely important? Do you think that Oracle would be a better choice? Some other database?

    Thanks!
     
    Nathan Malone, Apr 13, 2006 IP
  2. sacx13

    sacx13 Active Member

    Messages:
    438
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    58
    #2
    Oracle is the best on high traffic and uptime ... I have a Oracle database runnig for 2 years (Oracle 9.2.10)

    Medium applications - Mysql / Postgresql / MSSQL
    Enterprise applications - Oracle and probably others

    My 2 cents

    Regards
     
    sacx13, Apr 14, 2006 IP
  3. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,333
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #3
    digitalpoint, Apr 14, 2006 IP
  4. sacx13

    sacx13 Active Member

    Messages:
    438
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    58
    #4
    Only after 2 months I see this post and I can't stop without to say something :)

    I also use mysql cluster and is doing a very good job. It have only 1 big problem: you need to have a lot of RAM. Anyway I don't know if they fixed that right now but for me was a pain in the ass. My database now is have more than 18G Data and 10 G the index file. :)

    Regards
     
    sacx13, Sep 12, 2006 IP
  5. rps111

    rps111 Peon

    Messages:
    71
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    MySQ?L is free and well integrated with PHP....Postgres has a reputation of being slow but slight configuration can increase the speed much above the mysql.....oracle is paid but is the industry gold standard for years.

    Problems: MySQL DBs corrupt frequently when size of DB reaches above a few GBs. MS SQL and Oracle are paid. Postgres requires configuration for faster querying.
     
    rps111, Jul 30, 2007 IP
  6. sacx13

    sacx13 Active Member

    Messages:
    438
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    58
    #6
    Some years passed away from when this thread was started ... Some things have been changed:

    1. Mysql support cluster "storage" on disk (in past it supported only in RAM and you need to have RAM=1.1*Database size)
    2. Ingres is another good solution and support foreign keys and is ACID compliant and is supporting cluster in the same time

    Regards
     
    sacx13, Mar 4, 2009 IP
  7. mg1313

    mg1313 Peon

    Messages:
    532
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Let's not forget SQL Server from Microsoft...
     
    mg1313, Mar 8, 2009 IP
  8. nikolasgr

    nikolasgr Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    i never tried the ms. and the oracle just seemed to be too heavy for my teachers server.

    the ones i use now are postgre and mysql. postgre impressed me but when it comes to high traffic, my vote goes to mysql!
     
    nikolasgr, Mar 8, 2009 IP
  9. staseo

    staseo Greenhorn

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #9
    What about xml, SQlite or flat (php) databases?
     
    staseo, Nov 19, 2010 IP