Questions tagged [mysql-cluster]

MySQL's Distributed Database.

Filter by
Sorted by
Tagged with
2 votes
1 answer
160 views

What happens to mysql synchronous replication when read replica can't respond?

In the official doc https://dev.mysql.com/doc/mysql-replication-excerpt/8.0/en/replication.html It mentioned that if synchronous replication is required, use NDB instead For scenarios where ...
olaf's user avatar
  • 123
1 vote
0 answers
43 views

Persona Xtradb cluster CONFLICT DETECTED

I am working on a high-traffic platform with MySQL clustering using Percona XtraDB Cluster. I have a cluster consisting of 4 nodes. The database is receiving more than 500 requests per second for ...
Sam Wiki's user avatar
0 votes
0 answers
58 views

What is the best way to simulate split-brain?

I have a Windows failover cluster and would like to test if it works in a split-brain scenario. The cluster consists of virtual machine in hyper-V. How would one go about doing this?
Nothing Else's user avatar
-1 votes
3 answers
572 views

I am very frustrated by problems trying to set up mysql-cluster. There are no service files for NDB daemons

I am trying to get mysql-cluster going on Ubuntu 22 from the official MySQL apt repo. I keep running into complications. Certain ndb-related daemons are required ... like ndbd. But there are no ...
elyograg's user avatar
  • 103
0 votes
2 answers
237 views

Can't drop an NDB database because the storage engine is unavailable

I tried to set up a MySQL cluster and failed. I finally got it switched back to standard MySQL, but now I have an ndbinfo database that I cannot drop. It causes my automysqlbackup cron job to report ...
elyograg's user avatar
  • 103
1 vote
0 answers
21 views

Linux - MySQL Master/Slave cluster - upgrade 8.0.17 to 8.0.25

I'm running a cluster of MySql, 1 master, 1 slave (manage by an external app) on Linux and I would like to upgrade to the latest version in the same release without downtime. 8.0.17 to 8.0.25 ...
AnonymeJohnDoe's user avatar
0 votes
1 answer
44 views

MySQL partition failed

I do partition with 6.595.057 rows in MySQL with the Galera cluster. When I tried partition in server without galera, partition successfull. But when I tried partition in server with galera cluster, ...
Adi Prasetyo's user avatar
0 votes
1 answer
61 views

NDB Cluster Read and Write Process multiple Access

When using the MySQL NDB Cluster distributed database, the following general problem has arisen: To insert a new Record / Row, the last row in the database should be read, see if it is compatible with ...
programmer_13's user avatar
0 votes
2 answers
652 views

What is the best solution for synchronous sync and load balancing an InnoDB database

I'm trying to find the best setup to horizontally scale an ecommerce which is currently on a single dedicated server, but even reading some of the replies here on DBA I'm still confused on what is the ...
matrix's user avatar
  • 1
0 votes
0 answers
161 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
1 vote
1 answer
510 views

Proxysql setup for Percona PXC Multimaster cluster

I have a clean Ubuntu lab setup for PXC Cluster and Proxysql (each a separate VM)and i'm seeing this issue (error below). Is there a specific installation that needs to be followed for PXC cluster? I ...
Storm's user avatar
  • 11
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
1 answer
1k views

MySQL cluster Replication and Failover via docker-compose

I am using docker-compose to create MySQL cluster (NDB). After cluster gets created. This is my cluster configuration: ndb_mgm> show Connected to Management Server at: mysql-manager-1:1186 Cluster ...
Ishan's user avatar
  • 3
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
1 vote
1 answer
203 views

Is there a way to hide mysql innodb cluster queries from general_log?

When I start my innodb cluster I get many lines of cluster related logs in the mysql general_log file like below, how can I hide these from the log? 2020-06-26T14:40:43.719029Z 31774 Connect ...
Ken's user avatar
  • 21
0 votes
1 answer
205 views

Is there a way to set different destination order with mysql-router?

I have innodb cluster setup with 3 mysql instances. Each instance is on different server and each server has mysql-router also. I would like each mysql-router on each server to try to connect to the ...
Ken's user avatar
  • 21
-1 votes
1 answer
143 views

binlog not recording DML statement in mysqlcluster

I have created a MySQL NDB Cluster consisting of 2 data node, 1 mgm node and 1 mysqld for testing. Also i have created a slave for NDB to INNODB replication. My binlog are not recording DML statement ...
nooruddin dalvi's user avatar
0 votes
0 answers
151 views

MySQL cluster with HAProxy balancer outside of local network

I am building a mysql cluster on local network. I have 3 nodes and would like to load balance them using HAProxy. It works fine when I place HAProxy on one of my nodes inside of the network. I bind ...
Nikita Voevodin's user avatar
0 votes
1 answer
41 views

SQL Router Not Applying Round Rubin

I configure sql router under three machines and found if I use simple command mysql -u ia -pTest@123 --port=7001 then its not applying round rubin connection request but when i use with protocol ...
irfan_db's user avatar
0 votes
1 answer
374 views

mysql 8 ndbcluster distributed privileges

I've setup a mysql 8 ndbcluster but cannot get the distributed privileges working. following how to setup distributed privileges using NDB_STORED_USER (https://dev.mysql.com/doc/refman/8.0/en/mysql-...
carefreepineapple's user avatar
0 votes
1 answer
201 views

MySQL database cluster vs. replication setup for large crawler indexes

What is the most efficient way to set up a MySQL cluster or replication in an application that has a crawler/indexing engine with thousands of read/writes and then a separate front-end for public ...
zen's user avatar
  • 121
1 vote
1 answer
185 views

mysql data node not connecting to node manager on AWS EC2

I am trying to setup mySql manager + data node + sql server (Server A) and another data node cluster on (Server B). Both running on Ubuntu 16.04 amd_64 Server A /etc/hosts also on Server B Both ...
mohamed tebry's user avatar
0 votes
0 answers
276 views

ProxySQL and MySQL cluster

This article describes the set-up of MySQL cluster with one cluster node, two data nodes and one MySQL server. This article describes the configuration of ProxySQL where, MySQL servers are added into ...
cogitoergosum's user avatar
0 votes
1 answer
59 views

What will be with MySQL cluster if network problems between nodes?

I have 2 datacenters, each DC has MGT, SQL and Data nodes. How will MySQL NDB Cluster work if there are network problems between 2 DC? In this case 2 DC will work well, but they don't know ...
Epic555's user avatar
  • 101
0 votes
1 answer
1k views

MySQL Cluster - SQL node fail to connect Management Nodes

I am trying to deploy a 2 machines MySQL NDB Cluster with the following architecture: 192.168.1.12 – management node 192.168.1.12 – SQL node 192.168.1.12 – data node 192.168.1.13 – SQL node 192.168....
abouyahya85's user avatar
0 votes
0 answers
4k views

Newly built MySQL Galera Cluster does not start up in CentOS 7

I am setting up a 3 node MySQL Galera Cluster lab environment. All 3 nodes are CentOS 7 and followed the steps in below blog to setup mysql-wsrep-5.7 https://www.dreamvps.com/tutorials/install-...
udhayan dharmalingam's user avatar
0 votes
1 answer
503 views

config file and parameters for ndb_desc

I'm trying to execute ndb_desc from API client. The config and parameters are as below: my.cnf in mysqld: [mysql_cluster] ndb-connectstring=192.168.1.1,192.168.1.2 server-id=5 log-bin=mysql-bin ...
nyoto arif's user avatar
2 votes
1 answer
655 views

How can coupled databases be kept in sync with selective uni-directional syncing and with connections that can be off for days?

I am trying to create a database topology that looks like this: .------------. Bad Connection. Bad Connection. | Central DB | May go offline May go offline '-----...
284507243's user avatar
0 votes
1 answer
131 views

What steps to take to resize an existing MYSQL NDB Cluster?

I have an existing NDB Cluster. It's grown larger than I expected and I need to make it bigger. When I ask the management console for the ALL REPORT MEMORY, it looks like the datamemory is 65% full. ...
xer0x's user avatar
  • 103
-1 votes
1 answer
673 views

all gradestate.dat seqno: -1 why?

All my 3 nodes in mariadb galera cluster seqno is -1 and when i restart the whole cluster i need to start with --wsrep_new_cluster just to start the other nodes. can anyone help me with this? all 3 ...
demz merven's user avatar
0 votes
1 answer
135 views

ProxySQL in PXC and failing all nodes

I'm going to install Percona XtraDB Cluster, and I have two questions about it: 1- Is it the last step? https://www.percona.com/doc/percona-xtradb-cluster/LATEST/verify.html Or installing ProxySQL ...
behnamy01's user avatar
1 vote
2 answers
1k views

MySQL Solution to Sync 3 servers data

I have 3 servers which there is a load-balancer in front of them and sends the requests to these servers randomly. The script is the same in all of these 3servers, but I need to sync the DB in all of ...
behnamy01's user avatar
1 vote
1 answer
34 views

Mysql cluster configuration help

I am new to mysql cluster I was reading around the web how to set it up. I came up with 2 different set up not sure which one is better fail safe vs cost efficient. Our new site have clients in USA ...
find it now's user avatar
0 votes
1 answer
1k views

How to delete previous incarnation in MySQL (/w Group Replication)

There exist almost no mentions whatsoever of MySQL "incarnations", so I'm opening this topic to make a precedent, even if I solve it myself. Feel free to help of course :) 2018-08-10T16:21:34....
insideClaw's user avatar
0 votes
2 answers
2k views

MySQL Cluster setup, receiving error "Specify node id"

I am attempting to set up a MySQL Cluster. I have the following setup: One management node Two data nodes One SQL node Below is the config.ini file: [ndbd default] # Options affecting ndbd processes ...
subbhashree's user avatar
-1 votes
1 answer
356 views

MySQL Cluster - Data Node Restarting when database corrupt

I initially Have MySQL cluster with 2 Management and 2 Datanode. I added 2 Data node online and redistribute its data. So my current cluster setup is 4 Management Node + SQL and 4 Data node. There ...
Moch. Rasyid's user avatar
2 votes
1 answer
502 views

MySQL InnoDB or MySQL NDB Cluster which one to use

We have an application with 8000 users accessing in parallel(max). We are trying to bring in horizontal scaling. I came across MySQL NDB cluster. Should I go with it? Just for auto sharding and other ...
Mani's user avatar
  • 121
0 votes
1 answer
98 views

I can't add extra node after reset root password mariadb 10.1.20

I have a mariadb 10.1.20 cluster with 5 nodes. I don't know root password so I did the following steps: On second node, I stopped mysql service I set wsrep = OFF on /etc/my.cnf.d/server.cnf I ...
user3637971's user avatar
2 votes
1 answer
19k views

Dba.getCluster: This function is not available through a session to a standalone instance (RuntimeError)

I am using mysql innodb cluster. Connect to my instance use \c root@localhost:3306. The error message pops out when I issue var cluster = dba.getCluster('testCluster'). I've already created the ...
Yen's user avatar
  • 193
0 votes
2 answers
881 views

How to migrate MySQL Cluster (NDB) backup to a different ndb cluster?

I have two MySQL Clusters (NDB), Prod and Dev. Each cluster contains SQL nodes, Management nodes and Data nodes. Backups are done on one cluster using the article below: https://dev.mysql.com/doc/...
McJagger's user avatar
1 vote
1 answer
739 views

Excessive RAM consumption in MySQL Cluster

at this moment I have configured a cluster that has 5 nodes: 2 data nodes 2 SQL nodes 1 node manager My file.config.ini is the following: [ndbd default] NoOfReplicas = 2 # Number of replicas ...
Jonathan Diaz's user avatar
0 votes
1 answer
125 views

Scaling MySQL Cluster

I have an NDB cluster which consists of 4 data nodes. Some of the configuration parameters and system resources as : CPU: 32 RAM: 128GB Replication factor: 2 Data memory: 70GB Index memory: 10GB I ...
Gpost's user avatar
  • 73
1 vote
1 answer
2k views

MySQL Cluster 7.3 - NDB engine - Could not connect to storage engine

Setup I have installed three Oracle Linux 7.3. 2 for data nodes, 1 for management and SQL API node. The machines can ping each other, SSH working, "etc/hosts" files are properly filled: 127.0.0.1 ...
huksha's user avatar
  • 11
0 votes
1 answer
290 views

Geographical replication zones in MySQL Cluster?

In a default installation, data is shared indiscriminately across all data nodes. Is it possible to specify that certain tables can only be replicated across a specific group of data nodes? If so, ...
Kae Verens's user avatar
0 votes
1 answer
136 views

Deleted config.ini in MySQL cluster by mistake

I was trying to delete cache file of MySQL cluster for rolling restart, but by mistake I deleted the directory /var/lib/mysql-cluster from both the nodes. I have ndb_1_config.bin.1 file, but how can ...
Sagar Shinde's user avatar
1 vote
0 answers
32 views

Mysqlcluster data nodes synchronization rate

mysql cluster version: MySQL-Cluster-gpl-7.4.12-1.el6.x86_64 num of datanodes: 2 num of sqlnodes: 2 num of mgmt nodes: 2 Recently one on my datanode server was down(node4) due to power outage. ...
sherpaurgen's user avatar
-1 votes
1 answer
374 views

How do stored procedures work with NDB Mysql Cluster?

We are considering to use Mysql Cluster for sharding. However I can't find how it works with stored procedures. Is there a way to dispatch procedure invocation on particular shard, based on sharding ...
silent-box's user avatar
0 votes
1 answer
5k views

MySQL Node not Connecting to Management Nodes in NDB Cluster

I am trying to deploy a 8 machine MySQL NDB Cluster with 2 Management Nodes, 2 SQL Nodes and 4 Data Nodes. The base operating system is Ubuntu 16.04 and the MySQL Cluster software version is 7.5.4. ...
Mangesh's user avatar
4 votes
2 answers
9k 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 ...
tdaget's user avatar
  • 813
0 votes
1 answer
121 views

Problem in MySQL cluster when using two clusters

I have a master-slave MySQL Cluster 1 which is two way. It is working fine. I have another MySQL master-slave Cluster 2 where data is coming from Cluster 1 master to Cluster 2 master. It is also ...
Frank Martin's user avatar