Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [master-slave-replication]

The tag has no usage guidance.

76 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
1k 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 ...
3
votes
0answers
398 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 ...
3
votes
0answers
6k 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 ...
2
votes
0answers
22 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
0answers
136 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 ...
2
votes
1answer
325 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
1answer
95 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. ...
2
votes
0answers
506 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 ...
2
votes
2answers
1k 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
1answer
30 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
2answers
32 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 ...
1
vote
1answer
185 views

Issue with Time Zone while migrating MySQL on-premises DB to AWS RDS

I am having MySQL 5.6 database with PST time format in on-premises server. Now we are willing to migrate the database to RDS. For this, we have taken backup from physical server and restored in RDS ...
1
vote
1answer
123 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 ...
1
vote
1answer
56 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 ...
1
vote
0answers
165 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 ...
1
vote
1answer
278 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 ...
1
vote
1answer
638 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 ...
1
vote
1answer
2k 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
98 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 ...
1
vote
1answer
158 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 ...
1
vote
0answers
75 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 ...
1
vote
0answers
75 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 ...
1
vote
0answers
169 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 ...
1
vote
0answers
51 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 ...
1
vote
0answers
110 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'...
1
vote
1answer
876 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 ...
1
vote
0answers
168 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 ...
1
vote
1answer
303 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.
1
vote
0answers
213 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 ...
1
vote
1answer
32 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 ...
1
vote
1answer
29 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 ...
0
votes
0answers
11 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:~...
0
votes
0answers
9 views

Is it possible to replicate a cluster (not just a node)?

Making a master-master cluster is easy, as is replicating one of the master nodes to a read only slave. As is replicating that RO slave to other slaves. But, of course if the master node which ...
0
votes
0answers
24 views

Is it a good idea to have a read connection point to both write database and read replica?

In my laravel app I have a write connection to a write database, and a read connection to a dns server that is connected to a single read replica (as instructed here) In the past the dns server was ...
0
votes
0answers
24 views

Migrate a legacy application that uses MySQL replication

I have been working on the migration of a legacy ecommerce web application to a new server with far hardened security. I have found an aspect with the MySQL server that I am not acquainted with and I ...
0
votes
0answers
11 views

Replicatation broker between master and slave with 'Can't find master key from keyring

I Have created new instance on AWS installed mysql on the server and made that server as Slave and added it to master. Master is in different network. 1) Installed the keyring. Started the ...
0
votes
0answers
30 views

Insert Missing Data in Slave Database

We have a master slave replication [MySQL 5.6]. However In slave database 2 rows is missing in one table. I've tried to solve this using Percona Toolkit as suggested here. But pt-table-checksum ...
0
votes
0answers
53 views

Set slave_exec_mode value for RDS

I am trying to figure out a way to set slave_exec_mode to idempotent on Amazon RDS. I've checked the parameters associated with created DB instance on Amazon Console, but this parameter is not exit ...
0
votes
2answers
124 views

MariaDB slave replication stopped after slave upgrade to 10.1.41

After the recent MariaDB 10.1.41 update which happened on 01/Aug/2019, few of our slaves have stopped syncing relay logs from master which is on 10.1.40. Slaves which got automatically updated to 10.1....
0
votes
0answers
35 views

How to Un-Break MySQL Master/Slave replication

I had mysql master-slave replication working with mysql Ver 14.14 Distrib 5.7.27 -- totally awesome until it broke. Now, I'm not sure why but I cannot get it to work again. /etc/mysql/my.cnf has: ...
0
votes
0answers
17 views

In Mysql 8 user creation statements replicating on slave even after using replicate-ignore-db=mysql

Description: ` Normally in mysql replication Data Control Language (DCL) statements won’t replicate into slave if we are configuring replication with replicate-ignore-db=mysql or replicate-wild-...
0
votes
1answer
26 views

What will happen if master goes down in peer to peer replication?

In case of Peer to peer replication, if Master goes down, will the other two nodes continue synchronizing or not?
0
votes
0answers
76 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 ...
0
votes
2answers
66 views

syntax error for change replication

On a mysql 5.7 master, the following command generates syntax error. CHANGE REPLICATION FILTER REPLICATE_DO_DB = ('mydb') ERROR 1064 (42000): You have an error in your SQL syntax; check the manual ...
0
votes
1answer
26 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
2answers
174 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
0answers
24 views

Is there any global variable for PostgreSQL replication has configured or not

Is there any unique identifier or any global variable which can tell us if replication is configured in current PostgreSQL server. Other than this query select pg_is_in_recovery(); The above ...
0
votes
1answer
33 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
0answers
9 views

PostgreSQL streaming replication - secondary access

I have read that the streaming replication can be set up so the secondary receives the read only queries, but it is not clear to me how that is "turned on"? With Informix I used a connection manager ...
0
votes
0answers
27 views

SQL Server replication model snapshot, transactional and merge - which method can be used

I am trying to implement sql server database replication between 2 branch servers to a Head Office Server. My application is a distributed one, the main application is hosted on head office which is ...