Questions tagged [master-slave-replication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
15 votes
3 answers
40k views

Trying to understand SHOW SLAVE STATUS in MySQL

I have a Master-Slave replication setup and it looks like that it is running fine. Below is a result of SHOW SLAVE STATUS command: show slave STATUS\G; *************************** 1. row *************...
newbie14's user avatar
  • 969
3 votes
1 answer
4k views

mariadb Unknown system variable 'server_uuid'

Im trying to setup replication between mariadb(10.1.31-MariaDB - MASTER) and mysql(5.7.12-log - SLAVE). After executed the start slave, I got the below error. Fatal error: The slave I/O thread ...
TheDataGuy's user avatar
  • 1,910
2 votes
1 answer
787 views

Fetch just inserted data in master/slave model?

Say I have MySQL master DB(used for updates) and corresponding Slave DB(used for reads). Now user inserts the data into MASTER through application(java), just after insertion he tries to retrieve the ...
emilly's user avatar
  • 175
1 vote
1 answer
2k views

PostgreSQL - PUBLICATION tries to copy the data which already exists in another database?

I have database and table collection_city on one server. It has 21 rows. I have database and table collection_city on second server. It also has 21 rows. They both have this row: tinker=# table ...
Dejan's user avatar
  • 675
0 votes
0 answers
113 views

Replication Lag while migrating a live database

I have a live database that is on a server(mysql 5.7) that I want to completely migrate to a droplet created on an infrastructure provider with (mysql 8.1). I would also like to have a master slave ...
Chaitanya Valeti's user avatar
0 votes
3 answers
4k views

Metrics for monitoring master-slave replication

Is there some kind of query/view/table available in PostgreSQL that can reflect the actual status of a master-slave replication process? Perhaps the "degree" of sync between the nodes? The above is ...
Gonzalo Vasquez's user avatar
4 votes
1 answer
6k views

Service mongod fails after adding security.keyFile in config file

My mongo.conf: # where to write logging data. systemLog: destination: file logAppend: true path: /var/log/mongodb/mongod.log # Where and how to store data. storage: dbPath: /var/lib/mongo ...
Abdul Moiz's user avatar
4 votes
3 answers
2k views

In replication A->B->C, can A be binlog_format=STATEMENT and B be binlog_format=ROW?

I have replication setup between an on-prem MySQL 5.6 server (A) to another on-prem MySQL 5.6 server (B). I was setting up an AWS DMS instance (C) that I wanted to migrate and then replicate. It ...
Aaron R.'s user avatar
  • 143
4 votes
3 answers
31k views

PostgreSQL service start failed on CentOS 7

Installed PostgreSQL using: sudo yum install postgresql-server postgresql-contrib PostgreSQL version: 9.2.18 When start service: sudo service postgresql start Got error: Redirecting to /bin/...
cloud_cloud's user avatar
3 votes
2 answers
9k views

Change host IP of master in mysql replication

I have one master and one slave. Suppose IP of master is changed but the physical server is same. Now I want to update the new IP (of the master) at the slave server. At the slave server ...
srvnk's user avatar
  • 91
2 votes
1 answer
2k views

Postgresql - increase WAL retention to avoid slave go out of sync with master

I've setup a master / slave Postgresql (13.4) group, 1 master and 1 slave, using WAL warm standby. (refer: https://postgresql.org/docs/current/warm-standby.html#STANDBY-SERVER-SETUP) The slave gone ...
Eric's user avatar
  • 253
2 votes
1 answer
2k views

PostgreSQL replication not working after base backup

Last week we had an incident with our master PostgreSQL server instance which got totally thrashed so, we had to switch to our slave as our one and only DB instance. After the initial chaos was ...
Gonzalo Vasquez's user avatar
1 vote
2 answers
218 views

MYSQL DATABASE BACKUP

Currently my backup strategy invloves :- 1)I have one master server and two slaves (Data approximately 700 GBs and tables are of mixed innodb and myisam). 2)I take weekly and monthly backup from ...
karnish's user avatar
  • 47
1 vote
1 answer
1k views

Upgrading Postgres major version using logical replication

We have considered some options to upgrade our Postgres servers from the current (10) version to the latest (14). We decided no to do on the primary - since we need to do with the link option (so in ...
Chillax's user avatar
  • 131
0 votes
1 answer
2k views

Postgresql - recover slave after out of sync with master using WAL

I've setup a master / slave Postgresql (13.4) group, 1 master and 1 slave, using WAL warm standby. (refer: https://postgresql.org/docs/current/warm-standby.html#STANDBY-SERVER-SETUP) But, due to some ...
Eric's user avatar
  • 253
0 votes
1 answer
650 views

High Memory Usage on Replica - Mysql 8

Hope you're doing well. We've recently moved to Mysql 8 (from Mysql 5.7). We're using AWS RDS Service with MySql. The AWS Team is also looking for a solution btw. Since a few days, we're facing ...
NicolasCab's user avatar
0 votes
1 answer
332 views

Mongodb replica config slaveDelay but data still sync immediately

I've set slaveDelay to 600s but when the Primary data change, the Secondary data change immediately. Here's the curent configuration of repl with 2 server. "members" : [ { "_id" : 0, "host" : ...
Nguyen Trung's user avatar
0 votes
1 answer
480 views

Row-row based logging in a blackhole replication filter setup?

I am using two MySQL server instances on the same server to filter replication to a third external server. My filter slave is using the blackhole engine as described here: https://dev.mysql.com/doc/...
Istvan Dupai's user avatar