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!
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
MySQL Cluster is a good choice as well (different than normal MySQL): http://www.mysql.com/products/database/cluster/
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
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.
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
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!