Data Availability Archives

Data Guardian Roles for Data Availability

April 7, 2021Data Availability

Data Guardian Roles for Data Availability I've previously mentioned that Data Guardians have three key technical areas to spend their time: Data Availability, Data Performance and Data Security. I've also…

MySQL schema change options

March 31, 2021Data Availability

MySQL online schema change options There are two truths that collide in this post: Schema changes are a fact of life.Many schema changes are blocking in MySQL, which reduces data…

MySQL Semi-Synchronous Replication Basics

December 23, 2020MySQL High Availability

MySQL Semi-Synchronous Replication Basics Replication in MySQL is an important feature for achieving High Availability of your data. Asynchronous replication is the default in MySQL. It is easy to configure…

Data Availability Basics

December 16, 2020Data Availability2 Comments

Data Availability Basics Database high availability is all about managing the risk of database failures. When you talk of high availability, you hear all kinds of terms and acronyms: SPOF,…

MySQL Asynchronous Replication Basics

October 21, 2020MySQL High Availability

MySQL Asynchronous Replication Basics As a database administrator, you need to consider failures of hardware when thinking about the availability of your data. This is a basic principle of High…