Re: [Pacemaker] Adding VIP support for the MySQL RA

2011-11-12 Thread Michael Marrotte
An N+1 or N+X topology might be good for that cascading scenario... Find a sweet spot for the evict date. If slave are lagging too much, scale and tune. I haven't read Yves' patch, but I'll check it out. I just saw that he was looking for slave to work with VIP and suggested a couple ways I've

Re: [Pacemaker] Adding VIP support for the MySQL RA

2011-11-12 Thread Michael Marrotte
; installations where the current behavior is not adequate. I consider myself > more as a database specialist than an HA one so I may be more sensitive to > these problems. > > Regards, > > Yves > > On 11-11-12 09:19 AM, Michael Marrotte wrote: >> >> Are yo

Re: [Pacemaker] Adding VIP support for the MySQL RA

2011-11-12 Thread Michael Marrotte
slave lags behind too much, I want to > remove the vip but not stop the slave. > > On 11-11-11 06:12 PM, Michael Marrotte wrote: > > Why don't you simply colocate VIP's with the master/slave roles? > > On Fri, Nov 11, 2011 at 5:18 PM, Yves Trudeau wrote: > >> H

Re: [Pacemaker] Adding VIP support for the MySQL RA

2011-11-11 Thread Michael Marrotte
Why don't you simply colocate VIP's with the master/slave roles? On Fri, Nov 11, 2011 at 5:18 PM, Yves Trudeau wrote: > Hi, > I created a fork of the resource-agents and modified the mysql RA to > supports VIP. The support for read/write VIPs is something that currently > limits the use of pac

Re: [Pacemaker] Circular replication help needed - how to make sure VIP runs on same node with a healthy mysql

2011-11-06 Thread Michael Marrotte
The current MySQL RA supports master/slaves which is great. It would be nice if it supported multiple masters. If I have some free cycles, I'll look into adding it. I think lots of folks probably use DRBD b/c there's no RA alternative and they have some experience with it. When standing up a ne

Re: [Pacemaker] Circular replication help needed - how to make sure VIP runs on same node with a healthy mysql

2011-11-06 Thread Michael Marrotte
Attila: Hope this helps: primitive p_mysql ocf:heartbeat:mysql \ params binary="/usr/sbin/mysqld" config="/etc/mysql/my.cnf" \ replication_user="xxx" replication_passwd="xxx" \ test_passwd="password" pid="/var/run/mysqld/mysqld.pid" \ socket="/var/run/m

Re: [Pacemaker] can pacemaker do mysql Master/Slave.

2011-10-31 Thread Michael Marrotte
Joe: Yes. There is now support for replication (master/slave): - See if the installed MySQL RA (Resource Agent) includes support for replication (your paths might be different) grep -i 'replication capability' /usr/lib/ocf/resource.d/heartbeat/mysql #Marian Marinov, Flor

Re: [Pacemaker] Master/Master Setup

2011-10-22 Thread Michael Marrotte
aster/slave. Thanks for your help. ~Mike. On Sat, Oct 22, 2011 at 3:34 PM, Raoul Bhatia [IPAX] wrote: > hi! > > > On 22.10.2011 20:33, Michael Marrotte wrote: > >> primitive p_mysql ocf:heartbeat:mysql \ >> params binary="/usr/sbin/mysqld" config=&q

Re: [Pacemaker] Master/Master Setup

2011-10-22 Thread Michael Marrotte
] Event Scheduler: Loaded 0 events 111022 13:11:29 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.49-1ubuntu8.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) On Sat, Oct 22, 2011 at 3:34 PM, Raoul Bhatia [IPAX] wrote: > hi! > > > O

[Pacemaker] Master/Master Setup

2011-10-22 Thread Michael Marrotte
I have a 2-node MySQL master/slave to master/slave setup and am looking to add a MySQL "health" check that can take a node out of the cluster if its slave is unhealthy, e.g. out of sync. The master/slave master/slave config is working fine, hence writes in either node are replicated to the other n

Re: [Pacemaker] Upgrading the MySQL RA

2011-10-22 Thread Michael Marrotte
:. ${OCF_FUNCTIONS_DIR}/.ocf-shellfuncs I reverted the pathnames and no more error :) Thanks for the quick tip! ~Mike On Sat, Oct 22, 2011 at 6:41 AM, Raoul Bhatia [IPAX] wrote: > On 22.10.2011 12:35, Michael Marrotte wrote: > >> What's the correct way to upgrade an RA script, in particular

[Pacemaker] Upgrading the MySQL RA

2011-10-22 Thread Michael Marrotte
What's the correct way to upgrade an RA script, in particular, the MySQL RA? I've tried replacing /usr/lib/ocf/resource.d/heartbeat/mysql (and chmod +x) with the latest version found at github, but then get the following: lrmadmin[1470]: 2011/10/22_03:08:37 ERROR: lrm_get_rsc_type_metadata(578):