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
1answer
10 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
103 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
26 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
29 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
37 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
0answers
38 views

Option file required issue, While creating Mysql 5.7 InnoDB Cluster

I am trying to setup a Production Deployment of InnoDB Cluster in Azure Environment Getting Issue on the option file required. MySQL 127.0.0.1:3306 ssl JS > dba.configureLocalInstance(); ...
0
votes
2answers
578 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 > ...
0
votes
1answer
207 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
108 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
44 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
44 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 ...
1
vote
1answer
87 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
0answers
20 views

Ignore keys while mysql command line export

I am writing a bash script to export a few tables from the MySQL DB and import in the backup DB. I will repeat this process on an hourly basis and will keep all the tables by changing the table name. ...
0
votes
1answer
241 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
277 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
49 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
155 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
538 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
78 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
861 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
251 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
526 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
528 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
210 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
141 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
1answer
2k 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 ...
3
votes
2answers
4k 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 ...