Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-14 Thread Dan Frincu
Hi, I am pretty sure Linbit announced mysql RA with replication capabilities. Haven't seen documentation though. # crm ra meta mysql|grep ^replica replication_user (string): MySQL replication user replication_passwd (string): MySQL replication user password replication_port (string, [3306]):

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-14 Thread Ruzsinszky Attila
So I guess there are 2 ways for a MS setup with MySQL. OK. And where is a cookbook for setting up M-S config? Why not M-M? I tried to install MySQL Workbench for SLES11 SP1. There are some broken dependencies. :-( Instead of that fact workbench started. (complained about missin SSH tunnel) I

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-14 Thread Dan Frincu
So I guess there are 2 ways for a MS setup with MySQL. OK. And where is a cookbook for setting up M-S config? Have you even read that PDF, it documents just that, a MS setup with MySQL ... Why not M-M? You have an obsession, you should see a doctor about that. -- Dan FRINCU

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-14 Thread Ruzsinszky Attila
Have you even read that PDF, it documents just that, a MS setup with MySQL I've read many-many pdfs; htmls; readmes etc. without a real working config. Anyway, which PDF do you mention? Why not M-M? You have an obsession, you should see a doctor about that. It is not my theory. I got this

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-14 Thread Dan Frincu
Ruzsinszky Attila wrote: That's what I said - I didn't see it either. but if you you check the current RA: What do you think about this: http://www.lathiat.net/files/MySQL%20-%20DRBD%20%20Pacemaker.pdf I can't see if this is a real M-M or M-S setup. It's a Master-Slave setup. This is

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-13 Thread Ruzsinszky Attila
That's what I said - I didn't see it either. but if you you check the current RA: What do you think about this: http://www.lathiat.net/files/MySQL%20-%20DRBD%20%20Pacemaker.pdf I can't see if this is a real M-M or M-S setup. TIA, Ruzsi ___ Pacemaker

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Dan Frincu
Hi, Ruzsinszky Attila wrote: You're not making sense, first you say MySQL Master-Master, then you mention master mysqld on clusterB and slave mysqld on clusterA. So, which one is it: Yes, it is true. If I stop openais and I start mysql without openais the config is M-M (or Multi-Master).

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Ruzsinszky Attila
Hi, A MySQL Multi-Master architecture for a 2 node setup brings a lot of configuration and administration overhead and has no conflict detection or resolution. Integrating such a setup with Pacemaker only adds to the Yes, I found it. The real story: I want to learn clustering with a 2 node

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Dan Frincu
Hi, Ruzsinszky Attila wrote: Hi, A MySQL Multi-Master architecture for a 2 node setup brings a lot of configuration and administration overhead and has no conflict detection or resolution. Integrating such a setup with Pacemaker only adds to the Yes, I found it. The real story: I

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Ruzsinszky Attila
Hi, And now (officially) RHCS can also use Pacemaker http://theclusterguy.clusterlabs.org/post/1551292286 Nice. Yeah, like I said, Master-Master and Pacemaker without a proper resource agent will cause issues. Yes. big problems. Now let me explain this, a 2-node Multi-Master MySQL setup

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Dan Frincu
Hi, Ruzsinszky Attila wrote: Hi, And now (officially) RHCS can also use Pacemaker http://theclusterguy.clusterlabs.org/post/1551292286 Nice. Yeah, like I said, Master-Master and Pacemaker without a proper resource agent will cause issues. Yes. big problems. Now let me

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Ruzsinszky Attila
The mysql RA controls a single MySQL instance and the rest of the HA setup is done via DRBD Master-Slave resources. OK. Thank you for your help. Ruzsi ___ Pacemaker mailing list: Pacemaker@oss.clusterlabs.org

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Dennis Jacobfeuerborn
On 11/12/2010 01:50 PM, Dan Frincu wrote: [SNIP] server. Even the LSB script doesn't handle a Multi-Master setup. You'd have to write a custom resource agent, and it would probably fit your setup and your setup alone, meaning it couldn't be widely used for other setups, I know I had to make some

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Ruzsinszky Attila
Isn't a Multi-Master and DRBD a big no-no? It implies that two MySQL In this situation there isn't Multi-Master setup. It is just a normal single instance mysql process which will be switched by DRBD to active node. TIA, Ruzsi ___ Pacemaker mailing

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Vadym Chepkov
On Nov 12, 2010, at 11:14 AM, Ruzsinszky Attila wrote: Hi, And now (officially) RHCS can also use Pacemaker http://theclusterguy.clusterlabs.org/post/1551292286 Nice. Yeah, like I said, Master-Master and Pacemaker without a proper resource agent will cause issues. Yes. big

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Ruzsinszky Attila
I am pretty sure Linbit announced mysql RA with replication capabilities. Haven't seen documentation though. Any URL, or anything? Thanks, Ruzsi ___ Pacemaker mailing list: Pacemaker@oss.clusterlabs.org

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Vadym Chepkov
On Nov 12, 2010, at 1:11 PM, Ruzsinszky Attila wrote: I am pretty sure Linbit announced mysql RA with replication capabilities. Haven't seen documentation though. Any URL, or anything? http://lmgtfy.com/?q=linbit+mysql+replication Thanks, Ruzsi

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Ruzsinszky Attila
http://lmgtfy.com/?q=linbit+mysql+replication OK. I found that webinar. There isn't any printed (readable) doc. :-( TIA, Ruzsi ___ Pacemaker mailing list: Pacemaker@oss.clusterlabs.org http://oss.clusterlabs.org/mailman/listinfo/pacemaker Project

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Vadym Chepkov
On Nov 12, 2010, at 1:22 PM, Ruzsinszky Attila wrote: http://lmgtfy.com/?q=linbit+mysql+replication OK. I found that webinar. There isn't any printed (readable) doc. :-( That's what I said - I didn't see it either. but if you you check the current RA: # crm ra meta mysql|grep ^replica

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-12 Thread Ruzsinszky Attila
That's what I said - I didn't see it either. but if you you check the current RA: OK, sorry. # crm ra meta mysql|grep ^replica replication_user (string): MySQL replication user replication_passwd (string): MySQL replication user password replication_port (string, [3306]): MySQL replication

[Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-10 Thread Attila Ruzsinszky
Hi, Please help me! I want to solve the above task. I'm a beginner in cluster and MySQL. MySQL M-M setup is working. When I start cluster sw (pacemaker+openais) everything seems good. There is a master mysqld on clusterB node and slave mysqld on clusterA. If I connect to the common cluster IP

Re: [Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

2010-11-10 Thread Dan Frincu
Hi, Attila Ruzsinszky wrote: Hi, Please help me! I want to solve the above task. I'm a beginner in cluster and MySQL. MySQL M-M setup is working. When I start cluster sw (pacemaker+openais) everything seems good. There is a master mysqld on clusterB node and slave mysqld on clusterA.