In the old days, when we wanted to strengthen our skills the only option was to buy a good book. Nowadays one can find a lot of resources on the Internet, however quality is often poor. Fortunately there are still some great people who are brave enough to write new books that will help a new generation of women and men to build modern applications with MySQL the world's most popular open source database. Let me introduce you 3 MySQL books : Introducing the MySQL 8 Document Store / MySQL and JSON: A Practical Programming Guide / Pro MySQL NDB Cluster
In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Concurrency Issues with Load Testing Tools webinar.
First, I want to thank everybody for attending my May 23, 2018, webinar on troubleshooting tools for MySQL. The recording and slides for the webinar are available here. Below is the list of your questions that I was unable to answer fully during the webinar.
Q: What do you recommend for benchmarking NDB cluster? Which should be used and how?
A: The issue with benchmarking NDB cluster is not the tool choice, …[Read more]
In this series of blogs I will do my best to demonstrate how to
set up and run Cluster in Cloud environment by hand and by
utilizing MCC. For detailed configuration, I
will use MCC (Auto-installer). Some of the
information regarding this setup is provided in post by Mikael. Information regarding
Auto-installer is available in our documentation, HTML help files
in share/MCC distribution directory and in my blog post.
Cloud setupIt might come as surprise but for initial testing any instance should do. I started with 1CPU/1GB RAM ones. The target topology was:
- Host #1: Management node and Cluster client tools.
- Host #2: Multi-threaded DATA node. …
After dealing with Windows performance, I switched to MySQL
Cluster Configurator (MCC for short) project. This was quite a
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 changes made in new version.
There are many exciting new features in MySQL Cluster 7.6.4DMR including new MCC. To download MySQL Cluster 7.6.4DMR, please go to Development Releases tab. To see what's new in 7.6.4DMR, please follow this link.
MySQL Cluster Configurator in shortWith a single …
This blog gives some background to the decisions made when
storage engine NDB Cluster used in MySQL Cluster around how to support
real-time requirements (or as I sometime refer to it, predictable response
Requirement analysisWhen analysing the requirements for NDB Cluster based on its usage in telecom
databases two things were important. The first requirement is that we need to
be able to respond to queries within a few milliseconds (today even down to
tens of microseconds). The second requirement is that we need to do this while
at the same time supporting a mix of simple traffic queries combined with a
number of more complex queries running at the same time.
The first requirement was the main requirement that led to NDB Cluster using a
main memory storage model with durability on disk using a REDO log and
The swedish research institute, SICS, have worked hard for a few
developing a scalable and a highly available Hadoop implementation using
MySQL Cluster to store the metadata. In particular they have focused on the
Hadoop file system (HDFS) and the YARN. Using features of MySQL
Cluster 7.5 they were able to achieve linear scaling in number of name
nodes as well as in number of NDB data nodes to the number of nodes
available for the experiment (72 machines). Read the press release from
The existing metadata layer of HDFS is based on a single Java server
that acts as name node in HDFS. There are implementations to ensure
that this metadata layer have HA by using a backup name node and to
use ZooKeeper for heartbeats and a number of …
I have been fairly quiet on my blog for some time. We've been
developing new features for MySQL Cluster 7.5 and ensuring that the
quality is improved even further.
We're now very pleased to release a new version of MySQL Cluster.
MySQL Cluster 7.5 contains a number of new things that makes MySQL
Cluster even better.
1) You can declare a table as a READ_BACKUP table. This means that
the updating transactions will receive the commit acknowledge
a little bit later to ensure that we can always use any of the
replicas for reading. We will use the nearest replica for
committed reads, for locking reads we will still use the primary
replica to avoid deadlocks.
For applications that are mostly read-focused one can make it easier
to set this variable by setting the ndb-read-backup config variable
to 1 in the MySQL Server …
My first post in this series caused quite an
active discussion on Facebook. Readers correctly
noted some mistakes in dates and missing names in the list. I've
corrected some of the mistakes already and will correct some
others later. What was also noted is that initially support
for MySQL was provided by developers (this is really
important, we'll get back to this later), and of them many had
never even got a title of Support engineer. Of those who had not
I listed only Monty...
I just want to explain why I made these mistakes and/or why I (intentionally) had not listed developers etc. First of all, I based my post on my memories (so I could be also wrong about start dates and many details) and that's why I could not …
I'd like to devote this long weekend post, the first in a new
series, to my current and former colleagues who once worked or
still work in a company that provided public MySQL Support
service and had a job role of MySQL Support engineer. The list of
companies include MySQL AB/Inc ("good old MySQL"), Sun, Oracle,
Percona, MariaDB, FromDual, maybe more (I named only those that
surely provided or provides MySQL Support for customers outside
of the company).
This is not the first time that I write about "people of MySQL", in a wider sense "those who contribute to MySQL Community". Last time it was about …
Here’s a way to detect the sql query causing a lock or a session to fail, and also to identify the o.s.pid if need be (btw, no rocket science). “a” way.. I’m sure there are many others, so feel free to suggest, please.
So, we’re using MCM, and have created a MySQL Cluster like mentioned in the cluster intro session (in Spanish I’m afraid), using 7.4.6, which comes with 5.6.24.
With the env up and running, set up a schema, some data and run a few queries:
mysql> create database world; mysql> use world; Database changed mysql> source world_ndb.sql
(world_ndb.sql, as you might guess, is the world_innodb tables script, with a little adjustment as to which storage engine to be used.)
Once created, let’s lock things up in Cluster:
mysql -uroot -h127.0.0.1 -P3306 mysql> use test; …[Read more]