(Krunal Bauskar) In a clustering environment, we often see a node that needs to be taken down for maintenance. For a node to rejoin, it should re-sync with the cluster state. In PXC (Percona XtraDB Cluster), there are 2 ways for the rejoining node to re-sync: State Snapshot Transfer (SST) and Increm
Tag: Open Source
Where does my MySQL configuration variable value come from ?
(Frederic Descamps) As you may already know, there are many different places where a MySQL configuration variables can be initialized.
XtraBackup vs. OOM killer(usage of mprof)
(Shahriyar Rzayev) This small article is about nicely depicting memory usage prior to OOM killers show.
MySQL Clients and emojis !
(Frederic Descamps) As you probably already know, MySQL 8.0 supports Unicode 9.0 and our default charset moved from latin1 to utf8mb4.
InnoDB Cluster: setting up Production… for disaster! (2/2)
(Keith Hollman) Ok, so now we’re got our InnoDB Cluster a-clustering, MySQL Router a-routing, now we need some disaster to be a-disaster-recovering…
New optimizer hint for changing the session system variable.
(Sergey Glukhov) In MySQL 8.0.3, we have introduced a new optimizer hint called SET_VAR. This hint allows to change the value of a system variable for a single query.
MySQL and Linux Context Switches
(Peter Zaitsev) In this blog post, I’ll look at MySQL and Linux context switches and what is the normal number per second for a database environment.
InnoDB Cluster: setting up Production… for disaster! (1/2)
(Keith Hollman) Want to setup InnoDB Cluster and be prepared for a Disaster Recovery scenario? Get ready:
Towards Bigger Small Data
(Yoshinori Matsunobu) In MySQL ecosystems, it has been a very common practice to shard MySQL databases by application keys, and to manage multiple small sized MySQL instances. Main reason of the sharding was that a single server could not handle so much data. 10 years ago, typical commodity servers
MySQL InnoDB Cluster: how to handle performance issue on one member ?
(Frederic Descamps) Sometimes when you are using a MySQL InnoDB Cluster, you might encounter some performance issue because one node becomes dramatically slow.
