[Openstack-operators] Openstack and mysql galera with haproxy

Abel Lopez alopgeek at gmail.com
Thu Sep 18 20:47:57 UTC 2014


One big win is that using xtrabackup (or xtrabackup_v2 if you’re on 5.6) is that your tables don’t lock momentarily like they do using rsync.
At my previous shop, we had a replicated keystone db across various sites, so wan segments (gmcast.segment ) became an attractive way to speed replication.

On Sep 18, 2014, at 1:03 PM, Clint Byrum <clint at fewbar.com> wrote:

> Excerpts from Sławek Kapłoński's message of 2014-09-18 12:34:53 -0700:
>> Hello,
>> 
>> Thanks all of You guys for help. I will try to apply that percona's scripts 
>> and configure it in active/pasive mode.
>> About "mysql has gone away" I thought so it is not big problem but it looks 
>> "ugly" in logs 
>> Simon - I think that it is not related strictly to neutron and similar 
>> problems can happend also in nova.
>> 
>> I have one more question to You guys. I know that there is mysql cluster 
>> solution based on galera which is made by percona. Is it really better that 
>> "pure" mysql-wsrep and galera installed or maybe it doesn't matter?
>> 
> 
> One big reason it might be "better" is that Percona is quite good at
> supporting it. It also has direct support for more efficient re-syncing
> by using xtrabackup instead of the rather cumbersome "SST". But I could
> be mistaken, and pure mysql-wsrep might also have that.
> 
> _______________________________________________
> OpenStack-operators mailing list
> OpenStack-operators at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 496 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20140918/cc9bf69d/attachment.pgp>


More information about the OpenStack-operators mailing list