Tag - DBA

InnoDB Flushing in Action for Percona Server for MySQL

InnoDB Flushing in Action for Percona Server for MySQL

As the second part of the earlier post Give Love to Your SSDs – Reduce innodb_io_capacity_max! we wanted to put together some concepts on how InnoDB flushing works in recent Percona Server for MySQL versions (8.0.x prior to 8.0.19, or 5.7.x). It is important to understand this aspect of InnoDB in order to tune […]

Read more

Upgrading PostgreSQL – Patroni Cluster and Switching from Python 2 to Python 3

upgrading postgresql python 3

Python 2 has officially completed its life as of Jan 1st, 2020 and the Python 2.x branch will not be maintained anymore. You might be seeing repeated notices of deprecation in log files and terminals like:

Shell

DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as […]

Read more

Setup and Deploy Vitess on Kubernetes (Minikube) for MySQL – Part III of III

vitess kubernetes mysql pt3

In this blog post, we will continue to explore Vitess and test an example database provided in its repository. This is Part III of the previously discussed installation of Vitess on minikube environment, so please make sure to follow those steps to bring the cluster up to the following level.  

Shell

$ kubectl get pods,jobs
NAME […]

Read more

Amazon RDS MySQL Minor Upgrades: Not So Fast!

aws rds mysql minor upgrades

The promise of DBaaS like RDS is to reduce operational overhead (among other things) and one of the stellar cases is upgrades (major and minor). The suggested procedure involves just a couple of steps. For example, using AWS Console, you can enable “Auto minor upgrade” or modify the DB instance and schedule the upgrade […]

Read more

Give Love to Your SSDs – Reduce innodb_io_capacity_max!

reduce innodb io capacity max

The innodb_io_capacity and innodb_io_capacity_max are often misunderstood InnoDB parameters. As consultants, we see, at least every month, people setting this variable based on the top IO write specifications of their storage. Is this a correct choice? Is it an optimal value for performance? What about the SSD/Flash wear leveling?
Innodb_io_capacity 101
Let’s begin with what […]

Read more