Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
285
questions
0
votes
2
answers
36
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 ...
- 23
0
votes
0
answers
14
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 ...
0
votes
0
answers
60
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 ...
0
votes
0
answers
28
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 ...
- 101
0
votes
0
answers
28
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 ...
0
votes
1
answer
66
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: ...
0
votes
0
answers
22
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 ...
- 13
0
votes
0
answers
49
views
MySQL Master Slave Asynchronous GTID Replication Failover 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 ...
-1
votes
1
answer
62
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 ...
- 1
0
votes
1
answer
70
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....
- 91
0
votes
1
answer
24
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 ...
0
votes
0
answers
133
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 ...
0
votes
1
answer
154
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, ...
0
votes
1
answer
82
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 ...
1
vote
0
answers
96
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 ...
0
votes
1
answer
97
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 ...
1
vote
1
answer
515
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 ...
- 13
0
votes
1
answer
36
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 ...
- 1
1
vote
1
answer
335
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" ...
- 21
1
vote
1
answer
167
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 ...
- 131
0
votes
0
answers
41
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 ...
- 1
1
vote
0
answers
259
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 ...
0
votes
0
answers
235
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 ...
1
vote
1
answer
47
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?
2
votes
1
answer
308
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, ...
- 121
0
votes
0
answers
9
views
Change replication name when importing dump with master log position
I exported data from an existing database to bootstrap replication. When setting --master-data to 1 or 2 for mysqldump it writes the log position to the dump file. However the generated command does ...
- 101
0
votes
1
answer
53
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 ...
- 117
0
votes
0
answers
81
views
MariaDB replication works via MASTER_LOG_FILE, almost instantly fails using MASTER_USE_GTID
We have a weird issue with MariaDB version 10.4.28+maria~ubu2004 (the official binary release for Ubuntu 20.04 LTS).
We dumped the master data using mariabackup (we have a single database), and ...
0
votes
1
answer
98
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 ...
- 105
1
vote
1
answer
253
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 ...
- 31
0
votes
1
answer
119
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 ...
- 153
0
votes
1
answer
1k
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 ...
0
votes
0
answers
179
views
Making backups with mariabackup from slave MariaDB. Best Way possible
I am trying to determine the best way to create backups from a MariaDB 1.4 slave, and I have the following questions:
Will creating backups affect the MariaDB slave replication and performance?
Is it ...
- 1
0
votes
0
answers
254
views
MySQL 8.0 replication lag high
Since we have upgraded from 5.7 to 8.0 (8.0.30-22), the servers don’t appear to be performing as well with the replication. The will frequently show 1 second repl lag, sometimes shooting up to 30 ...
- 1
4
votes
0
answers
653
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 ...
- 141
0
votes
0
answers
86
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....
- 51
0
votes
1
answer
204
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-...
- 500
1
vote
0
answers
41
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.
...
- 167
0
votes
1
answer
537
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/...
- 167
2
votes
1
answer
706
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 : ...
- 167
0
votes
1
answer
207
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 ...
- 111
0
votes
1
answer
259
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 ...
- 101
0
votes
1
answer
9k
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 ...
0
votes
2
answers
239
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 &...
- 3
0
votes
0
answers
114
views
Replication Lag while migrating a live database
I have a live database that is on a server(mysql 5.7) that I want to completely migrate to a droplet created on an infrastructure provider with (mysql 8.1). I would also like to have a master slave ...
1
vote
0
answers
101
views
MySQL : Huge table truncation in replication environment
We have 2 tables of size 186G and 63G that are no longer in use and needs to be truncated from the database.
I cannot directly run the truncate table statement on the master DB as it has 14 replicas ...
- 11
0
votes
1
answer
268
views
Problem with seconds_behind_master in mysql replication with galera cluster
I have the next infrastructure of mysql servers:
Node1 - MySQL 5.1.X
Node2 - MariaDB 10.3.X
Node3 - MariaDB 10.3.X
Node4 - MariaDB 10.3.X
Node1 is a master replication node.
Node2 is a slave ...
0
votes
2
answers
389
views
High Load MariaDB Cluster (Galera Multi Master Replication) - Same hardware needed for Slaves?
My Galera Cluster is on very high load.
To run it fine, I´m using strong hardware and for sure a lot of custom MariaDB settings and custom OS tweaks.
Now, I want to add Slaves to get "realtime&...
3
votes
1
answer
6k
views
Postgres max_wal_size and wal_keep_size parameter
I am setting up Postgres v14 database. I have a question related to the max_wal_size and wal_keep_size parameters.
According to the documentation:
max_wal_size ⇒ Maximum size to let the WAL grow ...
- 131
1
vote
0
answers
123
views
aws documentation for DMS CDC is confusing
I am following this documentation https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.Security to enable CDC using logical replication.
I have pglogical ...
- 71