Is it safe to use Galera with Magento? - codership

The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Message from discussion Is it safe to use Galera with Magento?
Received-SPF: pass (google.com: best guess record for domain of mik...@mikjaer.com designates 109.202.159.50 as permitted sender) client-ip=109.202.159.50;
Message-ID: <50A37A5B.2070706@mikjaer.com>
Date: Wed, 14 Nov 2012 12:02:51 +0100
From: Mikkel Christensen <mik...@mikjaer.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:16.0) Gecko/20121026 Thunderbird/16.0.2
MIME-Version: 1.0
To: codership-team@googlegroups.com
Subject: Re: [codership-team] Is it safe to use Galera with Magento?
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>
In-Reply-To: <1a1cc9ed-d177-4459-95b7-889983edb801@googlegroups.com>
Content-Type: multipart/alternative;
 boundary="------------000106070403060303080802"

This is a multi-part message in MIME format.
--------------000106070403060303080802
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


>     Difference in data look scary. Is this typical?
>
Are you certain that all your tables are of type InnoDB?
>
>     What is recommended way of troubleshooting this issue? Is Magento
>     not fully compatible with Galera?
>
You need to add pk's to those tables without and generally to make sure 
to live up to the guidelines of Galera, i don't know of anybody who 
successfully ran Magento on Galera, but that doesn't mean it's 
imposible, just that noone (i have heard of) have done it yet, so please 
repport back on your findings :-)

Another good advice is to set up some kind of monitoring to alert you 
when Galera goes out of sync, when that happends you should examine 
logfiles to figure out what wend wrong to avoid it from happending again.

/ Mikkel

--------------000106070403060303080802
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <br>
    <blockquote
      cite="mid:1a1cc9ed-d177-4459-95b7-889983edb801@googlegroups.com"
      type="cite">
      <div>
        <blockquote class="gmail_quote" style="margin: 0;margin-left:
          0.8ex;border-left: 1px #ccc solid;padding-left: 1ex;">Difference
          in data look scary. Is this typical?</blockquote>
      </div>
    </blockquote>
    Are you certain that all your tables are of type InnoDB?<br>
    <blockquote
      cite="mid:1a1cc9ed-d177-4459-95b7-889983edb801@googlegroups.com"
      type="cite">
      <div>
        <blockquote class="gmail_quote" style="margin: 0;margin-left:
          0.8ex;border-left: 1px #ccc solid;padding-left: 1ex;"> What is
          recommended way of troubleshooting this issue? Is Magento not
          fully compatible with Galera? <br>
          <br>
        </blockquote>
      </div>
    </blockquote>
    &nbsp;
    You need to add pk's to those tables without and generally to make
    sure to live up to the guidelines of Galera, i don't know of anybody
    who successfully ran Magento on Galera, but that doesn't mean it's
    imposible, just that noone (i have heard of) have done it yet, so
    please repport back on your findings :-)<br>
    <br>
    Another good advice is to set up some kind of monitoring to alert
    you when Galera goes out of sync, when that happends you should
    examine logfiles to figure out what wend wrong to avoid it from
    happending again.<br>
    <br>
    / Mikkel<br>
  </body>
</html>

--------------000106070403060303080802--
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
Account Options
