The blog post How to Compile Percona Server for MySQL 5.7 in Raspberry Pi 3 by Walter Garcia, inspired me to create an updated install of Percona Server for the...
August 1 #MySQL #Percona Server for M #Raspberry Pi #Toolkit
There are a number of options for generating ID values for your tables. In this post, Alexey Mikotkin of Devart explores your choices for generating identifiers...
October 12 #MariaDB #MySQL #dbForge #Entry Level
In the context of providing managed WordPress hosting services, at Presslabs we operate with lots of small to medium-sized databases, in a DB-per-service model,...
October 11 #Advanced Level #auto-scaling #automated deployment #Containers
MySQL has locking capabilities, for example table and row level locking, and such locks are needed to control data integrity in multi-user concurrency. Deadlock...
September 24 #Dev #Deadlock #Entry Level #MySQL
The goal of this tutorial is to show you how to use multi-master to aggregate databases with the same name, but different data from different masters, on the sa...
September 10 #MariaDB #MySQL #Open Source Database #Replication
I was recently asked a question by mail about MySQL Lossless Semi-Synchronous Replication. As I think the answer could benefit many people, I am answering it in...
August 23 #Galera #InnoDB #MariaDB #MySQL
Amazon RDS for MySQL offers the option to automate minor version upgrades using the minor version upgrade policy, a property that lets you decide if Amazon is a...
July 10 #Amazon RDS #AWS #DevOps #MySQL
Modern applications often feature the use of data in many different languages. This is often true even of applications that only offer a user facing interface i...
June 12 #MySQL #Toolkit #Migration #Collation
Since summer 2017, Amazon RDS supports encryption at rest using AWS Key Management Service (KMS) for db.t2.small and db.t2.medium database instances, making the...
June 8 #Amazon RDS #AWS #Encryption #MySQL