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).
529
questions
0
votes
1
answer
106
views
Kubernetes MySQL Operator 8.4.0 not ready (stuck on start)
I have followed step by step the instructions to deploy the MySQL operator on Kubernetes. Following the instructions from the official page. Once deployed without errors, the operator is not in ready ...
- 1
0
votes
1
answer
109
views
Backup Mariadb from replica
I have cloud server with a MariaDB database that I want to backup.
To avoid use the bandwith to transfer locally generated backup files from the cloud service to my backup server, one of the ...
1
vote
0
answers
62
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 ...
- 11
1
vote
1
answer
1k
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 ...
- 113
0
votes
0
answers
21
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 ...
- 113
0
votes
1
answer
171
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 ...
- 157
1
vote
0
answers
725
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 ...
- 33
0
votes
1
answer
514
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....
- 33
2
votes
1
answer
282
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 ...
- 121
0
votes
0
answers
97
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 ...
- 111
2
votes
1
answer
187
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 ...
1
vote
0
answers
420
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 ...
- 83
2
votes
1
answer
1k
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 ...
- 83
0
votes
1
answer
270
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 ...
- 109
0
votes
1
answer
928
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
...
- 103
1
vote
1
answer
3k
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 ...
0
votes
1
answer
6k
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,...
- 135
0
votes
1
answer
80
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 ...
- 133
0
votes
1
answer
364
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 ...
- 51
2
votes
1
answer
694
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 ...
- 135
0
votes
0
answers
292
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 ...
1
vote
1
answer
354
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 ...
- 11
0
votes
1
answer
1k
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 ...
- 1
0
votes
1
answer
408
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 ...
- 121
0
votes
1
answer
140
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-...
- 103
0
votes
1
answer
565
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 ...
- 101
1
vote
1
answer
442
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 ...
- 119
0
votes
0
answers
194
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 ...
- 171
0
votes
0
answers
754
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',
...
- 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} ...
- 828
0
votes
1
answer
292
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 ...
- 101
0
votes
0
answers
46
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 ...
- 119
1
vote
1
answer
292
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 ...
- 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:...
- 73
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 ...
- 51
0
votes
2
answers
333
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 ...
- 13
1
vote
0
answers
219
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 ...
- 77
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 ...
- 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 ...
- 101
1
vote
0
answers
3k
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).
...
- 11
0
votes
1
answer
276
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
1
answer
5k
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 ...
user587541
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, ...
user587541
0
votes
1
answer
423
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 ...
- 1
0
votes
1
answer
716
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 ...
- 162
1
vote
0
answers
350
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 ...
- 21
0
votes
0
answers
50
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 ...
- 1
0
votes
1
answer
393
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 ...
- 167
0
votes
0
answers
61
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 ...
- 1
0
votes
1
answer
1k
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 ...
- 823