Questions tagged [master-slave-replication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
51 views

AWS RDS database replication replicates everything regardless my parameters group

I have a database in RDS that I want to replicate. I made a parameter group where I described which tables I want to be replicated. I applied it to my replica, and still it replicated the whole ...
user avatar
1 vote
1 answer
26 views

MySQL master slave replica interrupts after service restart or reboot

I've been using the master slave replica to keep a mySQL database and its disaster recovery perfectly aligned. I noticed that unfortunately every time the mySQL service restarts, or one of the server ...
user avatar
  • 11
0 votes
1 answer
21 views

Slaves replication not working

Hi, please help me!!! please find the attached error screenshot, i'm getting that error in the master server Thanks,
user avatar
  • 11
0 votes
2 answers
44 views

How to free up hard drive space after deleting millions upon millions of records in mariadb

We have an application where we are receiving information seconds apart, we record this information in a table that we call events, which currently weighs 240 GB, this is the largest we have so far. ...
user avatar
0 votes
0 answers
8 views

MYSQL Cluster replication issue: Update did on table not replicated on slave

I have setup master---slave channel replication but facing issue replication of statement on tables from master to slave NOT OK. New tables created are replicated while update on tables are not ...
user avatar
  • 1
2 votes
1 answer
41 views

Fix mysql replication crashed due to underlying storage corruption

we have critical database server running on two virtual machines. one virtual machine crashed due to underlying storage problem and we had to move it to different storage medium and recover the xfs ...
user avatar
0 votes
0 answers
43 views

Postgres13 logical replication degrading slowly

We're halfway through a postgres upgrade (from 11 to 13) and have run into a pretty unusual blocker, being that our 13 logical replica can't seem to keep up with changes from our 13 master. For ...
user avatar
0 votes
0 answers
10 views

execution time increases after turning off read replica in postgres

The task was assigned to me to check the performance of uploads and query execution separately for "read replica" turned on and turned off. Surprisingly when "read replica" was ...
user avatar
2 votes
2 answers
277 views

How to avoid replication lag in case all writes on master and reads on replica?

I have stuck with the replication lag problem. I am trying to refactor my DB infrastructure. The first step was read-write split. I used ProxySQL то implement it. Now I have masterDb where all INSERT ...
user avatar
-1 votes
1 answer
23 views

Mysql replication Ignore specific table

I want to exclude some table for replication in slave db. How i can do it. what steps needs to be implement on master server or slave server? I dont want anymore some tables in slave server. is there ...
user avatar
0 votes
0 answers
61 views

replicate-wild-do-table causes unknown database error My-001049 for CREATE PROCEDURE on not replicated schema

OS: RHEL 7.7 Percona server 8.0.26-16 I am trying to create a simple replication topology with one master and one slave. The master has 9 schema out of which three are being replicated to the slave. ...
user avatar
0 votes
1 answer
38 views

Replication from multiple masters to one slave

I have 2 Raspberry PI's and each run a MariaDB 10.3 server. Each has the same databases: vennens scheduler On the slave I've configured the 50-server.conf file with follow contents: master_pi1....
user avatar
2 votes
1 answer
197 views

Postgresql - increase WAL retention to avoid slave go out of sync with master

I've setup a master / slave Postgresql (13.4) group, 1 master and 1 slave, using WAL warm standby. (refer: https://postgresql.org/docs/current/warm-standby.html#STANDBY-SERVER-SETUP) The slave gone ...
user avatar
  • 179
0 votes
1 answer
152 views

Postgresql - recover slave after out of sync with master using WAL

I've setup a master / slave Postgresql (13.4) group, 1 master and 1 slave, using WAL warm standby. (refer: https://postgresql.org/docs/current/warm-standby.html#STANDBY-SERVER-SETUP) But, due to some ...
user avatar
  • 179
0 votes
1 answer
47 views

MariaDB master-bin Log Rotation

I've just setup MariaDB replication with 2 slaves in Debian 11 (Bullseye). I'm a bit alarmed to see the file size reach such a size without log rotation: -rw-rw---- 1 mysql adm 297394983 Dec 8 05:...
user avatar
1 vote
1 answer
233 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 ...
user avatar
0 votes
0 answers
189 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 ...
user avatar
0 votes
3 answers
95 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 ...
user avatar
1 vote
1 answer
60 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 ...
user avatar
0 votes
1 answer
26 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: ...
user avatar
0 votes
2 answers
81 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: ...
user avatar
  • 111
0 votes
1 answer
201 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 ...
user avatar
  • 121
0 votes
1 answer
73 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 ...
user avatar
0 votes
1 answer
105 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 ...
user avatar
  • 1
0 votes
0 answers
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 ...
user avatar
  • 59
0 votes
0 answers
26 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] ...
user avatar
0 votes
1 answer
34 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 ...
user avatar
0 votes
0 answers
14 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", "...
user avatar
  • 101
0 votes
0 answers
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 ...
user avatar
  • 101
2 votes
0 answers
45 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 ...
user avatar
  • 121
0 votes
1 answer
63 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 ...
user avatar
0 votes
0 answers
18 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. ...
user avatar
  • 59
0 votes
0 answers
73 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: ...
user avatar
  • 221
0 votes
1 answer
113 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, ...
user avatar
0 votes
0 answers
17 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 ...
user avatar
  • 59
0 votes
0 answers
148 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, ...
user avatar
  • 233
0 votes
1 answer
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 ...
user avatar
  • 111
0 votes
0 answers
15 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?
user avatar
  • 101
0 votes
0 answers
79 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" ...
user avatar
0 votes
0 answers
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 ...
user avatar
  • 101
-1 votes
2 answers
113 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 ...
user avatar
0 votes
1 answer
41 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 ...
user avatar
0 votes
1 answer
64 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 ...
user avatar
0 votes
1 answer
24 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) ...
user avatar
0 votes
1 answer
59 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 ...
user avatar
  • 1
3 votes
0 answers
477 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 ...
user avatar
1 vote
0 answers
121 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 = ...
user avatar
0 votes
1 answer
262 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 ...
user avatar
0 votes
1 answer
55 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 ...
user avatar
1 vote
1 answer
427 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 ...
user avatar
  • 59

1
2 3 4 5 6