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
1 vote
0 answers
34 views

Using Clone for addInstance on MySQL Innodb Cluster uses 100% Memory

When trying to add a new node to a MySQL Innodb cluster using Cluster.addInstance() and selecting the Clone option, within 2 or 3 minutes the donor nodes memory usages hits 100% on a server with 36Gb ...
mwarble's user avatar
  • 11
1 vote
1 answer
239 views

mysql bind-address change from 127.0.0.1 to server's IP Address breaks websites

I'm trying to setup mysql replica. On master when I change bind-address value in my.cnf to server's IP address some of websites break as they are using 127.0.0.1 as database host value. There are few ...
Vaughn's user avatar
  • 113
0 votes
0 answers
10 views

xtrabackup - copying my.cnf file from source to replica when there are different linux distros on source and replica

https://docs.percona.com/percona-xtrabackup/innovation-release/set-up-replication.html#3-configure-the-sources-mysql-server 4. Configure the Replica’s MySQL server Copy the my.cnf file from the Source ...
Vaughn's user avatar
  • 113
0 votes
1 answer
63 views

mySQL master-master replication

I have a 3 server mySQL/PHP/Apache cluster (each on different continents for maximum resilience). I have read a lot of advice which all says - don't do this! Essentially the reasons I want to do this ...
Andyj12's user avatar
  • 157
0 votes
0 answers
226 views

mysql SSL is required but the server doesn't support it

i generated these files in my master machine : openssl genrsa 4096 > ca-key.pem openssl req -new -x509 -nodes -days 9999 -key ca-key.pem > ca-cert.pem openssl req -newkey rsa:4096 -days ...
sina kzm's user avatar
0 votes
1 answer
250 views

connection refused mysql with telnet

i have 2 machines that can see each other and ping my issue is i want to telnet from slave machine to master machine and this is what i get: slave@slave:~$ telnet 192.168.1.131 3306 Trying 192.168.1....
sina kzm's user avatar
2 votes
1 answer
193 views

How to run mariadb replication without error?

I set up a master to slave replication according to the docs. I'm using ansible for this (see below). After the initial run (lock, backup, unlock, copy to slave host, import and start slave) the slave ...
Karsten S.'s user avatar
0 votes
0 answers
64 views

Can AWS NLB be used to load balance requests to Read Replicas?

This article from Nginx describes how Nginx TCP load balancing can be used against MySQL cluster. In the first diagram, I would like to replace the Nginx LB with AWS NLB where, the MySQL cluster runs ...
cogitoergosum's user avatar
2 votes
1 answer
130 views

Is there any way to encryption password?

I'm trying master-slave replication in MySQL, and I have a question about plain text passwords. When I created an account on the master server I tried select * from mysql.slave_master_info; and the ...
game streamer's user avatar
1 vote
0 answers
308 views

Using MySQL/MariaDB replication, how to know when the Replica is in a consistent state?

This is a question about MariaDB (mostly) and a replication that I am considering. For this replication, the Primary database is updated every minute by a process which can take about 15 seconds to ...
GingkoFr's user avatar
2 votes
1 answer
612 views

Is it possible to have MySQL/MariaDB bidirectional replication?

I am trying to install replication on several MariaDB servers. With no experience at all on this. I am wondering something. Would it be possible to have both servers acting simultaneously as master ...
GingkoFr's user avatar
0 votes
1 answer
137 views

Kubernetes InnoDBCluster: all pods should share one PersistentVolumeClaim?

Kubernetes InnoDBCluster: all pods should share one PersistentVolumeClaim? Following: https://dev.mysql.com/doc/mysql-operator/en/mysql-operator-innodbcluster-simple-kubectl.html kubectl create ...
eastwater's user avatar
  • 109
0 votes
1 answer
587 views

why mysql bin logs are not expiring even though expiry was set

I am using 5.7.37-log MySQL Community Server. my mysqld.cnf looks below: server_id = 11 log_bin = bin.log log-bin-index = bin-log.index binlog_format = row max_binlog_size = 100M socket = mysql.sock ...
santhosh's user avatar
  • 103
0 votes
1 answer
2k views

Using AWS Blue/Green deployment, how do I modify the staging database?

AWS has rolled out a Blue/Green Deployment feature for RDS, allow you to create a staging (green) database that's in parallel with your production (blue) database. Their documentation specifically ...
Paranoid Altoid's user avatar
0 votes
1 answer
4k views

How to fix MySQL 8 replication error 1062 after system reboot?

after a system reboot my replication stopped suddenly. So I'm trying to bring the slave back to the most current state. To do this I create a dump from the master's database and import it on the slave,...
Lars's user avatar
  • 135
0 votes
1 answer
36 views

Real time synchronization of databases with different data structure

I'm rewriting a legacy web application. At some point in time, I want old and new app, to work in parallel, on databases with different structure (both mysql). The troublesome part is that the ...
Maarduk's user avatar
  • 133
0 votes
1 answer
315 views

Is it possible to manage read/write requests on AWS RDS?

We are planning to create a read replica on our MySql Database on RDS but we want to manage this on AWS. Does AWS has a solution that manages requests and redirect them if write to the master ...
xxlali's user avatar
  • 51
2 votes
1 answer
514 views

How to MySQL replicate or cluster to setup a failover scenario?

after a massive data problem from my provider in GER, I'm now forced to deal with failover scenarios. But there are a few questions that I can't find any real answers to. So I hope someone can help me ...
Lars's user avatar
  • 135
0 votes
0 answers
215 views

MariaDB replication lagging up to a dozen times a day for no obvious reasons

We first set up MariaDB replication using less powerful servers but considering our increased database load we had to rent more powerful servers and that's when the troubles began. Right now the ...
Artem S. Tashkinov's user avatar
0 votes
1 answer
221 views

Promote to Master a MySQL slave that has its own slaves

MySQL standby & chained replication Having the current setup (not using GTID) (see link to image): PRODUCTION NODES: MASTER (A) -> SLAVE (A1) + SLAVE (A2) STANDBY NODES: -> SLAVE (B) (with ...
MGS's user avatar
  • 1
0 votes
1 answer
842 views

RHEL8.4 with Percona8.0.29 - Cluster fails error code 7

I have installed 3 x RHEL 8.4 Servers and have also installed the latest version of Percona XtraDB Cluster. I have left the my.cnf file pretty basic, wsrep also basic with just the required changes to ...
CliveG's user avatar
  • 1
0 votes
1 answer
328 views

Running MySQL server as slave for one DB and master for another

I have two MySQL server having master-slave replication for DB1. The slave server holds DB2. Because the slave server is not so powerfull I want to run analytics upon DB2 on the third server. Is it ...
Ralfeus's user avatar
  • 121
0 votes
1 answer
95 views

What should be in mysql replication MASTER_HOST='source_host_name'

I am trying to setup replication across two servers on AWS. I am following the documentation and I am up to this point. https://dev.mysql.com/doc/mysql-replication-excerpt/5.7/en/replication-howto-...
user1794918's user avatar
0 votes
1 answer
490 views

Different bin log file index on maria db galera nodes

Setup: Galera Cluster with 3 nodes running in Docker Containers. In front of every node is a maxscale proxy. Remotely is a replication slave running with bin-log replication where the cluster is ...
Jonas Marty's user avatar
1 vote
1 answer
326 views

Correct way to put a MySQL replicated environment safely into maintenance mode?

I need to perform some maintenance on our master/slave/slave MySQL cluster. The maintenance involves optimising three tables, at least one of which is being locked for a duration of approximately 2 ...
motorleague's user avatar
0 votes
0 answers
149 views

MySQL Replication Master => Slave => Master

I have set up MySQL master-slave replication successfully. But I realized it doesn't work if I would like to simulate the real-world case. Here is my scenario: Make sure the data have been fully ...
ITnewbie's user avatar
  • 171
0 votes
0 answers
680 views

Ubuntu 20.04 mysql-server 8 replication does not start

I am building a master-master replication with two servers which are talking to each other by local lan. I have: Server 1: mysql -uroot -p change replication source to source_host='192.168.1.3', ...
Foxina's user avatar
  • 1
1 vote
1 answer
39 views

MySQL 1 schema, 1 filesystem

This is a ''general'' question. Hear me out. Let's say I have a MySQL standalone or even a 3 or 5 nodes cluster. Would it be a good practice to have 1 filesystem per schema ? For example, schema{1..5} ...
yield's user avatar
  • 800
0 votes
1 answer
251 views

MYSQL: Many slave servers with smaller resources or less with larger resources

I want to create High availability with Master Slave replication (for Select query). I am wondering which one is better: Having smaller resources slaves but more servers or Having larger resources ...
yodann's user avatar
  • 101
0 votes
0 answers
43 views

2 servers, 2 databases on each, 1st server 1st db master and 2nd slave, 2nd server 1st db slave, 2nd master, is it possible?

I have 2 MySQL/MariaDB servers each of them with its own database and I would like to set up a continuous backup on each other via replication. Is it possible to make 1 DB master and 1 slave on each ...
Eugene's user avatar
  • 119
1 vote
1 answer
265 views

Update MySQL replication server position

I have been trying to set up a replication of a large DB (90GB) I have created a backup using mysqldump --single-transaction I have then restored that on the replication server. I have then enabled ...
jLynx's user avatar
  • 133
0 votes
1 answer
5k views

Error 'Character set '#255' is not a compiled character set and is not specified mySQL

Okay, I've hit a brick wall and have run out of ideas. Master: 8.0.25-0ubuntu0.20.04.1 Slave: 5.7.33-0ubuntu0.16.04.1-log Getting error with show slave status\G: Last_SQL_Errno: 22 Last_SQL_Error:...
Aninemity's user avatar
0 votes
1 answer
2k 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 ...
Mario Nette's user avatar
0 votes
2 answers
286 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 ...
WallyKaye's user avatar
1 vote
0 answers
204 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 ...
mbouzahir's user avatar
1 vote
1 answer
2k 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 ...
wmac's user avatar
  • 111
0 votes
3 answers
3k 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 ...
ArkoD's user avatar
  • 101
1 vote
0 answers
2k 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). ...
Sam89's user avatar
  • 11
0 votes
1 answer
263 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?
user595315's user avatar
0 votes
1 answer
3k 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 ...
user avatar
0 votes
1 answer
2k 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, ...
user avatar
0 votes
1 answer
384 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 ...
A B's user avatar
  • 1
0 votes
1 answer
654 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 ...
user540468's user avatar
1 vote
0 answers
319 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 ...
Malazzar's user avatar
0 votes
0 answers
49 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 ...
John's user avatar
  • 1
0 votes
1 answer
293 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 ...
aviv's user avatar
  • 167
0 votes
0 answers
55 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 ...
DBAJJ's user avatar
  • 1
0 votes
1 answer
819 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 ...
Abhinav's user avatar
  • 783
0 votes
0 answers
301 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 ...
user826323's user avatar
0 votes
1 answer
180 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 ...
Lê Minh Quân's user avatar

1
2 3 4 5
11