Skip to main content

Questions tagged [ndbcluster]

NDB Cluster : MySQL's Distributed MultiMaster Storage Engine

Filter by
Sorted by
Tagged with
0 votes
1 answer
30 views

SQL and Management Nodes on same server in NDB cluster. SQL Nodes not connecting

I've setup a ndb cluster with 7 nodes. 3 data nodes on their own servers, and 2 management nodes that each have a sql node on them on 2 servers. I've narrowed down what I think my issue is. My cluster ...
Mr. Berzerk's user avatar
2 votes
1 answer
166 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
0 votes
1 answer
26 views

Unable to import more than 110 Columns in single table in NDBC

I have configured NDBCLUSTER with 4 data nodes, 1 sql node and 1 management node. But I have increased the 4GB of DataMemory size for every node and IndexMemory size 500MB also. I have given ...
Debabrata's user avatar
0 votes
1 answer
107 views

MySQL NDB Cluster Community - High memory utilization by mysqld only on source/replica nodes

I have two MySQL NDB community clusters 8.0.30, each with 3 VMs Cluster#1_VM1: mysqld + ndb_mgmd Cluster#1_VM2: mysqld + ndb Cluster#1_VM3: mysqld + ndb Cluster#2_VM1: mysqld + ndb_mgmd Cluster#2_VM2: ...
Marcin Stolzmann's user avatar
0 votes
2 answers
257 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
0 votes
1 answer
62 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
196 views

MySql NDB cluster large transaction

I know that with NDB you can not do large transactions, if you do data nodes can restart into read-only mode and corrupt table. I need to copy records into a new table but the thing is this table ...
Rait's user avatar
  • 47
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 votes
1 answer
146 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
1 answer
379 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
1 vote
1 answer
194 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
282 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
239 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 : ...
Mubashar Iftikhar's user avatar
1 vote
0 answers
207 views

MariaDB Galera slave thinks it's replicating, but it isn't

I have a MariaDB 10.3 Galera slave node with general logging turned on. It's consuming binlogs generated by a MySQL 5.5 NDB cluster. The binlog format is row-based in both databases. SHOW ALL ...
Brian Bauman's user avatar
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
1 answer
509 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
0 votes
2 answers
437 views

Max DATAFILE size in NDB engine

My database setup is using NDB cluster with 2-3 nodes, on CentOS. While trying to test out the performance, i tried to store ~7mil records (around 2GB size) into one of the table. at around ~200k, it ...
nyoto arif's user avatar
0 votes
1 answer
261 views

partition in ndbcluster

My environment will use 2-3 cluster nodes. The db schema at first was designed without knowing the limitation/rules with NDBCLUSTER on (BIG mistake! I know). Some things I notice and want to ...
nyoto arif's user avatar
0 votes
1 answer
133 views

Ndb cluster change variable for heartbeat and disconnect

I search for a variable that I can increase in the server that I don't get any more this error: Node 2 missed heartbeat 2 Node 3 Disconnected Node 2 Disconnected I don't find anything. Regards,
pioupiou's user avatar
  • 137
0 votes
1 answer
134 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 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
258 views

MySQL clusters - sync a table [closed]

I've been developing a software that runs on hardware and now I need to synchronise DB on them, but only partly - several tables using MySQL Clusters(don't matter which style), each of hardware can ...
amelie's user avatar
  • 123
-1 votes
1 answer
360 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
1 vote
1 answer
534 views

What does SPJ stand for in MySQL parlance?

MySQL has a lot of references to SPJ in MySQL including in official Oracle slides but I can't find what it actually stands for. I see it show up in a few blogs too. I looked in the source and found ...
Evan Carroll's user avatar
  • 63.6k
2 votes
1 answer
724 views

Can't connect to MySQL NDB manager using ndb_desc

I've got a basic MySQL NDB cluster running - it works well. Manager, data and SQL nodes are all OK. 1 manager, 2 SQL nodes, 4 data nodes. 2 of the data nodes are from the initial creation, 2 are ...
user avatar
1 vote
0 answers
88 views

MySQL NDB Installer won't start (webserver already running)

I have encountered an odd error where I accidentally closed the shell that was running the python script that launched the installer for NDB cluster. The site stopped working, however, when I try to ...
AJ Henderson's user avatar
0 votes
2 answers
894 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
126 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
0 votes
1 answer
151 views

Adding Memcached plugin to Mysql Cluster Fails to start

I was able to setup a new mysql cluster, with total 6 VMs. New requirement is to add memcache plugin to mysql cluster, memcache failing to start with this error message WARNING -- Failed to allocate ...
bobby's user avatar
  • 1
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
446 views

MySQL Cluster Only Sync Partially [closed]

I am new to MySQL, but I have to solve this problem quickly. I installed FileRun (which is a file share service) on two nodes, those two nodes have MySQL Cluster backend. In Filerun GUI, I created a ...
NeilWang's user avatar
  • 103
1 vote
0 answers
21 views

How do I control the data that goes into each data node in NDBCLUSTER

I am currently working with NDBCLUSTER. I have the following table(a dummy example, since I cannot disclose details about actual application, but the structure is similar): create table student( ...
cazaimi's user avatar
  • 11
1 vote
0 answers
343 views

Why ndb data memory is 94% if i m using disk storage cluster

I have following structure 2 data node 1 management node 2 sql node i have create one log file of initial size 200M then created table space and added 3 data file data1.dat (initial size: 10GB) ...
kamal kishore's user avatar
1 vote
0 answers
33 views

Unexpectedly long query time NDBCluster

I'm having an issue where some queries take an abnormal execution time, meaning 3 to 5 seconds. This part of the schema is 2 tables A and B, where A has many to one relation to table B. Table A: ...
Crs's user avatar
  • 11
0 votes
1 answer
293 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
137 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
57 views

MySQL cluster and big database?

I hava a big mysql database(Innodb) about 50G, how can i import to mysql cluster. What is the best solution to translate db, save on disk or get a amount memory?
user124095's user avatar
1 vote
0 answers
33 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
377 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
1 vote
1 answer
363 views

Creating MySQL NDB cluster on Hyper-V

I want to create a MySQL NDB cluster on Hyper-V for testing so I have some questions in this regard. Can I use Windows XP 32 bit? (because I already have a VM) If not then can I use Windows 7 or 10? ...
Frank Martin's user avatar
0 votes
1 answer
520 views

mysql cluster with innodb utilizing high memory

I have implemented MySQL cluster with two data, sql and management node respectively. On one of the sql node I have ndb as well innodb engine for the huge tables which I can not able to convert into ...
Sagar Shinde's user avatar
2 votes
1 answer
626 views

MySQL NDB Cluster architecture?

I am looking for information that I am not able to find about MySQL cluster. I have to justify if it is possible to install in a production environment the three types of nodes (MySQL node + Data ...
Christophe Chirat's user avatar
0 votes
2 answers
256 views

MySQL NDB Cluster settings to prefer data node on localhost than remote

My current MySQL NDB Cluster configuration: Server 1 - management node Server 2 - huge machine running both ndbd and mysqld Server 3 - huge machine running both ndbd and mysqld NoOfReplicas = 1 So ...
Matthias's user avatar
  • 149
2 votes
1 answer
2k views

Poor usage of timestamp index

with a small table (about 2 M of rows, 5 classic columns, id, description, title, created_at, coordinates (point)) doing a WHERE created_at BETWEEN ... AND ... ORDER BY created_at LIMIT 50 is very ...
Zoé R.'s user avatar
  • 61
2 votes
0 answers
69 views

Mysql Cluster distribute data only one node..why?

here are following setup ndb_mgm -e show Connected to Management Server at: us-srv1.site.vrack:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=3 @192.168.0.2 (mysql-...
dev.meghraj's user avatar
1 vote
2 answers
2k views

Out of operation records in local data manager (increase MaxNoOfLocalOperations) from NDBCLUSTER

MaxNoOfConcurrentOperations=150000 MaxNoOfConcurrentTransactions=150000 MaxNoOfLocalOperations=150000 I have above parameters in config.ini, when i try to delete rows in a table i get below error ...
sherpaurgen's user avatar
0 votes
1 answer
109 views

How mysqlcluster can be durable and consistent?

I'm little noob and learning on how to use mysqlcluster,i have 1 management 2 datanode and 2 sqlnodes.According to a book "mysql cookbook" -alex davies and localcheckpoints and globalcheckpoints By ...
sherpaurgen's user avatar
1 vote
0 answers
337 views

Can I fix Lost arbitrator node errors in MySQL Cluster / NDB?

I have a cluster of eight MySQL Cluster nodes running NDB. At seemingly random intervals (around 1.5 weeks on average, but they seem to come in spurts when they show up), I see a pair of messages like ...
davidvgalbraith's user avatar