Galera on Mysql 5.6

[Jonathan Vallar]

We would like to inquire if Galera has multiple-master (multiple source host) to slave replication on hosts using Mysql 5.6 community edition. If yes, we would like to know the following:

1) How does the technology work? 

2) What is the licensing model?

3) What is the migration procedure if we have Mysql 5.6 (community edition) installed in the masters and the slave databases?

I am ready for a conference call next week if needed. Please advise when is your preferred schedule. Please be advised I am on GMT+8 timezone. 

[alexey.y...@galeracluster.com]

On 2015-10-06 18:49, Jonathan Vallar wrote:
> We would like to inquire if Galera has multiple-master (multiple source
> host) to slave replication on hosts using Mysql 5.6 community edition.

Galera cluster

1) is a SYNCHRONOUS replication system

2) every node is fully representative of the cluster, that is, it
carries all the data.

Every node in the cluster CAN be a master (source of updates), but every
node IS a slave. While this technically covers the problem as you
stated, chances are this is not what you want.

> If yes, we would like to know the following:
>
> 1) How does the technology work?

Using group communication and total ordering of replicated messages. For
more details, please see the documentation.

> 2) What is the licensing model?

GPLv2

> 3) What is the migration procedure if we have Mysql 5.6 (community
> edition)
> installed in the masters and the slave databases?

In short:

- you disconnect and create Galera cluster out of your slaves
- you make one of the cluster nodes a slave to the master
- when the cluster catches up with the master, you reidrect the load to
the cluster
- convert the master to Galera node and join the rest

Regards,
Alex

[Jonathan Vallar]

Hi,

Thanks for the feedback,

Can we have a conference call to discuss my inquiries?

Regards,

Jonathan

--

Regards,

 

jonathan

vallar

Technical Manager | Technical Management

+63 917 889 9932 | Google Maps