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
30 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
2answers
51 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
58 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
339 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
47 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
23 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
410 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
493 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
36 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
137 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
510 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
98 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
42 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
21 views

MySQL Slave is not replicating

Master: user@localhost [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 ...
0
votes
0answers
30 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 ...
0
votes
1answer
27 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 ...
0
votes
0answers
13 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 ...
0
votes
1answer
62 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 ...
0
votes
0answers
56 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 ...
0
votes
1answer
27 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 ...
0
votes
1answer
438 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-...
0
votes
1answer
351 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 ...
0
votes
2answers
398 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....
1
vote
0answers
75 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 ...
1
vote
1answer
170 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 ...
0
votes
0answers
389 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 - ...
2
votes
1answer
565 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 ...
0
votes
1answer
636 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] ...
2
votes
1answer
4k 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/...
0
votes
1answer
140 views

write master's slave thread lag flapping

if I have two mysql hosts pointed at each other: host A and host B: ------> hostA(write co-master) | | | -----> hostB (read-only co-master) why would hostA ever show replication delay when ...
0
votes
1answer
185 views

Setup master-master replication using mariabackup

Can please advise how I do master master replication? How can I get the exact position while the production server is keep on running and busy? To SCP to another server took about 7,8h , after waiting ...
0
votes
1answer
442 views

MySQL Cluster -> Galera MariaDB Cluster Replication not working, but no errors

I am setting up a database migration between a 2-node master cluster running MySQL Cluster 7.2 (MySQL 5.5) and a 2-node slave cluster (plus arbitrator) running MariaDB 10.3 with Galera clustering. I ...
0
votes
1answer
825 views

InnoDB Cluster - MySQL 8.0.13 upgrade to 8.0.14 on Ubuntu 18.04.1 LTS - Cluster creation fails

With the recent upgrade of MySQL from 8.0.13 to 8.0.14 on Ubuntu 18.04.1 LTS, I started getting an error by the time I issue the dba.createCluster('mycluster') after following the procedure to create ...
1
vote
1answer
716 views

Aurora Serverless Blue/Green deployment

I am currently investigating strategies for implementing blue/green deployment using RDS Aurora Serverless for Mysql. The 2 methods I am thinking about are: A. Create a duplicate database and ...
6
votes
2answers
659 views

Can I put the MySQL binlogs on a slow disk?

We have only 450 GB nvme space on our master server and the binlogs are using a lot of space, even if they are kept for only two days. Does writing the MySQL binlogs to a slower disk (like a remote ...
1
vote
0answers
552 views

Converting Mariadb Galera Cluster into Simple Master Slave Replication Cluster

Now we have this project to convert our Mariadb Galera Cluster (3 nodes) to Simple Master Slave cluster (One master and two slaves). So our goal to get rid of Galera and make our setup just async / ...
0
votes
1answer
66 views

MySQL Replication don't run after configuring

I'm practicing mysql replication with 2 Centos 6.9 64bit virtual machine. Setting process was fine but after I insert data to master server, Anythings happens in slave. MASTER SETTING mysql.cnf ...
0
votes
0answers
17 views

Best possible way to automate encrypted RDS mysql replication between 2 AWS accounts

I have 2 AWS accounts 1. Production 2. Development. I want to replicate the development RDS encrypted database to production account in a automated way. VPC peering is not allowed between the accounts ...
1
vote
2answers
409 views

MySQL replication, prevent hackers from deleting the main database and the deletions being replicated

I have a setup of a master/slave MySQL servers. My concern is that if the master database is hacked and the hackers delete tables or drop databases entirely, all the changes would be propagated to the ...
1
vote
1answer
3k views

Promoting MYSQL Slave to MYSQL Master

I have a MySQL setup with one master (M1) and one slave(S1). Due to some unforeseen issue I need to promote my slave server to master and demote master to slave. My MySQL version is 5.6 in Linux. ...
0
votes
1answer
219 views

Set up MySQL replication in Google Cloud Platform via Internal IP addresses

In one of our projects customer security prohibits instances with external IP connections, the instances are on-premise connected via VPN. In this project we set up a second network, allowing ...
0
votes
0answers
211 views

Master Master replication between RDS and database instance on EC2 Errno: 1032

I face this error many times with my replication Last_SQL_Error: Could not execute Delete_rows event on table db_name.event; Can't find record in 'event', Error_code: 1032; handler error ...
0
votes
0answers
583 views

MySQL Semi synchronous replication stuck

I have a mysql semi-synchronous replica-set with a master and 2 slaves. The replication happens fine to only one of the nodes but the other node is always stuck with the following status. ...
-1
votes
1answer
45 views

Website .htaccess redirection loop issue [closed]

I have my news website hosted in US and it is being managed by cloudfare. I have placed one local server in Nepal as well for faster serving of web pages. MYSql replication and web content sync is ...
0
votes
1answer
654 views

Mysql Master-Slave replication database duplication issue

I have done master-slave replication for performing web-server mirroring. Web contents are getting replicated properly. But I am facing issue in database replication. Database is replicated and slave ...
1
vote
1answer
2k views

MariaDb Master-master replication

I tried master-slave replication of mutliple databases of mariadb-5.5.52-1 in RHEL environment, the mariadb came as a part of nagiosxi application. while replicating from master to slave i had many ...
0
votes
1answer
252 views

mysql simple master-slave replication stops without any errors

mysql Ver 14.14 Distrib 5.7.21-20 (it's Percona fork, if it's matter). Trying to make simple M-S replication, only 2 servers, different id-s. Replications starts normally, but after a while (several ...
0
votes
1answer
477 views

Mariadb live sync using cron or replication

We have around 14 eCommerce sites which are working in 2 LAMP server. Two sites in server one and second server consist of rest of the sites. There is one central DB in which we are syncing all the ...
0
votes
3answers
5k views

MySQL Master-Master with offsets getting ERROR 1872

I'm trying to fix the replication between a master-master MySQL database replication model. Server 1 (with the IP of 192.168.2.6) is configured with: auto-increment-increment = 2 auto-...

1
2 3 4 5
10