List:General Discussion« Previous MessageNext Message »
From:Wes Modes Date:April 4 2012 12:11am
Subject:Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion
Wanted
View as plain text  
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

-- 
Wes Modes
Systems Designer, Developer, and Administrator
University Library ITS
University of California, Santa Cruz


Thread
HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWantedWes Modes30 Mar
  • Re: HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWantedRick James30 Mar
  • Re: HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWantedKaren Abgarian30 Mar
  • Re: HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWantedshawn green30 Mar
    • Re: HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWantedWes Modes2 Apr
      • Re: HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWantedRick James2 Apr
      • Re: HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWantedshawn green2 Apr
        • Re: HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWantedWes Modes2 Apr
          • Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion WantedTim Dunphy3 Apr
          • Re: HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWantedIan3 Apr
            • Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion WantedJohan De Meersman3 Apr
            • Re: HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWantedWes Modes3 Apr
            • Re: HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWantedWes Modes4 Apr
        • Re: Replication rings/maatkit (was: HA & Scalability w MySQL + SAN+ VMWare)Wes Modes3 Apr
          • Re: Replication rings/maatkit (was: HA & Scalability w MySQL + SAN + VMWare)Eric Bergen3 Apr
Re: HA & Scalability w MySQL + SAN + VMWare: Architecture SuggestionWantedWes Modes4 Apr