Questions tagged [master-slave-replication]
The master-slave-replication tag has no usage guidance.
271
questions
0
votes
0
answers
7
views
MariaDB replication works via MASTER_LOG_FILE, almost instantly fails using MASTER_USE_GTID
We have a weird issue with MariaDB version 10.4.28+maria~ubu2004 (the official binary release for Ubuntu 20.04 LTS).
We dumped the master data using mariabackup (we have a single database), and ...
0
votes
1
answer
28
views
Would MySQL Replication (master-slave) have prevented this problem?
I'm new to the idea of MySQL Replication (mainly because I've never really had data important enough to have redundancy until recently). Today I had a random crash of my MySQL 8 database with the ...
- 105
1
vote
1
answer
44
views
What could be causing the delay in synchronous replication between the master and slave nodes?
I have 2 PostgreSQL 13 database, one acting as a master and the other as a slave, using streaming replication with synchronous_commit=remote_apply. This means that all data written to the primary ...
- 11
0
votes
1
answer
26
views
Theoretical Question: What happens if replication is configured from primary postgres db on a deviated standby server?
I have a question: What happens if replication is configured from a primary Postgres server to a deviated standby server?
To explain more: Lets say I did a PITR restore from a 1-week-old backup on a ...
0
votes
1
answer
229
views
AWS RDS Can't complete Blue / Green changeover
I'm trying to do a Blue / Green changeover but it's failing with the error:
Switchover from DB cluster asamazon2-cluster to
asamazon2-cluster-green-xxxx was canceled due to external replication
on ...
0
votes
0
answers
35
views
Making backups with mariabackup from slave MariaDB. Best Way possible
I am trying to determine the best way to create backups from a MariaDB 1.4 slave, and I have the following questions:
Will creating backups affect the MariaDB slave replication and performance?
Is it ...
- 1
0
votes
0
answers
47
views
MySQL 8.0 replication lag high
Since we have upgraded from 5.7 to 8.0 (8.0.30-22), the servers don’t appear to be performing as well with the replication. The will frequently show 1 second repl lag, sometimes shooting up to 30 ...
- 1
3
votes
0
answers
112
views
MySQL replication - Follower stuck and behind
I understand there are lots of similar problems and threads but non of those solution helped me. Please read through the thread I will try to give as much information as possible:
I have setup a ...
- 131
0
votes
0
answers
50
views
MySQL replication not synced
I set up a replica between two MySQL servers. After my initial setup, the replication worked without any problem, but now they are out of sync.
On Master I can see:
Variable Valor
File mysql-bin....
- 51
0
votes
1
answer
47
views
Set new mariadb replica server by copying database files from another replica
A few tables in replica server (db2) where marked as crashed. We copied all database files (whole /var/lib/mysql) to another server (db3) in order to repair those tables. In the end we had to use pt-...
- 476
1
vote
0
answers
15
views
maximum number of physical replication on one server
I have a server with physical replication. It has been working very well till now.
I follow the procedure here : https://linuxhint.com/setup-physical-replication-postgresql/ to create the replication.
...
- 137
0
votes
1
answer
156
views
find error log for streaming replication
Recently the streaming replication fails after I restart the primary. I can not find the record using select * from pg_stat_replication
Now, I want to see it from the system log file at /var/log/...
- 137
2
votes
1
answer
120
views
Restart master in physical replication
I have 2 servers involving master-slave replication (physical replication).
I see the replication using select * from pg_replication_slots; there is a record saying :
user : rep_user`
application : ...
- 137
0
votes
1
answer
111
views
MySQL replication fails with permission error for unknown reason
Since 36h I'm struggling to setup a simple Master <-> Master replication with MySQL 8. None of the found solutions on the Internet works here and meanwhile I'm a bit desperate. Even the first ...
- 111
0
votes
1
answer
115
views
Read Replica block queries postgres
I've RDS PostgreSQL DB with read-replica. Also, have one script which frequently checks the blocking query but I faced one issue yesterday where the blocking query was a startup(backend_type)process ...
- 101
0
votes
1
answer
1k
views
Mysql replication fails when the master's binary log increments
I am currently running 2 instances of 8.0.31 MySQL Community Server on two virtual machines. These are set up with one way replication. The replication runs fine once set up, but at some point it ...
0
votes
0
answers
52
views
RDS Master MySQL AWS TO EC2 MySQL instance Replication
We have our master RDS MySQL in AWS , and slave set up done in EC2 instance, MySQL version 5.7, I have done the initial set up and replication working fine with single Database. In my case in master ...
- 1
0
votes
2
answers
65
views
How to perform mysqldump and import simultaneously?
I have a master database and a slave one. Recently, the slave has not synced with the master. So, I tried running mysqldump command to the master:
mysqldump -h <master_host> -u <user> -p &...
- 3
0
votes
0
answers
91
views
Replication Lag while migrating a live database
I have a live database that is on a server(mysql 5.7) that I want to completely migrate to a droplet created on an infrastructure provider with (mysql 8.1). I would also like to have a master slave ...
0
votes
0
answers
14
views
how to well replicate PhpMyAdmin well
I want to upgrade my actual server with 25 databases.
My actual server with 25 databases are working full time with big data (each database has almost 5GB) and have a lot of new data each minutes and ...
- 1
1
vote
0
answers
36
views
MySQL : Huge table truncation in replication environment
We have 2 tables of size 186G and 63G that are no longer in use and needs to be truncated from the database.
I cannot directly run the truncate table statement on the master DB as it has 14 replicas ...
- 11
0
votes
0
answers
134
views
MySQL version Upgrade from 5.5 to 8 without no downtime/very less downtime
May I get instructions from anyone on how to upgrade MySQL from version 5.5 to 8 with no downtime/minimum downtime.
Make a plan like that:
Step01# 5.5 (Master)---> 5.7 (Slave): Slave will be ...
0
votes
1
answer
156
views
Problem with seconds_behind_master in mysql replication with galera cluster
I have the next infrastructure of mysql servers:
Node1 - MySQL 5.1.X
Node2 - MariaDB 10.3.X
Node3 - MariaDB 10.3.X
Node4 - MariaDB 10.3.X
Node1 is a master replication node.
Node2 is a slave ...
0
votes
2
answers
275
views
High Load MariaDB Cluster (Galera Multi Master Replication) - Same hardware needed for Slaves?
My Galera Cluster is on very high load.
To run it fine, I´m using strong hardware and for sure a lot of custom MariaDB settings and custom OS tweaks.
Now, I want to add Slaves to get "realtime&...
1
vote
1
answer
1k
views
Postgres max_wal_size and wal_keep_size parameter
I am setting up Postgres v14 database. I have a question related to the max_wal_size and wal_keep_size parameters.
According to the documentation:
max_wal_size ⇒ Maximum size to let the WAL grow ...
- 111
1
vote
0
answers
70
views
aws documentation for DMS CDC is confusing
I am following this documentation https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.Security to enable CDC using logical replication.
I have pglogical ...
- 61
0
votes
1
answer
57
views
could not receive data from WAL stream: ERROR: requested WAL segment XXX has already been removed
Heads up - I have never dealt with postgres replication before; our DBA is on leave in Europe ATM.
It appears that something broke our replication a week ago; the master has 121 current wal files, ...
- 123
0
votes
2
answers
247
views
How do we switchover a slave to another master instead of promoting the slave to be the master?
We have a replication configuration wherein there are 2 Masters and 20 Replicas(Each master has 10 replicas). Now, we need to perform MySQL version upgrade on these instances. The approach for this ...
- 11
0
votes
0
answers
164
views
The best way to initialize table before logical replication
I am in the middle of setting up logical replication between 2 physical servers.
It involves 2 tables from the master with millions of rows. One table got 15 millions, and another one is 7 millions. ...
- 137
0
votes
0
answers
241
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 ...
- 101
1
vote
1
answer
303
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 ...
- 11
0
votes
0
answers
29
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,
- 11
1
vote
2
answers
2k
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.
...
0
votes
0
answers
26
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 ...
- 1
2
votes
1
answer
274
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 ...
- 123
0
votes
0
answers
227
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 ...
0
votes
0
answers
34
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 ...
- 124
2
votes
2
answers
1k
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 ...
-1
votes
1
answer
430
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 ...
0
votes
1
answer
100
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....
- 103
2
votes
1
answer
1k
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 ...
- 213
0
votes
1
answer
1k
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 ...
- 213
0
votes
1
answer
241
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:...
- 165
1
vote
1
answer
1k
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 ...
- 167
0
votes
0
answers
468
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 ...
- 167
1
vote
3
answers
609
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 ...
- 11
1
vote
1
answer
640
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 ...
- 15
0
votes
1
answer
51
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
2
answers
419
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:
...
- 111
1
vote
1
answer
704
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 ...
- 131