Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
220
questions
0
votes
0answers
10 views
PostgreSQL Slave unable to catch up with the Master
We have a four node Patroni cluster setup wherein one of the nodes is unable to catchup with the leader because of huge lag. I have tried the below steps but none of them are working.
Restart the ...
1
vote
0answers
31 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 ...
1
vote
0answers
24 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 = ...
1
vote
0answers
27 views
Error 1062 : Duplicate entry on the slave after a failover
I need a little bit of help for this problem :
I got this error :
Could not execute Write_rows event on table ....; Duplicate entry '16XXXXX-\xE790\XXXXXXX-16XXXXXX' for key 'PRIMARY', Error_code: ...
0
votes
0answers
53 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
1answer
30 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 ...
1
vote
1answer
9 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 ...
0
votes
1answer
24 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. ...
1
vote
1answer
28 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 ...
0
votes
1answer
70 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 ...
0
votes
1answer
30 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 ...
0
votes
1answer
71 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 ...
1
vote
2answers
27 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 ...
0
votes
1answer
26 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&...
-1
votes
1answer
39 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
0answers
40 views
Mongo Atlas connection error type=UNKNOWN, state=CONNECTING
Yesterday I've seen some strange behavior that my application can't connect to Atlas.
This has never happened before for about 1 year, and there was no application deploying going on.
The error that ...
0
votes
0answers
8 views
Pgpool create a cluster node with no application traffic
I have a pgpool cluster with 2 standby and 1 primary node. I am trying to create another node which will get replicated but will not handle any request or application traffic. It will solely be use ...
0
votes
0answers
15 views
Make slave has same “general_log” table like master server
Apologize for my English. I'm very new to database administration. I've been trying to set up MariaDB replication server by following this document.
The only data that I need to replicate is in a ...
0
votes
0answers
25 views
Binlog is not being updated in Master
I am using mysql 5.6.19-log MySQL Community Server (GPL). I have done the necessary changes in my.cnf to start Master<->Slave Replication. But binary files are created and but they are empty.
...
0
votes
1answer
78 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 ...
0
votes
1answer
109 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 ...
1
vote
2answers
196 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 ...
1
vote
1answer
19 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 ...
1
vote
1answer
18 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
0answers
45 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 ...
0
votes
0answers
25 views
Dump sql cloud mysql instance for external replica
I followed this guide to create an external replica of a cloud sql server: https://cloud.google.com/sql/docs/mysql/replication/configure-external-replica.I am getting this error when I try to start ...
0
votes
0answers
42 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 ...
2
votes
1answer
92 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. ...
1
vote
1answer
27 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 ...
2
votes
2answers
80 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 ...
0
votes
1answer
28 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 ...
0
votes
0answers
22 views
Mysql replication is running poorly on one of the slaves with no apparent changes
We have been using a master with 2 slaves for as long as I can remember with no major issues. Both slaves are lower in specification than the master so I do expect there to be lags at times and have ...
0
votes
0answers
25 views
How to turn on GTID on MariaDB if already using binary/position replication?
MariaDB 10.3
current master config
[mysqld]
log-bin
server_id=1
binlog-format=mixed
expire_logs_days=10
current slave config
[mysqld]
log-bin
server_id=2
binlog-format=mixed
expire_logs_days=10
I ...
1
vote
0answers
60 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 ...
0
votes
2answers
341 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 ...
0
votes
1answer
23 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 ...
0
votes
1answer
54 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 ...
0
votes
0answers
159 views
PostgreSQL Streaming Replication with Switchover
I'm trying to provide streaming replication between a master (T1) and slave (T2) and swapping their roles when necessary (i.e letting T1 be a slave to T2). So far I am able to get this working if I'm ...
0
votes
0answers
33 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 ...
0
votes
0answers
288 views
Mysql 8 Replication and promoting slave to master
I am not using GTID based replication and I have only one master
and one slave. This question is in general regarding Mysql 8 and I want to
be prepared when I have to deal with production systems. I ...
0
votes
1answer
50 views
Postgresql Streaming Replication on Windows failover
Hello i have setup streaming replication using PostgreSQL 11 on Windows working OK.
How can i manually use the replica ( it is hot_standby=on ) in case Master fails ?
What are the steps i have to ...
0
votes
0answers
249 views
Mariadb replication slave broken
I run Mariadb 10.3 on a Debian 10.3 server. The database was standalone until now and worked fine. Now I want to set it up as a replication slave. I use this as a guide:
https://www.linuxbabe.com/...
0
votes
1answer
36 views
Do I need to redesign my Database and get rid of foreign keys for successful replication?
I plan to set up MariaDB replication either in master-master or master-slave mode. The main issue I have now are worries after reading this documentation.
We use foreign keys a LOT and we also use a ...
1
vote
1answer
39 views
SLAVE off when loading data into the MASTER from another database
I have an active MASTER/SLAVE replication (Mariadb 10.2) with a single database (see scenario 1)
I decided to add in IMPORT database to populate the MASTER database as described in scenario 2. ...
1
vote
2answers
53 views
MySQL replication master-slave
I'm learning master-slave replication with MySQL and I could get it to work and also use the Percona backup tool to restore a slave. I learnt from this project https://github.com/vbabak/docker-mysql-...
0
votes
0answers
151 views
PostgreSQL Streaming Replication: no pg_hba.conf entry for use from host
I have been trying PostgreSQL streaming replication for couple of days using link https://www.percona.com/blog/2018/09/07/setting-up-streaming-replication-postgresql/
I have edited my master pg_hba....
0
votes
0answers
149 views
MySQL8.0 Replication Got Stuck “Applying batch of row changes (delete)”
When I configured Master-Slave replication it was working fine but after five weeks it is showing the following error.
*************************** 1. row ***************************
...
0
votes
0answers
31 views
Mysql Replication-Master and two slaves
I have one master and 2 slaves,one is replicating but another slave which is read-only not replicating.
From Master :
show master status;
+------------------+----------+--------------+---------------...
0
votes
0answers
226 views
PostgreSQL streaming replication, incompatible locales between different systems?
I have a PostgreSQL 11 server on a windows 10 machine. That machine is used in a harsh environment, and a win32 client program is used with it. That program requires cp1250 charsets. The windows is a ...
1
vote
0answers
130 views
How to check RDS MySQL database synchronization status
We were creating a read replica for an RDS MySQL (5.7.28) instance, and before the read replica became available one of our developer accidentally connected to the read replica and was able to write ...
