How do I increase IUD Scalability?
Hi all,
So we start with a single MySQL instance. We discover that we have a 3:1 SELECT to Insert/Update/Delete (IUD) ratio. We scale this by adding a slave or 2 and sending all SELECT statements to the slaves. Problem solved.
Now our app has grown to thousands of IUDs/sec. Our single master can no longer sustain go throughput on this. What is the best way to scale the master so that we can do more IUDs?
Master<->Master replication seems like a complex solution (automagically handle failover/reelection of master/resync on restore/etc..)
Would the next logical step be MySQL Cluster?
What is in between single master and Cluster for increasing IUD throughput?
Subject
Views
Written By
Posted
How do I increase IUD Scalability?
3718
July 29, 2008 04:01PM
1843
August 07, 2008 01:19PM
1898
August 07, 2008 01:33PM
1878
August 07, 2008 02:59PM
1994
August 07, 2008 05:56PM
1745
August 07, 2008 06:20PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.