0

We use mysql multi-source replication, analysts and developers works with the databases, it's a main task of server(cross-bases queries, etc). Mysql slave replicates data from about 10-15 servers, some of them is realy big (400gb, 500gb, 1.5tb). Slave host - ec2 r4.2xlarge. But have some problems, main of them - stability. Often there is an errors 1236, 1594. We fix one channel - another fails, sometimes it's critical.

Backups of most master databases are performed through ebs snapshot, where datadir located. But here another problem of mysql multi-source - work with backups, unlike multi instance replication, I can not just change datadir, where backup located.

I was trying to find a solution that at least partially solved the problems of stability and work with snapshots, but I found absolutely nothing. Did I understand correctly that there is no support for multi-source replication in the aws-RDS?

Maybe there is a similar solution, or there is another approach to solving the problem (FEDERATED is bad variant). Thanks for any help and advices.

Kostiuk Aleksandr
  • 509
  • 2
  • 14
  • You shouldn't be encountering these errors. Correctly initialized replication should just work. Errors are an indication that your initial setup is incorrect or perhaps that you are trying to use replication filtering without fully understanding the implications. If your masters are not using `BINLOG_FORMAT` = `ROW` then you should consider it. – Michael - sqlbot Sep 24 '17 at 06:02
  • @Michael-sqlbot thx, i read about it. – Kostiuk Aleksandr Sep 26 '17 at 18:10

2 Answers2

0

As Michael said, you shouldn't be encountering these errors. Multi source replication has quite stable now. I personally been using it for more than 2 years now. Yes I have faced some of issues like "slave trying to access binlogs that master has purged", but most of them were easy to sort out. I would recommend you to look at these replication topics:

We fix one channel - another fails, sometimes it's critical.

make sure you're not touching GTID set for other channels.

Did I understand correctly that there is no support for multi-source replication in the aws-RDS?

The feature still not available in any of AWS cloud services. https://forums.aws.amazon.com/thread.jspa?messageID=781416&tstart=0

avisheks
  • 1,178
  • 10
  • 27
-1

Multi source replication is not supported in RDS , you can use AWS DMS for same purpose .

Khurram Naseem
  • 19
  • 4