Questions tagged [master-slave-replication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
0 votes
1 answer
345 views

Mysql Replication trigger not executing on slave

Mixed replication is enabled. MySQL master has a table Products that has triggers on update and delete. On slave database we have different trigger on same table on update and delete. Master database ...
2 votes
1 answer
356 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, ...
1 vote
2 answers
881 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 ...
1 vote
1 answer
42 views

Mysql 5.7 Slave replication is Slow

We are trying to debug a slave lag issue - it is currently lagging behind the master by 24 hours. Deployed on a AWS EC2 machine Database size is around 600 GB Grows at roughly 500 MB to 1 GB per day ...
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 ...
0 votes
1 answer
48 views

MySQL master-slave stopped replication no Error on relay log

MySQL Master stopped sending updates 1 day ago to Slave there is no obvious error. Everything was working fine I tried to create DB, and Users, no updates on Slave also SO far I tried to remove the ...
0 votes
2 answers
403 views

High Load MariaDB Cluster (Galera Multi Master Replication) - Same hardware needed for Slaves?

My Galera Cluster is on very high load. To run it fine, I´m using strong hardware and for sure a lot of custom MariaDB settings and custom OS tweaks. Now, I want to add Slaves to get "realtime&...
0 votes
1 answer
1k views

Mysql 8.0.22 master slave replication: why slave is trying to create user?

I am following this repo (https://github.com/alexanderfefelov/docker-mysql-replication) to setup one master one slave replication. I am not able to get it working. The master seems to be OK, but the ...
2 votes
1 answer
358 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 ...
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 ...
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 ...
0 votes
1 answer
435 views

MySQL slave stuck on Applying batch of row changes (read)

Might be duplicate of: MySQL slave stuck on Applying batch of row changes (write) or MySQL8.0 Replication Got Stuck "Applying batch of row changes (delete)" I am trying to use MySQL 8.0.26 ...
-1 votes
1 answer
306 views

Read Replica block queries postgres

I've RDS PostgreSQL DB with read-replica. Also, have one script which frequently checks the blocking query but I faced one issue yesterday where the blocking query was a startup(backend_type)process ...
0 votes
1 answer
12k views

Mysql replication fails when the master's binary log increments

I am currently running 2 instances of 8.0.31 MySQL Community Server on two virtual machines. These are set up with one way replication. The replication runs fine once set up, but at some point it ...
0 votes
1 answer
707 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
682 views

find error log for streaming replication

Recently the streaming replication fails after I restart the primary. I can not find the record using select * from pg_stat_replication Now, I want to see it from the system log file at /var/log/...
1 vote
1 answer
404 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
373 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 ...
0 votes
0 answers
20 views

mysql replication on same server instances not working

I use sqlyog tool to work in MySQL. MySQL master-slave replication on same server replicates fine by using queries and restoring from the sqldump. But it doesn't replicate by using sqlyog tool. In ...
0 votes
1 answer
294 views

Problem with seconds_behind_master in mysql replication with galera cluster

I have the next infrastructure of mysql servers: Node1 - MySQL 5.1.X Node2 - MariaDB 10.3.X Node3 - MariaDB 10.3.X Node4 - MariaDB 10.3.X Node1 is a master replication node. Node2 is a slave ...
0 votes
2 answers
1k views

Effect of --flush-logs on a slave mysqldump?

I have this database setup: Master -> Slave A I would like to accomplish the following: Master -> Slave A -> Slave B I have reviewed the documentation. Master and Slave A are both in an ...
0 votes
3 answers
604 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 ...
2 votes
1 answer
431 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 ...
3 votes
1 answer
454 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. ...
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 ...
1 vote
1 answer
55 views

Change server_uuid in MySQL

I want to know if there is any way to update server_uuid; I am trying master-slave replication, and I need different server_uuid. FYI - I don't have server_uuid in my my.cnf file, and when I update it ...
0 votes
2 answers
437 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 ...
1 vote
2 answers
836 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 ...
0 votes
1 answer
1k views

Master slave replication with different mysql version is on both slave and master

Currently, we have MySQL master-slave replication. Both master and slave servers have Mysql 5.5 Currently I need to add one more Master server having version 5.7. Is it possible to add Multiple ...
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 ...
1 vote
1 answer
418 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 ...
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 ...
0 votes
2 answers
64 views

MySql binlog file getting truncated/shrinked during replication

There is a master-slave setup of a mysql db. The replication was going on fine until pos y when an error was thrown Client requested master to start replication from position > file size. I tried ...
0 votes
1 answer
528 views

Renaming multiple databases on a MySQL slave

I have 4 mysql databases that I'm replicating from a master to a slave. In the past, I have renamed one of them because the slave is also a dev server where it has a dev version of that schema with ...
2 votes
1 answer
613 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.
0 votes
1 answer
388 views

Archive logs Pg_archive cleaner

I have Postgres installed on windows 10. I have master-slave replication ( 1 pc is master and 2 other pc are slaves). I have archive logs saved on a file on master pc and slaves are connected to that ...
0 votes
3 answers
2k views

Broken Slave MySQL : How To Fix MySQL Replication (BINLOG) error in the Slave?

Before we start I can give some info about the versions, Ubuntu - 14.04, MySQL - 5.5 I have successfully configured the Master-Slave replication with two EC2 Ubuntu instances. My master is in Ubuntu ...
3 votes
1 answer
444 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. ...
0 votes
0 answers
15 views

Need to build MySQL replication with TSL cert between onPremises server as Master and Azure flex server as Slave

I have a requirement Need to build MySQL replication with TSL cert between onPremises server as Master and Azure flex server as Slave . On Master & slave host ssl is enabled . also i have followed ...
0 votes
0 answers
146 views

Failed to start patroni

I am trying to configure patroni and etcd. Etcd is working fine, but patroni is failing to start. I have 3 servers, I have installed patroni and etcd on each server. When I try to start patroni on ...
0 votes
0 answers
38 views

Rename the slave Postgresql database name

I have Master-Slave streaming replication working well with postgresql 13. I created the slave from the master successfully and data is synching nicely to the slave. Can I just change the name of the ...
0 votes
0 answers
41 views

Switch slave to new master

I have one master and 2 slaves in a mysql replication mode. All slaves are synchronised to the actual master. Because of space disk problem, I have to shutdown master_old to switch the first slave to ...
0 votes
1 answer
85 views

MySQL NDB Cluster Community - High memory utilization by mysqld only on source/replica nodes

I have two MySQL NDB community clusters 8.0.30, each with 3 VMs Cluster#1_VM1: mysqld + ndb_mgmd Cluster#1_VM2: mysqld + ndb Cluster#1_VM3: mysqld + ndb Cluster#2_VM1: mysqld + ndb_mgmd Cluster#2_VM2: ...
1 vote
0 answers
410 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 ...
0 votes
2 answers
258 views

could not receive data from WAL stream: ERROR: requested WAL segment XXX has already been removed

Heads up - I have never dealt with postgres replication before; our DBA is on leave in Europe ATM. It appears that something broke our replication a week ago; the master has 121 current wal files, ...
0 votes
0 answers
25 views

SQL Server Merge Replication using Web Synchronization - RESUMING SYNC

We are using MSSQL Merge Replication using Web Sync over extremely slow connection with many SQL Express subscribers. For some reason, occasionally, connection is dropped and the subscriber is trying ...
-1 votes
1 answer
72 views

Is there a difference between Range Type Partitioning & Temporal Data Tables (System-Versioned-Tables) in Maria DB 10.11.5?

I have a migration project (from Oracle) to Maria DB 10.11.5 (my choice). The needs of the database server are not ordinary. The database is to write to disk the results of software bots which are ...
0 votes
0 answers
66 views

MySQL Master Slave Asynchronous GTID Replication Failover over ProxySQL with little downtime

This is a production setup and I have to perform a failover from Master A to new potential master B. MySQL Version is 5.7 and CentOS 7 is the OS. I have a simple master slave setup with A as Master ...
0 votes
1 answer
306 views

Is there any unique identifier for PostgreSQL? How can the master identify its slave unqiuely?

Is there any way to have more than one PostgreSQL slave servers in the same system. If yes, how come a master detect each server as different slaves from the below query select * from ...

1
2 3 4 5 6