Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
18
questions
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 *************...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
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 ...
- 999
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
...
- 233
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 ...
- 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/...
- 343
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 ...
- 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 ...
- 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 ...
- 999
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 ...
- 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 ...
- 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 ...
- 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 ...
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" : ...
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/...
- 11