Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [ndbcluster]

NDB Cluster : MySQL's Distributed MultiMaster Storage Engine

0
votes
1answer
23 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 : ...
1
vote
0answers
41 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 ...
0
votes
0answers
6 views

Error in NdbJTie : message missing NULL ptr in end of keyData list

Question: com.mysql.clusterj.ClusterJDatastoreException: Error in NdbJTie: returnCode , code 4,276, mysqlCode -1, status 2, classification 1, message Missing NULL ptr in end of keyData list I am ...
0
votes
1answer
65 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....
0
votes
1answer
47 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 ...
0
votes
2answers
51 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 ...
0
votes
1answer
31 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 ...
-1
votes
1answer
17 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,
0
votes
1answer
23 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. ...
1
vote
1answer
25 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 ...
0
votes
0answers
17 views

Another datanode and sqlnode stopped after restart in NDB-Cluster

I have installed NDB-CLUSTER in centos 7 with 2 datanode,2 sqlnode and 1 management node.all the nodes were working properly but after restart only one datanode is connected to management node and ...
0
votes
1answer
26 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 ...
0
votes
1answer
152 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 ...
1
vote
1answer
32 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 ...
0
votes
2answers
67 views

Growing MySQL NDB Database. How to get High Availability?

Since last 2 year, we were using NDB Cluster for live database of our app, which is now have size of 7-10 GB, running on 6 Dedicated servers (6 data node, 2 api node, 1 mgm node) to have get maximun ...
2
votes
1answer
212 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 ...
1
vote
0answers
67 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 ...
0
votes
2answers
334 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/...
0
votes
1answer
270 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 ...
0
votes
1answer
39 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 ...
0
votes
1answer
100 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 ...
1
vote
1answer
731 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 ...
0
votes
1answer
55 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 ...
1
vote
0answers
17 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( ...
1
vote
0answers
166 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) ...
1
vote
0answers
26 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: ...
0
votes
1answer
150 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, ...
0
votes
1answer
78 views

by mistakenly deleted config.ini in mysql cluster

I was trying to delete cache file of mysql cluster for rolling restart but by mistake I have deleted directory /var/lib/mysql-cluster from both the nodes. I have ndb_1_config.bin.1 file but how can I ...
1
vote
0answers
49 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?
1
vote
0answers
22 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. ...
0
votes
1answer
186 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 ...
0
votes
1answer
2k 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. ...
1
vote
1answer
148 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? ...
0
votes
1answer
160 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 ...
2
votes
1answer
400 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 ...
0
votes
2answers
137 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 ...
2
votes
1answer
689 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 ...
2
votes
0answers
62 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-...
1
vote
2answers
608 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 ...
0
votes
1answer
64 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 ...
1
vote
0answers
183 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 ...
1
vote
1answer
403 views

three-table JOIN query on a MySQL Cluster has become unusably slow

I have a select query called by a script to our MySQL Cluster that has gone from running in a second or two to taking well over a minute per query (and it has to run this query 24000 times). Nothing ...
2
votes
1answer
1k views

All queries are so slow on mysql NDB cluster

Here is my situation: I got over 10G of web logs (around 30 million rows) and I mainly search it with various conditions. e.g.: select * from tbl where ip = '123.123.12.3' and agent = '...
1
vote
1answer
358 views

MySQL NDB cluster maximum data size

According to the limitations outlined at http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations.html, there can only be 48 data nodes. Does that mean, with number of replicas 2, I can ...
2
votes
0answers
107 views

Add index to mysql table with ndbcluster engine

I'm having trouble while adding index on mysql table with ndbcluster storage engine below is the error . [mysqlcluster ver. 7.4 GA] mysql> alter table `sks_staff_office` add index `pid_index` (pid)...
2
votes
1answer
2k views

MySQL Cluster: API node won't start successfully

I am working on setting up a MySQL NDB cluster in a test environment. I have 1 management node, 2 SQL nodes and 4 NDB nodes. The management nodes and NDB nodes all start successfully. They are ...
3
votes
2answers
5k views

ERROR WSREP`: gcs/src/gcs.cpp:gcs_open():1379:` Failed to open channel 'test_cluster'

I have three server that I want to Install Galera clustering on them, I followed this link to install and config it. but when I want to start the first server I got this error : root@node107:/home/...
1
vote
0answers
29 views

Is there a way to store more than 65KB in NDB engine?

I have to store some json files that are larger than 64KB so they cannot be stored in TEXT fields in NDB engine. Is there a practical way to solve this problem? 2 points: I have no option but to use ...
1
vote
0answers
365 views

Adding Data Nodes Online - Data Won't Redistribute

I have gone through the process of adding data nodes to my MySQL Cluster, using the guidelines provided here: https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-online-add-node-example.html. The ...
2
votes
0answers
414 views

Mysql Cluster Disk Storage Problem

We are currently create a Mysql Cluster with ndb distribution storage. We have a very large set of data so we want to config the ndb using the tablespace to store data in disk. I follow this link to ...