Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ndbcluster]

NDB Cluster : MySQL's Distributed MultiMaster Storage Engine

NDB Cluster is MySQL's Distributed MultiMaster Storage Engine. It was originally spawned from a proprietary database from Sony Ericcson. It was originally used for the Telco industry.

Features

  • Data Storage Nodes Where Data Resides
    • In Memory
    • On Disk
  • AutoSharding for I/O Scaling
  • 99.999% uptime (Less than 5 minutes Downtime Annually)
  • Subsecond Failover and Recovery
  • ACID Compliance
  • Online Backups
  • SQL and NoSQL APIs
  • Geographic Replication
  • and Much, Much More

For more information

115 questions
16
votes
1 answer

MySQL Sharding vs MySQL Cluster

Considering performance only, can a MySQL Cluster beat a custom data sharding MySQL solution? sharding = horizontal partitioning When I refer to sharding, I'm considering sharding made in the application layer, for instance, distributing records…
gsb
  • 405
  • 1
  • 4
  • 10
15
votes
2 answers

What are the benefits of using MySQL Cluster?

I have never dipped my hands in MySQL Cluster and want to know how it can benefit me. When is it best to use it, and does it have performance benefits?
RPK
  • 1,425
  • 6
  • 20
  • 39
8
votes
4 answers

MySQL Cluster RAM requirement

From MySQL 5.1, the data doesn't need to be entirely in memory anymore. I've read that the indexed columns (I think the entire index structure) must still be in memory (MySQL High Availability, 2010, pg. 533, "MySQL Cluster keeps all indexed columns…
gsb
  • 405
  • 1
  • 4
  • 10
5
votes
1 answer

How much data is needed to show MySQL Cluster's performance scaling vs. InnoDB

I am evaluating MySQL Cluster as a possible replacement for an InnoDB schema. So far, I have tested it with 10s of MB of data, and found MySQL Cluster slower than InnoDB; however, I have been told MySQL Cluster scales much better. How much data…
kd8azz
  • 151
  • 4
5
votes
2 answers

ERROR WSREP`: gcs/src/gcs.cpp:gcs_open():1379:` Failed to open channel 'test_cluster'

I have three server that I want to Install Galera clustering on them, I followed this link to install and config it. but when I want to start the first server I got this error : root@node107:/home/debian# service mysql start --wsrep-new-clusterping…
amir jj
  • 289
  • 1
  • 5
  • 16
4
votes
2 answers

Using all the CPU cores by NDBD and MySQL

We are running MariaDB which is a fork of MySQL with NDB cluster engine. The cluster includes one mysql node and two ndb data nodes. While benchmarking the cluster, we are trying to make a bottleneck of CPU and the mysql nodes has 8 cores in total.…
lampscholar
  • 41
  • 1
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
2 answers

fast bulk incrementing in MySQL

I have one big table foobar describing a many-to-many-relation and containing millions of foo's, millions of bar's and every bar having several hundereds of foo's -> billions of rows. CREATE TABLE `foobar` ( `foo_id` INT(10) UNSIGNED NOT…
Ben
  • 887
  • 1
  • 7
  • 9
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
3
votes
1 answer

How do I configure a MySQL Cluster with a redundant mysqld host?

this is my first post here, so go easy on me. I'm trying to rebuild my data architecture (which is currently a set of one primary MySQL server and a redundant fallback; the tables are primarily InnoDB for transactional features). This has worked…
Aejay
  • 131
  • 2
3
votes
3 answers

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 m1.large EC2 instances (8GB RAM). Here is the…
user2601966
  • 41
  • 5
3
votes
1 answer

Alter mysql database engine doesn't work from cluster to other

I got into this issue when I tried to alter my database table engine to InnoDB from ndbcluster, It did not work. But When I changed engine from InnoDB to ndbcluster it worked. It did not throw any error but did not work. I just want to know why this…
Ajay Bhojak
  • 151
  • 6
1
2 3 4 5 6 7 8