Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
270
questions
1
vote
1
answer
976
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 ...
CommunityBot
- 1
0
votes
1
answer
292
views
MySQL slave stuck on Applying batch of row changes (read)
Might be duplicate of:
MySQL slave stuck on Applying batch of row changes (write)
or
MySQL8.0 Replication Got Stuck "Applying batch of row changes (delete)"
I am trying to use MySQL 8.0.26 ...
CommunityBot
- 1
0
votes
1
answer
3k
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 ...
CommunityBot
- 1
2
votes
1
answer
323
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 ...
CommunityBot
- 1
1
vote
2
answers
413
views
MySQL master slave replica interrupts after service restart or reboot
I've been using the master slave replica to keep a mySQL database and its disaster recovery perfectly aligned.
I noticed that unfortunately every time the mySQL service restarts, or one of the server ...
- 1,173
2
votes
2
answers
2k
views
Importing a large mysql dump while replication is running
So we have a simple master/slave mysql replication running between two CentOS Servers.
The master has multiple databases. eg..
Database1
Database2
Database3
The issue is we have a mysql dumpfile ...
CommunityBot
- 1
0
votes
0
answers
16
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 ...
- 24.3k
0
votes
1
answer
508
views
High Memory Usage on Replica - Mysql 8
Hope you're doing well.
We've recently moved to Mysql 8 (from Mysql 5.7).
We're using AWS RDS Service with MySql. The AWS Team is also looking for a solution btw.
Since a few days, we're facing ...
CommunityBot
- 1
1
vote
1
answer
284
views
replicate-wild-do-table=channel_name:db_name.% doesn't work in MySQL 8.0 for channel based replication
I am trying to configure a replication topology where there will be one slave which will connect to two masters. Percona Server 8.0.25.
Master1- main master
bkp_server - slave to master1 and ...
CommunityBot
- 1
0
votes
1
answer
252
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/...
CommunityBot
- 1
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 ...
CommunityBot
- 1
1
vote
1
answer
293
views
migrate mysql DB between two servers using replication
I need to perform some steps, I have to migrate our company live DB to a new server, if I use normal way such as lock table, mysqldump, scp, mysql restore, it take around 5-6 hours, so I want to make ...
CommunityBot
- 1
2
votes
1
answer
385
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 ...
CommunityBot
- 1
1
vote
0
answers
48
views
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 ...
- 1,173
0
votes
0
answers
52
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
1k
views
Could you monitor all changes made within a postgresql database by somehow subscribing to the replication log?
I've been reading about postgresql replication and was wondering if it was somehow possible to listen to the replication binary log and push that to some tool like sumologic or splunk so that any ...
CommunityBot
- 1
0
votes
2
answers
391
views
Can MongoDB manage balancing between the Mongos Dynamically using TCP Balancer
If I have a business where I maintain 10 applications and I need to divide the request load of these 10 applications between 3 Mongos Dynamically.
Like the TCP Loadbalancer need to connect to MongoDB ...
CommunityBot
- 1
1
vote
2
answers
3k
views
How to free up hard drive space after deleting millions upon millions of records in mariadb
We have an application where we are receiving information seconds apart, we record this information in a table that we call events, which currently weighs 240 GB, this is the largest we have so far.
...
CommunityBot
- 1
0
votes
1
answer
861
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 ...
CommunityBot
- 1
1
vote
1
answer
2k
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 ...
- 42.5k
2
votes
1
answer
369
views
MariaDB - Replication - Unable to login remotely
So I've been trying to configure MariaDB replication for our server. Unfortunately I cannot get it replicating correctly.
So I've followed the MariaDB guide to the letter to get replication set up. ...
CommunityBot
- 1
2
votes
1
answer
95
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
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 ...
CommunityBot
- 1
1
vote
1
answer
36
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?
- 7,223
1
vote
2
answers
2k
views
Broken Slave MySQL : How To Fix MySQL Replication (BINLOG) error in the Slave?
Before we start I can give some info about the versions,
Ubuntu - 14.04, MySQL - 5.5
I have successfully configured the Master-Slave replication with two EC2 Ubuntu instances. My master is in Ubuntu ...
CommunityBot
- 1
2
votes
3
answers
246
views
Why is it not a good idea to use MariaDB's extra_port for replication?
MariaDB has an extra_port for administrative access that helps in cases the thread pool or main port is locked up.
MariaDB's documentation says it's use case is primarily administrative access and it ...
CommunityBot
- 1
1
vote
2
answers
662
views
Split read/write requests over different read/write datasources
Recently I have run some performance tests on the application I work on, and it turns out that it didn't do really well ( the problem is mainly between the back and the DB). So as investigating the ...
CommunityBot
- 1
3
votes
2
answers
7k
views
Change host IP of master in mysql replication
I have one master and one slave. Suppose IP of master is changed but the physical server is same. Now I want to update the new IP (of the master) at the slave server. At the slave server ...
- 7,843
0
votes
0
answers
7
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
259
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 ...
CommunityBot
- 1
0
votes
1
answer
21
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 ...
- 569
0
votes
1
answer
473
views
Renaming multiple databases on a MySQL slave
I have 4 mysql databases that I'm replicating from a master to a slave. In the past, I have renamed one of them because the slave is also a dev server where it has a dev version of that schema with ...
CommunityBot
- 1
15
votes
3
answers
38k
views
Trying to understand SHOW SLAVE STATUS in MySQL
I have a Master-Slave replication setup and it looks like that it is running fine. Below is a result of SHOW SLAVE STATUS command:
show slave STATUS\G;
*************************** 1. row *************...
- 201
0
votes
2
answers
526
views
Should I write to MySQL slave (replica) for reporting?
I intent to put reporting/analytics database on slave and run job scheduler every night to aggregate and insert data from operational database to reporting database.
Should I do this or I have to ...
CommunityBot
- 1
2
votes
1
answer
550
views
sync_binlog different for master and slave
Is it fine if sync_binlog is different for master and slave?
For my system I can see master has sync_binlog=1 and slave has sync_binlog=0.
CommunityBot
- 1
1
vote
1
answer
1k
views
fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'
I'm getting the following error;
Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'
I've tried setting this up on 3 ...
CommunityBot
- 1
1
vote
1
answer
361
views
MySQL 5.7 Can slave be ahead of master during replication
From my understanding, once commit() is received from client, transactions are written to binlog first before any commit is done to InnoDB.
In this case, is it possible for slaves to be ahead of ...
CommunityBot
- 1
0
votes
0
answers
25
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
293
views
Archive logs Pg_archive cleaner
I have Postgres installed on windows 10. I have master-slave replication ( 1 pc is master and 2 other pc are slaves). I have archive logs saved on a file on master pc and slaves are connected to that ...
CommunityBot
- 1
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. ...
CommunityBot
- 1
0
votes
1
answer
46
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 ...
- 74.8k
1
vote
1
answer
80
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 ...
- 42.5k
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 ...
CommunityBot
- 1
0
votes
1
answer
440
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 ...
- 11
0
votes
1
answer
39
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 ...
- 42.5k
1
vote
1
answer
3k
views
Slave stoping with Last_SQL_Errno: 1032
I have added an extra Slave server to an existing MySQL Replication. The Master server and the old Slave server are working fine without any issue, but the newly added server is stoping with the ...
CommunityBot
- 1
0
votes
2
answers
329
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&...
CommunityBot
- 1
0
votes
1
answer
891
views
Mysql 8.0.22 master slave replication: why slave is trying to create user?
I am following this repo (https://github.com/alexanderfefelov/docker-mysql-replication) to setup one master one slave replication. I am not able to get it working. The master seems to be OK, but the ...
CommunityBot
- 1
2
votes
2
answers
790
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 ...
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 ...
CommunityBot
- 1