Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
0
votes
0answers
9 views
MySQL: change from master/multi-slave setup to master/master/multi-slave
I have the following master / slave configuration using mysql: 1 master and 3 slaves (slaves used in time-consuming queries for reports).
I need to know if it is possible to convert a slave to master ...
-1
votes
0answers
18 views
What would happen if I write to the database that act as Slave and Master at the same time? [on hold]
slave-master still sync data from master?
if it sync, the data will the same as master if I insert some data to slave-master before.
1
vote
0answers
13 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,
...
0
votes
0answers
7 views
how to switch between master and slave instances in different zones for apsaradb
I am using ApsaraDB for RDS on Alibaba Cloud. According to Alibaba Cloud Each high-availability instance consists of a master instance and a slave instance. How I can switch between master and slave ...
1
vote
1answer
57 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
32 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
29 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
0answers
13 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 ...
0
votes
0answers
7 views
Data for only 2 tables not getting replicate on slave
I have set up of Master slave in MIXED binlog format. All servers are 5.6.22 version.
On master data is getting inserted but on slave for two tables data is not getting replicate. For other tables and ...
0
votes
0answers
7 views
Identify Replication Lag
I'm having replication lag issues using mysql Ver 14.14 Distrib 5.6.39-83.1, for Linux (x86_64) using 6.2. I've gone through this doc https://www.percona.com/blog/2014/05/02/how-to-identify-and-cure-...
2
votes
1answer
34 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
18 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
22 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
22 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
12 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
21 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
50 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
18 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, '...
0
votes
0answers
34 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
26 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
0answers
41 views
pglogical - Table Replication with pglogical, locks on sync_init status
I've successfully installed and got working a pglogical replication between 2 servers:
Provider: Postgresql 9.4
Subscriber: Postgresql 9.6
From time to time, I need to add some tables (or entire ...
0
votes
0answers
27 views
MYSQL 5.6 Replication broken in mixed base binlog format
I am using MySQL replication with binlog_format=mixed on master, but still Im getting error 1032 many times.
Last_SQL_Error: Could not execute Update_rows event on table mydb.mytable; Can't find ...
0
votes
1answer
21 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
35 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
18 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
31 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
66 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
23 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
34 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
0answers
82 views
Postgresql Replication stopped unexpectedly Slave server's service is not starting. How can I Resume replication?
Postgres Replication was working fine with Postgresql version 9.5. when the template of a DB with 10gb of data was created and then the slave server stopped. Its Postgres service is not starting now. ...
0
votes
1answer
55 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
149 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 ...
0
votes
1answer
173 views
MariaDB master-slave replication failover and failback
I'm trying to configure a DR instance of MariaDB (10.1.13) using master-slave replication.
I was able to establish the master-slave relationship with GTID by locking the tables on master, backing up ...
0
votes
0answers
62 views
Add new slave in MariaDB Replication
I have a Master server (A) and a Slave server (B). B is getting replicated from A [all the dbs (db1,db2,db3) except few tables]. Now, I need to add one more Slave but It has to replicate only db1 and ...
0
votes
1answer
90 views
PostgreSQL Slave keeps xlog files with replication slot
I setup one master and two PostgreSQL servers (v9.6). In the master (and slaves) I set max_replication_slots = 2 and archive_mode is commented out everywhere. The replication works fine: There are no ...
1
vote
0answers
410 views
Slave is running behind master on some slaves [closed]
I have set up of master and 300 slaves. Into this many Slaves are bare metals which are having more slaves as tail end nodes.
All mysql versions are 5.6.22
Binlog format is MIXED based. sync_binlog = ...
0
votes
0answers
25 views
percona mysql key_buffer_size value on replication slave
I noticed way odd behavior of replication slave due to altering key_buffer_size parameter.
I have 5.6.39 version of percona mysql and RAM 257671MB, according to the articles in the Internet i ...
1
vote
1answer
120 views
Why is MDB 10.2.14 not handling deadlocks properly when it did prior to upgrade from 10.1.22
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
0answers
162 views
Master-slave replication in MariaDB
I worked around with Master-slave replication in Mariadb 5.5.52 on RHEL 7.3 environment.
Master:
[mysqld]
log-bin
server_id=1
binlog-do-db=nagios
binlog-do-db=nagiosql
binlog-do-db=nagiosxi
bind-...
1
vote
0answers
514 views
Queries running very slowly in Amazon RDS PostgreSQL read-replica
We have been maintaining a project which has both web and mobile application platform. The backend of the project is developed in Django 1.10 and deployed in AWS.
At the beginning, when there were ...
0
votes
1answer
66 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
56 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 ...
0
votes
1answer
52 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 ...
1
vote
1answer
251 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
2answers
52 views
slave mysql configuration is not stored
EDIT
It seems that the problem is with my SSH connection, so I created a different question on serverfault. From what I understand so far, it that this problem is caused from the fact that the port ...
1
vote
1answer
894 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
0answers
146 views
Postgresql - Unable to connect slave after replication starts, but able to connect from remotely
I have a PostgreSQL master/slave setup. Today I created a new slave from the existing slave (cascading replication).
Master: 10.0.0.1
Slave1: 10.0.0.2
Slave2: 10.0.0.3 (this is the new one I have ...
1
vote
1answer
54 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
1answer
378 views
mariadb Unknown system variable 'server_uuid'
Im trying to setup replication between mariadb(10.1.31-MariaDB - MASTER) and mysql(5.7.12-log - SLAVE). After executed the start slave, I got the below error.
Fatal error: The slave I/O thread ...
1
vote
1answer
34 views
Howto reliably ship WAL log files between master and slave
I have a replication master and a slave on two different computers. Actually both databases are running in docker containers, and their WAL archive directories are exposed to the host machine using ...
