Questions tagged [mysql-replication]
Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves).
518
questions
0
votes
1
answer
24
views
Kubernetes InnoDBCluster: all pods should share one PersistentVolumeClaim?
Kubernetes InnoDBCluster: all pods should share one PersistentVolumeClaim?
Following: https://dev.mysql.com/doc/mysql-operator/en/mysql-operator-innodbcluster-simple-kubectl.html
kubectl create ...
- 103
0
votes
1
answer
53
views
why mysql bin logs are not expiring even though expiry was set
I am using 5.7.37-log MySQL Community Server.
my mysqld.cnf looks below:
server_id = 11
log_bin = bin.log
log-bin-index = bin-log.index
binlog_format = row
max_binlog_size = 100M
socket = mysql.sock
...
- 103
0
votes
0
answers
87
views
Using AWS Blue/Green deployment, how do I modify the staging database?
AWS has rolled out a Blue/Green Deployment feature for RDS, allow you to create a staging (green) database that's in parallel with your production (blue) database. Their documentation specifically ...
0
votes
1
answer
814
views
How to fix MySQL 8 replication error 1062 after system reboot?
after a system reboot my replication stopped suddenly. So I'm trying to bring the slave back to the most current state.
To do this I create a dump from the master's database and import it on the slave,...
- 135
0
votes
1
answer
30
views
Real time synchronization of databases with different data structure
I'm rewriting a legacy web application. At some point in time, I want old and new app, to work in parallel, on databases with different structure (both mysql). The troublesome part is that the ...
- 133
0
votes
1
answer
157
views
Is it possible to manage read/write requests on AWS RDS?
We are planning to create a read replica on our MySql Database on RDS but we want to manage this on AWS. Does AWS has a solution that manages requests and redirect them if write to the master ...
- 51
0
votes
0
answers
187
views
MySQL replication fails with connection error when server has second IP address
For a few days I've been struggling with a MySQL + Docker + ClusterIP problem. I'm trying to create a failover for my servers. If Server1 fails, Server2 should take over automatically. Both servers ...
- 135
2
votes
1
answer
210
views
How to MySQL replicate or cluster to setup a failover scenario?
after a massive data problem from my provider in GER, I'm now forced to deal with failover scenarios. But there are a few questions that I can't find any real answers to. So I hope someone can help me ...
- 135
0
votes
0
answers
95
views
MariaDB replication lagging up to a dozen times a day for no obvious reasons
We first set up MariaDB replication using less powerful servers but considering our increased database load we had to rent more powerful servers and that's when the troubles began.
Right now the ...
0
votes
1
answer
111
views
Promote to Master a MySQL slave that has its own slaves
MySQL standby & chained replication
Having the current setup (not using GTID) (see link to image):
PRODUCTION NODES: MASTER (A) -> SLAVE (A1) + SLAVE (A2)
STANDBY NODES: -> SLAVE (B) (with ...
- 1
0
votes
1
answer
340
views
RHEL8.4 with Percona8.0.29 - Cluster fails error code 7
I have installed 3 x RHEL 8.4 Servers and have also installed the latest version of Percona XtraDB Cluster. I have left the my.cnf file pretty basic, wsrep also basic with just the required changes to ...
- 1
0
votes
1
answer
177
views
Running MySQL server as slave for one DB and master for another
I have two MySQL server having master-slave replication for DB1. The slave server holds DB2. Because the slave server is not so powerfull I want to run analytics upon DB2 on the third server. Is it ...
- 121
0
votes
1
answer
40
views
What should be in mysql replication MASTER_HOST='source_host_name'
I am trying to setup replication across two servers on AWS. I am following the documentation and I am up to this point.
https://dev.mysql.com/doc/mysql-replication-excerpt/5.7/en/replication-howto-...
- 103
0
votes
0
answers
189
views
Upgrading MySQL from 5.1 to 8.0 replication
I have been tasked with replacing a MySQL 5.1 server with MySQL 8.0.
So I built a CentOS 7 machine with MySQL 5.7 and now I am replicating from 5.1 => 5.7
Then I built a RHEL 9 machine with MySQL 8....
- 13
0
votes
1
answer
340
views
Different bin log file index on maria db galera nodes
Setup:
Galera Cluster with 3 nodes running in Docker Containers. In front of every node is a maxscale proxy. Remotely is a replication slave running with bin-log replication where the cluster is ...
- 101
1
vote
1
answer
100
views
Correct way to put a MySQL replicated environment safely into maintenance mode?
I need to perform some maintenance on our master/slave/slave MySQL cluster. The maintenance involves optimising three tables, at least one of which is being locked for a duration of approximately 2 ...
- 53
0
votes
0
answers
107
views
MySQL Replication Master => Slave => Master
I have set up MySQL master-slave replication successfully. But I realized it doesn't work if I would like to simulate the real-world case. Here is my scenario:
Make sure the data have been fully ...
- 171
0
votes
0
answers
523
views
Ubuntu 20.04 mysql-server 8 replication does not start
I am building a master-master replication with two servers which are talking to each other by local lan.
I have:
Server 1:
mysql -uroot -p
change replication source to source_host='192.168.1.3',
...
- 1
1
vote
1
answer
35
views
MySQL 1 schema, 1 filesystem
This is a ''general'' question. Hear me out.
Let's say I have a MySQL standalone or even a 3 or 5 nodes cluster.
Would it be a good practice to have 1 filesystem per schema ?
For example, schema{1..5} ...
- 751
0
votes
1
answer
183
views
MYSQL: Many slave servers with smaller resources or less with larger resources
I want to create High availability with Master Slave replication (for Select query).
I am wondering which one is better:
Having smaller resources slaves but more servers or
Having larger resources ...
- 101
0
votes
0
answers
40
views
2 servers, 2 databases on each, 1st server 1st db master and 2nd slave, 2nd server 1st db slave, 2nd master, is it possible?
I have 2 MySQL/MariaDB servers each of them with its own database and I would like to set up a continuous backup on each other via replication.
Is it possible to make 1 DB master and 1 slave on each ...
- 119
1
vote
1
answer
183
views
Update MySQL replication server position
I have been trying to set up a replication of a large DB (90GB)
I have created a backup using mysqldump --single-transaction
I have then restored that on the replication server.
I have then enabled ...
- 133
0
votes
1
answer
3k
views
Error 'Character set '#255' is not a compiled character set and is not specified mySQL
Okay, I've hit a brick wall and have run out of ideas.
Master: 8.0.25-0ubuntu0.20.04.1
Slave: 5.7.33-0ubuntu0.16.04.1-log
Getting error with show slave status\G:
Last_SQL_Errno: 22
Last_SQL_Error:...
- 73
0
votes
1
answer
1k
views
keepalived delay before bringing ip up
Is it possible to configure a delay before bringing the virtual IP up in keepalived?
Background:
I have multiple Master/Master MySQL Setups. Only one Master is used at time. Keepalived is used for VIP ...
- 51
0
votes
2
answers
203
views
Mysql Server, with Mariadb Slaves, disk usage high and many binlog files
I have a Mysql Master server and a few MariaDB slaves connected to it. I have an issue in that my disk usage on the slaves have gone a bit mad.
My master server is 163GB with bin log files of 100Mb ...
- 13
1
vote
0
answers
158
views
MySQL hangs on SELECT from table with blob fields
I managed to create a mysql InnoDB cluster with three nodes and a router everything works great but when i try to run a select query from the table below from a another server it freezes, but it works ...
- 77
1
vote
1
answer
2k
views
Solving slave MySQL: waiting for the slave SQL thread to free enough relay log space
My slave MYSQL server has stopped syncing with the following status output. Could someone please suggest me a course of action to solve the problem? The database is around 400G so starting from zero ...
- 111
0
votes
2
answers
2k
views
Haproxy with MySQL Cluster Setup
I have 2 MySQL servers with master-master replication between them. The replication is working fine.
I need to configure high availability between them so that if either one of them goes down, the ...
- 101
1
vote
0
answers
2k
views
MySql Slave Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.00116, end_log_pos 8631
I have Active-Passive-Master-Master replication setup in Mysql with version 5.7.
I found the below error in MySql2 (passive Master server) but the status show it's in sync with Master server (mysql1).
...
- 11
0
votes
1
answer
228
views
Master-Slave replication with additional selective replication
Using MySQL 5.6 Enterprise is it possible to have a normal master/slave replication between a master and slave with full replication then a second slave server to only have certain tables?
0
votes
1
answer
1k
views
Mysql slave stoped and fail to initialize relay log
A couple of days ago I setup a slave MySQL server (Mysql Community Server 8.0.21). So far we only use it for backup using mysqldump. I did notice that he was using too much memory, but I did not mind ...
user587541
0
votes
1
answer
2k
views
Failed mysql replication [closed]
After we realize that our backups (dump) where taking too long, and an incident where the VPS provider shutdown our database vps for 2 hours, we decided to try replication (not going to remove backup, ...
user587541
0
votes
1
answer
279
views
Replicate_Do_DB and Replicate_Wild_Do_Table - Replication does not work
I have been tasked to set replication up on a slave host. The master database is a "data store" where tables are dropped, recreated, and reloaded on a daily basis.
My initial setup of the ...
- 1
0
votes
1
answer
484
views
MySQL 5.7 on Ubuntu 18.04.4 LTS does not recognize any configuration-variable
I am trying to create a master-master replication between two databases, one being an RDS instance with MySQL 5.6.44 on AWS the other one being on an Ubuntu-Server running MySQL 5.7 (I was unable to ...
- 152
1
vote
0
answers
269
views
How to configure keepalived, so that choosing master is not static?
I have already managed to configure a setup where I have a master and a backup machine, so when the master fails the backup goes back up. And when the master starts again, it takes the master position ...
- 21
0
votes
0
answers
38
views
Best mysql database architecture for a worldwide project
I would like to know your opinion about how to build the best database architecture posible.
This is a website, let's say it is a forum, with traffic from everywhere around the globe.
I'm trying to ...
- 1
0
votes
1
answer
187
views
MySQL 8.0 replica going out of sync with error on executing statements
I have this configuration:
Master running MySQL 5.5 with log file format: STATEMENT
Slave running MySQL 8.0 - connected to (1) master. Log file format: ROW
Another Slave running MySQL 8.0 - connected ...
- 167
0
votes
0
answers
25
views
MySQL master slave replication issue
I have enabled filtered replication in MySQL. Only one table is being replicated from master to slave using replicate-do-table option and the replication is going smooth. Today morning I have noticed ...
- 1
0
votes
1
answer
476
views
How to decide right time to start using read replica in MySQL
I have an ecommerce website with around 30,000 daily users with over 50,000 sessions. We are using RDS m5.xlarge instance. We are not facing any issues as such in read or write operations on day to ...
- 723
0
votes
0
answers
256
views
missing data in master-to-master replication with mysql instances
I am using MySQL 8. I have two masters which are configured as master-master replication with the following configuration in my.cnf.
The configuration is identical, except server-id. It seemed to be ...
- 103
0
votes
1
answer
122
views
Cannot connected to virutal IP loadbalancer direct to mysql server
I can't connect to the Database server though virtual IP
https://towardsdatascience.com/high-availability-mysql-cluster-with-load-balancing-using-haproxy-and-heartbeat-40a16e134691
I follow this ...
- 191
0
votes
1
answer
1k
views
MariaDB / MySQL single master multiple slave odd behavior
I am trying to setup replication from a single Master server to multiple slaves. I followed the traditional steps...
On Master:
Updated my.cnf file:
log-bin = /var/log/mysql/master-bin
log-...
- 3
0
votes
1
answer
1k
views
Does LOCK TABLE block replication?
I have a master and a database MySQL with the following setup:
AWS RDS MySQL
Version 5.7.26
GTID enabled and strictly enforced
I have a process that does a LOCK TABLE over one of the tables in the ...
- 101
2
votes
2
answers
1k
views
Automaticaly restoring SQL replication after power outage
I have two Sql databases, "MASTER" and "SLAVE", and I use Sql replication to get them synchronized. I'm using MariaDB 10 on both databases.
The MASTER database is installed on a linux PLC using Docker....
- 23
1
vote
0
answers
112
views
Setup Local Persistent Volume on physical machines with Kubernetes
Let me make a statement first: I'm new to Kubernetes, please take it easy if I'm asking wrong questions.
Ok, here is what I'm gonna do. I'm planning to build a Kubernetes for my project using some ...
- 131
1
vote
1
answer
592
views
Should I use public IP or private IP for connecting servers within the same VPC?
I have 2 Linux servers on AWS. Both servers are in the default vpc (aws default vpc). Both of these servers have their own Elastic IP. I also have a webServer which is inside the same vpc.
I want to ...
- 508
0
votes
0
answers
665
views
Aurora-mysql cross-region replicas fail with views/procedures/functions
UPDATE 2 - AWS released Aurora-mysql platform update 1.19.1 which addresses this and other issues. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Updates.1191.html
UPDATE - ...
- 101
2
votes
1
answer
1k
views
Amazon Aurora read-only slaves slowly increase to 100% CPU and die
We have a master database instance hosted on AWS Aurora (mysql) and have many read-only slaves being replicated from it. The master and the 4-12 autoscaling slaves are currently of db.r4.4xlarge size ...
- 102
0
votes
1
answer
952
views
Master- Master Replication breaks after server Reboot
I have a Master-Master Replication with the following Configuration. Due to some patches, we have to Reboot the both the masters. But when i check the replication i s broken.
MASTER 1:
[mysqld]
...
- 11
2
votes
1
answer
10k
views
error 1236 A slave with the same server_uuid/server_id as this slave has connected to the master
I got this error when configuring single master multiple slave servers.
Last_IO_Error :Got fatal error 1236 from master when reading data from binary log : ' A slave with the same server_uuid/...
- 51