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).
499
questions
0
votes
1answer
22 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 ...
0
votes
1answer
45 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 ...
1
vote
0answers
55 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 ...
1
vote
1answer
264 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 ...
0
votes
0answers
36 views
MariaDB binary logging and master-master replication
I am trying to set up MariaDB master-master replication on a Debian server.
Server version: 10.3.25-MariaDB-0+deb10u1 Debian 10.
I have read many tutorials and all of them says it´s necessary to edit ...
0
votes
0answers
21 views
Mysql Error 1062 after reboot server
Accidentally I shut down one of my mysql server (8.0.20) that is in a multi master replication environment. After that, he started complaining about duplicated primary key. After some research, i come ...
0
votes
2answers
321 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 ...
1
vote
0answers
424 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).
...
0
votes
1answer
30 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
1answer
122 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 ...
0
votes
1answer
453 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, ...
0
votes
1answer
92 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 ...
0
votes
1answer
38 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 ...
0
votes
0answers
20 views
MySQL Slave is not replicating
Master:
[email protected] [fusion]> show master status\G
*************************** 1. row ***************************
File: maindb-bin.006968
Position: 120
...
1
vote
0answers
25 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 ...
