Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
129
questions with no upvoted or accepted answers
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 ...
4
votes
0
answers
653
views
MySQL replication - Follower stuck and behind
I understand there are lots of similar problems and threads but non of those solution helped me. Please read through the thread I will try to give as much information as possible:
I have setup a ...
- 141
4
votes
0
answers
696
views
How to get the Slave commit timestamp using MySql replication?
I've been looking for ways to collect information about the replication delays on MySql 8. I found an alternative solution, but I imagine there's a more straightforward way to do that.
By reading its ...
- 41
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
3
votes
0
answers
2k
views
Got fatal error 1236 from master when reading data from binary log
I am trying to do a MySQL failover, in some situations I endup with broken replication. Any idea what could be the cause of it ?
Background
Needed to perform a host updates on master host. Hence ...
- 49
3
votes
0
answers
843
views
RESET MASTER; does not reset GTID_EXECUTED
I'm trying to get replication up and running between two kubernetes pods, and am getting the dreaded @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty. error.
root@central-vm:~...
- 606
3
votes
1
answer
441
views
Can I stop replication of create/drop index statement on one slave of Mysql 5.6?
I have this cluster where master and slave uses same indexes but one of the slaves has some extra indexes (large machine which runs some analytics queries).
So I have to maintain two sets of indexes. ...
3
votes
0
answers
557
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
308
views
Setup proxysql read-write split with both galera cluster and master slave replication
I have the following setup:
Three node galera cluster (galera-1, galera-2, galera-3)
galera-2 is master to slave-1 (master-slave replication)
slave-1 is master to both slave-2 and slave-3
slave-1, ...
- 121
2
votes
0
answers
109
views
Issues with failback for logical replication using postgres
I am using PostgreSQL 13 to set up logical replication. When the original active node (A) becomes the secondary, the prior secondary(B) which is now active node needs to sync to the (A) node.
To ...
- 121
2
votes
0
answers
304
views
Faster way to restore MySQL innoDB dump
I have a below MySQL configuration.
# The MySQL server
[mysqld]
....
key_buffer = 384M
max_allowed_packet = 5M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = ...
- 49
2
votes
1
answer
2k
views
fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'
I'm getting the following error;
Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'
I've tried setting this up on 3 ...
- 23
2
votes
1
answer
437
views
MariaDB - Replication - Unable to login remotely
So I've been trying to configure MariaDB replication for our server. Unfortunately I cannot get it replicating correctly.
So I've followed the MariaDB guide to the letter to get replication set up. ...
- 21
2
votes
1
answer
1k
views
Could you monitor all changes made within a postgresql database by somehow subscribing to the replication log?
I've been reading about postgresql replication and was wondering if it was somehow possible to listen to the replication binary log and push that to some tool like sumologic or splunk so that any ...
- 121
2
votes
0
answers
281
views
How I can find out which postgresql I am connected into when behind a load balancer?
I have the following database replication setup:
As you can see I do a master-slave replication and I use aload balancer in order to connect into read-only replicas.
So I want to test this setup, ...
2
votes
1
answer
1k
views
Mongodb replica set primary and secondary node conf fail when one slave is down
In my env, I had created MongoDB replica set conf for high availability so one server fails should be handled by other also in my conf I have 3 DB server and 1 arbiter too but,
my slave's server ...
2
votes
1
answer
425
views
Finding temporary table name in MariaDB
As I reported some days ago to MariaDB bug tracker the following bug: https://jira.mariadb.org/browse/MDEV-17420, slave replicas with version 10.2.x are leaking temporary tables on MyISAM files.
Our ...
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
2
votes
1
answer
350
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
2
votes
0
answers
326
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
2
votes
0
answers
553
views
Cluster using docker
We are creating a new application using microservices, and for that we would like to be able to raise database instances just like we raise new instances for the application's microservices. We do not ...
- 141
2
votes
2
answers
2k
views
Importing a large mysql dump while replication is running
So we have a simple master/slave mysql replication running between two CentOS Servers.
The master has multiple databases. eg..
Database1
Database2
Database3
The issue is we have a mysql dumpfile ...
- 21
2
votes
1
answer
589
views
sync_binlog different for master and slave
Is it fine if sync_binlog is different for master and slave?
For my system I can see master has sync_binlog=1 and slave has sync_binlog=0.
- 121
1
vote
0
answers
96
views
MySQL -> MariaDB Replication throws Collation Error
We are moving from MySQL on AWS RDS to MariaDB on-premise. To do so without downtime, we planned to create a replication first between the MySQL master and the MariaDB slave and then promote the ...
1
vote
1
answer
167
views
Write latency for adding an index on read replica
This is a question that I've not been able to find any good documentation for on the internet.
I think it's a common industry standard that for tables with heavy writes, you add an index on the read ...
- 131
1
vote
0
answers
259
views
SOLVED - Mariadb replication Master Slave fail with error code 1595
I've a strange problem.
A Mariadb replication start failing since this morning.
Until today everything works fine from month.
This is my scenario:
I've a server in a DC which is the master, and a ...
1
vote
1
answer
47
views
How to identify binlog_format for a specific query?
I have binlog_format set to MIXED and it states that mariadb will decide whether to use ROW or STATEMENT based logging for each query. Where can I see that information for a specific query?
1
vote
0
answers
41
views
maximum number of physical replication on one server
I have a server with physical replication. It has been working very well till now.
I follow the procedure here : https://linuxhint.com/setup-physical-replication-postgresql/ to create the replication.
...
- 167
1
vote
0
answers
101
views
MySQL : Huge table truncation in replication environment
We have 2 tables of size 186G and 63G that are no longer in use and needs to be truncated from the database.
I cannot directly run the truncate table statement on the master DB as it has 14 replicas ...
- 11
1
vote
0
answers
123
views
aws documentation for DMS CDC is confusing
I am following this documentation https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.Security to enable CDC using logical replication.
I have pglogical ...
- 71
1
vote
2
answers
757
views
MySQL master slave replica interrupts after service restart or reboot
I've been using the master slave replica to keep a mySQL database and its disaster recovery perfectly aligned.
I noticed that unfortunately every time the mySQL service restarts, or one of the server ...
- 11
1
vote
1
answer
380
views
replicate-wild-do-table=channel_name:db_name.% doesn't work in MySQL 8.0 for channel based replication
I am trying to configure a replication topology where there will be one slave which will connect to two masters. Percona Server 8.0.25.
Master1- main master
bkp_server - slave to master1 and ...
1
vote
1
answer
345
views
migrate mysql DB between two servers using replication
I need to perform some steps, I have to migrate our company live DB to a new server, if I use normal way such as lock table, mysqldump, scp, mysql restore, it take around 5-6 hours, so I want to make ...
- 11
1
vote
1
answer
243
views
MySQL DB as Master for some tables and Slave for others
I have 2 DBs - DB1 (back-office) and DB2 (web application). The data needs to be synced between the 2. I'm happy with the idea of full master-master replication and may have to implement it, but ...
1
vote
0
answers
281
views
How to hot merge MariaDb databases from multiple servers into a single one
Current Configuration
I currently have 3 servers:
server australia with the database canberra
servers belgium and germany are a galera cluster with the database bruxelles.
Target Configuration
My ...
- 111
1
vote
0
answers
92
views
Getting error while starting slave on MySQL slave./ Backups in MySQL 8.0.20
I want to set up below command for daily MySQL database backup.suppose We have more than 50 MySQL database in server.
I am using below command to take backup of all databases on server.
Note: I am ...
- 133
1
vote
0
answers
341
views
How to check RDS MySQL database synchronization status
We were creating a read replica for an RDS MySQL (5.7.28) instance, and before the read replica became available one of our developer accidentally connected to the read replica and was able to write ...
- 11
1
vote
1
answer
407
views
MySQL 5.7 Can slave be ahead of master during replication
From my understanding, once commit() is received from client, transactions are written to binlog first before any commit is done to InnoDB.
In this case, is it possible for slaves to be ahead of ...
1
vote
2
answers
785
views
Split read/write requests over different read/write datasources
Recently I have run some performance tests on the application I work on, and it turns out that it didn't do really well ( the problem is mainly between the back and the DB). So as investigating the ...
- 111
1
vote
0
answers
326
views
Physical and logical replication slots on Postgres (same time)
I wonder if it's possible to have a setup when changes from a single Postgres master streamed to two (or more) replicas same time, but some replicas to use streaming (logical) replication and some to ...
- 111
1
vote
1
answer
200
views
Postgresql streaming replication slow on macOS
I am using PostgreSQL 10.1 on MAC on which I am trying to set up streaming replication. I configured both master and slave to be on the same machine. I find the streaming replication lag to be slower ...
1
vote
1
answer
1k
views
PostgreSQL - Replica Recovery Process Stuck frequently (epoll_wait taking too much time)
We have Master Slave Setup with Asynchronous Streaming Replication (Replication Slots). Frequently our Replica's entire Postgres processes seems to be doing nothing (or stuck?). Since ...
- 299
1
vote
0
answers
433
views
Cascading binary replication to logical postgres
Im using Postgres 10, and I was wondering if its possible to cascade a logical replication from a binary slave replica? I am looking to have databases with the same data but indexed in a different way ...
- 785
1
vote
0
answers
110
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
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
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
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
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
1
vote
0
answers
332
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
1
vote
0
answers
364
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