Question : To my understanding, a master-slave replication might be set up where clients can read from multiple databases. However, […]
Tag: master-slave-replication
How does trigger file in recovery.conf work?
Question : Can someone explain how the trigger_file in recovery.conf works? As far as I know the standby server will […]
MySQL Replication Slave Status OK but Data inconsistent
Question : We are using MySQL 5.7, and have a Master and 3 Slave servers replication setup. All the 4 […]
Does a single replica gives any performance improvement?
Question : Consider a case where you have a single PostgreSQL database. Then you add a replica (hot standby) and […]
Slave stoping with Last_SQL_Errno: 1032
Question : I have added an extra Slave server to an existing MySQL Replication. The Master server and the old […]
PostgreSQL Master server act as a slave for 2nd DB on new server
Question : I have a strange situation I’m are trying to resolve. I’ve googled around but I haven’t found a […]
Postgres 10 Log Shipped Replica with cascading replication
Question : I’m planning for a tricky (at least for me) migration whereby I have master postgres 10 db from […]
Stored procedure in master slave replication
Question : I have a master-slave replication for a schema products which is being replicated with binlog_do_db = products. one […]
Do I need to redesign my Database and get rid of foreign keys for successful replication?
Question : I plan to set up MariaDB replication either in master-master or master-slave mode. The main issue I have […]
Can I edit queued MySQL binary logs for replication?
Question : I have a simple Master-Slave replication set up, but Slave keeps falling behind do to what appears to […]