[Openstack-operators] Openstack and mysql galera with haproxy
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:
>> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 496 bytes
Desc: Message signed with OpenPGP using GPGMail
More information about the OpenStack-operators