Thanks, Ian. W.
On 4/4/2012 4:02 AM, Ian wrote: > On 04/04/2012 01:11, Wes Modes wrote: >> 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 >> Ian, what is the best place to ask specific questions about mysql-proxy? >> >> In general, here are my questions: >> >> 1. Does the proxy sit on a separate server and route all MySQL >> requests, or is it installed on each of the MySQL nodes and >> re-shuffle MySQL requests to the appropriate place? >> >> 2. Can multiple proxies be run in concert to provide redundancy and >> scalability as well as eliminate SPoF and bottlenecks? >> >> 3. In 2007 when RW Splitting was new, there were a few problems and >> limitations. What is the current status of development of this >> important feature? >> >> Thanks! >> >> And again I appreciate the brainstorming that many have done here to >> find a solution that fits my requirements. >> >> Wes > Hi Wes, > > I'm afraid I can't help you with your questions as I have never actually > used MySQL Proxy! I was aware of its existence so brought it up in case > it fitted your needs. > > I sympathize with your position and hope you find the answers you need. > > 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
