NDB Cluster : MySQL's Distributed MultiMaster Storage Engine

learn more… | top users | synonyms

4
votes
2answers
2k views

How much data is needed to show MySQL Cluster's performance scaling vs. InnoDB

I am evaluating MySQL Cluster as a possible replacement for an InnoDB schema. So far, I have tested it with 10s of MB of data, and found MySQL Cluster slower than InnoDB; however, I have been told ...
1
vote
2answers
2k views

Which one to use? InnoDB Replication or MySQL Cluster?

I am building a url shortener and I use InnoDB as the storage engine for link data. I will start with a single VPS containing both application instance and MySQL database instance on the same Virtual ...
2
votes
1answer
31 views

What happens when a MySQL Cluster node is disconnected

I am trying to design a multi-master clustered MySQL database which will be spread through out the country. The main reason for having a cluster is so that when the internet, in one location (or ...
1
vote
1answer
181 views

MySQL cluster concurrency

I have a little application that executes select queries against a MySQL cluster. By using 1 thread to read a record the latency is x. By using 2 threads to read records concurrently the avg latency ...
0
votes
1answer
160 views

Mysql Cluster Exceeding MaxBufferedEpochs

I have an mysql cluster which have 4 api nodes, 2 management nodes and 4 data nodes. Today, I was having problems while trying to connect database and all queries was hanging at "Opening tables" ...
0
votes
1answer
17 views

MySQL NDBcluster 7.3 limitation on Table Joining in a single SQL statement

I am a novice user of Mysql database and recently my company is evaluating MySQL Cluster for its shared nothing architecture and synchronised replication. However my colleagues informed me that the ...
0
votes
1answer
575 views

ndbcluster: Error: 1114, The table is full, when using table

I have searched for a while about this error. I have a MySQL cluster running with 2 data nodes. The cluster houses a few other databases. I have a dump of a database in --tab format from another ...
0
votes
1answer
432 views

NDB Cluster seems to ignore foreign_key_checks=OFF

According to MySQL documentation on the local foreign_key_checks variable Beginning with MySQL Cluster NDB 7.3.2, setting this variable has the same effect on NDB tables as it does for InnoDB ...
0
votes
1answer
1k views

mysql cluster table full error

I installed a new mysql cluster on windows (for evaluation). I created a table using command below. After I insert just over 1 million records into the table it gives me the "table datadump is full" ...
3
votes
0answers
1k views

Why is loading data into MySQL cluster taking so long?

I have a mysql-5.5.22 ndb-7.2.6 cluster 64bit running on Centos 6 with each node installed on the same Citrix Xen Server communicating via a virtual private network. Each node has 4GB of RAM, 4 vCPUs ...
2
votes
0answers
103 views

Can't connect to MySQL Cluster Storage (data) nodes

I've deployed a MySQL Cluster with a few nodes, and I want to access the storage nodes directly from another machine using NDBAPI. When I tried to connect from the same host it worked, but when I try ...
1
vote
0answers
18 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
56 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 ...
1
vote
0answers
39 views

Mysql Cluster Restore A Backup To A Database With A Different Configuration

I have an mysql cluster which have 4 data nodes and number of replicas is 2. So I have 2 node groups with 2 data nodes in a every node group. I planing to add 4 data nodes more to this cluster. ...
1
vote
0answers
618 views

Delete operation mysql cluster

I am trying to delete some entries from table on a cluster and I get this error ERROR 1297 (HY000): Got temporary error 233 'Out of operation records in transaction coordinator (increase ...
1
vote
0answers
214 views

Error in alter table reorganize partition for MySQL Cluster

My cluster contains 48 million rows and cluster contains 4 storage nodes . After that I add online storage node and executed alter table 'customer_tbl' reorganize partition. Some parameters of ...
1
vote
0answers
823 views

MySQL cluster stuck in start phase 4, how to proceed?

Over the weekend our cluster we set up for evaluation had one of its data nodes lose network connectivity briefly. This was while another data node was in the middle of a restart (which had been going ...
0
votes
0answers
29 views

MySQL replication/cluster of multiple databases

I looking for a suitable MySQL replication technology. I'll try to explain our use case first. We have several applications: - 1 public web application - multiple customized enterprise web ...
0
votes
0answers
6 views

Table is Full when adding index on ndb cluster

Table is Full when adding index on ndb cluster. What can I do to surpass this issue? This is my config file enter code here [ndb_mgmd] hostname=10.10.10.4 datadir=/var/lib/cluster [ndbd_default] ...
0
votes
0answers
59 views

Data nodes stuck at starting

After updating the config.ini (I updated my MaxNoOfAttributes, MaxNoOfTables, MaxNoOfOrderedIndexes,etc.) on my management node and running the ndb_mgmd with --initial command. I can't seem to start ...
0
votes
0answers
27 views

Configuring additional data node

After configuring the data node and the config.ini for the management node. When I run the ndb_mgmd -f /var/lib/mysql-cluster/config.ini --initial The table data that were created for previous ndbd ...
0
votes
0answers
44 views

Configuring MySQL Cluster

I'm having trouble in configuring my data nodes. My setup is 1 management node, 1 SQL node and 2 data nodes. I'm running mysql-cluster-gpl-7.4.8-linux-glibc2.5-x86_64 on my cluster. My question is do ...
0
votes
0answers
43 views

ndb_desc - Unable to Connect to Management Server

I'm having issues with the ndb_desc program working in MySQL Cluster. I have additional [mysqld(API)] nodes available for connection from any host: [ndbd default] NoOfReplicas=2 DataMemory=16384M ...
0
votes
0answers
33 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 ...
0
votes
0answers
31 views

MySQL Cluster in-memory only table

I am testing MySQL cluster with NDBCLUSTER engine. We intend to use MySQL cluster DB to contain READ PERFORMANCE critical tables which will reside only in memory. We have also tried the MEMORY ...
0
votes
0answers
55 views

Mysql Cluster Reorganize Partitions On Partial Cluster

I have changed MAX_ROWS on partial (while a data node disconnected) cluster then reorganized partitions. When i try to restart data node which was disconnected i get following error: 2015-11-13 ...
0
votes
0answers
36 views

Degraded insert performance when selecting from the join of two ndb tables

I am seeing degraded insert performance when inserting data that is selected from the join of two (or more) ndb tables. Minimum query to reproduce: INSERT INTO tableC SELECT col1,col2,col3 FROM ...
0
votes
0answers
89 views

MySQL Cluster set DataMemory

I have MySQL Cluster with 5 nodes on 3 servers Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=2 @192.168.1.111 (mysql-5.6.24 ndb-7.4.6, Nodegroup: 0, *) id=3 ...
0
votes
0answers
51 views

Mysql Cluster Data Node Hangs on Phase 5 While Starting

I have an mysql cluster which have 4 api nodes, 2 management nodes and 4 data nodes. Today one of data nodes has gone offline due missing heartbeat. After i tried to restart, it hangs on phase 5. I ...
0
votes
0answers
760 views

Lock wait timeout exceeded; try restarting transaction in NDB

I encountered an error while using an opensource product with a mysql cluster. The error stacktrace is shown below. Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting ...
0
votes
0answers
250 views

Not getting satisfactory performance improvement with NDB Cluster

Since last few days, I am trying to improve performance of MySQL NDB Cluster but can't figure out what I am missing/being mistaken in defining/tuning parameters. I have these configurations running ...
0
votes
0answers
4k views

getting SQL Error (1452): Cannot add or update a child row: a foreign key constraint fails (Unknown error code)

I am getting error with MySQL NDB Cluster 7.3.5 as described below: I have two tables: -User Profiles -User Services User services is a child table which contains foreign key constraint ...