For dynamic websites like Auction sites. Whats the best thing to do for the back-end? I see "packeged" turnkey websites being sold in MySQL.
The problem is, i have a large marketing budget, for offline and online marketing. If user traffic increases so fast, will MySQL be able to handle it? Ive Seen the licensed version of MySQL, which is called MySQL Clustering. Is this any good for this?
Problem is, oracle standard edition costs about £10,000. This is way over budget for a start up website. I mean we can get it, but what if things go wrong?
I just dont know where to start. I have heard contradicting things. Some peopel said MySQL, if organised very well, can show performance like Oracle!!!! (As far as transactions per second is concerned).
If i go with MySQL, what range of users can it support without slowing down anything?
2006-12-06 11:28:34 · 6 answers · asked by WPReviews 2 in Computers & Internet ➔ Software
The reliability and recoverability are with Oracle. If you can afford to loose transactions, by all means, go with MySql. But be aware, the large sites using it are using it for relatively static presentation data - not transactional data.
2006-12-07 16:46:14 · answer #1 · answered by oohhbother 7 · 0⤊ 1⤋
mySQL should be perfectly adequate for most purposes. A properly tuned mySQL server can handle huge databases and large numbers of queries with no problem -- plus, as you pointed out, it's much cheaper than Oracle! Many high-traffic websites use mySQL quite happily.
O'Reilly publishes a good book called High Performance MySQL that gives some useful tips on how to squeeze the most out of your database server.
2006-12-06 19:32:28 · answer #2 · answered by MarnenLK 6 · 0⤊ 0⤋
Oracle is used for large mainframes by big organisations. Generally, it's overkill for a webpage.
If you are planning on hosting your own webserver, go the freeware way with a Linux + Apache + PHP + MySQL.
Do njot worry about having too big a DB, MySQL is designed for huge databses aswell. If you ever get to the point where MySQL cannot handle your business, you will have enough resources to switch to Oracle.
2006-12-06 19:35:24 · answer #3 · answered by Tim 6 · 1⤊ 0⤋
MySQL has certainly been deployed for large sites, and has been proven to scale well. The downside is that it lacks in some of the security and other features of oracle. For example, with the (faster) MyISAM storage engine you don't get transactions, referential integrity constrains (foreign key, ON DELETE xxxx, etc). If you don't need a fully relational database, or don't mind using InnoDB, you might consider it.
Also look in to PostgreSQL. Check out this review of the three:
http://www.suite101.com/article.cfm/oracle/115560
2006-12-06 19:38:33 · answer #4 · answered by tvh2k 2 · 0⤊ 0⤋
Lots of huge sites use MySQL including Yahoo and Google, I think its more than adequate for anything you could ever possibly throw at it.
2006-12-06 19:35:20 · answer #5 · answered by Christopher J 4 · 1⤊ 0⤋
mysql can handle numerous connections ; its all dependent on your hosting service and plan.
2006-12-06 19:33:07 · answer #6 · answered by arus.geo 7 · 1⤊ 0⤋