MySQL's Distributed Database.

learn more… | top users | synonyms

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
113 views

Question about a two-node MariaDB Galera Cluster

Hypothetical situation: Node1 is where data gets written to by the app server ... it was where the cluster was bootstrapped from. Node 2 is the second node in the cluster. Both these nodes run in the ...
1
vote
1answer
969 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
659 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
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 ...
1
vote
1answer
380 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 ...
0
votes
1answer
31 views

Unable to connect to mysql remote

I am struggling to connect MySQL database with my application, I am having the following set up 3 Applications running in cluster mode and trying to connect with same DB. MySQL database running on ...
0
votes
1answer
96 views

How to change the replication State Transfer SST to IST in Galera Config

I would like to migrate 700GB data to galera cluster(2node+1arbitrator). I found that IST is the best method for huge DBs.So how to forecfully change the replication from SST to IST in Galera Config. ...
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
16 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
413 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
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
243 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
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 ...
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
40 views

Expanding MariaDB cluster (sharding)

I have an expanding MariaDB 3 node cluster and need to expand the available storage. Each node has (to make the maths slightly easier) 120Gb of database storage. As this is replicated, the total DB ...
1
vote
0answers
27 views

MySQL Cluster “ALTER ONLINE TABLE … STORAGE MEMORY” doubt

I have a MySQL Cluster database where the data is both in-memory and written to disk. I'm trying to understand the ALTER ONLINE TABLE ... STORAGE MEMORY statement, so that I can use this technique to ...
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
61 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
92 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
86 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
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
213 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
59 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
820 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
10 views

load balancer in mysql cluster

Do MySQL cluster has its own inbuilt load balancer ? If yes then how can we use it ? I don't want to use third party tool like HA PROXY to set up LB because of financial constraint. As per MySQL DOC ...
0
votes
0answers
22 views

MariaDB Galera cluster write all nodes

I've setup a MariaDB Galera cluster. It replicates OK, and works OK. I want to be able to allow inserts in all the cluster nodes, not only on the first node, and right now, I can't do it. It allow ...
0
votes
0answers
11 views

How do data files for data disk tables work with MySQL Cluster?

I have a few questions about data disk storage of tables in MySQL Cluster that don't seem to be addressed in MySQL's official documentation. When creating a data file for a table/tables to be stored ...
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
38 views

ndb_restore issue

I'm facing following issue while trying to restore backup in mysql cluster. It will be great help for me if some body can share idea on these Backup Id = 2 Nodeid = 4 backup path = ./ Opening file ...
0
votes
0answers
41 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
32 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
30 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
74 views

How to import HUGE/LARGE data with LOW RAM/Memory in MySQL Cluster

MySQL Cluster has 5 nodes, each node has 20GB RAM How to import 50GB data InnoDB (140M rows per table) Error: Node 2: Data usage is 100%(512000 32K pages of total 512000) Node 2: Index usage is ...
0
votes
0answers
88 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
50 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
30 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
0answers
25 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
30 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
48 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
0answers
142 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
20 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
67 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
408 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
1k 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 ...