Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mysql-cluster]

MySQL's Distributed Database.

"MySQL Cluster is often confused with other cluster technologies; please use the "ndbcluster" tag instead.

Technically, "MySQL Cluster" is the Distributed Database technology that provides

  • Shared-nothing clustering
  • Auto-sharding
  • 99.999 % Availability

MySQL Cluster is implemented through the NDB or NDBCLUSTER storage engine for MySQL ("NDB" stands for Network Database).

Contrast: Galera, PXC, InnoDB Cluster.

148 questions
9
votes
2 answers

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
  • 579
  • 1
  • 7
  • 11
8
votes
2 answers

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 but without success. First of all I tried to find…
Oleksandr
  • 403
  • 2
  • 6
  • 14
6
votes
3 answers

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 database but it did have many locks once this…
jaseUK
  • 161
  • 1
  • 3
6
votes
2 answers

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 separate the write operations from the reads. I want…
Robert
  • 705
  • 3
  • 12
  • 20
5
votes
3 answers

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 node: set global…
Oleksandr
  • 403
  • 2
  • 6
  • 14
4
votes
1 answer

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 management node and 2 MySQL Servers (MySQLD) MySQL…
Ahmad Abuhasna
  • 2,718
  • 4
  • 25
  • 36
4
votes
1 answer

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 disable Redo logging in MySQL cluster.
Yogesh Ballani
  • 463
  • 5
  • 14
4
votes
1 answer

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 existing 5.1 hosts to ensure that it can handle the load…
internetdotcom
  • 232
  • 1
  • 12
4
votes
2 answers

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 than 2 hours to restart. Is MySQL Clustering a…
srj
  • 41
  • 1
4
votes
2 answers

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]... Meaning they connect to the manager as data…
sswahn
  • 81
  • 1
  • 6
4
votes
0 answers

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 and 10GB of diskspace. There are no other…
user4659
4
votes
2 answers

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 me the fundamental difference between such…
tdaget
  • 825
  • 2
  • 12
  • 23
4
votes
1 answer

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 them with 20 GB of RAM and others with 10 GB of RAM.…
amir jj
  • 289
  • 1
  • 5
  • 16
4
votes
1 answer

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 replication happens which is very vulnerable due to…
tesla747
  • 1,910
  • 10
  • 42
  • 77
3
votes
1 answer

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
  • 313
  • 2
  • 7
  • 20
1
2 3
…
9 10