Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
273
questions
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
0
votes
0
answers
118
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 ...
- 1
0
votes
1
answer
260
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 ...
- 1
2
votes
2
answers
809
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?
- 23
0
votes
1
answer
923
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 ...
- 133
0
votes
2
answers
1k
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 ...
- 149
0
votes
0
answers
54
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
0
answers
26
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
1
answer
175
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 ...
- 125
2
votes
2
answers
793
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 ...
- 997
0
votes
1
answer
104
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 ...
- 95
0
votes
0
answers
40
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
1
answer
243
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.
...
- 117
1
vote
1
answer
194
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
1
answer
1k
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,
...
- 122
2
votes
1
answer
5k
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. ...
- 412
0
votes
1
answer
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 ...
- 144
1
vote
1
answer
980
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 ...
- 278
4
votes
0
answers
624
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 ...
- 41
2
votes
1
answer
1k
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
0
answers
360
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,
...
- 3,606
0
votes
2
answers
596
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
1
answer
866
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 ...
- 123
0
votes
1
answer
484
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?
- 103
2
votes
1
answer
387
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
1
answer
476
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, '...
- 103
1
vote
0
answers
414
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 ...
- 775
0
votes
1
answer
650
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='...
- 103
0
votes
1
answer
93
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 ...
- 123
0
votes
1
answer
465
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 ...
- 149
0
votes
1
answer
70
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 ...
- 111
3
votes
1
answer
414
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
1
answer
1k
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 = '...
- 23
0
votes
1
answer
31
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 ...
- 111
1
vote
1
answer
293
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 ...
- 113
0
votes
1
answer
265
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 ...
- 149
3
votes
1
answer
3k
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 ...
- 171
0
votes
1
answer
1k
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 ...
- 151
0
votes
1
answer
731
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 ...
- 21
2
votes
1
answer
842
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 ...
- 301
6
votes
1
answer
3k
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
1
answer
460
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/...
- 11
0
votes
1
answer
401
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
1
answer
175
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 ...
- 83
2
votes
1
answer
1k
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 ...
- 131
0
votes
2
answers
908
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 ...
- 131
2
votes
1
answer
4k
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 ...
- 21
2
votes
1
answer
324
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 ...
- 121