Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
293
questions
0
votes
1
answer
391
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 ...
CommunityBot
- 1
1
vote
1
answer
423
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
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
2
answers
352
views
MySQL DB as Master for some tables and Slave for others
I have 2 DBs - DB1 (back-office) and DB2 (web application). The data needs to be synced between the 2. I'm happy with the idea of full master-master replication and may have to implement it, but ...
CommunityBot
- 1
2
votes
1
answer
455
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
0
votes
3
answers
658
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
2k
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
4
votes
1
answer
786
views
Does a MySQL replication slave need to be as powerful as the master?
I want to back-up my MySQL server on another server in another location (for data safety). The problem is the other server is half as powerful as the main one.
I don't need the server to be 100% ...
- 15.5k
0
votes
1
answer
465
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, ...
CommunityBot
- 1
0
votes
0
answers
17
views
Reset replica of multi-master
We have a master-master binlog replication using MySQL 8.0 where only master1 is written to by the application and master2 is pretty much a hot standby. I had a replica of master2 where that server ...
- 101
0
votes
0
answers
98
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 ...
0
votes
2
answers
456
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
937
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
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
0
votes
1
answer
1k
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
0
votes
1
answer
388
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 ...
CommunityBot
- 1
1
vote
1
answer
412
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 ...
CommunityBot
- 1
1
vote
1
answer
439
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
1
answer
29
views
On running multiple mysql slaves using same data directory
In our production system, we have 8 slave databases of 17tb size each. data is being replicated from common master in real time to these slaves .
now my question is can i
run mysql slave on a ...
- 1,750
2
votes
1
answer
630
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
2
votes
1
answer
3k
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
0
answers
14
views
MongoDB Replicaset secondary nodes using more disk space than primary
Mongodb v4.4.29
I have a replicaset with Single Primary, 2x Secondaries. All three are hosted on AWS using t3.large instances, with volumes attached formatted as XFS.
But i noticed 2 weeks ago the ...
- 11
0
votes
1
answer
577
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
1
vote
1
answer
156
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 ...
- 21
0
votes
1
answer
505
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
479
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
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
2
votes
1
answer
516
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, ...
CommunityBot
- 1
1
vote
2
answers
1k
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 ...
CommunityBot
- 1
0
votes
1
answer
378
views
Mysql Replication trigger not executing on slave
Mixed replication is enabled.
MySQL master has a table Products that has triggers on update and delete. On slave database we have different trigger on same table on update and delete.
Master database ...
CommunityBot
- 1
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
439
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
494
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
1k
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
1
answer
368
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
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
1
vote
1
answer
1k
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
2
answers
18k
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
0
votes
1
answer
1k
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
1
answer
811
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
0
votes
0
answers
50
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 ...
- 97
1
vote
1
answer
446
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
0
answers
23
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 ...
0
votes
0
answers
35
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 ...
0
votes
0
answers
47
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 ...
0
votes
0
answers
20
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 ...
- 216
0
votes
2
answers
38
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 ...
- 216
0
votes
1
answer
107
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 ...
- 216
2
votes
2
answers
4k
views
Postgresql - increase WAL retention to avoid slave go out of sync with master
I've setup a master / slave Postgresql (13.4) group, 1 master and 1 slave, using WAL warm standby.
(refer: https://postgresql.org/docs/current/warm-standby.html#STANDBY-SERVER-SETUP)
The slave gone ...
- 3,672
0
votes
3
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 ...
- 145