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

60 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
  • 825
  • 2
  • 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
  • 1
  • 3
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
  • 2,266
  • 6
  • 35
  • 49
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
  • 4
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
  • 1
  • 6
2
votes
1 answer

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 instances, alone with Mysql-Shell Ver 8.0.21. I…
Chandra Kanth
  • 121
  • 1
  • 4
2
votes
1 answer

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 servers. When I run router on server1 I use the…
Manuel
  • 91
  • 7
2
votes
1 answer

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 this was happening the server restarted once server…
dan
  • 53
  • 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

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 disabled) manually for the cluster again. It…
Yen
  • 193
  • 2
  • 3
  • 11
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
2
votes
2 answers

how to resolve innodb cluster conflict

I am currently maintaining an innodb cluster with three nodes. It runs well but sometimes one node will be MISSING then I have to bring it up online again. The problem is I inserted a table without primary key. Then a node failed. When I want to…
Yen
  • 193
  • 2
  • 3
  • 11
1
2 3 4