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

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