In previous blog posts we have looked at how to migrate TPCC-like schema that has been created using SysBench. Now, we have it in our Vitess cluster and we would like to take it a next step further and see how it can be sharded. Analysing the schema and queries The first step that we … Continued
This is another short blog where we try to answer questions commonly asked (at least per Google) by MySQL users. Today we will take a look at the following question: how to create a database in MySQL? What is a database in MySQL? First of all, the question is – what is a database in … Continued
In the previous blog in our Vitess series we have explained how to migrate your data into Vitess cluster using logical backup and then keep it in sync for the period of testing using asynchronous replication. Let’s try something similar but a bit different this time. We are going to use a nice feature of … Continued
One of the most common questions according to Google is how to change the root password in MySQL. This blog is an attempt to answer this question. We will try to consider different scenarios that you may encounter in real life – how to change passwords in general, if you know it and, which is … Continued
In the previous couple of blogs we have been looking at the basic scaling options in Vitess. We have added replicas, sharded our data, created custom shards and many more. In this blog we would like to start a new series, learning more about how the application interacts with Vitess, how to identify performance issues, … Continued