Author: Kevin Markwardt

Comparing Pgpool-II and PgBouncer

While I was in the process of determining different HA solutions for PostgreSQL, Pgpool and PgBouncer both came into the equation on multiple occasions.  So I decided to evaluate them and determine what kind of performance they could handle.  I…

Read More >

How to Set Up REPMGR with WITNESS for PostgreSQL 10

This blog post will go over how to set up and implement repmgr which is the PostgreSQL application to manage replication between primary and replica nodes, allowing for quick and easy failover and rebuilding of replicas. For reference, all commands…

Read More >

How to Test MySQL Server Hostname with ProxySQL Multiplexing

Overview While working on a MySQL Galera cluster with ProxySQL, I was in the process of testing traffic going to the MySQL nodes by using the @@hostname command to ensure which MySQL host behind the proxy the query ran on….

Read More >

How to manage multiple MySQL binary installations with SYSTEMD

This blog will go into how to manage multiple MySQL binary installations with SYSTEMD using the systemctl command.  With package installations of MySQL using YUM or APT, it’s quick and easy to manage your server’s state by executing systemctl commands…

Read More >

MySQL streaming Xtrabackup to slave recovery

Overview There are times when I need to restore a slave from a backup of a master or another slave, but too many times I have taken the typical approach of taking the backup on the source server and then…

Read More >

MySQL log rotation

Overview I find far too often that MySQL error and slow query logs are unaccounted for.  Setting up log rotation helps make the logs manageable in the event that they start to fill up and can help make your troubleshooting…

Read More >

Ansible and AWS automation

Overview The goal was to create and manage a MySQL RDS instance and learn how to control AWS resources by using Ansible. With Ansible interacting with AWS it’s best to determine how hard or easy it is to build and…

Read More >

Creating an external slave for a live AWS Aurora Instance

Kevin Markwardt, MySQL Database Consultant at Pythian, explains how to set up an external slave for a live Amazon AWS Aurora instance.

Read More >

MySQL encrypted streaming backups directly into AWS S3

Overview Cloud storage is becoming more and more popular for offsite storage and DR solutions for many businesses. This post will help with those people that want to perform this process for MySQL backups directly into Amazon S3 Storage. These…

Read More >

In depth: MySQL 5.6+ DDL

Kevin Markwardt, MySQL Database Consultant at Pythian, provides an in-depth look at MySQL 5.6+ DDL.

Read More >