Tag: MySQL Cluster

Clustering

Partial LCP in MySQL Cluster 7.6.4

Today MySQL Cluster 7.6.4 DMR is out. This new version contains some very interesting new developments in the area of checkpointing. When I developed the original NDB algorithms in the late 90s the computer I had access to had 2 CPUs, 1 GByte of memory. At the time we were aiming at 10.000 updates per …

Software

MySQL Cluster 7.6.4 is out

MySQL Cluster 7.6.4 DMR is out. This new version contains a number of goodies. 1) Local checkpoint algorithm have been rewritten The new checkpointing is designed to scale to at least 16 TBytes of DataMemory sizes Checkpoints will be much faster, this decreases recovery times significantly Table fragments that are not updated will not need …

Software

MySQL Cluster Manager 1.4.5 released!

  MySQL Cluster Manager 1.4.5 is now available for download from My Oracle Support. Overview MCM 1.4.5 contains further stability and usability improvements of MySQL Cluster Manager. The 1.4.5 release bundles MySQL Cluster 7.5.9. However, since MySQL Cluster 7.5.7, system tables contain sufficient information for MCM to properly support rolling reconfigurations when ndb_cluster_connection_pool is enabled …

Clustering

Is your MySQL software Cluster ready?

When we do Galera Cluster consulting we always discuss with the customer if his software is Galera Cluster ready. This basically means: Can the software cope with the Galera Cluster specifics? If it is a software product developed outside of the company we recommend to ask the software vendor if the software supports Galera Cluster …

Clustering

Partitions number in MySQL Cluster

  As stated in the MySQL Cluster documentation: Partition.  This is a portion of the data stored by the cluster. There are as many cluster partitions as nodes participating in the cluster. Each node is responsible for keeping at least one copy of any partitions assigned to it (that is, at least one replica) available …

Clustering, Security

How to Secure Your Open Source Databases with ClusterControl

  Security is one of the most important aspects of running a database. Whether you are a developer or a DBA, if you are managing the database, it is your responsibility to safeguard your data and protect it from any kind of unauthorized access. The unfortunate fact is that many organizations do not protect their …

Clustering

What is the default sharding key in MySQL Cluster?

MySQL Cluster does an automatic sharding/partitioning to the tables across data nodes, enabling databases to scale horizontally to serve read and write-intensive workloads, but what is the default sharding key used in partitioning the data? According to the recent update (Oct, 2016) of the MySQL Cluster white paper, primary key is the default sharding key: …