Questions tagged [master-slave-replication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
728 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
0answers
8 views

Dump sql cloud mysql instance for external replica

I followed this guide to create an external replica of a cloud sql server: https://cloud.google.com/sql/docs/mysql/replication/configure-external-replica.I am getting this error when I try to start ...
1
vote
1answer
305 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
0answers
22 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 ...
1
vote
1answer
344 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 ...
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 ...
0
votes
2answers
207 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 ...
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 ...
0
votes
2answers
206 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....
2
votes
1answer
434 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 ...
0
votes
2answers
415 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 ...
2
votes
1answer
23 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
0answers
90 views

PostgreSQL streaming replication, incompatible locales between different systems?

I have a PostgreSQL 11 server on a windows 10 machine. That machine is used in a harsh environment, and a win32 client program is used with it. That program requires cp1250 charsets. The windows is a ...
2
votes
1answer
150 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
2answers
216 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
1answer
279 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
1answer
20 views

Why is it not a good idea to use MariaDB's extra_port for replication?

MariaDB has an extra_port for administrative access that helps in cases the thread pool or main port is locked up. MariaDB's documentation says it's use case is primarily administrative access and it ...
1
vote
1answer
145 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
13 views

Fault tolerance for Database sharding and Database partitioning

I'm aware that database sharding is splitting up of datasets horizontally into various database instances, whereas database partitioning uses one single instance. In Database Sharding, what if one of ...
2
votes
2answers
23 views

What is the maximum latency / distance mysql replication can tolerate without having errors or wrong data?

I have two machines in a master - slave replication. I want to know if they are in two seperate places e.g. London, England and Tokyo, Japan are there going to be any latency issues. What exactly is ...
0
votes
0answers
16 views

Mysql replication is running poorly on one of the slaves with no apparent changes

We have been using a master with 2 slaves for as long as I can remember with no major issues. Both slaves are lower in specification than the master so I do expect there to be lags at times and have ...
0
votes
1answer
89 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 ...
2
votes
1answer
592 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
2answers
87 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
1answer
134 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
0answers
14 views

How to turn on GTID on MariaDB if already using binary/position replication?

MariaDB 10.3 current master config [mysqld] log-bin server_id=1 binlog-format=mixed expire_logs_days=10 current slave config [mysqld] log-bin server_id=2 binlog-format=mixed expire_logs_days=10 I ...
1
vote
1answer
103 views

Does pg_export_snapshot work across replicas?

This is probably of little importance, but it's possible in PostgreSQL to retrieve the transaction snapshot with pg_export_snapshot and restore it with set transaction to start a second transaction ...
0
votes
1answer
108 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
0answers
40 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 ...
1
vote
1answer
134 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
2answers
40 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 ...
0
votes
1answer
468 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
1answer
446 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 ...
1
vote
1answer
353 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.
2
votes
1answer
181 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
1answer
273 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 ...
0
votes
1answer
15 views

slow wal replay in backup postgres12 server

We have the following PG12 setup with Master, replica and readonly replica with archive. master and replica both has 2cpu, 4gb ram readonly replica with archive has 2 cpu, 2gb ram below you can ...
1
vote
1answer
1k 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
2answers
366 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
16 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 ...
0
votes
0answers
35 views

PostgreSQL Streaming Replication with Switchover

I'm trying to provide streaming replication between a master (T1) and slave (T2) and swapping their roles when necessary (i.e letting T1 be a slave to T2). So far I am able to get this working if I'm ...
0
votes
0answers
32 views

MySQL 5.7 Master-Slave Replication Functional but Not Replicating New Records

I've got a Master-Slave topology set up with the following two servers: Master Information: OS: GNU/Linux Centos 7.6.1810 (Core) Kernel: 3.10.0-042stab140.4 MySQL version: 5.7.25 Server_id: 1 Slave ...
0
votes
0answers
51 views

Mysql 8 Replication and promoting slave to master

I am not using GTID based replication and I have only one master and one slave. This question is in general regarding Mysql 8 and I want to be prepared when I have to deal with production systems. I ...
1
vote
1answer
39 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
1answer
28 views

Postgresql Streaming Replication on Windows failover

Hello i have setup streaming replication using PostgreSQL 11 on Windows working OK. How can i manually use the replica ( it is hot_standby=on ) in case Master fails ? What are the steps i have to ...
0
votes
1answer
29 views

Do I need to redesign my Database and get rid of foreign keys for successful replication?

I plan to set up MariaDB replication either in master-master or master-slave mode. The main issue I have now are worries after reading this documentation. We use foreign keys a LOT and we also use a ...
0
votes
0answers
82 views

Mariadb replication slave broken

I run Mariadb 10.3 on a Debian 10.3 server. The database was standalone until now and worked fine. Now I want to set it up as a replication slave. I use this as a guide: https://www.linuxbabe.com/...
1
vote
2answers
38 views

MySQL replication master-slave

I'm learning master-slave replication with MySQL and I could get it to work and also use the Percona backup tool to restore a slave. I learnt from this project https://github.com/vbabak/docker-mysql-...
1
vote
1answer
23 views

SLAVE off when loading data into the MASTER from another database

I have an active MASTER/SLAVE replication (Mariadb 10.2) with a single database (see scenario 1) I decided to add in IMPORT database to populate the MASTER database as described in scenario 2. ...
0
votes
0answers
27 views

Mysql Replication-Master and two slaves

I have one master and 2 slaves,one is replicating but another slave which is read-only not replicating. From Master : show master status; +------------------+----------+--------------+---------------...