MySQL's Distributed Database.

learn more… | top users | synonyms

0
votes
0answers
14 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 ...
0
votes
1answer
20 views

Mysql datadir and binlogs: same partition or not?

On a MySQL cluster, does it make sense to store MySQL database files and binlogs in different partitions? (This is about partitions on the same physical disk. If they were on different physical ...
0
votes
0answers
8 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
19 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 ...
1
vote
0answers
21 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
26 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 ...
0
votes
0answers
14 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
1answer
54 views

What's the best setup for a MySQL multi master replication for a POS in a restaurant?

We're in the process of implementing a point of sale (POS) solution where we have heavily modified an existing open source POS. The original POS was never created with replication/synchronization ...
0
votes
0answers
17 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
26 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 ...
0
votes
0answers
22 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
36 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 ...
2
votes
1answer
53 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
1answer
28 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
30 views

Avoiding “too many active scans” on MySQL Cluster

I'm running some deletions against tables in MySQL Cluster, and keep hitting the "Too many active scans" error. I'm aware of the article by Johan Andersson, however in this case the parameters are ...
0
votes
1answer
57 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. ...
2
votes
1answer
392 views

How do I configure AWS Aurora to separate write/read operations

I want to migrate my database instance from AWS RDS MySQL to Aurora, but I have a doubt about replication and how Aurora management the write/read operations. I have my application and I want to ...
0
votes
0answers
55 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 ...
1
vote
0answers
57 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 ...
1
vote
0answers
36 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
1answer
74 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
0answers
37 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
1answer
113 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" ...
3
votes
1answer
465 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
29 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 * ...
1
vote
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
0answers
24 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 ...
1
vote
0answers
29 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
44 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
108 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 ...
1
vote
1answer
34 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
56 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
105 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
125 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
1answer
75 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 ...
0
votes
0answers
19 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
48 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
82 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
1answer
312 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
0answers
65 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 ...
1
vote
1answer
784 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 ...
2
votes
1answer
498 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 ...
1
vote
1answer
363 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
589 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 ...
0
votes
1answer
687 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
1
vote
0answers
81 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 ...
3
votes
2answers
2k 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?
2
votes
1answer
765 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 ...
0
votes
1answer
49 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 ...