Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
148
questions
0
votes
0answers
14 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
8 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
21 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 ...
1
vote
2answers
24 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
15 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
0answers
28 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
1answer
47 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
12 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
12 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-...
1
vote
1answer
29 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
41 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 ...
0
votes
1answer
31 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 ...
0
votes
1answer
116 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.
...
0
votes
1answer
21 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
vote
1answer
24 views
Master mysq8 slave Mariadb 10.3 Error 22
Master (mysql Ver 8.0.16)
Slaventer code heree (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 '/...
0
votes
1answer
28 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 ...
0
votes
1answer
36 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 : ...
0
votes
0answers
53 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
38 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
23 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
100 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
20 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
29 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
2answers
152 views
Change user password on slave
Our users can only access the slave database.
How can I let them change their passwords on their own or when their passwords expire?
0
votes
1answer
107 views
pt-table-sync: syncing slave from master that has different credentials?
I have a MySQL slave under my full control and a master server where I have only read-only login. Also, logins are different. At some point replication have stopped due to some kind of problem.
I ...
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
2answers
238 views
Upgrade Antelope to Barracuda on Slave
I received a Last_Errno: 1118,
Last_Error: Error 'Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row ...
0
votes
0answers
23 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 ...
0
votes
0answers
118 views
mariabackup --prepare after copying to slave
Hi dear community of smart people,
I'm setting up MariaDB master/slave replication and for the first time I have decided to try mariabackup utility for transferring the full database backup from ...
0
votes
0answers
18 views
MySQL: Ignore a Row in a table of a particular Database
I had replication in place between 3 databases, I am trying to ignore a Row in a table of a particular Database. I tried many ways but i couldn't, and also i couldn't find anything in online that ...
0
votes
1answer
27 views
Is there an option to prioritize a table while replication conflict occurs?
I have a master slave configuration for my production stage environment. Sometimes I need to write to some tables of my stage server i.e slave server. In that case conflicts occurs as content from ...
1
vote
1answer
94 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
58 views
How to reduce replication lag between master slave Aurora MySQL db instances?
AWS aurora MySQL master slave DB instances have high replication lag around 19 millisecond.
Please let me know how to reduce the replication lag time?
0
votes
0answers
49 views
Error 'Unknown Collation: '2048' on query
I'm doing MYSQL Replication for the first time.
Master mysql version: mysql Ver 14.14 Distrib 5.1.52, for pc-linux-gnu (i686) using readline 5.1
Slave Version: mysql Ver 14.14 Distrib 5.1.73, for ...
0
votes
0answers
72 views
mysql drop user has broken the replication
I was dropping a user on master. But that didn't execute on Slave. Instead its broken the replication.
GTID enabled Parallel
replication enabled.
On Master:
Binlog-do-db: prod_db
binlog-ignore-db: ...
0
votes
1answer
50 views
MariaDB replication from master to slave
After doing some research around this topic, I should be attempting this task soon. However, I have two questions going around my head - could do with an experienced professional answering them.
I am ...
0
votes
0answers
18 views
mysql cluster with 1 master 1 node and 2 slave
My Query is I want to set up MySQL cluster with 1 Master 1 Node and 2 Slave with Auto failover. If my master is down node should assign slave as a master.
Can anyone suggest me an idea to do that? As ...
0
votes
1answer
79 views
How to solve replication in MongoDB only with two machines?
I have two machines connected in a ring network, each one running Wildfly in HA mode using JGroups ant MongoDB in HA Mode using Replica Set. The machine 1 is the primary and machine 2 is secondary.
...
0
votes
1answer
55 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
153 views
global foreign_key_checks = 0 on RBR slave
Example schema:
CREATE SCHEMA account;
CREATE TABLE `user` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NULL DEFAULT NULL,
`address` VARCHAR(50) NULL DEFAULT NULL,
...
1
vote
1answer
701 views
MySQL Replication Slave Status OK but Data inconsistent
We are using MySQL 5.7, and have a Master and 3 Slave servers replication setup. All the 4 servers are dedicated for MySQL use only, and belong to the same data-center, connected over Private Network. ...
0
votes
1answer
35 views
Can i control access end point When some table data changed In Mysql Semisynchronous Replication
I'm trying to set up One master Multi slave in MySQL 5.7
My architecture is like this.
Master - First slave(sync)
Second slave, Third slave, Fourth slave, Fifth slave(async)
My question is, If ...
1
vote
1answer
80 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 ...
2
votes
0answers
99 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
284 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
0answers
38 views
Why slaveDelay is not respected by mongoDB replica?
I've seen related article below:
Mongodb replica config slaveDelay but data still sync immediately
My secondary node is set to be delayed by 3600 seconds:
...
"members" : [
{
"_id" : 0,
...
0
votes
1answer
36 views
Seconds_Behind_Master alternates between 0 and a number x
I have a slave server with mariadb 10.3.10 on debian 9. For several days the server has been working correctly, Seconds_Behind_Master was always kept at 0 indicating that it was properly synchronized. ...
0
votes
1answer
45 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
1answer
43 views
What's the difference between Replicate_Wild_Ignore_Table & Replicate_Ignore_Table?
In my site's master/slave setup:
Replicate_Wild_Ignore_Table = %.cache%, &
Replicate_Ignore_Table is empty.
What's the difference between the two?
1
vote
1answer
43 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 ...
