Questions tagged [master-slave-replication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
296 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
206 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
1answer
27 views

mysqldump generating inconsistent dumps

I cannot get mysqldump to generate a dump that will properly restore. The dump is being generated to setup a new slave, but whenever the slave starts up, it gets foreign key constraint failures. I'm ...
0
votes
1answer
19 views

Can we replicate or restrict specific databases in MongoDB

In MySQL, we are having replicate-do-db/replicate-ignore-db during replication, where we can replicate or restrict specific databases from Master to Slave. In the similar way, is there any specific ...
0
votes
1answer
18 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 ...
0
votes
1answer
121 views

Master DB Ran Out Of Space

My master server ran out of space today (at 20:22). My transactions logs ended up broken into multiple files: -rw-rw---- 1 mysql mysql 228M Jul 31 20:22 mysql-bin.000914 -rw-rw---- 1 mysql mysql ...
0
votes
0answers
7 views

Applying batch of row changes (delete) MySQL Replication Stuck

I am using Master Slave replication for master and slave . Master Configuration 64 GB RAM 2 TB SSD Slave Configuration : 16 GB RAM 2 TB SSD My database size is 750 GB. When i configured ...
1
vote
1answer
100 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
136 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
1answer
78 views

MySQL [Bad handshake] error after update

I have MASTER-SLAVE configuration on 2 servers. The MySQL replication is set over SSL (I use self-signed certificates). Everything had been working well. But today some packages (mysql also) were ...
0
votes
2answers
138 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....
1
vote
1answer
25 views

Is it possible to configure pgbouncer to distribute queries among master and slave?

We have master (write-read) and slave (readonly) Postgres 10 databases. Slave is online replication from master. Now our application (c# webapi) connects to master only directly. We want to execute ...
0
votes
1answer
88 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
1answer
161 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 ...
0
votes
1answer
235 views

Row-row based logging in a blackhole replication filter setup?

I am using two MySQL server instances on the same server to filter replication to a third external server. My filter slave is using the blackhole engine as described here: https://dev.mysql.com/doc/...
0
votes
1answer
116 views

Restore server instance using logical backup and wal files

Is it possible to restore a database instance using logical backup and wal files? A senior SQL Server DBA asked me to implement below scenario in PostgreSQL took the logical backup using pg_dumpall ...
2
votes
1answer
334 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 ...
0
votes
1answer
101 views

Row based replication on slave where as statement based on Master

We have a master slave setup of MYSQL 5.6. Master and slave runs SBR replication where as slave is not writing binlogs. We need to enable binlogs on the Slave server but we want the binlogs to be in ...
-1
votes
1answer
254 views

bigchaindb set up and run cluster node error

I have been following the instructions given on: https://docs.bigchaindb.com/projects/server/en/latest/production-nodes/setup-run-node.html in an attempt to create a cluster. However I get this error ...
0
votes
1answer
18 views

created and deleted a database on mysql slave host by mistake

I have 2 hosts: server1 (master) and server2(slave). By mistake I've created and dropped a database "test" on server2(slave). If the cluster will switch the master to server2, will there be any issues?...
0
votes
1answer
352 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 ...
0
votes
1answer
33 views

MySQL Fast Database Data Validation Master/Slave

I'm moving a MySQL database from the US to Australia and have a requirement where downtime is kept to an absolute minimum. The database is 400GB is size, replication is working without any issues. ...
0
votes
1answer
346 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 ...
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
3answers
35 views

Mysql master-slave config in my.cnf

I'm following this guide to setting up a master-slave config (https://support.rackspace.com/how-to/set-up-mysql-master-slave-replication/) and i'm confused about the end of the document where they are ...
2
votes
1answer
106 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
251 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 ...
1
vote
0answers
21 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:~...
2
votes
0answers
23 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, ...
0
votes
2answers
324 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 ...
1
vote
1answer
33 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
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 ...
1
vote
1answer
646 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
25 views

Percona 5.7.24 : How to fix disk slave storage full

I find that my slave disk is full, but I don't understand what makes it full. Can anyone help me explain what this file is? And how it is formed, so that it makes lots of files that make storage full. ...
11
votes
2answers
25k views

Trying to understand SHOW SLAVE STATUS in MySQL

I have a Master-Slave replication setup and it looks like that it is running fine. Below is a result of SHOW SLAVE STATUS command: show slave STATUS\G; *************************** 1. row *************...
1
vote
1answer
131 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
889 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
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 ...
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 ...
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
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 ...
1
vote
2answers
34 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

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
32 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
1answer
22 views

MySQL replication without baseline data import

I've been reading about MySQL replication and all the resources I've looked at say that a data import (be it a mysqldump, or a raw data dump import) is needed before replication can start. I'm trying ...
1
vote
1answer
202 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 ...
0
votes
0answers
67 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
0answers
44 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
1answer
124 views

MariaDB | Sync Master with Slave in another Datacenter

We have a web application hosted on a dedicated server at Datacenter A. I am in the process of setting up a disaster recovery protocol and am considering the following. My current plan is to purchase ...
0
votes
0answers
18 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-...