Received: by 10.52.27.164 with SMTP id u4mr396386vdg.8.1352893259076;
        Wed, 14 Nov 2012 03:40:59 -0800 (PST)
X-BeenThere: codership-team@googlegroups.com
Received: by 10.220.219.69 with SMTP id ht5ls284250vcb.7.gmail; Wed, 14 Nov
 2012 03:40:57 -0800 (PST)
Received: by 10.52.19.201 with SMTP id h9mr139174vde.0.1352893257631;
        Wed, 14 Nov 2012 03:40:57 -0800 (PST)
Date: Wed, 14 Nov 2012 03:40:57 -0800 (PST)
From: myeagleflies <thr...@globi.org>
To: codership-team@googlegroups.com
Cc: myeagleflies <thr...@globi.org>, henrik.i...@avoinelama.fi, 
	henrik.i...@avoinelama.fi
Message-Id: <79bc44ba-e622-4078-b032-f10bfe5e05bf@googlegroups.com>
In-Reply-To: <1a1cc9ed-d177-4459-95b7-889983edb801@googlegroups.com>
References: <0b8fedcd-7a07-4bff-939a-5347dc8422fc@googlegroups.com>
 <CAKHykevnECW2rv6Ji90OKq9atAf-bqQmsXTtyXusSGw4g=8-tw@mail.gmail.com>
 <3aac75ec-00be-4951-96c2-e9813fb97b0c@googlegroups.com>
 <1a1cc9ed-d177-4459-95b7-889983edb801@googlegroups.com>
Subject: Re: [codership-team] Is it safe to use Galera with Magento?
MIME-Version: 1.0
Content-Type: multipart/mixed; 
	boundary="----=_Part_646_14938951.1352893257244"

------=_Part_646_14938951.1352893257244
Content-Type: multipart/alternative; 
	boundary="----=_Part_647_24702480.1352893257245"

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

Please take a look http://pastebin.com/e5tZ0YL3

On Wednesday, November 14, 2012 10:50:22 AM UTC, Ilias Bertsimas wrote:
>
> Hi,
>
> That sounds weird, could you please post the results of SHOW STATUS LIKE 
> 'WSREP%'; from both of your nodes ?
>
> Kind Regards,
> Ilias.
>
> On Wednesday, November 14, 2012 10:46:14 AM UTC, myeagleflies wrote:
>>
>> We started testing Galera + Magento 10 days ago. Our setup is: 2 galera 
>> nodes and 2 garbd nodes. One of the galera nodes has virtual IP assigned to 
>> it via pacemaker. This is our cluster IP. Magento webservers communicate 
>> with cluster IP. This way one node is de facto primary and second galera 
>> node is secondary. We do not need to talk with both nodes at same time. 
>> Projected traffic to our website is small. Main purpose for Galera is to 
>> allow for easy failover.
>>
>> I found some issues recently:
>> - I could not run 'USE magento' on one of the nodes. googled for it and 
>> someone suggested rebooting such node. Reboot seems to fix the issue. node 
>> is now properly connected to cluster.
>> - there are differences in data on both nodes. some tables contain more 
>> rows on one node than on another. and there is even one table which is 
>> missing on one of the nodes!
>>
>> Difference in data look scary. Is this typical? What is recommended way 
>> of troubleshooting this issue? Is Magento not fully compatible with Galera? 
>>
>> We do have some tables without primary keys. If DELETE operations were 
>> performed on those tables this could explain differences in data in those 
>> tables. However this does not explain why one table is missing. 
>>
>> I am quite puzzled and looking for an advice.
>>
>> Thanks in advance!
>>
>
------=_Part_647_24702480.1352893257245
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Please take a look http://pastebin.com/e5tZ0YL3<br><br>On Wednesday, Novemb=
er 14, 2012 10:50:22 AM UTC, Ilias Bertsimas wrote:<blockquote class=3D"gma=
il_quote" style=3D"margin: 0;margin-left: 0.8ex;border-left: 1px #ccc solid=
;padding-left: 1ex;"><font face=3D"verdana, sans-serif">Hi,</font><div><fon=
t face=3D"verdana, sans-serif"><br></font></div><div><font face=3D"verdana,=
 sans-serif">That sounds weird, could you please post the results of SHOW S=
TATUS LIKE 'WSREP%'; from both of your nodes ?</font></div><div><font face=
=3D"verdana, sans-serif"><br></font></div><div><font face=3D"verdana, sans-=
serif">Kind Regards,</font></div><div><font face=3D"verdana, sans-serif">Il=
ias.</font></div><div><br>On Wednesday, November 14, 2012 10:46:14 AM UTC, =
myeagleflies wrote:<blockquote class=3D"gmail_quote" style=3D"margin:0;marg=
in-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex">We started testi=
ng Galera + Magento 10 days ago. Our setup is: 2 galera nodes and 2 garbd n=
odes. One of the galera nodes has virtual IP assigned to it via pacemaker. =
This is our cluster IP. Magento webservers communicate with cluster IP. Thi=
s way one node is de facto primary and second galera node is secondary. We =
do not need to talk with both nodes at same time. Projected traffic to our =
website is small. Main purpose for Galera is to allow for easy failover.<br=
><br>I found some issues recently:<br>- I could not run 'USE magento' on on=
e of the nodes. googled for it and someone suggested rebooting such node. R=
eboot seems to fix the issue. node is now properly connected to cluster.<br=
>- there are differences in data on both nodes. some tables contain more ro=
ws on one node than on another. and there is even one table which is missin=
g on one of the nodes!<br><br>Difference in data look scary. Is this typica=
l? What is recommended way of troubleshooting this issue? Is Magento not fu=
lly compatible with Galera? <br><br>We do have some tables without primary =
keys. If DELETE operations were performed on those tables this could explai=
n differences in data in those tables. However this does not explain why on=
e table is missing. <br><br>I am quite puzzled and looking for an advice.<b=
r><br>Thanks in advance!<br></blockquote></div></blockquote>
------=_Part_647_24702480.1352893257245--

------=_Part_646_14938951.1352893257244--