Date: Wed, 10 Oct 2012 13:30:42 -0700 (PDT)
From: Ilias Bertsimas <award...@gmail.com>
To: codership-team@googlegroups.com
Message-Id: <be80f3a8-67fc-45ba-974f-853df2ce79de@googlegroups.com>
Subject: Galera and proper checking of status from load balancer.
MIME-Version: 1.0
Content-Type: multipart/mixed; 
	boundary="----=_Part_20_27968477.1349901042643"

------=_Part_20_27968477.1349901042643
Content-Type: multipart/alternative; 
	boundary="----=_Part_21_2164461.1349901042644"

------=_Part_21_2164461.1349901042644
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hello,

I am trying to figure out when a galera node is able to serve requests so 
the load balancer can direct traffic to it.
Right now I am using a check to get the galera status number and if it is 4 
(SYNCED) I consider it able to serve requests.
The issue I am having is when I run the daily backup using xtrabackup. In 
the last 5 mins of the backup when everything gets locked and the 
transaction log is streamed it seems the other nodes do not serve requests 
either although there is nothing logged about it and if they are affected 
by locked node.

Kind Regards,
Ilias.

------=_Part_21_2164461.1349901042644
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<font face="verdana, sans-serif">Hello,</font><div><font face="verdana, sans-serif"><br></font></div><div><font face="verdana, sans-serif">I am trying to figure out when a galera node is able to serve requests so the load balancer can direct traffic to it.</font></div><div><font face="verdana, sans-serif">Right now I am using a check to get the galera status number and if it is 4 (SYNCED) I consider it able to serve requests.</font></div><div><font face="verdana, sans-serif">The issue I am having is when I run the daily backup using xtrabackup. In the last 5 mins of the backup when everything gets locked and the transaction log is streamed it seems the other nodes do not serve requests either&nbsp;although&nbsp;there is nothing logged about it and if they are affected by locked node.</font></div><div><font face="verdana, sans-serif"><br></font></div><div><font face="verdana, sans-serif">Kind Regards,</font></div><div><font face="verdana, sans-serif">Ilias.</font></div>
------=_Part_21_2164461.1349901042644--

------=_Part_20_27968477.1349901042643--