Questions tagged [master-slave-replication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
4
votes
1answer
2k 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
0answers
5 views

Slave is maxing memory usage when I'm performing a backup on master

Is there a way to optimize this? I am running a multi-source replica on my slave. As per my observation, whenever the biggest master DB (around 40GB) gets backed up, the slave's memory is being used ...
0
votes
0answers
12 views

pgbackrest: Is it possible to have repo and hot standby on the same node?

I am trying to use 2 nodes: Node A as primary node. Node B as standby + REPO node. Is it possible to do this? My configuration looks like this right now: Primary node - pgbackrest.conf [global] ...
0
votes
1answer
248 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
2answers
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 ...
0
votes
1answer
23 views

Best way to start Master - Slave replication

I'm trying to get replication set up between two servers with the eventual goal of switching the slave over to be the master (I'm trying to upgrade the hardware stack with as little interruption as ...
0
votes
1answer
95 views

PostgreSQL pg_rewind use cases

Let's say that I configured streaming replication between Server A (master) and Server B (slave). If server A goes down and Server B is promoted, would I be able to use pg_rewind, where Server B is ...
1
vote
1answer
3k 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 ...
1
vote
1answer
687 views

Can a MySQL 5.6 master replicate to a 5.7 slave, which in turn replicates to a MySQL 8 slave?

According to the docs, "MySQL supports replication from one release series to the next higher release series. For example, you can replicate from a master running MySQL 5.6 to a slave running MySQL 5....
0
votes
2answers
676 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 ...
1
vote
1answer
388 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 ...
2
votes
1answer
197 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 ...
0
votes
1answer
119 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
1answer
430 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 ...
0
votes
2answers
293 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
0answers
9 views

Mongo secondary unable to connect to primary

I have a cluster made of 4 mongo members: 1 arbiter, 2 secondaries, and 1 primary. The configuration is as follows: rs0:SECONDARY> rs.conf() { "_id" : "rs0", "...
0
votes
0answers
12 views

Replicating multiple unrelated servers

We have a bunch of live websites running simple LAMP stacks. We have nightly backups to the cloud, but this means that an event like the Strasbourg fire at OVH might happen just before your backup ...
2
votes
0answers
22 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 ...
1
vote
1answer
230 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
1answer
188 views

What does this error mean "A slave with the same server_uuid/server_id as this slave has connected to the master;"?

Upon searching for this, the main cause of this error is usually when using snapshots or cloning the machine. But I did not do this. I perform mysqldump --master-data=2 on the master then restore the ...
2
votes
1answer
165 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. ...
0
votes
2answers
657 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 ...
1
vote
1answer
172 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 ...
0
votes
1answer
125 views

High Available PostgreSQL with Patroni and Replication

I want to build a highly available PostgreSQL cluster using patroni with etcd. I want to have 3 server (1 master and 2 slaves) in my cluster, so if something goes wrong one of the slaves automatically ...
0
votes
2answers
624 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 ...
2
votes
1answer
914 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
1answer
422 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
1answer
161 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 ...
0
votes
1answer
244 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 ...
1
vote
1answer
252 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 ...
0
votes
1answer
20 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 ...
1
vote
2answers
362 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
0answers
11 views

Why is it that my redis slaves are not promoting to master when requirepass, masterauth is enabled on my original master server?

I am running redis on 3 VMs. When authentication (requirepass, masterauth) is disabled, a slave will be promoted to be the master, but when I put authentication on it, no slaves are being promoted. ...
0
votes
0answers
25 views

MySQL: slave log sequence number is in the future (but master is fine)

I have a master server replicating to a slave. I'm being plagued by this error message on the slave: 2021-07-01 08:39:25 7f04881ee700 InnoDB: Error: page 194 log sequence number 142640849934 InnoDB: ...
0
votes
1answer
161 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
1answer
115 views

Where is pt-table-checksum finding this hostname?

The Setup: An EC2 instance running MySQL 5.6 locally replicating to RDS MySQL. The VPC IP address range is 172.0.0.0/8. Somehow the slave got out of sync and I'm getting this error when I do SHOW ...
0
votes
1answer
21 views

Why slave_parallel_workers affects TPM

I ran a few HammerDB benchmarks and mess with the configurations. And I notice different values of slave_parallel_workers have a considerable impact on TPM. As far as I understand, ...
0
votes
1answer
626 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 ...
0
votes
0answers
11 views

Is there an option in redis for a slave to not be promoted to master?

What I want to accomplish is to not let my VM in Zone 3 be promoted to master? Is there such thing on Redis? Similar to mongo members.priority? Here is my setup Zone 1 redis-1 192.168.0.1 Zone 2 ...
0
votes
0answers
34 views

Privileges of mysql/mariadb replication accounts

I've created a replication account on a master(server1) and client(server2). This is the output of SHOW GRANTS FOR 'repl'@'192.168.1.%'; on a master; GRANT REPLICATION SLAVE, BINLOG MONITOR, ...
1
vote
1answer
2k 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 ...
3
votes
1answer
288 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. ...
1
vote
1answer
139 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 ...
0
votes
2answers
406 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 ...
0
votes
1answer
17 views

GCP Cloudsql Mysql Replica unresponsive after mass delete on Master

Directed here from S/O We have a Master/Replica configuration for Mysql innodb(5.7.32) databases in Cloud SQL... We have a single Table (let's call it Master table) partitioned on Two keys having both ...
0
votes
1answer
16 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 ...
-1
votes
2answers
45 views

How to make transactions atomic in Mysql 5.6

How do we make the following transactions atomic? conn - is a connection to the old primary, which is being reset as replica now. Python code conn.execute('unlock tables') conn.cursor().execute('stop ...
2
votes
1answer
816 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
1answer
13 views

Replication setup

Currently, I have a production setup which consists of one Primary server and one Replica server, lets call them Primary1 and Replica1. All databases from Primary1 are replicating to Replica1. Now, I ...
0
votes
0answers
8 views

How to do mysql 8.0.24 master-slave replication switch?

I am using two machines for mysql 8.0.24 master-slave replication, if the master database hangs, what action can the slave database take to become the master?

1
2 3 4 5