[MDEV-4834] Multi source, can not create multiple domains on the same master Created: 2013-08-01 Updated: 2015-10-30 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | VAROQUI Stephane | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 3 |
| Labels: | replication | ||
| Description |
|
Having a spider proxy to shard data on multiple schema into blackhole tables i now need some slave to read from the same master but using separate schema replicate-do-db. Every slave is replicating a couple of pre shard schema in asynchrone but in all case every slave can serve all the shards . change master 'dshard19' to master_host='192.168.0.30' , master_port=5013, master_user='skysql', master_password='skyvodka', master_log_file='mysql_sandbox5013-bin.000002', master_log_pos=6176; What i don't get is during a prove of concept at a client we did not get this issue and have been able to build the same solution on the same release number only difference all instances was on dedicated servers . Can we introduce a parameter to enable multi source replication to a single master |
| Comments |
| Comment by VAROQUI Stephane [ 2013-09-18 ] |
|
Using the workaround of <> hostname all pointing to the same master The error log is saturated with following errors we have 8 shards per physical servers * 2 messages * 4K inserts this is killing the disk We need a way to remove those messages. What we found is starting 9 replications domains and stoping the last one disable those messages and save us. 30917 19:22:00 [Note] Master 'ccmstats_shard01': Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.001701' at position 30233338 |