MySQL Cluster : MySQL's Distributed Database

learn more… | top users | synonyms

0
votes
1answer
160 views

MySQL Cluster work well but ndb_desc doesn't work

I have deployed and configured MySQL cluster. It works fine. ndb_mgm> show Connected to Management Server at: localhost:1186 Cluster Configuration [ndbd(NDB)]2 node(s) id=2@192.168.56.2 ...
0
votes
0answers
7 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
19 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" ...
4
votes
1answer
577 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 ...
0
votes
1answer
728 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
1answer
481 views

MySQL cluster error: “Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock”

I am trying to configure MySQL cluster under three Windows 7 machines with disabled firewall, cluster information is like the following: 2 hosts with each running 1 data node 3rd host running ...
0
votes
1answer
244 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
115 views

MySQL Cluster error on UPDATE: increase MaxNoOfConcurrentOperations

I had a table with ~0.5M rows and tried to exec simple query, something like UPDATE table SET col1=-90 + RAND()*90, col2=-180+RAND()*360 WHERE col1=9999 but result was ERROR 1297 (HY000): Got ...
1
vote
1answer
332 views

Does MariaDB-Galera Cluster support LAST_INSERT_ID and mysql_info?

As far as I understand, Galera does not support table locking, but what information can be retrieved about the last query? LOCK/UNLOCK TABLES cannot be supported in master-master replication. Lock ...
3
votes
1answer
74 views

Active-active Cluster In MySQL

I'm planning to go for a 3-node active-active MySQL cluster which will not have more 100 databases. Many experts here have already told there are issues with MySQL 5.6 and 5.7 where circular ...
0
votes
0answers
18 views

MySQL Cluster query all nodes at once

Is there a way to query all the available nodes of the cluster in one command ? (Make the same query go individually for each host and show the results.) mysql -uuser -p -hmyhost.com -e "select * ...
0
votes
1answer
11 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
467 views

MariaDB Galera Cluster - nodes fail to start

This is a new installation (fresh VM and MariaDB install). For some reason, the nodes are having trouble joining the master server. The master server would pause at Preparing binlog files for ...
3
votes
1answer
695 views

All four data nodes in MySQL Cluster in same node group

I am testing MySQL Cluster 7.2. I have two servers, mysql1 and mysql2. I want the management server and two data nodes to run on mysql1 and two other data nodes to run on mysql2. My config.ini file ...
0
votes
0answers
12 views

HAProxy node sequencing

Is there a way to configure HAProxy to stop sending queries to one of the nodes in a percona xtradb cluster if that node is running a very slow query i.e, bypassing the node processing the extremely ...
0
votes
0answers
17 views

Mysql Cluster Don't save data on data node

I am using mysql cluster. This is my setup [ndbd(NDB)] 2 node(s) id=2 @192.168.64.236 (mysql-5.6.23 ndb-7.4.4, Nodegroup: 0, *) id=3 @192.168.64.235 (mysql-5.6.23 ndb-7.4.4, Nodegroup: 0) ...
0
votes
0answers
33 views

Does galera cluster works in thecloud (Azure IAAS)

We are moving our infrastructure into the cloud (Microsoft) Our current MySQL master-Slave environments will be moved as Infrastructure as a service. At the same time I have been asked to look to ...
0
votes
1answer
84 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 ...
0
votes
1answer
28 views

MySQL Cluster node utf8

I have configured MySQL Cluster (5.6) with two data nodes and managment node. Problem is that I cannot put special chars - looks like encoding is not set to utf8/utf16. I logged into each node and ...
1
vote
0answers
43 views

MySQL Cluster 7.4.6 - Analyze table failure on 15m reference table

I'm running MySQL Cluster 7.4.6 on Azure VM's with the following infrastructure: 2 x Mgmt Nodes: Ubuntu 14.10LTS, 2 cores, 3.5GB ram 2 x MySQL API Nodes: Ubuntu 14.10LTS, 2 cores, 3.5GB ram 2 x Data ...
3
votes
2answers
1k views

What's the difference between MySQL Fabric and MySQL Cluster

I'm new to the MySQL world and was confused by the two. Don't they both provide high availability and sharding? Also, how does WebScaleSQL compare?
0
votes
0answers
79 views

Temporary table not supported in MySQL Cluster

I am new to MySQL Cluster and as I don't have opportunity to try it now I am interested in one thing. In the official pages of MySQL Cluster, there is a statement about temporary tables for NDB ...
0
votes
1answer
50 views

MySQL (ndb) Cluster and BLOB Datatype access issue

I'm currently investigating moving our INNODB database to an ndb cluster (vs buying bigger servers (again) and moving the master / slaves to these). So far my testing on a small cluster has been ...
1
vote
0answers
472 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 ...
0
votes
0answers
70 views

Is mysql cluster a viable choice for real time data availability when it comes to data in high volumes (petabytes)?

I've been reading a lot of articles promoting MySql Cluster as a big data storage solution for real time applications, one of which is this one . But as I went through the Mysql Cluster docs, I saw ...
0
votes
0answers
18 views

MySQL Cluster - use subnet in config.ini for [MYSQLD] connections?

In MySQL Cluster (7.3), is there any way to lock down the [mysqld] section in config.ini to a small subnet, rather than setting it to a single IP Address, or open for any IP Address? I've searched ...
0
votes
0answers
33 views

MySQL Cluster TransactionInactiveTimeout and “operations”

Description: http://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-ndbd-definition.html#ndbparam-ndbd-transactioninactivetimeout I have couple of questions about this parameter. First of all, what ...
1
vote
0answers
55 views

MySQL Cluster - 'ONLINE' is deprecated Please use ALGORITHM=INPLACE

I'm just testing MySQL CLuster 7.3.8. According to the documentation, after adding new Data Nodes I need to ALTER my tables to spread the data to the new Data Nodes. So, I run: ALTER ONLINE TABLE ...
0
votes
0answers
57 views

Mysql cluster edition uses more RAM than configured in configuration file for data nodes. Both SQL and DATA nodes show full RAM usage

I have a MySQL cluster 7.3.6 setup with 4GB RAM for SQL nodes and data nodes on Ubuntu. RAM usage is shown using ndb_mgm's all report memory command is less and even if I have 500 MB data, both SQL ...
0
votes
0answers
56 views

MySQL Cluster, memcached process at 100%

I am running 4 nodes. All separate servers. 2 mgmt nodes. 2 data/sql nodes. The problem I have is this. When all the nodes are running. I telnet into memcached and do the following: [root@db ~]# ...
2
votes
1answer
500 views

ERROR 1297: Got temporary error 4010 'Node failure caused abort of transaction' from NDBCLUSTER when importing data

I have the cluster built by one MGM Node and two data/sql nodes When importing data to an NDB node the importation crashes returning the following: ndb_2# mysql -u root -p db < data.sql Enter ...
2
votes
1answer
330 views

What is the Best way to set Disaster recovery setup for percona Xtra DB Cluster?

We do have a Percona XtraDB Cluster(Master-Master-Master) setup in one country. Now we want to setup a disaster recovery setup in some other country. Please provide us the best possible ways to do ...
0
votes
0answers
22 views

SQL nodes in MySQL Cluster

I running mysql cluster in windows 8.1 on 3 machines 2 mngmd 2 sql node 3 data nodes in the first machine I tried to connect MySQL server with localhost and tried to put my old database it ...
0
votes
0answers
116 views

Properly reload MySQL Cluster Management Server Windows Service configuration

I'm writing a little utility to manage MySQL Cluster and have to know how to reload config.ini sometimes. I'm faced with mysterious problem when MySQL Cluster Management Server installed as Windows ...
1
vote
2answers
900 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 ...
0
votes
1answer
520 views

Tokudb storage engine as mysql-cluster storage engine

Can we use tokudb storage engine as mysql-cluster storage engine? If can, how? I search over google and found nothing
0
votes
1answer
39 views

Can I use MySQL-SERVER tunning variables in MYSQL CLUSTER?

When tunning MySQL-SERVER for best performance, the edition is done down my.cnf file. Such as: max_connections = 500 wait_timeout = 600 sort_buffer_size = 2M Can I improve MySQL CLUSTER ...
0
votes
0answers
54 views

Data usage increase although remove data in table MySQL Cluster

I try to test my MySQL cluster system. I add data to a table and use command ndb_mgm all report memoryusage. The data usage in data node increases. When I remove all data in the table and use command ...
0
votes
0answers
18 views

Is online schema change possible with MySQL Cluster?

I believe that this is the first question on this community. I'm surveying MySQL Cluster for next project in my workplace. I read a lot official/unofficial pages on the web. But I'm not a native ...
1
vote
0answers
57 views

MySQL Cluster Master Master Replication - broken Leg

I have two MySQL Clusters which normally operate with Master - Master Replication between two of their nodes. Site 1 gets the majority of the write traffic, with Site 2 writing small amounts of ...
0
votes
1answer
355 views

Difference between SQL node and Data Node

In a MySQL cluster, there are several different types of nodes: Management Node, SQL Node, Data Node, API Node, What are the differences between the latter three types?
1
vote
1answer
144 views

How to export mysql databases with different ENGINE?

I'm setting up MySQL Cluster. As it uses ENGINE=NDBCLUSTER, how could I export my databases from MySQL Server specifying the ENGINE? Is there a way to do this? All my tables are MYISAM
0
votes
0answers
113 views

error add new data node to mysql cluster

i'm deploying MySQL Cluster and i have prolem when i want add a new data node to cluster, i follow this link enter link description here , but i get error at step 5. When i run command: ndbd -c ...
0
votes
0answers
84 views

MySQL Cluster online backup vs mysqldump. Automatization of cluster backups

There is some special kind of backups in MySQL Cluster: online backup It creates copies of data at Data Nodes. If I understand correctly this is backup of all data that can be stored at Data Nodes, ...
0
votes
0answers
299 views

MySQL Cluster lock wait timeout exceeded when trying to deal with huge amount of queries

I'm trying to deal with many connections and sometime I get following error: ERROR : Lock wait timeout exceeded; try restarting transaction The bigger number of queries the least number of ...
2
votes
1answer
105 views

MySQL cluster replication: Slave cluster should not store any data except data replicated from master cluster?

I am researching MySQL cluster replication. I read a section "We assume that the slave server or cluster is dedicated to replication of the master, and that no other data is being stored on it" in ...
1
vote
1answer
459 views

MySQL cluster: Failover between data node

Today, I do some expirements for understanding MySQL cluster better. MySQL cluster works fine: ndb_mgm> show Connected to Management Server at: localhost:1186 Cluster Configuration ...
0
votes
1answer
62 views

MySQL replication issue when master gets restarted

I have the following environment: NodeA and NodeB in NDB cluster. NodeC InnoDB outside cluster. NodeB is replication master and NodeC is slave. I have set up replication and it works fine. The ...
0
votes
1answer
798 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
274 views

MySQL Cluster MaxNoOfConcurrentOperations and RAM

Why increasing of MaxNoOfConcurrentOperations lead to higher consumption of RAM? I need high value for fast filling tables with some random data, but i noticed that my datanodes are swapping at ...