Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
270
questions
4
votes
1
answer
850
views
Why does mysqldump stop the slave SQL thread for the entire backup?
I realized recently that I was using --master-data to dump a backup from a replication slave when what I really wanted was --dump-slave. After switching to --dump-slave, I see that mysqldump will stop ...
2
votes
0
answers
91
views
Fault tolerant cross datacenter MySQL replication & failover strategy [duplicate]
Which of the following method is the most fault tolerant way to achieve cross datacenter MySQL replication using DNS failover and why?
MySQL master-master replication with one primary/active node and ...
- 121
3
votes
2
answers
64
views
How do I create a MySQL slave server of a bunch of MyISAM databases on a master
I have a MySQL master server and slave became corrupt because of space issues on the master. Binary logs are potentially corrupt and I don't trust them. The databases are using MyISAM tables.
I want ...
- 253
0
votes
1
answer
318
views
Understanding Simple MongoDB Replication Works
I've been using MongoDB (3.2.9) replication for years and barely know the detail how it works. My Stack is Rails 4.2.5 with Mongoid 5.1.3. I've 3 database servers, let's call them A (Primary), B (...
- 3
4
votes
1
answer
716
views
Can PostgreSQL slave server act as master for a new database?
My question is somewhat related to:
https://stackoverflow.com/questions/19331577/does-postgres-replication-native-support-per-database-level-replication
We have master-slave replication set up on ...
- 145
0
votes
1
answer
515
views
How to create a multiple mysql replication
My question is about to create a mysql replication server.
Here i have multiple slaves and i want replicate all respective database into multiple master server .
Que is that how could i set multiple ...
1
vote
0
answers
354
views
Master-slave + master-master replication at the same time
Can a MySQL database which is doing master-slave replication to a number of slaves be configured to do master-master replication to a new server at the same time?
I have an application that has a ...
- 121
1
vote
1
answer
66
views
runtime replication
We have a master-master replication setup with 3 databases being replicated between both masters; 'database a', 'database b', 'database c'. Replication is row-based.
'database c' had an issue and we ...
- 179
1
vote
1
answer
50
views
Lost entire MySQL Server. Unsure if "master-slave" or "master-master" - How to tell?
Yup - my db02 server lost a disk, and the array itself is corrupt (RAID5, yet corrupt data.) I was able to get the OS back online, but the corruption is severe. I have zero documentation about the ...
- 111
1
vote
2
answers
200
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
5k
views
How does trigger file in recovery.conf work?
Can someone explain how the trigger_file in recovery.conf works?
As far as I know the standby server will become the primary server when it detects the trigger_file. But how will the trigger_file be ...
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
1
vote
1
answer
101
views
Master-Slave semi circle replication not working in MySQL
I didn't know how to describe it so I am calling it semi circle. Here's what I am doing.
Server A
Server B = This is slave of Server A
Server C = This is slave of Server B
When I update something ...
- 441
4
votes
0
answers
7k
views
Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave
I am trying to setup multi source replication. In my slave I have defined following two properties in its configuration file.
master-info-repository=table
relay-log-info-repository=table
These ...
- 441
4
votes
2
answers
6k
views
MySQL slave not able to execute long running update query
I am running a Master-slave replication servers of MySQL. As part of clean up of old data, i ran a delete query which deletes huge number of records from the database. It ran fine on Master server but ...
- 241
0
votes
3
answers
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 ...
- 949
3
votes
2
answers
6k
views
org.postgresql.util.PSQLException: ERROR: canceling statement due to conflict with recovery
I currently have a PostgreSQL slave node that is presenting problems, that don't arise in the master node. Seems to be related with the node sync process.
Complete stacktrace:
org.postgresql.util....
- 949
2
votes
3
answers
3k
views
SELECT from slave and INSERT into master in MySQL
I'm using PHP/Laravel and MySQL databases.
Briefly, I want to use slave databases for reads and master database for writes.
What Laravel config, Laravel package, or database tool do you suggest to ...
- 141
5
votes
3
answers
5k
views
MySQL Master/Slave replication on same VM instance?
I'm fairly new to databases so I hope this isn't a silly question!
Is it possible to set up master/slave replication on the SAME server?
I understand there are not any advantages to this in terms of ...
- 113
15
votes
3
answers
38k
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 *************...
- 959