Galera is a quite useful piece of technology that allows us to build highly available database clusters. This is one of the reasons why we are hearing questions about it a lot during our MySQL consulting activities. If you wonder what it is, we have an introductory post that explains basic concepts and features of … Continued
Galera cluster, be it MariaDB Cluster, Percona XtraDB Cluster or Galera Cluster from Codership uses quorum calculations to make sure the data consistency is safe in case of a split-brain and that the majority of the nodes will continue to operate while nodes that are in the minority will stop executing changes. We have discussed … Continued
In one of the recent blog posts we have discussed how to rename a table in MySQL. Another common question is: how to rename a database? Let’s say we have one database with one table in it: mysql> use sbtest; Reading table information for completion of table and column names You can turn off this … Continued
Vitess attempts to be as transparent for the user as possible. As you may imagine, for a platform that supports sharding, this is not the easiest thing to do. There are quite a few factors you should consider when planning the execution of the queries. Indexes, sharding design, how to aggregate cross-shard data and so … Continued
In this short blog post we will take a look at how to rename a table in MySQL. Sounds fairly simple, but we’ll try to dig a little deeper under the surface. How to rename a table in MySQL? As for the table, the solution is very simple: mysql> USE sbtest; Reading table information for … Continued