[MXS-307] Add multi-source replication support in MaxScale Created: 2015-08-12  Updated: 2017-12-01  Resolved: 2016-10-10

Status: Closed
Project: MariaDB MaxScale
Component/s: binlogrouter
Affects Version/s: None
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: Dipti Joshi (Inactive) Assignee: Massimiliano Pinto (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2016-15

 Description   

Add support for multi-source replication in Binlog Server

(1) Binlog Server should be able to replicate from multiple masters
Support CHANGE MASTER syntax for registering with multiple masters
CHANGE MASTER 'master-name' MASTER_HOST = 'master_host_ip', MASTER_USER = 'master_replication_user', MASTER_PASSWORD = 'password', MASTER_PORT = 3306;

(2) Binlog Server should be able to re-write the schema name
Support the same behavior as --replicate-rewrite-db option in MariaDB/MySQL slave

See example how it is done in a MariaDB/MySQL slave https://mariadb.com/blog/multisource-replication-how-resolve-schema-name-conflicts

 Comments   
Comment by Massimiliano Pinto (Inactive) [ 2016-08-03 ]

dshjoshi

Where will the events from from multiple backends be saved?

Binlog server design is to provide exact replica of the master binlog files.

Some questions:

1) There will be different binlog files, stored in different direcories, based on CHANGE MASTER 'master-name'
2) if not how the events would be stored, in one binlogfile only?
3) How the slave servers would replicate from binlog server?
4) Which binlog file will they ask if there are different ones?

Is this a proper use case for a replication proxy? Maybe not.

Right now it's possible to configure N binlog services, even without listeners and get separate binlog events from separate servers.

The mentioned "re-write the schema name" applies to SQL thread in the salve which cannot apply in binlog server where there is no SQL handling

A detailed document with proper uses cases is needed before any estimate.

This blog post is also important:

http://blog.booking.com/better_parallel_replication_for_mysql.html

It describes parallel replication and binlog servers

Generated at Thu Feb 08 03:58:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.