Questions tagged [multi-source-replication]
3 questions
1
vote
1 answer
Does Percona MySQL Server 5.7.23 support multi-source replication?
We want to run multi-source replication.
Server version: 5.7.23-23-log Percona Server (GPL), Release '23', Revision '500fcf5'
mysql> CHANGE MASTER TO MASTER_HOST='1.2.3.4', MASTER_PORT=3306, MASTER_USER='repl', MASTER_PASSWORD='xxx' for…
Gotenks
- 367
- 6
- 14
0
votes
0 answers
Mysql replication with different column definitions on Master and Slave
Suppose that I have below table definitions in Master and Slave :
master> CREATE TABLE t1 (id INT(11) NOT NULL AUTO_INCREMENT,
c1 INT(11) NOT NULL,
c2 INT(11),
PRIMARY KEY (`id`,`c1`)
)ENGINE=InnoDB;
slave> CREATE TABLE t1 (id INT(11) NOT…
Madushan Perera
- 2,568
- 2
- 17
- 36
0
votes
1 answer
Number of masters for particular slave in multi source Replication MySQL?
Mysql has launched a new feature that a single slave server has multiple master server in which replication can be handled with the help of flag called channel for each separate master server.
I want to know:
What's the max number of master a slave…
Aman Aggarwal
- 17,619
- 9
- 53
- 81