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

MySQL router Access denied for user 'routeruser'@'%' to database 'mysql_innodb_cluster_metadata' (1044)

I am trying to deploy MySQL-router in kubernetes, I had some problems previously and they were fixed. Now mysql-router pod is showing following error in kubernetes logs mysql-router-pod -n mysql-...
0
votes
0answers
31 views

ERROR 3911 (HY000) at line 24: Cannot update GTID_PURGED with the Group Replication plugin running

heyy all, we want to move our current mysql 5.6 server to mysql-8 innodb cluster. for this, we are setting up a replication like 5.6 -> temporary 5.7 -> mysql-8 cluster. We already have the ...
0
votes
0answers
33 views

MySQL Group Replication - Member won't join after clone, access denied for for user mysql_innodb_cluster

I have a problem with a MySQL group replication cluster member not joining the cluster group after cloning operation. Question: How do I get the failed member to join the group again and be able to ...
0
votes
1answer
29 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 ...
0
votes
0answers
22 views

MySQL innoDB cluster auto rejoin failed

3 node cluster, single primary. heavy read/write was happening on the master node. Restart the Master node. Then node 3 became the master. After the restart, the old master was in recovery state "...
0
votes
0answers
18 views

MySQL Group Replication Vs InnoDB cluster

Im just trying to understand the difference between InnoDB vs Group replication InnoDB cluster is built on top of GR, but what it have additionally than the GR? When to use group replication and when ...
0
votes
0answers
40 views

MySQL Split-Brain Scenario

So basically a Fault-Tolerant InnoDB Cluster has 3 nodes. In my case I have the same setup as recommended, then suddenly the Master Node(Primary) crashed then when the Master Node(Primary) trying to ...
1
vote
2answers
116 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 ...
1
vote
0answers
336 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 (username@1.2.3.4:3306), I have created ...
0
votes
1answer
24 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 ...
3
votes
2answers
264 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. ...
0
votes
0answers
95 views

MySQL InnoDB Cluster - database backup restoration

I have a 3 node MySQL InnoDB Cluster. I wanted to restore few databases around 20 GB each. Please help me with following questions: Can I restore it on Read/Write node through MySQL Router? Do I ...
0
votes
1answer
156 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 ...
0
votes
0answers
53 views

Router Configuration for HA InnoDB Cluster

I've set up three Ubuntu MySQL servers (18.04 LTS / 8.0.17) in a single-primary InnoDB cluster and have installed mysqlrouter on an application server. With the router’s configuration manually ...
0
votes
1answer
114 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 ...
1
vote
1answer
1k 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/...
0
votes
1answer
42 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 ...
0
votes
0answers
47 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 ...
0
votes
1answer
93 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 : ...
0
votes
3answers
1k 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 > ...
-1
votes
1answer
811 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 ...
1
vote
1answer
248 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 ...
0
votes
1answer
80 views

Mysql Innodb cluster does not show mysql server instances in Mysql shell

I followed docker innodb cluster manual method to create an innodb cluster. Now in mysql server instance, by running select * from performance_schema.replication_group_members, I can see the group ...
0
votes
1answer
72 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 ...
2
votes
1answer
120 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 ...
0
votes
1answer
343 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....
1
vote
0answers
444 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 ...
1
vote
0answers
71 views

MySQL Shell Python Client library

Is there a python client library available to interact with MySQL Admin API and to do similar stuff that MySQL Shell does. From the documentation of MySQL Shell, I could see that there is a --py mode ...
1
vote
1answer
262 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 ...
3
votes
2answers
799 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....
4
votes
1answer
98 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, ...
1
vote
1answer
1k 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 ...
0
votes
1answer
329 views

mysql innodb cluster 3 nodes, 2 lagging almost 24 hours

I have a 3 node setup and the 2 read only nodes are way behind (like 24 hours) from the rw node.. I saw here: https://bugs.mysql.com/bug.php?id=86797 to restart the lagging node and will pick up by ...
1
vote
0answers
598 views

MySQL InnoDb Cluster Replication Issue

I am trying to setup MySQL InnoDB Cluster. I am using version 5.7.20 of the MySQL server. I am able to create a cluster. When I try to add the first slave is when I run into my issue. It complains ...
1
vote
1answer
822 views

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 ...
0
votes
1answer
331 views

InnoDB Cluster Read-Only Lag Behind Writer

For software testing purposes, I'm using MySQL v5.7 and MySQL Router with a sandbox deployment of an InnoDB cluster with one read-write instance and two read-only instances. I'd like to be able to ...
1
vote
0answers
171 views

mysqld slowly eats memory

Summary My company recently deployed mysql innodb cluster as a backend database system using docker. To be exact, the cluster was deployed on Oct 3rd, so it has been almost two months. Recently, ...
0
votes
2answers
3k views

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 ...
4
votes
2answers
5k views

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 ...