MySQL Cluster : MySQL's Distributed Database

learn more… | top users | synonyms

2
votes
1answer
585 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 ...
1
vote
1answer
262 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 ...
1
vote
1answer
369 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 ...
1
vote
1answer
131 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 ...
1
vote
1answer
313 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 ...
1
vote
1answer
507 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
47 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 ...
0
votes
1answer
161 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
118 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
1answer
50 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
597 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" ...
2
votes
0answers
767 views

MySQL Cluster LOAD DATA too slow

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 and 10GB ...
1
vote
0answers
11 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 ...
1
vote
0answers
32 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 ...
1
vote
0answers
50 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 ...
1
vote
0answers
401 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
171 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
57 views

memcached+mysql cluster maximum memory

I'm deploying a system with memcached and mysql cluster. The command line is: memcached -E lib/ndb_engine.so -e "connectstring=maddy:1186;role=dev" I can't specify the -m argument since I used -E ...
1
vote
0answers
639 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
43 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
0answers
34 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
14 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
13 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 ...
0
votes
0answers
42 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
42 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 ~]# ...
0
votes
0answers
17 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
85 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 ...
0
votes
0answers
30 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
13 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 ...
0
votes
0answers
68 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
64 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
223 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 ...
0
votes
0answers
14 views

What is the preferred mode of replication for a MySQL Cluster?

Reading about MySQL Cluster, I'd like to know about what are the preferred models of replication. I understand that it supports asynchronous replication out of the box, but I'm not sure of how it ...
0
votes
0answers
44 views

MySQL Cluster Datafile Sizing and Information_schema files tables

I'm trying to migrate a system to MySQL Cluster which holds space around 30GB while it's originally stored in single mysql database where the storage engine is InnoDB. I try to write non-indexed ...
0
votes
0answers
219 views

MySQL Cluster management node does not start (node has different checksum)

Please help me to start data management node. I have installed cluster with autoinstaller and it was working. Now i'm trying to change config (i want to change amount of DataMemory) and run cluster. I ...
0
votes
0answers
139 views

Cluster with shared storage

I actually use MariaDB Galera Cluster with 3 master nods. Workload is about 70% read, 30% write and it's very important to have consistent data with every select - this is why I choose Galera ...
0
votes
0answers
27 views

MySQL distributed database with mysql access to each node

I have task to implement particular database structure: Multiple mysql servers with data using the same schema. Each server can see and edit only his particular part of data. And One master server ...
0
votes
0answers
830 views

Cannot start MySQL cluster with single node

For some testing I have installed MySQL Cluster. I can get it to work with configuration suggested in Lunix guick start guide. My configuration: [ndb_mgmd] hostname=localhost ...