Categories

Galera – How to add a Galera node to the cluster?

Galera Cluster is a very useful flavour of MySQL with its strengths in High Availability and easiness of provisioning new nodes and keeping the existing nodes in sync. We have a couple of blog posts covering different features of the Galera cluster. Quite common question we hear is: how to add a new Galera node … Continued

Read more...

MySQL Architecture – What to use? MySQL replication or Galera Cluster?

In the past we have written blogs discussing MySQL asynchronous replication and providing basic insights into Galera Cluster. MySQL replication is a well-known, battle-tested solution but also Galera Cluster is a mature, well-tested product. We are quite frequently asked: which one should I choose? Would Galera Cluster work better for me than MySQL replication? This … Continued

Read more...

How to create a user in MySQL?

One of the most commonly asked, MySQL-related questions according to Google, is: “How to create a user?” We would like to answer this question in this short blog post. So, how to do it? Of course, there are many software tools that can make it easier for you, for example MySQL Workbench, we will focus … Continued

Read more...

Vitess – How to upgrade Vitess Cluster?

Quite recently we have seen the release of a new Vitess version (v12.0.0) and this may lead to some questions – how to upgrade your Vitess installation when you use the Kubernetes and Vitess operator? In this blog post we would like to show the upgrade process of a simple Vitess cluster. There are several … Continued

Read more...

MySQL Architecture – When to use MySQL replication?

While working with customers, performing MySQL consulting and discussing architecture, we quite frequently are being asked a very important question. Which MySQL flavour we should use? What are the pros and cons of using MySQL replication, Galera Cluster or InnoDB Cluster? This is definitely a complex question but we thought we could prepare a couple … Continued

Read more...