Category: Clustering

Clustering

Convert Galera Node to Async Slave And Vice-versa With Galera Cluster

Recently, I was working with one of our customers and this was their requirement as they wanted to automate this process for converting a galera node to async slave and make async slave to galera node without shutting down any servers. This blog post will provide a step-by-step instruction on how to accomplish this. Here, …

Clustering

What is MySQL NDB Cluster?

I have had the opportunity to write a blog for Apress with a brief introduction to MySQL NDB Cluster. The blog gives a brief overview of the history and why you should consider it. The architecture is described before some key characteristics are discussed. If you are interested, the blog can be found at https://www.apress.com/us/blog/all-blog-posts/what-is-mysql-ndb-cluster/15454530. …

Clustering

MySQL Cluster 7.6 includes new Cluster Configurator

After dealing with Windows performance, I switched to MySQL Cluster Configurator (MCC for short) project. This was quite a change for me having to deal with Python back-end and JavaScript front-end, languages I was not so familiar with. For the history of the project, please refer to Andrew’s blog post for I will concentrate on …

Clustering

Announcing Galera Cluster Security Release for MySQL 5.5.59, 5.6.39, 5.7.21 with Galera 3.23

Codership is pleased to announce the release of Galera Replication library 3.23, implementing wsrep API version 25. This release incorporates all changes up to MySQL 5.7.21, MySQL 5.6.39 and MySQL 5.5.59, including several fixes to vulnerabilities reported by Oracle in here. New features and notable fixes in Galera replication since last binary release by Codership …

Clustering

MySQL Cluster 7.5 inside and out

A new book on MySQL Cluster is out. It is called MySQL Cluster 7.5 inside and out. It is on its way out to all internet sites. Currently it is accessible on adlibris.se and on BoD’s bookshop and now also cdon.com. They are all in swedish, but with Google Translate that should be possible to overcome. It will hit …

Clustering

Updated: Become a ClusterControl DBA – Deploying your Databases and Clusters

We get some nice feedback with regards to our product ClusterControl, especially how easy it is to install and get going. Installing new software is one thing, but using it properly is another. It is not uncommon to be impatient to test new software and one would rather toy around with a new exciting application …

Clustering

Updated: Become a ClusterControl DBA: User Management

  In the previous posts of this blog series, we covered deployment of clustering/replication (MySQL / Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health, how to make your setup highly available through HAProxy and MaxScale, how to prepare yourself against disasters by scheduling backups, …

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 …

Clustering

How To Achieve PCI Compliance for MySQL & MariaDB with ClusterControl

  Watch and listen to Laurent Blume, Unix Systems Engineer & PCI Specialist and Vinay Joosery, CEO at Severalnines, as they discuss all there is to know about how to achieve PCI compliance for MySQL & MariaDB with ClusterControl in the replay of our latest webinar. The Payment Card Industry Data Security Standard (PCI-DSS) is …

Clustering

How to convert galera node to async slave and vice-versa with MariaDB Galera Cluster

Recently, I was working with one of our customer and this is what their requirement as they want to automate this process for converting galera node to async slave and make async slave to galera node without shutting down any server. ———- I’ve tested locally with my galera cluster and it’s working smoothly. But with …