(Kedar Vaijanapurkar) This post is a lab experiment learning from migration to the Percona Xtradb Cluster (Galera) and a very unexpected DEADLOCK scenario which took me back to basics.
Tag: Open Source
Quest for Better Replication in MySQL: Galera vs. Group Replication
(Przemys³aw Malkowski) UPDATE: Some of the language in the original post was considered overly-critical of Oracle by some community members. This was not my intent, and I’ve modified the language to be less so. I’ve also changed term “synchronous” (which the use of is inaccurate and misleading) to “
MySQL Group Replication… synchronous or asynchronous replication ?
(Frederic Descamps) After some feedback we received from early adopters or discussions during events like FOSDEM, I realized that there is some misconception about the type of replication that MySQL Group Replication is using. And even experts can be confused as Vadim’s blog post illustrated it.
Group Replication: Shipped Too Early
(Vadim Tkachenko) This blog post is my overview of Group Replication technology.
MySQL on Docker: Composing the Stack
(Ashraf Sharif) Docker 1.13 introduces a long-awaited feature called compose-file support, which allow us to define our containers with a nice simple config file instead of a single long command. If you have a look at our previous “MySQL on Docker” blog posts, we used multiple long command lines to
MySQL and MariaDB authentication against pam_unix
(Shinguz) The PAM authentication plug-in is an extension included in MySQL Enterprise Edition (since 5.5) and in MariaDB (since 5.2).
JSON Support in PostgreSQL, MySQL, MongoDB, and SQL Server
(Baron Schwartz) If you’ve been watching the evolution of database technologies over the past few years, you’ve seen how quickly JSON has quickly cemented its position in major database servers. Due to its use in the web front-end, JSON has overtaken XML in APIs, and it’s spread through all the laye
How to deploy and manage MySQL multi-master replication setups with ClusterControl 1.4
(Krzysztof Ksiazek) MySQL replication setups can take different shapes. The main topology is probably a simple master-slave setup. But it is also possible to construct more elaborate setups with multiple masters and chained setups.
MyRocks, InnoDB and in-memory insert performance
(Mark Callaghan) This is yet another result to understand an insert-only workload. In this case the database is small enough to be cached by the storage engine.
MySQL 8 Invisible Indexes
(Dave Stokes) MySQL 8 features invisible indexes. But what good is an index if you can see it?
