User roles in MySQL
User Roles in MySQL User management is one of the key tasks around securing your database. It provides the rules for who can connect, and what they can do after…
Data Guardian Roles for Data Security
Data Guardian Roles for Data Security There can be no doubt that we live in the age of information. From business data, to professional sports statistics, to self-driving vehicles, the…
Basic MySQL Optimizer Tracing
Basic MySQL Optimizer Tracing Have you investigated a query that is performing poorly? If so, you likely are familiar with the concept of EXPLAINing the query to see how the…
Data Guardian Roles for Data Performance
Data Guardian Roles for Data Performance In today's age, users demand instant response times for any application they use. You may have the best product on the market, but if…
Data Guardian Roles for Data 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
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…
Reactive versus Proactive work
Reactive versus Proactive work I've previously mentioned that a Data Guardian will spend their time in three key technical areas when caring for the data environment: Availability, Performance, and Security.…
Data Guardian Toolbox: Vagrant
Data Guardian Toolbox: Vagrant It's time to introduce another tool in the Data Guardian Toolbox. Lightweight containers such as can be provided by Docker are all the rage these days.…
Data Guardians replace the DBA
Data Guardians replace the DBA I've mentioned several times this concept of being a Data Guardian. I want to dive a bit deeper into why I think Data Guardians are…
3 Reasons to Use Open Source Databases
3 Reasons to Use Open Source Databases I believe data is the single most important commodity of your company. That means choosing the right way to store it is extremely…