Questions tagged [master-slave-replication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
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
511 views

PostgreSQL logical replication slave - shouldn't it be read-only and available only for subscription updates?

I have database and table collection_city on one server. It has 21 rows. I have database and table collection_city on a second server. It also has 21 rows. They both have this row: tinker=# table ...
0
votes
1answer
388 views

PostgreSQL - PUBLICATION tries to copy the data which already exists in another database?

I have database and table collection_city on one server. It has 21 rows. I have database and table collection_city on second server. It also has 21 rows. They both have this row: tinker=# table ...
0
votes
1answer
2k views

Postgres Logical Replication - “replication slot ”mysub“ was not created in this database”

I have two database servers 192.168.150.210 and 192.168.150.220 I created publication and subscription successfully for logical replication. postgresql.conf file is modified on both servers. ...
0
votes
1answer
98 views

MySQL CLustering Options

I have two MySQL Database Servers i.e. One is Active Server --> Master and second is Passive Server --> Slave. And as we know we have 3-4 MySQL HR,DR Solutions / Clustering options.For example 01 : ...
0
votes
2answers
207 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 ...
0
votes
2answers
720 views

Upgrade Antelope to Barracuda on Slave

I received a Last_Errno: 1118, Last_Error: Error 'Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row ...
0
votes
1answer
38 views

Is there an option to prioritize a table while replication conflict occurs?

I have a master slave configuration for my production stage environment. Sometimes I need to write to some tables of my stage server i.e slave server. In that case conflicts occurs as content from ...
0
votes
1answer
57 views

MariaDB replication from master to slave

After doing some research around this topic, I should be attempting this task soon. However, I have two questions going around my head - could do with an experienced professional answering them. I am ...
0
votes
1answer
127 views

How to solve replication in MongoDB only with two machines?

I have two machines connected in a ring network, each one running Wildfly in HA mode using JGroups ant MongoDB in HA Mode using Replica Set. The machine 1 is the primary and machine 2 is secondary. ...
0
votes
1answer
149 views

What's the difference between Replicate_Wild_Ignore_Table & Replicate_Ignore_Table?

In my site's master/slave setup: Replicate_Wild_Ignore_Table = %.cache%, & Replicate_Ignore_Table is empty. What's the difference between the two?
0
votes
1answer
344 views

Create a mysql replication from multiple master and single slave server? [closed]

How to create mysql replication with multiple master server and with single slave server? how to edit the "CHANGE MASTER TO MASTER_HOST='12.34.56.789',MASTER_USER='slave_user', MASTER_PASSWORD='...
0
votes
1answer
29 views

Some dates replicated with a +4 offset

I've set up replication between an EC2 instance as master and a MySQL 5.5 RDS instance as slave. Everything is (mostly) fine except for one odd thing: the dates in a transaction table are either ...
0
votes
1answer
382 views

PostgreSQL Slave keeps xlog files with replication slot

I setup one master and two PostgreSQL servers (v9.6). In the master (and slaves) I set max_replication_slots = 2 and archive_mode is commented out everywhere. The replication works fine: There are no ...
0
votes
1answer
142 views

Row based replication on slave where as statement based on Master

We have a master slave setup of MYSQL 5.6. Master and slave runs SBR replication where as slave is not writing binlogs. We need to enable binlogs on the Slave server but we want the binlogs to be in ...
0
votes
1answer
128 views

Restore server instance using logical backup and wal files

Is it possible to restore a database instance using logical backup and wal files? A senior SQL Server DBA asked me to implement below scenario in PostgreSQL took the logical backup using pg_dumpall ...
0
votes
1answer
93 views

Do i need streaming replication slots as many of replicas in postgres?

Correct me if I am wrong but I’m thinking that if I have 4 different read only replica servers I need 4 streaming replication slots, one for each of them? Or all of them can you use one?
0
votes
1answer
147 views

MariaDB | Sync Master with Slave in another Datacenter

We have a web application hosted on a dedicated server at Datacenter A. I am in the process of setting up a disaster recovery protocol and am considering the following. My current plan is to purchase ...
0
votes
1answer
513 views

Too much data queued in replication slots

Periodically we run a batch process that sequentially backups (delete, vacuum and later remote storage in AWS' S3) for a set of about 20.000 tables with the following shell script: #!/bin/bash ...
0
votes
1answer
470 views

Can drbd be used for mongodb replication or active/passive setting?

From this guide we know DRBD can used for PostgreSQL Active/Passive setting: https://www.howtoforge.com/how-to-set-up-an-active-passive-postgresql-cluster-with-pacemaker-corosync-and-drbd-centos-5.5-...
0
votes
1answer
55 views

Can I edit queued MySQL binary logs for replication?

I have a simple Master-Slave replication set up, but Slave keeps falling behind do to what appears to be a simple checkout system. Master can keep up because it runs multi-threaded, but since the ...
0
votes
1answer
267 views

What sequence when changing the master MySQL server, but not IP?

I change the replica to the master server. But the IP master remains the same. * The second replica itself will continue to work, without changing the settings? * On the old master, just change ...
0
votes
1answer
44 views

Which server to be master and which one slave database?

I have an application for which I‌ want to set up a master/slave mysql database, because the current db struggles under high load. I have two different servers for db replication. Lets call them A ...
0
votes
1answer
306 views

Understanding Simple MongoDB Replication Works

I've been using MongoDB (3.2.9) replication for years and barely know the detail how it works. My Stack is Rails 4.2.5 with Mongoid 5.1.3. I've 3 database servers, let's call them A (Primary), B (...
0
votes
1answer
401 views

How to create a multiple mysql replication

My question is about to create a mysql replication server. Here i have multiple slaves and i want replicate all respective database into multiple master server . Que is that how could i set multiple ...
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 ...
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 ...
0
votes
2answers
40 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
81 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
0answers
43 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 ...
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
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
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 ...
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 ...