Questions tagged [master-slave-replication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
20 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 ...
0
votes
0answers
33 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 ...
0
votes
3answers
29 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 ...
1
vote
1answer
17 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 ...
0
votes
1answer
22 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
2answers
47 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: ...
0
votes
1answer
66 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 ...
0
votes
1answer
18 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
1answer
37 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 ...
0
votes
0answers
5 views

Slave is maxing memory usage when I'm performing a backup on master

Is there a way to optimize this? I am running a multi-source replica on my slave. As per my observation, whenever the biggest master DB (around 40GB) gets backed up, the slave's memory is being used ...
0
votes
0answers
20 views

pgbackrest: Is it possible to have repo and hot standby on the same node?

I am trying to use 2 nodes: Node A as primary node. Node B as standby + REPO node. Is it possible to do this? My configuration looks like this right now: Primary node - pgbackrest.conf [global] ...
0
votes
1answer
29 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 ...
0
votes
0answers
11 views

Mongo secondary unable to connect to primary

I have a cluster made of 4 mongo members: 1 arbiter, 2 secondaries, and 1 primary. The configuration is as follows: rs0:SECONDARY> rs.conf() { "_id" : "rs0", "...
0
votes
0answers
13 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 ...
2
votes
0answers
33 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 ...
0
votes
1answer
26 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 ...
0
votes
0answers
14 views

Why is it that my redis slaves are not promoting to master when requirepass, masterauth is enabled on my original master server?

I am running redis on 3 VMs. When authentication (requirepass, masterauth) is disabled, a slave will be promoted to be the master, but when I put authentication on it, no slaves are being promoted. ...
0
votes
0answers
48 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: ...
0
votes
1answer
39 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, ...
0
votes
0answers
14 views

Is there an option in redis for a slave to not be promoted to master?

What I want to accomplish is to not let my VM in Zone 3 be promoted to master? Is there such thing on Redis? Similar to mongo members.priority? Here is my setup Zone 1 redis-1 192.168.0.1 Zone 2 ...
0
votes
0answers
62 views

Privileges of mysql/mariadb replication accounts

I've created a replication account on a master(server1) and client(server2). This is the output of SHOW GRANTS FOR 'repl'@'192.168.1.%'; on a master; GRANT REPLICATION SLAVE, BINLOG MONITOR, ...
0
votes
1answer
14 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 ...
0
votes
0answers
13 views

How to do mysql 8.0.24 master-slave replication switch?

I am using two machines for mysql 8.0.24 master-slave replication, if the master database hangs, what action can the slave database take to become the master?
0
votes
0answers
53 views

Editing file /etc/mysql/my.cnf for Master-slave repllication

here is my "my.cnf" file: # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" ...
0
votes
0answers
11 views

After mysql 8.0.24 does master-slave replication, if the master database hangs, how does the slave database switch to the master database?

After mysql 8.0.24 does master-slave replication, if the master database hangs, how does the slave database switch to the master database? If it can switch, what are the exact steps? If switching is ...
-1
votes
2answers
74 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 ...
0
votes
0answers
15 views

How does the slave database server back up the logs of the master database server?

Now that the master-slave replication architecture for MySQL 8.0.24 has been built, how does the slave database server back up the logs of the master database server? I'm looking for transaction logs ...
0
votes
1answer
17 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 ...
0
votes
1answer
42 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 ...
0
votes
1answer
17 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) ...
0
votes
1answer
26 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 ...
0
votes
0answers
47 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 ...
2
votes
0answers
270 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
80 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
187 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
1answer
180 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
37 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
164 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
56 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
365 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
225 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
37 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
440 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
30 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
47 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
45 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
225 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
9 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
36 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
58 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. ...

1
2 3 4 5