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).

Filter by
Sorted by
Tagged with
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 ...

15 30 50 per page
1
2 3 4 5
34