List:General Discussion« Previous MessageNext Message »
From:Prabhat Kumar Date:June 13 2012 9:01pm
Subject:Re: i need advice on redundancy of mysql server.
View as plain text  
Does really Master-Master replication provide load balancing feature?
since, each node need to replicate to other node, and MySQL replication
still a is single threaded replication , it mean there is only single
replication thread  sql_thread for DML queries.

eg.

There is two node with master master replication - Master -1 & Master 2.

  *app1 --read/write* ---> *Master 1 --* single thread*-- Master 2*
---< *read/write
-- app1*

Its just a *high availability* not a load balancing*.*

Thanks,
On Wed, Jun 13, 2012 at 2:33 AM, Johan De Meersman <vegivamp@stripped>wrote:

> ----- Original Message -----
> > From: "Joey L" <mjh2000@stripped>
> >
> > It sounds like you are all consultants.
>
> Hehe. I'm not :-p
>
> A lot are, though, because the combined technical knowledge on this list
> draws in consultants looking for stuff, and having experienced consultants
> on the list in turn heightens the combined technical knowledge again.
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>


-- 
Best Regards,

Prabhat Kumar
MySQL DBA

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

Thread
i need advice on redundancy of mysql server.Joey L11 Jun
  • Re: i need advice on redundancy of mysql server.Ananda Kumar11 Jun
    • Re: i need advice on redundancy of mysql server.Shawn Green11 Jun
      • Re: i need advice on redundancy of mysql server.Joey L11 Jun
        • Re: i need advice on redundancy of mysql server.Shawn Green11 Jun
          • Re: i need advice on redundancy of mysql server.Baron Schwartz11 Jun
            • Re: i need advice on redundancy of mysql server.Andrew Moore11 Jun
              • Re: i need advice on redundancy of mysql server.Baron Schwartz11 Jun
                • Re: i need advice on redundancy of mysql server.Joey L12 Jun
                  • Re: i need advice on redundancy of mysql server.Claudio Nanni12 Jun
                  • Re: i need advice on redundancy of mysql server.Johan De Meersman13 Jun
                    • Re: i need advice on redundancy of mysql server.Prabhat Kumar13 Jun
    • Re: i need advice on redundancy of mysql server.Joey L11 Jun
      • Re: i need advice on redundancy of mysql server.Andrew Moore11 Jun
        • Re: i need advice on redundancy of mysql server.Joey L11 Jun
  • RE: i need advice on redundancy of mysql server.Rick James13 Jun
    • Re: i need advice on redundancy of mysql server.Joey L14 Jun