Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
270
questions
1
vote
1
answer
112
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. ...
- 798
1
vote
2
answers
103
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-...
0
votes
0
answers
641
views
MySQL8.0 Replication Got Stuck "Applying batch of row changes (delete)"
When I configured Master-Slave replication it was working fine but after five weeks it is showing the following error.
*************************** 1. row ***************************
...
- 1
1
vote
0
answers
316
views
How to check RDS MySQL database synchronization status
We were creating a read replica for an RDS MySQL (5.7.28) instance, and before the read replica became available one of our developer accidentally connected to the read replica and was able to write ...
- 11
0
votes
1
answer
21
views
Replication members count limitation in MongoDB
Is it possible to configure only one secondary and one primary in MongoDB Replication?
- 11
2
votes
1
answer
1k
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....
- 203
0
votes
1
answer
17
views
question about MySQL5.7 server(Master) and a MariaDB 10.3(Slave)
I have question:
I want to install a MySQL5.7 server(Master) and a MariaDB 10.3(Slave).Replay SQL(select and update) on the slave server after SQL running on the master server.get slow sql log on ...
- 3
0
votes
0
answers
24
views
Calculating Total Time Taken to Replicate
I wanted to know whether there are any open source tools or in built functions for generating replication metrics. Basically i wanted to calculate the time difference between changes in the Master vs ...
- 1
0
votes
1
answer
317
views
How to add/update data from slave server to master server in MariaDB?
I am experimenting on whether I can tweak the functionality of master-slave replication. I can write data in my master server which gets updated in the slave server but it cannot happen the other way. ...
- 42
0
votes
2
answers
572
views
Setting connection collation in master for slave replication
I am trying to replicate a MySQL 8 server (master) to MySQL 5.7 (slave) instance. I know it is not officially supported, but the thing is we need to use a service that has only supports MySQL 5.7.
I ...
- 115
1
vote
1
answer
103
views
MySQL replication not finished on next site call
I have 3 MySQL8.0 instances. Two of them are slaves. Each site call I‘m reading the slave till the first write Request is made. Afterwards Only the Master is used during the request. Now, if I write ...
- 13
3
votes
1
answer
2k
views
MySQL 8.016 master with MariaDB 10.2 slave on AWS RDS, Character set '#255' is not a compiled character set
I have a MySQL 8.016 master and a MariaDB 10.2 slave, both running on AWS RDS. This was working perfectly until today, when I figured I wanted to do chain replication instead, like this
MySQL 8.016 ->...
- 135
0
votes
0
answers
128
views
Alter Table operations blocks replication in MySQL
We are using Amazon Web Service's MySQL 5.7.26 with 4 read-only replicas. After some Alter Table operations we have found that the replication stops working. The symtoms are great replica lag that is ...
- 105
1
vote
2
answers
4k
views
MySql replication failed with error 1236 data position > file size with relay-bin file not increasing
My slave machine reset and now on SLAVE SHOW STATUS\G I have the error:
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start ...
- 9
0
votes
1
answer
473
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 ...
- 121
1
vote
1
answer
3k
views
Replication Hung - Seconds_Behind_Master Increasing
One of my slave is no longer replicating. The seconds_behind_master continue to increase, Exec_Master_Log_Pos does not increase, and Relay_Log_Space does increase. Slave_IO_Running and ...
- 149
0
votes
0
answers
182
views
create backup on mysql master-slave
I have MySQL version 5.7 with a master-slave configuration. but I'm confused to make a backup cron. Is there a way to do a backup while remaining safe to master-slave? I heard that using mysqldump is ...
0
votes
1
answer
419
views
PostgreSQL 9.6 pg_rewind - takes a long time to replicate
I use Streaming Replication,and Replication works normally.
Two servers are HA and PostgreSQL DB is replicated.
The data in the DB is about 40G.
When a failover occurs, the slave is successfully ...
0
votes
1
answer
300
views
How to resynchronize replica in Postgresql
I have a server with Centos6 and Postgresql 9.2, I have set up a replica in postgresql to another server of the same characteristics, today in the morning I have an error in the archiver process on ...
- 139
0
votes
1
answer
248
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 ...
- 101
1
vote
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 ...
- 111
2
votes
1
answer
1k
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 ...
- 997
1
vote
2
answers
2k
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 ...
- 121
2
votes
1
answer
4k
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 ...
- 121
0
votes
1
answer
29
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?...
- 123
0
votes
1
answer
119
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. ...
1
vote
3
answers
2k
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 ...
- 115
3
votes
0
answers
780
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:~...
- 569
2
votes
0
answers
192
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, ...
1
vote
1
answer
94
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.
...
- 113
1
vote
1
answer
361
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
0
answers
101
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 ...
- 413
0
votes
0
answers
37
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 ...
- 111
0
votes
0
answers
273
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 ...
- 101
1
vote
2
answers
662
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 ...
- 111
0
votes
1
answer
189
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 ...
0
votes
0
answers
344
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 ...
- 189
0
votes
2
answers
375
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
1
vote
1
answer
398
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 ...
- 133
1
vote
1
answer
1k
views
PostgreSQL logical replication slave - shouldn't it be read-only and available only for subscription updates?
I have database and table collection_city on one server. It has 21 rows. I have database and table collection_city on a second server. It also has 21 rows.
They both have this row:
tinker=# table ...
- 655
1
vote
1
answer
2k
views
PostgreSQL - PUBLICATION tries to copy the data which already exists in another database?
I have database and table collection_city on one server. It has 21 rows.
I have database and table collection_city on second server. It also has 21 rows.
They both have this row:
tinker=# table ...
- 655
0
votes
1
answer
5k
views
Postgres Logical Replication - "replication slot "mysub" was not created in this database"
I have two database servers 192.168.150.210 and 192.168.150.220
I created publication and subscription successfully for logical replication.
postgresql.conf file is modified on both servers.
...
- 655
0
votes
1
answer
150
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?
- 1,233
2
votes
1
answer
459
views
Master mysq8 slave Mariadb 10.3 Error 22
Master (mysql Ver 8.0.16)
Slave (mysql Ver 15.1 Distrib 10.3.15-MariaDB)
I have this error
Error 'Character set '#255' is not a compiled character set and is not specified in the '/usr/share/...
- 135
0
votes
1
answer
116
views
MySQL replication process parallel with user process?
I have process which executes query like below on Mysql(InnoDB) slave
INSERT ignore INTO user_profile_temp (some_fields)
select some_fields from user_profile
user_profile is bigtable of 8GB ...
- 165
0
votes
1
answer
212
views
MySQL CLustering Options
I have two MySQL Database Servers i.e.
One is Active Server --> Master and second is Passive Server --> Slave.
And as we know we have 3-4 MySQL HR,DR Solutions / Clustering options.For example
01 : ...
1
vote
0
answers
269
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 ...
- 111
0
votes
2
answers
1k
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 ...
- 101
0
votes
1
answer
220
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 ...
- 111
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 ...
- 101