Skip to main content

Questions tagged [master-slave-replication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
44 views

MySQL Exec_Master_Log_Pos is slow to update in replica compared to actual data

I'm trying to use Exec_Master_Log_Pos from SHOW REPLICA STATUS to check whether the replica is caught up to the master. However, Exec_Master_Log_Pos appears to take a while to update. When I add a row ...
Victor L's user avatar
  • 101
0 votes
0 answers
20 views

How to enable keyring_file on replication server MySQL?

I recently activated the keyring_file plugin on my master server (5.7.44-enterprise-commercial-advanced-log), so the replication server presented errors when trying to execute alter table xxxxxx ...
alexandredelcol's user avatar
0 votes
0 answers
22 views

New MySQL 8.0 slave added to a 5.7 Percona Mysql cluster is stuck Waiting for dependent transaction to commit

I've tried following several guides to add a new Percona cluster as a slave to another cluster. The new cluster will run MySQL 8.0 while the old cluster needs to continue running 5.7 for a few more ...
VagrantPaladin's user avatar
0 votes
0 answers
27 views

Can't get hostname for your address flooded in error log even if skip-name-resolve is enabled and many unauth users in processlist in percona 8.0.25

Information about the currently configured percona servers : We are using percona 8.0.25 server. Mysql service is running with skip-name-resolve enabled. host_cache_size=753 but the ...
Sana Ansari's user avatar
0 votes
0 answers
14 views

AWS RDS MySQL read replica's failover and standby instance's failover

This question is for AWS RDS MySQL I have recently started studying RDS, trying to study from the documentation as well as other sources. For following scenario I am unable to understand certain ...
Avinash Pawar's user avatar
0 votes
0 answers
40 views

PostgreSQL Failure To Reinitialise Replica With pg_basebackup [duplicate]

I have a master-replica PostgreSQL 9.5 setup. I'm trying to reinitialize the replica by doing the following: Stop replica service ( /etc/init.d/postgresql stop ) Clear data directory ( rm -rf /path/...
Aaron Ullal's user avatar
1 vote
1 answer
66 views

Mysql 5.7 Slave replication is Slow

We are trying to debug a slave lag issue - it is currently lagging behind the master by 24 hours. Deployed on a AWS EC2 machine Database size is around 600 GB Grows at roughly 500 MB to 1 GB per day ...
user1428716's user avatar
0 votes
1 answer
179 views

MySQL master-slave stopped replication no Error on relay log

MySQL Master stopped sending updates 1 day ago to Slave there is no obvious error. Everything was working fine I tried to create DB, and Users, no updates on Slave also SO far I tried to remove the ...
awd's user avatar
  • 1
0 votes
0 answers
23 views

mysql replication on same server instances not working

I use sqlyog tool to work in MySQL. MySQL master-slave replication on same server replicates fine by using queries and restoring from the sqldump. But it doesn't replicate by using sqlyog tool. In ...
Sameerul Anwar's user avatar
1 vote
1 answer
262 views

Change server_uuid in MySQL

I want to know if there is any way to update server_uuid; I am trying master-slave replication, and I need different server_uuid. FYI - I don't have server_uuid in my my.cnf file, and when I update it ...
datascinalyst's user avatar
0 votes
2 answers
117 views

MySql binlog file getting truncated/shrinked during replication

There is a master-slave setup of a mysql db. The replication was going on fine until pos y when an error was thrown Client requested master to start replication from position > file size. I tried ...
toros's user avatar
  • 23
0 votes
0 answers
15 views

Need to build MySQL replication with TSL cert between onPremises server as Master and Azure flex server as Slave

I have a requirement Need to build MySQL replication with TSL cert between onPremises server as Master and Azure flex server as Slave . On Master & slave host ssl is enabled . also i have followed ...
Uday Raj Gupta's user avatar
0 votes
0 answers
270 views

Failed to start patroni

I am trying to configure patroni and etcd. Etcd is working fine, but patroni is failing to start. I have 3 servers, I have installed patroni and etcd on each server. When I try to start patroni on ...
Farid Zahidov's user avatar
0 votes
0 answers
72 views

Rename the slave Postgresql database name

I have Master-Slave streaming replication working well with postgresql 13. I created the slave from the master successfully and data is synching nicely to the slave. Can I just change the name of the ...
Shehan Simen's user avatar
0 votes
0 answers
52 views

Switch slave to new master

I have one master and 2 slaves in a mysql replication mode. All slaves are synchronised to the actual master. Because of space disk problem, I have to shutdown master_old to switch the first slave to ...
erwann le guevedec's user avatar
0 votes
1 answer
107 views

MySQL NDB Cluster Community - High memory utilization by mysqld only on source/replica nodes

I have two MySQL NDB community clusters 8.0.30, each with 3 VMs Cluster#1_VM1: mysqld + ndb_mgmd Cluster#1_VM2: mysqld + ndb Cluster#1_VM3: mysqld + ndb Cluster#2_VM1: mysqld + ndb_mgmd Cluster#2_VM2: ...
Marcin Stolzmann's user avatar
0 votes
0 answers
30 views

SQL Server Merge Replication using Web Synchronization - RESUMING SYNC

We are using MSSQL Merge Replication using Web Sync over extremely slow connection with many SQL Express subscribers. For some reason, occasionally, connection is dropped and the subscriber is trying ...
db-hopper's user avatar
0 votes
1 answer
85 views

MySQL Master Slave Asynchronous GTID Replication Failover/Switchover over ProxySQL with little downtime

This is a production setup and I have to perform a failover from Master A to new potential master B. MySQL Version is 5.7 and CentOS 7 is the OS. I have a simple master slave setup with A as Master ...
Avinash Pawar's user avatar
-1 votes
1 answer
78 views

Is there a difference between Range Type Partitioning & Temporal Data Tables (System-Versioned-Tables) in Maria DB 10.11.5?

I have a migration project (from Oracle) to Maria DB 10.11.5 (my choice). The needs of the database server are not ordinary. The database is to write to disk the results of software bots which are ...
Ed Nett's user avatar
0 votes
1 answer
99 views

Why data files are different on master slave nodes?

I recently set up a Postgres15 master-slave (Primary-secondary) cluster on 2 nodes. At the time of starting, I ensured that data files are exactly the same on both the nodes. The size of the DB is 1....
Abhishek B's user avatar
0 votes
2 answers
31 views

Replication Error: Last_IO_Errno: 1236 - Replicating two different channels from same master

Need little help with a production issue. Case: I had to migrate two schema from MasterA to MasterC. It would have been a simple exercise but because it was decided to migrate schema1 first and later ...
Avinash Pawar's user avatar
0 votes
0 answers
245 views

Regarding catalog_xmin in Replication slot

Definition of catalog_xmin from postgres Documentation:- The oldest transaction affecting the system catalogs that this slot needs the database to retain. VACUUM cannot remove catalog tuples deleted ...
manjunath's user avatar
0 votes
1 answer
369 views

Postgres hot_standby_feedback supersedes or uses vacuum_defer_cleanup_age?

According to this web article, the hot_standby_feedback parameter makes use of the vacuum_defer_cleanup_age parameter to calculate when it will send updates? According to the postgres documentation, ...
user68052's user avatar
0 votes
1 answer
183 views

Regarding Hot_standby_feedback parameter

I have seen in source code (https://github.com/postgres/postgres/blob/914e72e6e8d3e94346f3495dac36d46aa9912bb5/src/backend/replication/walreceiver.c#L1191) regarding XLogWalRcvSendHSFeedback function ...
manjunath's user avatar
1 vote
0 answers
162 views

MySQL -> MariaDB Replication throws Collation Error

We are moving from MySQL on AWS RDS to MariaDB on-premise. To do so without downtime, we planned to create a replication first between the MySQL master and the MariaDB slave and then promote the ...
Developer Jano's user avatar
1 vote
1 answer
165 views

How to interpret the contents of a replication slot state file in the data directory

We know that there is a state file for slot in the data/pg_replslot/<slot_name> directory. It is needed when server restarts after a crash. Questions: How is the data stored inside this state ...
manjunath's user avatar
1 vote
1 answer
922 views

MariaDB replication server's SQL Thread stuck at 'Waiting for prior transaction to commit'

Replication hangs often at a one Master - One Replica setup. From processlist the SQL worker threads seems to wait indefinitely with 'Waiting for prior transaction to commit' status. Once this happens ...
StackUser's user avatar
0 votes
1 answer
41 views

How to monitor mysql master - slave replication in windows os and failover in event of failure of master

I have a master and 3 slave all on windows OS. I need a tool I can use to monitor replication and failover to a slave incase the master is goes down. What tool do you recommend. I prefer open source ...
Shevy's user avatar
  • 1
1 vote
1 answer
780 views

How to resolve GTID difference between Master and Slave servers in MariaDB replication using MaxScale?

I wrote accidently directly on the Slave DB, and therefore the data is not in sync anymore. When I check MaxScale status, all servers are running, but the Slaves are not detected as "Slave" ...
Lucian Tarbă's user avatar
1 vote
1 answer
348 views

Write latency for adding an index on read replica

This is a question that I've not been able to find any good documentation for on the internet. I think it's a common industry standard that for tables with heavy writes, you add an index on the read ...
Sidharth Samant's user avatar
0 votes
0 answers
81 views

Docker instances with MySQL replication and reboot

After a reboot of the system with two docker instances with MySQL replication, the slaves always breaks the replication with a Slave_IO ending not running. Last time I had to redo all the process from ...
SirLouen's user avatar
1 vote
0 answers
632 views

SOLVED - Mariadb replication Master Slave fail with error code 1595

I've a strange problem. A Mariadb replication start failing since this morning. Until today everything works fine from month. This is my scenario: I've a server in a DC which is the master, and a ...
Paolo Daniele's user avatar
0 votes
0 answers
408 views

Error 13117 while setting up master-slave replication with both DB servers being on the same Mac M1 machine

I am trying to create a master-slave replication with both the Mysql Servers being on the same machine. The first mysql server, which I intend to keep as the master was installed using the Mysql ...
karan kapoor's user avatar
1 vote
1 answer
57 views

How to identify binlog_format for a specific query?

I have binlog_format set to MIXED and it states that mariadb will decide whether to use ROW or STATEMENT based logging for each query. Where can I see that information for a specific query?
Marko Milivojevic's user avatar
2 votes
1 answer
439 views

Setup proxysql read-write split with both galera cluster and master slave replication

I have the following setup: Three node galera cluster (galera-1, galera-2, galera-3) galera-2 is master to slave-1 (master-slave replication) slave-1 is master to both slave-2 and slave-3 slave-1, ...
supercoco's user avatar
  • 121
0 votes
1 answer
67 views

How/Why are in-flight transactions lost in synchronous replication in contrast to semi-synchronous

I'm reading through an article on why SQL databases are hard to scale and problems with ACID. Here's the link to the short article: Link Today's solution is usually post-write replication, where each ...
asn's user avatar
  • 127
0 votes
1 answer
141 views

Would MySQL Replication (master-slave) have prevented this problem?

I'm new to the idea of MySQL Replication (mainly because I've never really had data important enough to have redundancy until recently). Today I had a random crash of my MySQL 8 database with the ...
Ethan Allen's user avatar
1 vote
1 answer
453 views

What could be causing the delay in synchronous replication between the master and slave nodes?

I have 2 PostgreSQL 13 database, one acting as a master and the other as a slave, using streaming replication with synchronous_commit=remote_apply. This means that all data written to the primary ...
Rio Fajar's user avatar
0 votes
1 answer
194 views

Theoretical Question: What happens if replication is configured from primary postgres db on a deviated standby server?

I have a question: What happens if replication is configured from a primary Postgres server to a deviated standby server? To explain more: Lets say I did a PITR restore from a 1-week-old backup on a ...
Abraam Magued's user avatar
0 votes
1 answer
2k views

AWS RDS Can't complete Blue / Green changeover

I'm trying to do a Blue / Green changeover but it's failing with the error: Switchover from DB cluster asamazon2-cluster to asamazon2-cluster-green-xxxx was canceled due to external replication on ...
Nigel McLaughlin's user avatar
4 votes
0 answers
965 views

MySQL replication - Follower stuck and behind

I understand there are lots of similar problems and threads but non of those solution helped me. Please read through the thread I will try to give as much information as possible: I have setup a ...
Sisir's user avatar
  • 141
0 votes
0 answers
108 views

MySQL replication not synced

I set up a replica between two MySQL servers. After my initial setup, the replication worked without any problem, but now they are out of sync. On Master I can see: Variable Valor File mysql-bin....
Javi M's user avatar
  • 61
0 votes
1 answer
312 views

Set new MariaDB replica server by copying database files from another replica

A few tables in replica server (db2) were marked as crashed. We copied all database files (whole /var/lib/mysql) to another server (db3) in order to repair those tables. In the end we had to use pt-...
Ela's user avatar
  • 500
1 vote
0 answers
54 views

maximum number of physical replication on one server

I have a server with physical replication. It has been working very well till now. I follow the procedure here : https://linuxhint.com/setup-physical-replication-postgresql/ to create the replication. ...
padjee's user avatar
  • 187
0 votes
1 answer
965 views

find error log for streaming replication

Recently the streaming replication fails after I restart the primary. I can not find the record using select * from pg_stat_replication Now, I want to see it from the system log file at /var/log/...
padjee's user avatar
  • 187
2 votes
1 answer
1k views

Restart master in physical replication

I have 2 servers involving master-slave replication (physical replication). I see the replication using select * from pg_replication_slots; there is a record saying : user : rep_user` application : ...
padjee's user avatar
  • 187
0 votes
1 answer
248 views

MySQL replication fails with permission error for unknown reason

Since 36h I'm struggling to setup a simple Master <-> Master replication with MySQL 8. None of the found solutions on the Internet works here and meanwhile I'm a bit desperate. Even the first ...
Lars's user avatar
  • 111
-1 votes
1 answer
343 views

Read Replica block queries postgres

I've RDS PostgreSQL DB with read-replica. Also, have one script which frequently checks the blocking query but I faced one issue yesterday where the blocking query was a startup(backend_type)process ...
Kaushal panchal's user avatar
0 votes
2 answers
16k views

Mysql replication fails when the master's binary log increments

I am currently running 2 instances of 8.0.31 MySQL Community Server on two virtual machines. These are set up with one way replication. The replication runs fine once set up, but at some point it ...
M.Barbara's user avatar
0 votes
2 answers
348 views

How to perform mysqldump and import simultaneously?

I have a master database and a slave one. Recently, the slave has not synced with the master. So, I tried running mysqldump command to the master: mysqldump -h <master_host> -u <user> -p &...
duyl97's user avatar
  • 3

1
2 3 4 5 6