Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mysql-innodb-cluster]

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

MySQL InnoDB Cluster was released (GA) on April 12, 2017. It consists of three components:

  • MySQL Server (5.7+) with group replication
  • MySQL Shell (1.0+)
  • MySQL Router (2.1+) which is a database proxy

As with Galera cluster, only the InnoDB storage engine is supported. (And hence the name: InnoDB Cluster.) One difference from Galera is that it's not recommended to have geo-distributed nodes in InnoDB Cluster. (See Group Replication Limitations.)

Contrast: Galera, MySQL NDB Cluster

For more information

50 questions
4
votes
1 answer

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, while altering the existing table (which does not…
Tom Taylor
  • 141
  • 3
4
votes
2 answers

Mysql Group replication vs Mysql Cluster

[disclaimer] I'm not new to databases but totally novice about replication and cluster ... As you may know Mysql made available a new functionality : MySql Group Replication. Is anyone can explain me the fundamental difference between such…
tdaget
  • 803
  • 1
  • 12
  • 23
3
votes
0 answers

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 back online. When I run the…
Kanshi
  • 31
  • 2
3
votes
0 answers

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 (username@1.2.3.4:3306), I have created the cluster, and that seems to be ok. then I…
IGGt
  • 1,855
  • 3
  • 21
  • 39
3
votes
2 answers

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. Please change the server ID of the instance to add: all…
Wize
  • 135
  • 3
3
votes
2 answers

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.04.3 server LTS x 2 REP0 - REP1 All server instances…
jc__
  • 131
  • 3
2
votes
0 answers

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 available in each site and there is a dedicated MPLS…
Shoieb Arshad
  • 21
  • 1
2
votes
1 answer

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'); cluster =…
Heril Muratovic
  • 123
  • 5
2
votes
1 answer

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 using a replication method when networks are…
LahiruTM
  • 146
  • 7
2
votes
1 answer

MySQL InnoDB cluster pricing

On https://www.mysql.com/products/community/, the InnoDB Cluster is listed as part of the MySQL community edition, but when clicking the "Download MySQL Community Edition" link and further, I end up on the NDB cluster documentation. So I'm confused…
kenneho
  • 23
  • 3
1
vote
1 answer

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 find a way to capture the output from mysqlshell's…
IGGt
  • 1,855
  • 3
  • 21
  • 39
1
vote
1 answer

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 primary node has applied its backlog while the latter…
Matthew Kwong
  • 113
  • 4
1
vote
2 answers

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 to run a select query from the table below from…
mbouzahir
  • 111
  • 3
1
vote
1 answer

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 after I restored a backup in a test database on…
Abdul Raheem Ghani
  • 462
  • 5
  • 10
  • 21
1
vote
2 answers

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 just copied the previous InnoDB configuration…
Jung
  • 11
  • 2
1
2 3 4