Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

Questions tagged [mysql-cluster]

MySQL's Distributed Database.

Filter by
Sorted by
Tagged with
9 votes
2 answers
8k 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?
Mark13426's user avatar
  • 579
8 votes
2 answers
33k views

How to recover MariaDB Galera Cluster after full crash?

I crashed all my 3 nodes. After all nodes have been started I noticed that mariadb is dead. An I couldn't run it again. I am using CentOS 7 on all servers I tried to start first node and then others ...
Oleksandr's user avatar
  • 393
6 votes
2 answers
23k 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 ...
Robert's user avatar
  • 695
6 votes
3 answers
6k views

Mysql Alter Tables took 5 hours to add 1 column

Had an issue recently where to add a column on a table with 1 million rows took 5 hours. I added a column with default value of 1. This was done during the night so there was not much activity on the ...
jaseUK's user avatar
  • 161
5 votes
3 answers
44k views

How to restart MariaDB Galera cluster?

How to restart MariaDB Galera cluster? After all node have been crashed I try to recover the cluster but without success. I have only 2 nodes. As documentation says I set a parameter on one of the ...
Oleksandr's user avatar
  • 393
5 votes
1 answer
787 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....
Gpost's user avatar
  • 73
4 votes
2 answers
9k views

Mysql Group replication vs Mysql Cluster

[disclaimer] I'm not new to databases but totally novice about replication and cluster ... As you may know Mysql made available a new functionality : MySql Group Replication. Is anyone can explain ...
tdaget's user avatar
  • 813
4 votes
1 answer
7k views

Is MySQL Cluster a right choice?

I'm having a MySQL dual-master Replication of MySQL, each one of the servers have 21 GB memory, I'm now searching for a clustering solution for this project, It's possible to have 6 server: two of ...
amir jj's user avatar
  • 289
4 votes
1 answer
2k 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 ...
tesla747's user avatar
  • 1,896
4 votes
2 answers
815 views

Is MySQL Clustering a viable option for a DB expecting 5TB of data in 5 years?

We plan to implement MySQL Clustering.The database should support 5 years of data and expected data/year is 1TB. When we created a test enviornment with the DB size as 200GB, NDB Cluster took more ...
srj's user avatar
  • 41
4 votes
2 answers
6k 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]....
sswahn's user avatar
  • 81
4 votes
1 answer
2k views

How to solve the error "Error 'Got error 0 'No error' from NDBCLUSTER' on query"?

I'm currently working with a large network of MySQL 5.1 DBs (using MyISAM tables) and I'm evaluating a move to MySQL Cluster. I would like to have the MySQL Cluster replicate off of one of the ...
internetdotcom's user avatar
4 votes
1 answer
2k 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 ...
Yogesh Ballani's user avatar
4 votes
1 answer
11k views

MySQL cluster error: "Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock" [closed]

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 ...
Ahmad Abuhasna's user avatar
4 votes
0 answers
2k 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 ...
Craig Efrein's user avatar
  • 9,640
3 votes
2 answers
2k views

MySQL Cluster On Cloud vs MySQL Cluster On Dedicated Cluster

I saw this interesting article : http://mikaelronstrom.blogspot.com/2012/02/105bn-qpm-using-mysql-cluster-72.html and it made me get interested in MySQL Cluster. After little chat with hosting ...
Baba's user avatar
  • 131
3 votes
1 answer
4k 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
tachomi's user avatar
  • 313
3 votes
1 answer
352 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 ...
Luke Nguyen's user avatar
3 votes
1 answer
452 views

Slow-running query on clustered MySQL environment

I've got a very simple query, directly equivalent to SELECT * FROM sometable t WHERE somecol = 'somevalue' ORDER BY createdon DESC LIMIT 0,20000; When I run this query on my non-clustered ...
keithl8041's user avatar
3 votes
1 answer
881 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)...
Saif Ur Rehman's user avatar
3 votes
3 answers
2k 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 ...
rlandster's user avatar
  • 365
3 votes
1 answer
503 views

MySQL licensing [closed]

I have looked at a few questions posted in stackoverflow https://stackoverflow.com/questions/225987/can-someone-explain-mysqls-license-and-what-it-means-to-closed-source-developme https://...
user93353's user avatar
  • 131
3 votes
3 answers
2k views

MySQL cluster fast inserts but slow selects

I have a MySQL cluster with 3 Data Nodes and one SQL node. Currently I have 1 million 1kb records. The inserts are very fast, takes only a few ms. But the selects are very slow >20s. All machines are ...
user2601966's user avatar
2 votes
1 answer
19k views

Dba.getCluster: This function is not available through a session to a standalone instance (RuntimeError)

I am using mysql innodb cluster. Connect to my instance use \c root@localhost:3306. The error message pops out when I issue var cluster = dba.getCluster('testCluster'). I've already created the ...
Yen's user avatar
  • 193
2 votes
1 answer
163 views

What happens to mysql synchronous replication when read replica can't respond?

In the official doc https://dev.mysql.com/doc/mysql-replication-excerpt/8.0/en/replication.html It mentioned that if synchronous replication is required, use NDB instead For scenarios where ...
olaf's user avatar
  • 123
2 votes
3 answers
163 views

Distributing MySQL database on n systems

I have a webserver in my application which talks to a single MySQL node. Instead of having just one MySQL node, I want to have a cluster of n nodes which form my database. Is it possible to do ...
Thebestshoot's user avatar
2 votes
3 answers
642 views

MySQL Cluster Installation

I am very new to mysql-cluster.I downloaded the binaries and was trying to configure it on my local machine. Can anybody suggest how to install it on single machine with the 1 management node,2 data ...
Abdul Manaf's user avatar
  • 9,677
2 votes
1 answer
1k 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 ...
Narasimha T. Juvvigunta's user avatar
2 votes
2 answers
2k views

MySQL Cluster - Got error 1601 'Out extents, tablespace full' from NDB

I am trying to do some tests on MySQL Cluster. I am creating my database using following commands: CREATE DATABASE test1; use test1; CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undofile.dat' ENGINE = NDB; ...
Michał Herman's user avatar
2 votes
1 answer
681 views

Error on data node startup in MySQL-cluster

Running a 24 core server (with HT enabled) I tried increasing MaxNoOfExecutionThreads to 24 to perform some benchmarks and got the following error: 2013-02-27 11:21:44 [ndbd] INFO -- Trying to ...
Nimzo's user avatar
  • 21
2 votes
1 answer
262 views

Which database to use? [closed]

Hey there. I am looking for a free to use for commercial website database that should have these design features, in the given order: Auto-Sharding (getting more free space by adding more server ...
sh sh sh's user avatar
2 votes
1 answer
2k 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 ...
Shane's user avatar
  • 93
2 votes
1 answer
1k 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 ...
Chris Telinde's user avatar
2 votes
1 answer
3k 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 ...
tachomi's user avatar
  • 313
2 votes
1 answer
947 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 ...
user3054547's user avatar
2 votes
1 answer
299 views

Data usage increases initially when reorganize partition mysql cluster

In my MySQL cluster, the data usage of 4 data nodes is approximately 77%. I added a new data node online, and attempted to reorganize partition to redistribute data among all data nodes. But before ...
Anshul's user avatar
  • 73
2 votes
1 answer
1k 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 ...
Michel Feldheim's user avatar
2 votes
1 answer
848 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 ...
Martin's user avatar
  • 121
2 votes
2 answers
552 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 ...
Yogesh Ballani's user avatar
2 votes
1 answer
655 views

How can coupled databases be kept in sync with selective uni-directional syncing and with connections that can be off for days?

I am trying to create a database topology that looks like this: .------------. Bad Connection. Bad Connection. | Central DB | May go offline May go offline '-----...
284507243's user avatar
2 votes
1 answer
514 views

MySQL InnoDB or MySQL NDB Cluster which one to use

We have an application with 8000 users accessing in parallel(max). We are trying to bring in horizontal scaling. I came across MySQL NDB cluster. Should I go with it? Just for auto sharding and other ...
Mani's user avatar
  • 121
2 votes
1 answer
622 views

MySQL NDB Cluster architecture?

I am looking for information that I am not able to find about MySQL cluster. I have to justify if it is possible to install in a production environment the three types of nodes (MySQL node + Data ...
Christophe Chirat's user avatar
2 votes
0 answers
69 views

Mysql Cluster distribute data only one node..why?

here are following setup ndb_mgm -e show Connected to Management Server at: us-srv1.site.vrack:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=3 @192.168.0.2 (mysql-...
dev.meghraj's user avatar
2 votes
1 answer
448 views

Where do i change the my.cnf on mysql cluster

I'm trying to change the max_allowed_packet setting on mysql cluster (version 7.4.8) - i have 5 nodes 2x SQL Node 2x Data Node 1x Managament Node I have updated the my.cnf on all of the servers -> [...
Manse's user avatar
  • 57
2 votes
0 answers
177 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)...
sherpaurgen's user avatar
2 votes
0 answers
501 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 ...
Jeff Lee's user avatar
2 votes
1 answer
2k 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" ...
user18896654353's user avatar
2 votes
0 answers
1k 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 ...
Ahmad Aabed's user avatar
2 votes
0 answers
293 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 config....
Anshul's user avatar
  • 73
2 votes
0 answers
2k 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 ...
internetdotcom's user avatar