Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

0
votes
0answers
22 views

Multi-master PowerDNS setup

I'm trying to set up multiple PowerDNS hosts (masters), that will write to a Galera MariaDB backend. I provisioned a HAProxy loadbalancer in front of the Galera cluster nodes and all the PowerDNS ...
1
vote
1answer
34 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 ...
0
votes
0answers
38 views

Failed to create connection pool: Failed to initialize pool: Communications link failure

We are using mysql router service 8.0 with group replication 1 master and 2 slaves 5.7.24 and 2 application host. After initating the app services we got the error in the middle ware log. ERROR [xx....
0
votes
0answers
21 views

MySQL and Postgres replication to the same slave

I need to set up multi-source replication from several different servers to one slave so that I can mine data from the slave without increasing load on the masters. This is my first time setting up ...
6
votes
2answers
247 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
67 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
0answers
15 views

How to properly set high availability architecture [duplicate]

I am running a PrestaShop 1.6 on a dedicated server with : 128GB RAM and 16c Intel Xeon 3.4(GHz). This server has Web(apache2) and DB (mysql5.5) in the same box for approx. 100 constant users. It is ...
0
votes
1answer
56 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
71 views

MySQL slave status always missing

My MySQL add a instance but its status is always missing. I have try to run CHANGE MASTER TO master_host = 'node1',master_port = 3306,MASTER_USER = 'root',MASTER_PASSWORD='xxxx',master_log_file='...
0
votes
0answers
13 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
63 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
209 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
82 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
102 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
62 views

mysql ndb cluster and table partitioning

I have mysql ndb cluster with 3 datanodes. I want to break one of my tables into partitions based on one column (maybe date), the question is that what happens after I run partitioning script : I ...
0
votes
0answers
88 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. ...
0
votes
0answers
245 views

Cross-VPC private RDS endpoint resolution from an RDS instance for replication

TL;DR : I'm trying to build cross-account MySQL RDS replication, but RDS seem to resolve DNS endpoints to public IP instead of private for cross-VPC RDS masters. I've set up VPC peering (across two ...
-1
votes
1answer
35 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
68 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
507 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
77 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
100 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
2answers
696 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
128 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
3answers
378 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
47 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
448 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
0answers
97 views

MySQL doesn't replicate data into newly created table

I have 1 master server (srvdb01) and 1 slave server (srvdb02) with already running mysql replication for 1 database (abcdb). srvdc01 master conf is log_bin = /var/log/mysql/mysql-...
0
votes
1answer
20 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
192 views

Mysql master to master group replication on ubuntu 16.04

I configure mysql master to master group replication using following link https://www.digitalocean.com/community/tutorials/how-to-configure-mysql-group-replication-on-ubuntu-16-04 I have connected ...
0
votes
0answers
127 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
1k 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
29 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
369 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/...
0
votes
2answers
57 views

Mysql master-master temporarily unreachable, lots of 'Sleep' queries

I have a working MySQL master-master setup. I noticed that sometimes, when one of the servers becomes unreachable, the other fills up with queries in Sleep status. I don't know what the queries are ...
0
votes
0answers
129 views

Mysql replication delay

I designed three mysql as follows. mysql1(master): original master mysql2(slave) : mysql2 Synchronize to mysql1 After several hours. mysql3(slave) : mysql3 Synchronize to mysql1 instantly. The above ...
0
votes
1answer
648 views

MySQL 5.7 Replication Error “Can't create database”

I've dumped a test database backup to a newly created test slave server, but I'm having trouble getting the replication moving. Since the dump, I've only added one record to the master database to ...
0
votes
1answer
22 views

Mysql master/slave setup - what users do i need?

I am currently setting up an master and 2 slaves (performance read queries) - Master -> 1 Slave works already. But now I want to add a second slave, I can not connect tho. Do I have to create a second ...
0
votes
1answer
408 views

Export Local MySQL Table Into Remote Database

I am trying to export only some tables in a local database, into a remote database which has the same name of these tables + some other tables (I want to overwrite the remote database tables which has ...
2
votes
1answer
394 views

mariadb replication over ssh tunnel

I'm trying to do mariadb replication over a ssh tunnel. Here is my config. First, I created a ssh tunnel from my replication server(R1) to my Master server (M1). ssh -L 13306:localhost:3306 -p 22111 ...
1
vote
0answers
131 views

The ndb_mgmd daemon does not start

The ndb_mgmd daemon does not start I want to configure a NDB Mysql cluster, I followed the documentation of its official page. Install version 7.5 of mysql-cluster-community and I have the following ...
2
votes
1answer
4k views

Slave_SQL_Running: No: MySQL replication stopped working

Replication on my slave database (MySQL 5.7.12) stopped working suddenly. When I run SHOW SLAVE STATUS\G I see the following error: Last_Errno: 1396 Last_Error: Error 'Operation CREATE USER failed ...
0
votes
1answer
500 views

MySQL Replication failing on `mysql`.`user` changes

I have a simple master - slave setup with MySQL 5.6 that keeps failing whenever I make changes to the mysql.user table. The master is set to replicate two databases, neither of which are the mysql ...
0
votes
1answer
2k views

Fix MySQL group_replication applier module failed to start

TL/DR: this question is not about master-slave replication. It is about NEW feature of multi-master group-replication (available starting v5.7.17). We have working workaround, but it takes hours due ...
1
vote
2answers
2k views

Slave replication stops with Last_SQL_Errno: 1032

I have added an extra Slave server to an existing MySQL Replication. The Master server and the old Slave server are working fine without any issue, but the newly added server is stoping with the ...
1
vote
1answer
254 views

Suppressing warning “Statement may not be safe to log in statement format” in mysqld.log

I've noticed the mysqld.log is being filled up with these log messages about the statement not be safe to log in a statement format for the MySQL replication. I know the query is fine, and from what ...
0
votes
1answer
243 views

Accessing a Google Cloud Replica of an external on-prem master

I just set up a MySQL replication on Google Cloud Platform using my external on-prem server as replication master. I just follow this guide https://cloud.google.com/sql/docs/mysql/replication/...
0
votes
2answers
235 views

MySQL Group Replication - does read only operations supported for disconnected node?

Please consider the following topology of some organization, consisting of 4 branches (A,B,C,D). All branches are located in different geo locations and interconnected with VPN: This organization ...
1
vote
0answers
240 views

Mysql replication, master_log_pos sync but tables not update

First, my replication config on Master: server-id = 1 replicate-same-server-id = 0 auto-increment-increment = 1 auto-increment-offset = 1 log-bin = /var/log/mysql/mysql-bin.log expire_logs_days = 5 ...
0
votes
2answers
276 views

how to mirror a database and implement failover solution

There are many questions that address the issue of failover and Im a bit overwhelmed which is why I am asking about my specific situation here. my setup is as follows: I have three servers running ...