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
14 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
15 views

Percona xtradb cluster breaks with conflict message when importing data into it

I have been banging my head over the wall for the past 2 weeks on this. I initially thought this was due to a bad or unsupported DDL syntax. But right now I am not sure of anything anymore. I have a ...
0
votes
0answers
10 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
0answers
19 views

Multi-source replication is not accepting “channel” for replication filter

I'm trying to make a slave that will have database replication from two different master. When I'm trying to set replication filter based on the channel, MySQL server is throwing syntax error. I've ...
0
votes
0answers
65 views

Laravel with Galera DB cluster

I have a Laravel project and created a Galera DB cluster. A feature of the cluster is that it is available on three different IP addresses. How can I declare these IP addresses for Laravel to use? I ...
0
votes
0answers
16 views

Mysql 5.5: Replicate 1 db and several tables from another

all. I am using Mysql5.5 and need to replicate one database in it's entirety (db1), plus 6/45 tables from another database (db2). I've locked the master and dumped both db1 and db2, plus noted the ...
0
votes
1answer
20 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
27 views

Automatically route MySQL connections based on GEO location to a closest Galera cluster node

So I managed to bring up a Galera cluster of 3 nodes as per this tutorial. The cluster works as expected. However, the task at hand is to automatically forward request from application to cluster's ...
0
votes
0answers
38 views

Specifying slave database in my.cnf binlog_do_db causes MySQL to stop working

I'm following pretty straightforward instructions on how to set up master / slave replication using this article from Digital Ocean. On the slave side, I've imported a database called "xyz". The next ...
0
votes
0answers
24 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
23 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
235 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
67 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
0answers
27 views

How to Achieve Multi-Region API Server without Database Conflict

Currently I'm building a webapp that has an intended global audience, no specific region. To reduce latency I've gone through the usual steps of having a Redis in-memory cache, local caching in ...
0
votes
2answers
97 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
61 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
118 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
201 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 - ...
1
vote
1answer
280 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
365 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] ...
1
vote
1answer
2k 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
111 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
117 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
347 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
459 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
435 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
473 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
447 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
65 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 ...
0
votes
2answers
287 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 ...
0
votes
1answer
2k 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
197 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
172 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
393 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
43 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
364 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 ...
0
votes
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
168 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
309 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
3k 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
vote
1answer
285 views

MySQL 5.6 Deadlock Issue

I have a sporadic deadlocking issue with MySQL 5.6. This server is configured as a read only slave, which is why it is extremely odd there is a deadlock issue. I have innodb_lock_wait_timeout set to ...
2
votes
1answer
718 views

Percona MySQL 5.7 Replication error 1236 “unknown error reading log event on the master”

we are using two instances of 5.7.20-18-log (in the meantime updated to 5.7.21-21-lo) Percona Server in a master-master (dbm1 / dbm2) replication. The application only uses dbm1 for writes and reads ...
1
vote
1answer
49 views

Possible to drop MariaDB (MySQL) InnoDB databases by deleting directories?

I'm working out the fastest way to spin up a new slave server, which will only require some of our databases. The basic plan is: Stop existing slave Take LVM snapshot and re-start slave (so it can ...
0
votes
1answer
813 views

mysqldump --single-transaction on slave (without stopping replication)

Is it okay to run mysqldump --single-transaction on Slave DB without stopping replication (stop slave;)? This is for regular daily backup so we can restore Master DB in case of a storage disaster. ...
0
votes
1answer
32 views

maxscale 2.1 upgrade breaks client authentication

upgrading from maxscale from maxscale-2.0.1-1.x86_64 to maxscale-2.1.13-1.x86_64 causes my replication user to no longer authorize. I've verified the grants are correct and blew away the cache dir, to ...
0
votes
0answers
164 views

MySQL group replication configuration issue

I am trying to create an instance in one AWS region that would be a group replica of an instance in a different region(both are database servers). I followed the below link to do this. https://www....
1
vote
2answers
5k views

How to “safely” shutdown/restart a Galera cluster?

First time setting up Galera (Ubuntu 14.04) and I'm unable to restart the cluster after rebooting my nodes. I'm following the this guide and it doesn't exactly mention how to handle a shutdown or ...
0
votes
0answers
30 views

mariaDB replication stops when creating image in aws

Currently using aws as my db hosting. Instead of using RDS I am using instances to include mariaDB and distribute few instances over different region for replication. Everything works fine but ...
1
vote
1answer
545 views

mariaDB master to master replication [closed]

I have just started using mariaDB. I wanted to make a master to master replication. Tried a few tutorials but all failed. I have followed a newer tutorial in do https://www.digitalocean.com/...

1
2 3 4 5
10