Database User Management with Ansible
Database User Management with Ansible I've been talking a lot about automation and its place in the database industry. Today, I want to show one example of automation that comes…
Horizontally scaling databases
Horizontally scaling databases You started out as a proof of concept that exploded and now have a product that is used by millions. Let's talk about scaling your data due…
Ansible for Data Management
Ansible for Data Management I continue the discussion on automation with a practical tool that every Data Guardian should learn. Let's discuss why Ansible is such an important tool in…
What is a DBaaS?
What is a DBaaS? When database administrators think of automation, there might be a lot of fear for the future. There's a big elephant in the room when this fear…
Automation is Evil
Automation is Evil!Do it anyway. Hey y'all, I want to let you know that Data Guardians automate tasks that are low-value but high impact. People either don't automate on purpose…
Sysbench for Data Performance
Sysbench for Data Performance When you look at the performance of your databases, it's good to have an understanding of baseline performance. Benchmarking will help you here. For open-source databases,…
Big Data leads to Data Hoarding
Big Data leads to Data Hoarding I've said before that the three areas a Data Guardian will spend time on are Availability, Performance and Security of their databases. There's one…
MySQL Semi-Synchronous Replication Basics
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
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,…
Snooping MySQL passwords with eBPF
Snooping MySQL passwords with eBPF Common sense and Data Security best practices dictate that you should not provide cleartext passwords. However, I often see this exact thing when connecting to…