Am I right in seeing that if you can split reads and writes without the application having to be replication-aware, one does not need multiple masters? One can simply have standard MySQL replication, yes?
For us, we only were interested in multiple masters so that we could read or write from any of the available MySQL nodes. W. On 4/3/2012 3:04 AM, Ian wrote: > On 03/04/2012 00:47, Wes Modes wrote: >> Thanks again for sharing your knowledge. I do believe the answers I've >> receiving, but since I have requirements that I cannot easily alter, I'm >> also gently pushing my expert advisers here to look beyond their own >> preferences and direct experience. >> >> RE: Shared storage. I can easily let go of the preference to take >> advantage of shared storage. I understand duplicated databases are the >> essence of database redundancy. You make good points. >> >> In terms of the acceptability of a small fraction of users being >> temporarily unable to access services: rather than sharding, which >> again requires more control over the application than we have, I was >> more envisioning that would be the fraction of users who hit the one >> peer MySQL server that is temporarily unavailable due to h/w or s/w >> failure or DB corruption while its fail over is powered up. >> >> Does MySQL cluster seem like it will address my requirements to allow us >> to horizontally scale a number of MySQL nodes as peers without >> separating reads and writes, or slaves and masters. >> >> Wes > Hi Wes, > > If you can't alter the application to split reads and writes, why not > let MySQL Proxy to do it for you? > > http://forge.mysql.com/wiki/MySQL_Proxy > > Combine this with haproxy and you could build a multi-master environment > with each master having any number of slaves. Set MySQL Proxy to send > writes to the masters and reads to the slaves. > > Regards > > Ian -- Wes Modes Systems Designer, Developer, and Administrator University Library ITS University of California, Santa Cruz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
