Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
10
questions
11
votes
2answers
28k 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 *************...
2
votes
1answer
394 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 ...
0
votes
3answers
3k 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 ...
4
votes
2answers
21k 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/...
4
votes
3answers
1k 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 ...
2
votes
1answer
607 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 ...
1
vote
1answer
2k 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
...
0
votes
1answer
221 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
0answers
33 views
PostgreSQL Streaming Replication: no pg_hba.conf entry for use from host
I have been trying PostgreSQL streaming replication for couple of days using link https://www.percona.com/blog/2018/09/07/setting-up-streaming-replication-postgresql/
I have edited my master pg_hba....
0
votes
1answer
280 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/...
