NDB Cluster : MySQL's Distributed MultiMaster Storage Engine

learn more… | top users | synonyms

0
votes
0answers
15 views

Error with grants when migrated to NDB cluster

we are trying to migrate the data from mysql 5.1 to mysql 5.6 NDB cluster 7.4.x. 1. we migrated the data using some scripts and restored the grants but the users are not able to login, We checked ...
5
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
1answer
65 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
48 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 ...
1
vote
1answer
10 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 ...
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 ...
0
votes
1answer
478 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 ...
1
vote
1answer
205 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" state....
0
votes
1answer
726 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 ...
1
vote
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" ...
1
vote
0answers
28 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)...
0
votes
0answers
84 views

MySQL replication/cluster of multiple databases

I am 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
15 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] ...
1
vote
1answer
138 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 ...
2
votes
1answer
261 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/...
4
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 ...
1
vote
0answers
20 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 ...
3
votes
2answers
3k views

MySQL Cluster: Problem Connecting the SQL node

In a MySQL cluster I have three hosts, one with a manager node, and the other two are each both a data node and sql node. Connecting to the manager is possible, however only as [ndbd] and not [mysqld]....
1
vote
1answer
342 views

getting “table is full” error even if the table size is much smaller than tablespace

Currently I am using MySQL NDBCluster 7.3.5. I have created one UNDOFILE hhme.dat with INITIAL_SIZE=200m. Also one tablespace hhmefep_tbs with DATAFILE hhmefep_tbs.dat having INITIAL_SIZE=500M ENGINE=...
0
votes
0answers
76 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
48 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 ...
1
vote
2answers
3k views

Backup plan for MySQL NDB cluster databse not innoDB

I have a Database which will grow more than 250GB all data is in NDB engine(2 datanodes) and no other mysql engine used for data store. What are the best approaches or plans for MySQL Cluster NDB ...
0
votes
0answers
80 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 ...
1
vote
0answers
82 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
49 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 ...
2
votes
1answer
45 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 node)...
0
votes
0answers
35 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 ...
1
vote
1answer
97 views

Master-Master Replication with MySQL Cluster - Duplicate Writes in Both Directions

I have created 2 MySQL Clusters; each cluster is located in a separate geographic location. I have set these clusters up in a Master-Master, Geographic Replication fashion, so that data can be written ...
0
votes
0answers
87 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 06:09:...
2
votes
2answers
267 views

MySQL Cluster Steps To Recover Data If Catstrophic Failure Occurs

I want to know if a catstrophic failure occurs (like a power outage), and all nodes in MySQL Cluster are shutdown in cluster then data will be lost even though a backup was taken? Or it possible that ...
0
votes
0answers
39 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 ...
1
vote
1answer
91 views

MySQL Cluster - Management Node Redundancy

I am trying to design a fully redundant MySQL Cluster implementation for a service provider's network. Nodes within this cluster will be geographically separated between towns in the state that the ...
1
vote
2answers
1k views

Better diagnostics when starting ndb nodes?

I have an ubuntu linux server that uses mysql cluster 7.2.5 x64. Whenever I start an ndb node and check with ndb_mgm -e show, it stays in "starting" state for a long time. When I use top to check the ...
0
votes
0answers
137 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 @192.168.2....
11
votes
1answer
8k views

MySQL Sharding vs MySQL Cluster

Considering performance only, can a MySQL Cluster beat a custom data sharding MySQL solution? sharding = horizontal partitioning When I refer to sharding, I'm considering sharding made in the ...
1
vote
0answers
40 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. ...
0
votes
0answers
916 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
65 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 ...
4
votes
1answer
786 views

How to removing or reduce the size of redo logs in MySQL cluster

Can anybody tell me that how can we reduce the redo log file size or can we remove the redo log file size in MySQL Cluster and also what will be the impact of it on performance of cluster.Also can we ...
3
votes
1answer
830 views

Alter mysql database engine doesn't work from cluster to other

I got into this issue when I tried to alter my database table engine to InnoDB from ndbcluster, It did not work. But When I changed engine from InnoDB to ndbcluster it worked. It did not throw any ...
1
vote
1answer
21 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 ...
1
vote
1answer
158 views

Mysql Cluster Ndb Restore Foreign key constraint violated

I am trying to restore mysql cluster backup on slave cluster. When i run ndb_restore command it gives me following error: $ /usr/local/mysql/bin/ndb_restore -n 6 -b 15 -r ./6 Opening file './6/...
1
vote
0answers
657 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
2answers
1k views

Mysql cluster fast inserts but slow selects

I have a mysql cluster with 3 Data Nodes and one SQL node. Curently I have 1million 1kb records. The inserts are very fast, takes only a few ms. But the selects are very slow >20s. All machines are ...
1
vote
1answer
2k views

Problem with MySQL Cluster in practice

I am researching MySQL cluster. For the purpose, I do a demo with 4 virtual machines. I have some problems in practice. Topology My topology contains four nodes Node 1: management node, ip address ...
1
vote
1answer
244 views

MySQL Cluster ndb_desc and parttions

I have mysql cluster with two datanodes and noofreplicas=2. According to documentation there must be 1 nodegroup, 2 partitions and 4 parts at all (2 primary and 2 backup). I have a table with 1000000 ...
0
votes
0answers
272 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 ...
2
votes
1answer
401 views

MySQL cluster DataMemory and DiskPageBufferMemory parameters

I want to setup a MySQL cluster. The amount of data is more than double the amount of RAM. I have 3 Data Nodes each with 8GB RAM. QUESTIONS What is a good rule for the DataMemory and ...
1
vote
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 (...