Data Security Basics
Data Security Basics It's often true that spending a little bit of time now can save you a lot of headache in the future. And this is definitely the case…
Stop granting SUPER to your MySQL application users
Stop granting SUPER to your application users Hey y'all, I need to rant a bit about a basic security principle for a minute. Very often when I'm reviewing permissions for…
Basic InnoDB Tuning
Basic InnoDB Tuning MySQL 8.0 innodb_dedicated_server MySQL offers a lot of knobs and levers to tune its behavior, and InnoDB offers a few more. In general, I believe you shouldn't…
Database Performance Lessons from Factory Town
Database Performance Lessons from Factory Town When focusing on database performance, I can't think of anything more important than having visibility into your query workload . We will explore this…
MySQL Asynchronous Replication Basics
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…
What is a Database Administrator?
What is a Database Administrator? I've been a MySQL Database Administrator, or DBA, for over 15 years. I want to answer the question about what a database administrator is, and…
Docker for the MySQL DBA
DistributedDBA Docker for the MySQL DBA I want to highlight one of my favorite tools as a MySQL DBA for local testing: I've put together a video below. If you…