Re: [Linux-ha-dev] [PATCH] add the new parameter for replication network in mysql RA

2011-11-21 Thread Junko IKEDA
Hi Raoul, Thank you for your comments! this method should leave the slave be if the master did not change since the last sync. consider:   crm node standby node02; crm node online node02 the slave should pick up where it left using mysql's own way of saving the last replication information

Re: [Linux-ha-dev] [PATCH] add the new parameter for replication network in mysql RA

2011-11-18 Thread Raoul Bhatia [IPAX]
hello junko-san! i think might spotted an error in your patch. please correct me if i'm wrong! consider this code using * node01 = master * node02 = slave * replication_hostname_suffix = -mysqlrep set_master() { local new_master_host master_log_file master_log_pos local

Re: [Linux-ha-dev] [PATCH] add the new parameter for replication network in mysql RA

2011-11-15 Thread Raoul Bhatia [IPAX]
hello junko-san! On 2011-11-15 03:31, Junko IKEDA wrote: Hi Raoul, Sure, thanks! i committed our combined changes to my repository: https://github.com/raoulbhatia/resource-agents/commits/mysql i'll test them and will then issue a pull request. thank you for your contribution! raoul --

Re: [Linux-ha-dev] [PATCH] add the new parameter for replication network in mysql RA

2011-11-14 Thread Junko IKEDA
Hi, sorry, agein. My previous patch was wrong. I attached the new one. Thanks, Junko 2011/11/11 Junko IKEDA tsukishima...@gmail.com: Hi, The current mysql RA, it set hostname (= uname -n) as its replication network, but I have the following restriction. # uname -n node01 # cat

Re: [Linux-ha-dev] [PATCH] add the new parameter for replication network in mysql RA

2011-11-14 Thread Raoul Bhatia [IPAX]
hello junko-san! On 2011-11-14 11:00, Junko IKEDA wrote: diff --git a/heartbeat/mysql b/heartbeat/mysql index eb14ac8..56a7b17 100755 --- a/heartbeat/mysql +++ b/heartbeat/mysql ... @@ -281,6 +283,30 @@ The port on which the Master MySQL instance is listening. content type=string

Re: [Linux-ha-dev] [PATCH] add the new parameter for replication network in mysql RA

2011-11-14 Thread Raoul Bhatia [IPAX]
hello junko-san! i propose the following documentation update to clarify the parameter's usage. parameter name=replication_hostname_suffix unique=0 required=0 longdesc lang=en A hostname suffix that will be added when setting the MySQL replication master. This enables the use of a seperate

Re: [Linux-ha-dev] [PATCH] add the new parameter for replication network in mysql RA

2011-11-14 Thread Junko IKEDA
Hi Raoul, Sure, thanks! Regards, Junko 2011/11/14 Raoul Bhatia [IPAX] r.bha...@ipax.at: hello junko-san! i propose the following documentation update to clarify the parameter's usage. parameter name=replication_hostname_suffix unique=0 required=0 longdesc lang=en A hostname suffix that

[Linux-ha-dev] [PATCH] add the new parameter for replication network in mysql RA

2011-11-11 Thread Junko IKEDA
Hi, The current mysql RA, it set hostname (= uname -n) as its replication network, but I have the following restriction. # uname -n node01 # cat /etc/hosts 192.168.100.101 node01 # maintenance LAN for node01 192.168.100.101 node02 # maintenance LAN for node02 192.168.200.101 # replication LAN