Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
287
questions
1
vote
1
answer
319
views
Replication of databases with specific prefix on master
There are options to dynamically set variables on replication slaves, like replicate_wild_do_table and replicate_wild_ignore_table.
But, are there any options for replication master to dynamically set ...
- 113
0
votes
1
answer
273
views
Master DB Ran Out Of Space
My master server ran out of space today (at 20:22). My transactions logs ended up broken into multiple files:
-rw-rw---- 1 mysql mysql 228M Jul 31 20:22 mysql-bin.000914
-rw-rw---- 1 mysql mysql ...
- 149
3
votes
1
answer
3k
views
MySQL Replication binary relay logs transfer too slowly
Master server
MySQL 5.6.28
Ubuntu 14.04
8 core CPU
Slave server
Slave: MySQL 5.7.22
Ubuntu 18.04
16 core CPU
Both of them have 64GB of RAM and plenty of disk space.
What I did up to this ...
- 171
0
votes
1
answer
1k
views
MariaDB master-slave replication failover and failback
I'm trying to configure a DR instance of MariaDB (10.1.13) using master-slave replication.
I was able to establish the master-slave relationship with GTID by locking the tables on master, backing up ...
- 151
0
votes
1
answer
754
views
PostgreSQL Slave keeps xlog files with replication slot
I setup one master and two PostgreSQL servers (v9.6). In the master (and slaves) I set max_replication_slots = 2 and archive_mode is commented out everywhere. The replication works fine: There are no ...
- 21
2
votes
1
answer
901
views
Why has deadlock behaviour changed between MariaDB 10.1.22 and 10.2.14?
Since upgrading MariaDB 10.1.22 to 10.2.14 our MariaDB slaves are encountering deadlocks that are not handled in less than 600 seconds thus the classic semaphore decision to crash the server. The ...
- 301
6
votes
1
answer
3k
views
Queries running very slowly in Amazon RDS PostgreSQL read-replica
We have been maintaining a project which has both web and mobile application platform. The backend of the project is developed in Django 1.10 and deployed in AWS.
At the beginning, when there were ...
0
votes
1
answer
473
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
0
votes
1
answer
422
views
Row based replication on slave where as statement based on Master
We have a master slave setup of MYSQL 5.6. Master and slave runs SBR replication where as slave is not writing binlogs.
We need to enable binlogs on the Slave server but we want the binlogs to be in ...
0
votes
1
answer
183
views
Restore server instance using logical backup and wal files
Is it possible to restore a database instance using logical backup and wal files?
A senior SQL Server DBA asked me to implement below scenario in PostgreSQL
took the logical backup using pg_dumpall ...
- 93
2
votes
1
answer
1k
views
Load balancing between 2 servers using MySQL Router
I want to setup a simple master-slave MySQL replication. I also want to balance the load between the 2 servers. Can I use MySQL Router 2.1 for that purpose? As I read the official documentation, it ...
- 131
0
votes
2
answers
981
views
slave mysql configuration is not stored
EDIT
It seems that the problem is with my SSH connection, so I created a different question on serverfault. From what I understand so far, it that this problem is caused from the fact that the port ...
- 131
2
votes
1
answer
5k
views
Mysql replication broken due to 'Duplicate entry' with error code 1062 on slave server
Mysql Slave replication was working fine, but suddenly it has crashed due to duplicate entries error
The slave SQL thread stops due to duplicate entries in MySQL DB, which I have kept in ...
- 21
2
votes
1
answer
345
views
Cross-Continent SQL High-Latency Data Synchronization
How would one go about synchronizing a MySQL database cross-continent, while keeping the distributed application using the DB running fast (<0.2s page loads) ?
My database contains about 2.5GB of ...
- 121
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,900
1
vote
1
answer
210
views
Howto reliably ship WAL log files between master and slave
I have a replication master and a slave on two different computers. Actually both databases are running in docker containers, and their WAL archive directories are exposed to the host machine using ...
- 411
0
votes
1
answer
82
views
Single slave for multiple masters in AWS AuroraDB
We are planning to use AWS Aurora(MySQL version) as our relational database. There will be three masters in different regions. We need the data from these masters replicated in a single slave. I think ...
- 545
1
vote
1
answer
59
views
PostgreSQL Master server act as a slave for 2nd DB on new server
I have a strange situation I'm are trying to resolve. I've googled around but I haven't found a clear answer so I thought I'd pose it to the good people at DBA on StackEx to get a second opinion.
We ...
- 11
1
vote
1
answer
767
views
Is it possible to create a MySQL slave from a MariaDB master?
I need to create a MySQL slave instance which replicates the data from a MariaDB master. (I guess it won't work.) Any advice on how to create this replica architecture using MariaDB and MySQL?
I am ...
- 41
1
vote
0
answers
102
views
When the master db fails, the slave db will enable the write mode. How do I synchronize the master db with the information written to the slave db?
have two database. They are db1 and db2. db1 master, slave at db2.
d1 have write/read mode. d2 have read mode.
I have a problem like this: When the master db fails, The slave db will enable the ...
- 11
-1
votes
1
answer
297
views
MySQL Replication Relay for Peer-to-peer replication for Multi-master replications [closed]
Any one knows about MySQL Replication Relay for Peer-to-Peer Replication for Multi-master replications?
Please share if you know anything with example and syntax for multiple clients with as masters ...
- 99
1
vote
0
answers
124
views
MySQL Lagging Slave Across Data Centers
We seem to have a strange issue from time to time during heavy write workload , a slave in a different data center starts to lag behind the master but when we STOP and START the slave the it starts to ...
- 11
0
votes
1
answer
1k
views
commit or rollback on a statement based replication, effect on auto increment id
How commit or rollback is safe on statement based replication in terms of auto_increment column?
If I execute below queries, shoudn't there be discrepancy between master and slave in auto_increment ...
- 157
0
votes
2
answers
976
views
Stored procedure in master slave replication
I have a master-slave replication for a schema products which is being replicated with binlog_do_db = products.
one of the the tables in the master schema is being archived by calling a stored ...
- 103
2
votes
1
answer
5k
views
Can I use MariaDB as a replication slave for MySQL?
I've been a MySQL user/administrator for many years and I've been considering a switch to MariaDB. We have a statement-replicated setup with a MySQL slave and I've been thinking that one way to ease-...
0
votes
1
answer
189
views
Do i need streaming replication slots as many of replicas in postgres?
Correct me if I am wrong but I’m thinking that if I have 4 different read only replica servers I need 4 streaming replication slots, one for each of them?
Or all of them can you use one?
- 113
2
votes
0
answers
324
views
MongoDB not performing well when set Read from secondary
I have a mongoDB database, with 1 primary and 1 secondary in replicaset(and 1 arbiter). Both the servers are hosted on aws on c4.2xlarge instances(with 1.5 TB of SSD on each).
Mongo version of primary ...
- 155
0
votes
1
answer
1k
views
Mongo replicaSet dispersed over all continents
I have problem in operating mongo replicaSet which works on all continents.
The primary data is located in Europe and want to replicate it distant locations in US, Brasil, Tokyo, Sydney and Dublin.
...
- 103
2
votes
1
answer
748
views
Mysql database replication with geo-distributed servers
I am just a developer, who doesn't have deep knowledge in DBA. So need experts suggestions in this.
I have two offline databases in two cities, I want to make a synchronization between two databases ...
- 145
0
votes
1
answer
210
views
MariaDB | Sync Master with Slave in another Datacenter
We have a web application hosted on a dedicated server at Datacenter A. I am in the process of setting up a disaster recovery protocol and am considering the following.
My current plan is to purchase ...
- 135
2
votes
3
answers
1k
views
Seconds_Behind_Master high even though Read_Master_Log_Pos and Exec_Master_Log_Pos are very close
From what I understand from https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html, seconds_behind_master is the difference in the timestamp of where the IO thread is currently writing in the ...
- 31
-1
votes
1
answer
292
views
bigchaindb set up and run cluster node error
I have been following the instructions given on: https://docs.bigchaindb.com/projects/server/en/latest/production-nodes/setup-run-node.html in an attempt to create a cluster.
However I get this error ...
1
vote
1
answer
929
views
Too much data queued in replication slots
Periodically we run a batch process that sequentially backups (delete, vacuum and later remote storage in AWS' S3) for a set of about 20.000 tables with the following shell script:
#!/bin/bash
...
- 969
-1
votes
2
answers
262
views
Address of master PostgreSQL for replication?
What is the address (that goes to pg_hba.conf) for the master computer which is connected only to the internet which a slave VPS server will connect to for PostgreSQL replication?
0
votes
2
answers
419
views
Can MongoDB manage balancing between the Mongos Dynamically using TCP Balancer
If I have a business where I maintain 10 applications and I need to divide the request load of these 10 applications between 3 Mongos Dynamically.
Like the TCP Loadbalancer need to connect to MongoDB ...
0
votes
1
answer
67
views
Mysql master-slave replication makes no sence
I have the following values in my.cnf settings in a simple Master -> Slave setup:
# MASTER my.cnf:
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
binlog_format=ROW
binlog_do_db = db2
...
- 201
1
vote
0
answers
119
views
postgres 8.4: makeslave it's own master
For a DR test, I've tried to split the slave from the master. To do this, I edited the master postgresql.conf, turned off archive_mode and restarted. No problem.
Now I'm trying to make the slave a ...
- 606
0
votes
1
answer
312
views
MySQL Replication - Resync master after slave taking over
A few days ago, we've had to stop every machine for some maintenance. Two of these were a MySQL master-slave. After the restart, the master didn't get the service back online and, due to the critical ...
- 111
2
votes
1
answer
2k
views
how can be changed hot_standby parameter on postgres 9.6 aws/rds?
I have a postgres solution on aws/rds with a master and a read replica.
master slave
hot_standby on on
transaction_read_only on on
...
- 21
0
votes
1
answer
758
views
Can drbd be used for mongodb replication or active/passive setting?
From this guide we know DRBD can used for PostgreSQL Active/Passive setting:
https://www.howtoforge.com/how-to-set-up-an-active-passive-postgresql-cluster-with-pacemaker-corosync-and-drbd-centos-5.5-...
- 333
4
votes
3
answers
30k
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/...
- 333
1
vote
0
answers
132
views
Replicate Specific Tables with fully qualified statements removed
Currently we have a replication system that is a master to slave, which that slave is also a master. We are replicating our web server to our stats server so we can report on users traffic as well. We'...
- 105
2
votes
2
answers
3k
views
Post Mortem Analysis: PostgreSQL replication failed
We have a PostgreSQL 9.4.9 production server which was replicating to a slave instance, but today I discovered that the instance is out of sync!
The obvious actions would be to recreate the slave, ...
- 969
1
vote
1
answer
3k
views
Slave stoping with Last_SQL_Errno: 1032
I have added an extra Slave server to an existing MySQL Replication. The Master server and the old Slave server are working fine without any issue, but the newly added server is stoping with the ...
- 123
0
votes
1
answer
863
views
Can I create a table and database on a slave without breaking replication?
I have One Mysql master server and Slave server running on ec2. The replication is working fine. Now I need to make some changes. I need to add new slave server to the current replication loop.
Is ...
- 123
3
votes
1
answer
2k
views
How does one scale out with master-slave replication?
To my understanding, a master-slave replication might be set up where clients can read from multiple databases. However, they can only write to the master. I believe this helps guarantee ACIDity.
I ...
- 261
3
votes
0
answers
554
views
Replication doesn't resume once it fails to connect
We have MySQL replication running for our application. Right now the slave fails to resume if it fails to connect to the server for some time.
We get the error below:
[ERROR] Slave I/O: error ...
- 89
2
votes
1
answer
772
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
0
answers
308
views
MySql slave thinks that the query didn't run on the master, no helpful error
We have a master-slave replication that was running perfectly until recently.
Today i've found the error:
Query caused different errors on master and slave. Error on master: message (format)='Size ...
- 11
0
votes
2
answers
560
views
Should I write to MySQL slave (replica) for reporting?
I intent to put reporting/analytics database on slave and run job scheduler every night to aggregate and insert data from operational database to reporting database.
Should I do this or I have to ...
- 101