Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
198
questions
0
votes
0answers
22 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
23 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
20 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
23 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
13 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
16 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
14 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
40 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
38 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
15 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
16 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
35 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
32 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
49 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
28 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
80 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
29 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
23 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
37 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
42 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
64 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
27 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
90 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
66 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 ...
0
votes
1answer
12 views
Replication members count limitation in MongoDB
Is it possible to configure only one secondary and one primary in MongoDB Replication?
1
vote
1answer
38 views
Can a MySQL 5.6 master replicate to a 5.7 slave, which in turn replicates to a MySQL 8 slave?
According to the docs, "MySQL supports replication from one release series to the next higher release series. For example, you can replicate from a master running MySQL 5.6 to a slave running MySQL 5....
0
votes
1answer
14 views
question about MySQL5.7 server(Master) and a MariaDB 10.3(Slave)
I have question:
I want to install a MySQL5.7 server(Master) and a MariaDB 10.3(Slave).Replay SQL(select and update) on the slave server after SQL running on the master server.get slow sql log on ...
0
votes
0answers
13 views
Calculating Total Time Taken to Replicate
I wanted to know whether there are any open source tools or in built functions for generating replication metrics. Basically i wanted to calculate the time difference between changes in the Master vs ...
0
votes
1answer
20 views
How to add/update data from slave server to master server in MariaDB?
I am experimenting on whether I can tweak the functionality of master-slave replication. I can write data in my master server which gets updated in the slave server but it cannot happen the other way. ...
0
votes
1answer
99 views
Setting connection collation in master for slave replication
I am trying to replicate a MySQL 8 server (master) to MySQL 5.7 (slave) instance. I know it is not officially supported, but the thing is we need to use a service that has only supports MySQL 5.7.
I ...
1
vote
1answer
32 views
MySQL replication not finished on next site call
I have 3 MySQL8.0 instances. Two of them are slaves. Each site call I‘m reading the slave till the first write Request is made. Afterwards Only the Master is used during the request. Now, if I write ...
0
votes
1answer
203 views
MySQL 8.016 master with MariaDB 10.2 slave on AWS RDS, Character set '#255' is not a compiled character set
I have a MySQL 8.016 master and a MariaDB 10.2 slave, both running on AWS RDS. This was working perfectly until today, when I figured I wanted to do chain replication instead, like this
MySQL 8.016 ->...
0
votes
0answers
28 views
Alter Table operations blocks replication in MySQL
We are using Amazon Web Service's MySQL 5.7.26 with 4 read-only replicas. After some Alter Table operations we have found that the replication stops working. The symtoms are great replica lag that is ...
0
votes
2answers
105 views
MySql replication failed with error 1236 data position > file size with relay-bin file not increasing
My slave machine reset and now on SLAVE SHOW STATUS\G I have the error:
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start ...
0
votes
1answer
106 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 ...
1
vote
1answer
370 views
Replication Hung - Seconds_Behind_Master Increasing
One of my slave is no longer replicating. The seconds_behind_master continue to increase, Exec_Master_Log_Pos does not increase, and Relay_Log_Space does increase. Slave_IO_Running and ...
0
votes
0answers
25 views
create backup on mysql master-slave
I have MySQL version 5.7 with a master-slave configuration. but I'm confused to make a backup cron. Is there a way to do a backup while remaining safe to master-slave? I heard that using mysqldump is ...
0
votes
0answers
11 views
Does replica config parameter affect primary/master RDS Postgres?
I want to add hot_standby_feedback = on to a RDS readonly replica.
The problem is that the replica currently has a parameter group already attached, which is inherited from the master. My question is:...
0
votes
1answer
139 views
PostgreSQL 9.6 pg_rewind - takes a long time to replicate
I use Streaming Replication,and Replication works normally.
Two servers are HA and PostgreSQL DB is replicated.
The data in the DB is about 40G.
When a failover occurs, the slave is successfully ...
0
votes
0answers
49 views
issues with temporary table with proxysql using mysql replication
I have the following stage, we are implementing a database with 3 nodes with proxysql, this database is using percona xtradbcluster, inside the code is created a temporary table and is successful its ...
0
votes
1answer
80 views
How to resynchronize replica in Postgresql
I have a server with Centos6 and Postgresql 9.2, I have set up a replica in postgresql to another server of the same characteristics, today in the morning I have an error in the archiver process on ...
0
votes
1answer
58 views
mysqldump generating inconsistent dumps
I cannot get mysqldump to generate a dump that will properly restore. The dump is being generated to setup a new slave, but whenever the slave starts up, it gets foreign key constraint failures.
I'm ...
0
votes
1answer
51 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 ...
0
votes
0answers
115 views
Applying batch of row changes (delete) MySQL Replication Stuck
I am using Master Slave replication for master and slave .
Master Configuration
64 GB RAM 2 TB SSD
Slave Configuration :
16 GB RAM 2 TB SSD
My database size is 750 GB.
When i configured ...
0
votes
1answer
122 views
Can we replicate or restrict specific databases in MongoDB
In MySQL, we are having replicate-do-db/replicate-ignore-db during replication, where we can replicate or restrict specific databases from Master to Slave.
In the similar way, is there any specific ...
0
votes
1answer
371 views
MySQL [Bad handshake] error after update
I have MASTER-SLAVE configuration on 2 servers. The MySQL replication is set over SSL (I use self-signed certificates).
Everything had been working well. But today some packages (mysql also) were ...
1
vote
1answer
409 views
Is it possible to configure pgbouncer to distribute queries among master and slave?
We have master (write-read) and slave (readonly) Postgres 10 databases. Slave is online replication from master.
Now our application (c# webapi) connects to master only directly. We want to execute ...
0
votes
1answer
21 views
created and deleted a database on mysql slave host by mistake
I have 2 hosts: server1 (master) and server2(slave).
By mistake I've created and dropped a database "test" on server2(slave).
If the cluster will switch the master to server2, will there be any issues?...
0
votes
1answer
40 views
MySQL Fast Database Data Validation Master/Slave
I'm moving a MySQL database from the US to Australia and have a requirement where downtime is kept to an absolute minimum.
The database is 400GB is size, replication is working without any issues. ...
1
vote
3answers
173 views
Mysql master-slave config in my.cnf
I'm following this guide to setting up a master-slave config (https://support.rackspace.com/how-to/set-up-mysql-master-slave-replication/) and i'm confused about the end of the document where they are ...
