2

You understood correctly. Since streaming replication keeps the replica a physical copy of the primary database cluster, you can only replicate between one primary and one replica. There are two options: Keep three clusters on the replica machine, one for each primary cluster. Use logical replication. With logical replication, you have to make sure that ...


1

The database generates WAL for the entire database instance. It is the logical sender's job to sort them out to restrict and construct what gets sent. I don't think there is a way to get the logical sender to work ahead. You should look at why it is falling behind, not why there is a lot of WAL.


1

Solved. Before command CREATE USER you have to put: use mysql; and then it is replicated to slave server


1

You probably want a cluster such as MySQL InnoDB Cluster (from Oracle) or MariaDB Galera Cluster or Percona XtraDB Cluster in each region for high availability. You can write to any of the nodes in the cluster and the transaction will be automatically replicated to the other nodes. Note that both Percona XtraDB Cluster and MariaDB Galera Cluster are based on ...


1

As you already found out your master database is too busy for single replication worker to handle all of the changes. You need to cluster your tables - but make sure you do it in such way that tables with foreign keys are handled with the same worker, otherwise you might get into situation where foreign key constraint will prevent data from being inserted ...


1

This adds to @Miroslav's answer except that the hostname found in /etc/hostname had to match the hostname found in /etc/hosts (dont forget to reboot when changed). I was using a common /etc/hosts file for all my servers but wasn't updating the /etc/hostname file to match. Goodluck


1

It looks like AWS DMS (Database Migration Service) supports migrating data from external SQL instances. I was able to set up a migration task that replicates data and changes from Heroku to RDS. Whether it actually works for me is yet to be seen ;) --- EDIT --- Looks like services like DMS don't work with Heroku, because they require more privileged roles ...


Only top voted, non community-wiki answers of a minimum length are eligible