Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [mysql-innodb-cluster]

MySQL's high-availability, multi-master, replication clustering solution for the InnoDB storage engine with automatic failover

Filter by
Sorted by
Tagged with
0 votes
0 answers
27 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
0 votes
0 answers
29 views

mysql clusterset vs replication

We run a medium sized app which may need the potential to grow but for a few years a single Mysql server would be sufficient. However we host on Azure which twice in the last 6 months has gone down ...
Antony's user avatar
  • 101
1 vote
1 answer
329 views

Configuring High Availability for MySQL Router in a MySQL InnoDB Cluster

I've configured a MySQL InnoDB Cluster for high availability with two servers on a Windows system (Server 1: h01xxxxxxxxx1, IP: 10.xxx.xx.61, Server 2: h01xxxxxxxxx2, IP: 10.xxx.xx.71), running ...
alaa's user avatar
  • 11
0 votes
0 answers
84 views

It's possible switchover a innodb cluster instance as primary?

If I am in topologyMode Single-Primary, it's possible to switchover the primary instance between machines in the cluster? I did not find anything in the documentation. Ie: in my lab I have: topology&...
Astora's user avatar
  • 723
1 vote
0 answers
35 views

Delay Async Replication Time ClusterSet

I have following setup: Primary InnoDB Cluster with 3 instances(following Group Replication Protocol), R/W setting. Replica InnoDB Cluster with 3 instances(following Group Replication Protocol), R/O ...
nyx's user avatar
  • 11
0 votes
1 answer
289 views

Load Balancing in mysql InnoDB cluster

I have set up an InnoDB cluster with one primary(R/W) and two secondaries (R/O) and bootstrapped a MySQL Router. The router has 2 port 6646(R/W port) and 6647(R/O) port. My application is currently ...
Wong Chung sze's user avatar
0 votes
1 answer
115 views

mysql-shell: assign the return for dba.checkInstanceConfiguration() to a javascript variable

I am trying to create a javascript file that is invoked by mysql-shell that can automatically test, using dba.checkInstanceConfiguration("user@mysql-node:3306"), if instance is ready for ...
goremo's user avatar
  • 1
0 votes
1 answer
561 views

Mysql innodb cluster: Cannot start primary node

I am trying my first set up for innodb cluster based on the book 'Introducing InnoDB Cluster Learning the MySQL High Availability Stack' by Charles Bell. While trying to launch the primary node with ...
goremo's user avatar
  • 1
0 votes
1 answer
159 views

MySQL InnoDB Cluster config - configure node address

I first asked this question on Stack Overflow but I woke up this morning to the realization that it belongs over here. I'm setting up an InnoDB Cluster using mysqlsh. This is in Kubernetes, but I ...
Jerry's user avatar
  • 101
1 vote
1 answer
293 views

Inndob Cluster - Automatically collect the output from mysqlsh?

Is there a way to take the output from mysqlshell and use it in a script or similar. I have set up a basic cluster for testing (3 x MySQL 8.0.27 databases, running on Debian 11). I am now trying to ...
IGGt's user avatar
  • 2,126
1 vote
1 answer
507 views

Removing router from MySQL InnoDB cluster

Currently I have configured 3 node MYSQL InnoDB Cluster with two routers. Is it possible to remove one of the router from cluster? what are the implications ? using cluster.listRouters() I could see ...
user avatar
0 votes
1 answer
139 views

exitStateAction not working as expected on MySQL INNODB Cluster

I'm in the process of setting up and testing an Innodb Cluster. So far I have three nodes running 8.0.27 and two routers all working fine. I now want to test what happens if the network connection ...
IGGt's user avatar
  • 2,126
0 votes
1 answer
269 views

MySQL Group Replication Vs InnoDB cluster

I am new to MySQL world. I would like to understand the difference between MySQL Group Replication and InnoDB cluster, is there any other differences apart from router configuration for InnoDB cluster?...
var's user avatar
  • 1
2 votes
0 answers
282 views

mySQL cluster with Active Active DC

Let me give you a bit of background before jumping into the discussion. Our company is running two DC's in active active scenario, we spent a lot of money on getting specialized hardware to be ...
Shoieb Arshad's user avatar
0 votes
1 answer
693 views

Why slave_parallel_workers affects TPM

I ran a few HammerDB benchmarks and mess with the configurations. And I notice different values of slave_parallel_workers have a considerable impact on TPM. As far as I understand, ...
Matthew Kwong's user avatar
1 vote
1 answer
296 views

MySQL Group Replication consistency EVENTUAL vs BEFORE_ON_PRIMARY_FAILOVER

As far as I understand, BEFORE_ON_PRIMARY_FAILOVER is exactly behaving like EVENTUAL in normal scenarios until a failover happened, which the former will block all new transactions until the new ...
Matthew Kwong's user avatar
0 votes
1 answer
281 views

MySQL client goes down after using setPrimaryInstance() in InnoDB clustering, but the cluster remains up with all nodes functioning

So, I have a cluster of 3 nodes, each in a different data center located in the same city. My architecture is a single primary one where one node (let's call it Node 1) is primary and the other two ...
stressed out's user avatar
0 votes
0 answers
80 views

MySQL 8 Innodb clustering add instance error

During MySQL 8 innodb clustering add instance. Cluster.addInstance: The port '33101' for localAddress option is already in use. Specify an available port to be used with localAddress option or free ...
Goutam Jana's user avatar
3 votes
0 answers
3k views

MySQL/InnoDB cluster unable to reboot

I have a three-node MySQL/InnoDB cluster (version 8.0.25), that has been deployed by Juju/OpenStack a couple of month ago. The cluster has recently crashed and I unfortunately can't manage to bring it ...
Kanshi's user avatar
  • 31
0 votes
0 answers
162 views

1205 Lock wait timeout exceeded after switching to multi-primary topology in MySQL InnoDB Cluster

I have set up an InnoDB cluster using MySQL (version 8.0.23) Shell. I added three nodes to my cluster. At first, my topology was a single-primary topology where I had one master node and two slave ...
stressed out's user avatar
0 votes
1 answer
3k views

Mysql Innodb Cluster Replication

Hello Everyone, This is the first time I'm doing cluster replication. But I stuck on Adding Instance. I don't know why this error is coming behind. "The error says The START GROUP_REPLICATION ...
Karan's user avatar
  • 11
0 votes
2 answers
3k views

What contributes to the transaction size on a MySQL UPDATE?

Background We're running a MySQL 8 INNODB cluster behind some Java services. We received an error from the application because we'd exceeded the group replication transaction size limit (“Error on ...
scarba05's user avatar
  • 103
1 vote
2 answers
566 views

MySQL hangs on SELECT from table with blob fields

I managed to create a mysql 8 InnoDB cluster with three nodes (VPS in one dedicated server, 25GB ram in each VPS, Total RAM in the server 96GB) and MySQL Router 8 everything works great but when I try ...
mbouzahir's user avatar
  • 111
2 votes
1 answer
3k views

MySQL InnoDB Cluster - Add instance issue with local port

I have an issue to add instance to MySQL InnoDB Cluster using MySQL Shell. Here are the steps that I have done: Login to one DB-01 node Run command: mysqlsh shell.connect('username@ip-address:port'); ...
Heril Muratovic's user avatar
1 vote
1 answer
2k views

Cannot rejoin or add instance to MySQL InnoDB cluster

I have a MySQL InnoDB cluster running where I had added three nodes, one is having the Primary role and the others are Secondary. Today morning, the two secondary nodes were removed from the cluster ...
Abdul Raheem Ghani's user avatar
0 votes
1 answer
118 views

Innodb mysql 5.7 cluster wont join after reboot

I get the following when I try to recover the cluster from a complete outage. Can anyone advise what's going on cluster = dba.rebootClusterFromCompleteOutage() Dba.rebootClusterFromCompleteOutage: ...
Dino Daniel's user avatar
1 vote
1 answer
4k views

Mysql InnoDB Cluster

I'm trying to setup mysql innodb cluster. I have couple of Digital Ocean (DO) instances running centos 7. I have installed Mysql Ver 8.0.21 for Linux on x86_64 (MySQL Community Server - GPL) on the DO ...
Chandra Kanth's user avatar
0 votes
1 answer
2k views

MySQL Group Replication - Offline Node with cluster Metadata 1.0.1

I have a production MySQL Group Replication setup out of three Nodes. The cluster has Metadata Version 1.0.1. Today, one node went down an during rejoin phase, it says, it cannot connect to the ...
t2m's user avatar
  • 11
1 vote
2 answers
563 views

Tuning MySQL on GROUP REPLICATION

I'm close to switch from old version of MySQL 5.6 ( master / slave configuration ) to MySQL 8 ( 3 nodes on multi-master configuration ) in GROUP REPLICATION. The tables are 99% InnoDB. The webfarm ...
Jung's user avatar
  • 11
3 votes
0 answers
2k views

MySQL Group Replication - Peer address is not valid

I have been trying to set up an MySQL Innodb Cluster, initially with two databases, both MySQL 8.0.19. But I keep getting the same errors. On the first one ([email protected]:3306), I have created ...
IGGt's user avatar
  • 2,126
0 votes
1 answer
308 views

Innodb cluster options missing

I have successfully installed and run an INNODB Cluster on mysql 8.0.19 However I cannot set options for the cluster when we run cluster=dba.getCluster(); cluster.options(); We get the following ...
Wize's user avatar
  • 135
3 votes
2 answers
1k views

MySQL incorrectly saying serverID non unique when adding an instance to the InnoDB cluster

I Get the following error when adding the second instance to a MYSQL Innodb Cluster ERROR: Cannot add instance 'XXX' to the cluster because it has the same server ID of a member of the cluster. ...
Wize's user avatar
  • 135
2 votes
1 answer
946 views

How to configure MySQL Router on two application servers?

I have three MySQL servers running with group replication and inside a InnoDB Cluster. I have two app servers that will be connecting to the cluster and I need to configure mysql router on both app ...
Manuel's user avatar
  • 71
2 votes
1 answer
2k views

Relay log read fail, relay or master log currupt ,How to repair?

I am running mysql InnoDB cluster 8.0.17(group replication) During the repication the slave disk gets full and no space left at all the thread waits for the disk space to be freed at the same time ...
dan's user avatar
  • 53
1 vote
1 answer
6k views

Unable to add new instance on MySQL InnoDB cluster

I'm setting up new MySQL InnoDB cluster 8.0.16 consisting of three instances: srv-mysql-01 srv-mysql-02 srv-mysql-03 I run JS-script in mysql shell for build cluster: mysqlsh --file=/tmp/...
Aleksey B.'s user avatar
0 votes
1 answer
142 views

Repair GTID from Restore with sql_log_bin=0 and then drop table

I have been experimenting with mysql innodb cluster. One of the errors i've come across I don't know how to remedy or why exactly it causes a permanent death to any slave that wishes to catch up to ...
Watson's user avatar
  • 155
0 votes
0 answers
196 views

Mysql 8.0 table_rows problem

I'm doing an application and I have the following problem: I'm doing a LOAD DATA INFILE into a table from a txt file, that has 2 million rows. I want to see the table_rows of my table with: SELECT ...
Leonardo Quatrocchi's user avatar
0 votes
1 answer
238 views

MySQL CLustering Options

I have two MySQL Database Servers i.e. One is Active Server --> Master and second is Passive Server --> Slave. And as we know we have 3-4 MySQL HR,DR Solutions / Clustering options.For example 01 : ...
Mubashar Iftikhar's user avatar
1 vote
3 answers
5k views

Innodb cluster setup error

Reframed: Here are the steps I followed but is resulting into an error: I am connected to my primary node (10.0.0.4) and I checked the config of all the nodes using below: MySQL localhost JS > ...
user5594148's user avatar
-1 votes
1 answer
4k views

InnoDB cluster error: ReferenceError: cluster is not defined

I was setting up the MySQL InnoDB cluster, when I got this error. I created the cluster from the primary node, the cluster.status() was giving output as 'ONLINE' at this point with only one node part ...
user5594148's user avatar
1 vote
1 answer
666 views

Secondary nodes in mysql 8.0.15 innodb cluster are not reading group_replication_member_expel_timeout variable from my.cnf

I have setup a 3 node mysql 8.0.15 innodb cluster. I have been trying to set group_replication_member_expel_timeout variable to 60 via the /etc/my.cnf file. Although the primary node has read the ...
Lalith Kumar H's user avatar
0 votes
1 answer
383 views

Why does MySQL InnoDB cluster not show MySQL server instances in MySQL shell?

I followed the docker innodb cluster manual method to create an InnoDB cluster. Now in the MySQL server instance, by running select * from performance_schema.replication_group_members, I can see the ...
Tiina's user avatar
  • 101
0 votes
1 answer
294 views

how the mysql server settings replicatd in innodb cluster

I just started learning about cluster so I don't have much knowledge if question is not appropriate please forgive me. I have a 3 node InnoDB cluster running .suppose if I want to tune my server by ...
dan's user avatar
  • 53
2 votes
1 answer
539 views

How to setup two mysql servers with group replication to work individually, when no network

I have two mysql servers in two different places. Both servers must be able to read and write. All tables are designed to based on unique id (UUID) primary key. I want to sync these two databases live ...
LahiruTM's user avatar
  • 146
0 votes
1 answer
680 views

Application considerations when using a multi-primary innodb cluster

I'm developing a scalable cloud application and I wish to use a multi-primary cluster to be better able to scale horizontally when needed. I have experience with a single primary cluster configuration....
Dylan James McGannon's user avatar
1 vote
0 answers
925 views

Delete query end state lasts tens of seconds in innodb cluster

I have an InnoDB cluster with three nodes running with 4GB ram and 80GB SSD on Linode. I am trying to delete around 240000 of rows from MySQL InnoDB cluster in one go. However, it stuck at query end ...
Yen's user avatar
  • 193
1 vote
1 answer
554 views

check slave status innodb cluster

On InnoDB cluster, I have tried to execute command 'show slave status' to get status of a slave. But the system returns 0 row. So now I want to check the status of a slave, check which bin log file is ...
gohan's user avatar
  • 13
3 votes
2 answers
2k views

How to change MySQL InnoDB cluster from single primary mode to multi primary mode?

My goal is to setup, in a lab environment, a MySQL InnoDB cluster in multi-primary mode. I have read much, but I cannot get this setup to work. Ubuntu 16.04.3 server LTS x 3 SQL0 - SQL2 Ubuntu 16....
jc__'s user avatar
  • 131
4 votes
1 answer
575 views

Does MySQL allows incoming queries while altering a table?

I'm adding a new column to an existing table say ABC with the following query, ALTER TABLE ABC add column STATUS int(10) NOT NULL This is done in master, slave and secondary slaves. Meanwhile, ...
Tom Taylor's user avatar
2 votes
1 answer
4k views

Restart event scheduler and alter event when slave being promoted to master

I am using innnodb cluster. It is good that every time a R/W node failed the R/O node will being promoted to R/W. However I have to restart scheduler and alter event enabled (originally slave side ...
Yen's user avatar
  • 193