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
0 answers
3 views

Mysql privileges broken by log_bin_trust_function_creators=1 flag

My privileges seem to be broken all round since enabling log_bin_trust_function_creators on GCP Cloud SQL I needed a trigger, which they don't allow at all with Binary Logging (which is enabled). So I ...
user avatar
  • 1
0 votes
0 answers
19 views

MariaDB Replication Master Slave Login Slave Login Forbidden

Good day everybody, As a newbie, I apologize if I'm doing this wrong. About the situation: We have two physical Ubuntu servers. These are in the same network and act as master/slave servers. The ...
user avatar
  • 1
0 votes
0 answers
18 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 ...
user avatar
  • 151
0 votes
0 answers
132 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', ...
user avatar
  • 1
0 votes
0 answers
45 views

MySQL replication warning "Automatically adding IPv4 localhost address to the allowlist. It is mandatory that it is added."

I have a MySQL 8.0.27 InnoDB cluster running on three Ubuntu 20.04 servers. Everything's working fine, but when MySQL starts I get these warnings in MySQL's error log: 2021-12-07T21:26:47.858979Z 2 [...
user avatar
  • 862
0 votes
0 answers
52 views

How to ignore DATABASE.TABLE SQL queries in binlog in MySQL for the databases I don't want to replicate

I set up replication for 1 database with binlog_do_db setting. But there are some queries like: USE replicated_db; DELETE not_replicated_db.table; Which breaks replication (with an error about ...
user avatar
  • 119
0 votes
0 answers
40 views

How do you set up MySQL master-master replication for my digitalocean host and my laragon localhost?

I created a Laravel web application on my computer using Laragon, then hosted it on Digital Ocean and it works fine. Now, I am supposed to implement a Mysql master-to-master replication for my "...
user avatar
  • 1
0 votes
0 answers
23 views

MySQL group replication with no downtime

Simple question - I have a server running MySQL and need to set up group replication. Can't afford downtime. How can one set up a mysql group replication on a running mysql server? (the other servers ...
user avatar
  • 1
0 votes
0 answers
17 views

SSL/TLS connection with onPremise MySQL Database

I'm trying to use SSL/TLS to encrypt the replication from an on premise MySQL database to a Google SQL Replica instance - This is the error I get.... "error": { "code": 400, "...
user avatar
  • 11
1 vote
1 answer
32 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} ...
user avatar
  • 615
0 votes
1 answer
52 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 ...
user avatar
  • 101
0 votes
0 answers
35 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 ...
user avatar
  • 119
1 vote
1 answer
82 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 ...
user avatar
  • 133
0 votes
0 answers
26 views

Azure MySQL create replica downtime

According to Azure Docs: When you create a replica for a source that has no existing replicas, the source will first restart to prepare itself for replication. Take this into consideration and ...
user avatar
  • 103
0 votes
0 answers
16 views

server replication stops. sql thread is not runnning

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 ...
user avatar
0 votes
1 answer
1k 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:...
user avatar
0 votes
1 answer
496 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 ...
user avatar
0 votes
2 answers
103 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 ...
user avatar
1 vote
0 answers
93 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 ...
user avatar
1 vote
1 answer
867 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 ...
user avatar
  • 111
0 votes
2 answers
1k 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 ...
user avatar
  • 101
1 vote
0 answers
978 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). ...
user avatar
  • 11
0 votes
1 answer
116 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?
user avatar
0 votes
1 answer
270 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
1k 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
182 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 ...
user avatar
  • 1
0 votes
1 answer
187 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 ...
user avatar
1 vote
0 answers
97 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 ...
user avatar
0 votes
0 answers
32 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 ...
user avatar
  • 1
0 votes
1 answer
64 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 ...
user avatar
  • 167
0 votes
0 answers
14 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 ...
user avatar
  • 1
0 votes
1 answer
215 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 ...
user avatar
  • 633
0 votes
0 answers
123 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 ...
user avatar
0 votes
1 answer
43 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 ...
user avatar
0 votes
1 answer
811 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-...
user avatar
0 votes
1 answer
743 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 ...
user avatar
1 vote
2 answers
770 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....
user avatar
1 vote
0 answers
96 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 ...
user avatar
1 vote
1 answer
327 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 ...
user avatar
0 votes
0 answers
544 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 - ...
user avatar
  • 101
2 votes
1 answer
876 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 ...
user avatar
0 votes
1 answer
759 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] ...
user avatar
2 votes
1 answer
7k 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/...
user avatar
0 votes
1 answer
187 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 ...
user avatar
0 votes
1 answer
213 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 ...
user avatar
0 votes
1 answer
644 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 ...
user avatar
0 votes
1 answer
1k 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 ...
user avatar
  • 3
1 vote
1 answer
894 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 ...
user avatar
  • 295
6 votes
2 answers
849 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 ...
user avatar
  • 402
1 vote
0 answers
758 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 / ...
user avatar

1
2 3 4 5
11