Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
273
questions
1
vote
1
answer
2k
views
What does running "show slave status" on a master server show?
We are using monitoring software that is throwing an error saying that Slave_IO_Running is returning No for replication on our master server. It is in fact true that when running show slave status on ...
- 167
0
votes
0
answers
508
views
MariaDB replication error 1236: 'Could not find first log file name in binary log index file'
I received an error during MariaDB replication that I'm not sure how to fix. Replication is a new topic to me and I acquired these databases and their architecture through a job, so I've done some ...
- 167
1
vote
3
answers
804
views
Automatically start SLAVE (mysql) Master Master
I performed the configuration of a database replication (slave), performed it as MASTER MASTER, however, every time I restart as machines, I need to manually start the slave
I use the command:
START ...
- 11
1
vote
1
answer
783
views
converting master node to slave node in postgresql streaming replication scenario
I have 2 identical PostgreSQL 13 server and configured streaming replication for both server. (nodeA is master, nodeB is slave)
It working very well normally. All DML, DDL operation replicates ...
- 15
0
votes
1
answer
57
views
Mysql 5.5 Master > Slave/Master > Slave Not working
I am trying to get a database that is the main database but replicates one database from another server to replicate both the replicated database and the local database to another slave.
SERVER1: ...
0
votes
2
answers
515
views
When queries start executing on standby server the replay lag starts to increase
I have a two servers with following specs:
8 vCPU, 32768 MB RAM, 640 GB SSD
The master Postgres 13.3 database (db1) is installed on first server (Ubuntu 16.04.7) with the following config:
...
- 111
1
vote
1
answer
840
views
Upgrading Postgres major version using logical replication
We have considered some options to upgrade our Postgres servers from the current (10) version to the latest (14). We decided no to do on the primary - since we need to do with the link option (so in ...
- 131
1
vote
1
answer
285
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 ...
0
votes
1
answer
295
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 ...
- 1
0
votes
1
answer
116
views
Best way to start Master - Slave replication
I'm trying to get replication set up between two servers with the eventual goal of switching the slave over to be the master (I'm trying to upgrade the hardware stack with as little interruption as ...
- 113
0
votes
0
answers
17
views
Replicating multiple unrelated servers
We have a bunch of live websites running simple LAMP stacks. We have nightly backups to the cloud, but this means that an event like the Strasbourg fire at OVH might happen just before your backup ...
- 101
2
votes
0
answers
93
views
Issues with failback for logical replication using postgres
I am using PostgreSQL 13 to set up logical replication. When the original active node (A) becomes the secondary, the prior secondary(B) which is now active node needs to sync to the (A) node.
To ...
- 121
0
votes
1
answer
225
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 ...
- 551
0
votes
0
answers
262
views
MySQL: slave log sequence number is in the future (but master is fine)
I have a master server replicating to a slave. I'm being plagued by this error message on the slave:
2021-07-01 08:39:25 7f04881ee700 InnoDB: Error: page 194 log sequence number 142640849934
InnoDB: ...
- 231
0
votes
1
answer
417
views
Why slave_parallel_workers affects TPM
I ran a few HammerDB benchmarks and mess with the configurations. And I notice different values of slave_parallel_workers have a considerable impact on TPM.
As far as I understand, ...
- 113
0
votes
1
answer
21
views
Replication setup
Currently, I have a production setup which consists of one Primary server and one Replica server, lets call them Primary1 and Replica1. All databases from Primary1 are replicating to Replica1.
Now, I ...
- 111
-1
votes
2
answers
163
views
How to make transactions atomic in Mysql 5.6
How do we make the following transactions atomic?
conn - is a connection to the old primary, which is being reset as replica now.
Python code
conn.execute('unlock tables')
conn.cursor().execute('stop ...
- 49
0
votes
1
answer
121
views
GCP Cloudsql Mysql Replica unresponsive after mass delete on Master
Directed here from S/O
We have a Master/Replica configuration for Mysql innodb(5.7.32) databases in Cloud SQL... We have a single Table (let's call it Master table) partitioned on Two keys having both ...
- 11
0
votes
1
answer
294
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 ...
- 21
0
votes
1
answer
89
views
How to setup Mysql master-slave replication with the slave meant for testing where divergence is OK
Problem:
I have a staging DB server on which functionality is tested before pushing it to the production environment. Now, we want to start doing VA/PT (Vulnerability Analysis and Penetration Testing) ...
1
vote
1
answer
294
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 ...
- 11
3
votes
0
answers
1k
views
Got fatal error 1236 from master when reading data from binary log
I am trying to do a MySQL failover, in some situations I endup with broken replication. Any idea what could be the cause of it ?
Background
Needed to perform a host updates on master host. Hence ...
- 49
2
votes
0
answers
231
views
Faster way to restore MySQL innoDB dump
I have a below MySQL configuration.
# The MySQL server
[mysqld]
....
key_buffer = 384M
max_allowed_packet = 5M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = ...
- 49
0
votes
1
answer
513
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 ...
0
votes
1
answer
143
views
High memory usage in Masters with MariaDB and Vitess
I'm running a Kubernetes Cluster with MariaDB 10.3.20 and Vitess 6. Everything is running fine, but the memory usage in the Master nodes is always around 90%. I don't have OOM right now, but I was ...
- 111
1
vote
1
answer
1k
views
How to properly restart a MySQL Master server?
We are running on Azure VM wherein you can not expand the attached disk while the VM is running. So we need to stop the VM first before doing anything on the disk size/performance.
We just have 1 ...
- 109
0
votes
1
answer
264
views
How to change MySql Master-Master Replication to Master-Slave Replication
I currently have MySql Master-Master replication set-up with Read_only on Master2.
There were lot of sync issues so I've stopped replication from Master2 to Master1 by stopping the Slave in Master1. ...
- 27
2
votes
3
answers
2k
views
What does this error mean "A slave with the same server_uuid/server_id as this slave has connected to the master;"?
Upon searching for this, the main cause of this error is usually when using snapshots or cloning the machine. But I did not do this. I perform mysqldump --master-data=2 on the master then restore the ...
- 109
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 ...
- 13
0
votes
2
answers
179
views
Does a single replica gives any performance improvement?
Consider a case where you have a single PostgreSQL database. Then you add a replica (hot standby) and you send all the reads to that replica. This is what does Rails for example.
Does this gives any ...
- 523
0
votes
1
answer
2k
views
Mysql Innodb Cluster Replication
Hello Everyone,
This is the first time I'm doing cluster replication. But I stuck on Adding Instance. I don't know why this error is coming behind. "The error says The START GROUP_REPLICATION ...
- 11
1
vote
2
answers
323
views
Is it possible to have 1 slave server with multiple master?
Here is my set of master server:
DbServer1 - 10.1.0.1
DbServer2 - 10.1.0.2
DbServer3 - 10.1.0.3
DbServer4 - 10.1.0.4
and my replica server would be on 10.1.0.5
Is this doable if I create 4 instances ...
- 109
1
vote
1
answer
312
views
Troubleshooting "Can't connect ..." from MySQL slave to master
Although I can connect from slave to master via a command-line mysql client, my slave can't connect to the master as part of its replication task. SHOW SLAVE STATUS cites a "Permission denied&...
- 190
-1
votes
1
answer
137
views
MySQL Master and Replica different size of files
Recently I noticed that my replica and master storage is quite different. To be exact replica takes 250GB more.
Both are dedicated servers, both are exact specs, both have exact disk drives and ...
0
votes
1
answer
895
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 ...
- 101
0
votes
1
answer
1k
views
mariadb: replication master and slave have equal MySQL server ids
I'm a novice mariadb user trying to set up a master with multiple slaves using mariadb-10.4.17 on fedora33.
I believe at one point I inadvertently ran the "change master" command on the ...
- 135
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 ...
- 81
1
vote
1
answer
130
views
Postgres 10 Log Shipped Replica with cascading replication
I'm planning for a tricky (at least for me) migration whereby I have master postgres 10 db from a cloud provider that will not allow for replication user connection. I do have a base backup and WAL ...
- 143
1
vote
1
answer
172
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 ...
1
vote
0
answers
222
views
How to hot merge MariaDb databases from multiple servers into a single one
Current Configuration
I currently have 3 servers:
server australia with the database canberra
servers belgium and germany are a galera cluster with the database bruxelles.
Target Configuration
My ...
- 111
1
vote
1
answer
436
views
High Available PostgreSQL with Patroni and Replication
I want to build a highly available PostgreSQL cluster using patroni with etcd. I want to have 3 server (1 master and 2 slaves) in my cluster, so if something goes wrong one of the slaves automatically ...
- 11
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. ...
- 21
2
votes
3
answers
248
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 ...
- 121
2
votes
2
answers
797
views
What is the maximum latency / distance mysql replication can tolerate without having errors or wrong data?
I have two machines in a master - slave replication. I want to know if they are in two seperate places e.g. London, England and Tokyo, Japan are there going to be any latency issues.
What exactly is ...
- 21
-1
votes
1
answer
271
views
Fault tolerance for Database sharding and Database partitioning
I'm aware that database sharding is splitting up of datasets horizontally into various database instances, whereas database partitioning uses one single instance.
In Database Sharding, what if one of ...
- 143
1
vote
0
answers
92
views
Getting error while starting slave on MySQL slave./ Backups in MySQL 8.0.20
I want to set up below command for daily MySQL database backup.suppose We have more than 50 MySQL database in server.
I am using below command to take backup of all databases on server.
Note: I am ...
- 133
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 ...
- 71
0
votes
1
answer
415
views
slow wal replay in backup postgres12 server
We have the following PG12 setup with Master, replica and readonly replica with archive.
master and replica both has 2cpu, 4gb ram
readonly replica with archive has 2 cpu, 2gb ram
below you can ...
- 1
1
vote
1
answer
330
views
PostgreSQL pg_rewind use cases
Let's say that I configured streaming replication between Server A (master) and Server B (slave). If server A goes down and Server B is promoted, would I be able to use pg_rewind, where Server B is ...
- 35
0
votes
0
answers
105
views
MySQL 5.7 Master-Slave Replication Functional but Not Replicating New Records
I've got a Master-Slave topology set up with the following two servers:
Master Information:
OS: GNU/Linux Centos 7.6.1810 (Core)
Kernel: 3.10.0-042stab140.4
MySQL version: 5.7.25
Server_id: 1
Slave ...
- 124