Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [master-slave-replication]

The tag has no usage guidance.

-3
votes
0answers
24 views

MySQL Replication via SSH Tunnel - Master Server ID same as Slave ID [closed]

I followed the below link to setup replication via SSH Tunnel. But the replication doesn't work as can be seen in the output below. mysql> show slave status\G; *************************** 1. row **...
1
vote
1answer
16 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
23 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
28 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
19 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
27 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
21 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
55 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
73 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
63 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
8 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
140 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
22 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
61 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
26 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
60 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
29 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
48 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
62 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
43 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
16 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
64 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
34 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
100 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
461 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
34 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
65 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
55 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
256 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
33 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
33 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
37 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
30 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
39 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
0answers
282 views

percona slave ERROR 1872 (HY000)

I have setup PXC on CentOS 7.5 and replication between PXC nodes is working just fine. However, when I try to set up a slave on one of the PXC nodes, I get this error when I run "START SLAVE". root@...
0
votes
1answer
66 views

Does the row locking on slave database also apply to master database?

In a transaction, for example, START TRANSACTION; SELECT count(*) as count FROM `order` WHERE user_id = 25286 LOCK IN SHARE MODE; INSERT INTO `order` (`id`, `user_id`, `product_id`) VALUES (NULL, '...
1
vote
0answers
103 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 ...
0
votes
1answer
145 views

Create a mysql replication from multiple master and single slave server? [closed]

How to create mysql replication with multiple master server and with single slave server? how to edit the "CHANGE MASTER TO MASTER_HOST='12.34.56.789',MASTER_USER='slave_user', MASTER_PASSWORD='...
0
votes
1answer
29 views

Mariadb 10.1.13 - log positions similar but “seconds behind master” is behind

The setup I have is a master/slave replication, both running Mariadb 10.1.13. On the slave I noticed that the Seconds_Behind_Master parameter is showing a delay due to some form of lagging, but the ...
0
votes
1answer
107 views

Mysql Slave Claims to be Running but New Records Not Appearing and No Delay

I've created a new mysql master and a slave. My master is also a slave of another running instance. The replication between those two works fine so I don't believe my issue is there. I created a dump ...
0
votes
1answer
22 views

MySQL how to migrate to new server without data lost?

I'm using AWS RDS, with 1 master & 1 slave. Just now I alter 1 of the table and hangup halfway, so I force stop the process. Now the database got some problem. Let say I wanted to instantiate a ...
2
votes
1answer
65 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
1answer
241 views

Master-slave replication doesn't work on PostgreSQL 9.6

I tried to create a master/slave configuration with two servers and Postgres 9.6 I modified master and slave postgresql.conf in /etc/postgresql/9.6/main Same for master and slave: data_directory = '...
0
votes
1answer
27 views

Some dates replicated with a +4 offset

I've set up replication between an EC2 instance as master and a MySQL 5.5 RDS instance as slave. Everything is (mostly) fine except for one odd thing: the dates in a transaction table are either ...
1
vote
1answer
72 views

Replication of databases with specific prefix on master

There are options to dynamically set variables on replication slaves, like replicate_wild_do_table and replicate_wild_ignore_table. But, are there any options for replication master to dynamically set ...
0
votes
1answer
76 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 ...
2
votes
1answer
499 views

MySQL Replication binary relay logs transfer too slowly

Master server MySQL 5.6.28 Ubuntu 14.04 8 core CPU Slave server Slave: MySQL 5.7.22 Ubuntu 18.04 16 core CPU Both of them have 64GB of RAM and plenty of disk space. What I did up to this ...