MySQL peformance, capacity and high traffic
Posted on 2006-05-01
We are looking at developing an online business. Like everyone setting up, we would hope it would become large in usage and storage. We are trying to think of the long term of what would be required if this goal was achieved.
I have read database comparisons, and of course these differ depending on who has done them and their familiarity with the databases, so I was really hoping to get some real world experience from people. MySQL is claimed to be only for small to medium size companies in many reviews, however you often hear of companies that have used mySQL for quite large capacity.
I have just started to read about clustering and am wondering how far you could really push mySQL. I believe ver 5 did focus more on Enterprise grade and I would welcome input from people that have really pushed this or know of others who have. We can't aford Oracle and I realise there is a free express one, but this has limitations. It also seems that with Oracle we would always have our hand in our pockets, and I think it is beyond our means to be honest. I know Posgres is another favoured one. I am asking about MySQL because it's free, fast, the one I know, am able to get access to programmers at reasonable rates, but I am concerned that MySQL may not last the distance if the business was successful.
I am thinking there must be many successful web businesses which have started from nothing, and not likely to have been able to afford an Oracle, or do they all move over to Oracle at some point?
For example does anyone know what database Amazon, Ebay, PayPal etc. use? I am interested in high traffic sites, with large storage capacity that still perform well.
I have put 500 points on this, and hope that I will get a few responses and split the points. I hope that is acceptable.