Tag - DBA

5 Things DBAs Should Know Before Deploying MongoDB

Before Deploying MongoDB

MongoDB is one of the most popular databases and is one of the easiest NoSQL databases to set up for a DBA.  Oftentimes, relational DBAs will inherit MongoDB databases without knowing all there is to know about MongoDB.   I encourage you to check out our Percona blogs as we have lots of great […]

Read more

The Evolution of the DBA Role

evolution of the DBA role

As I interface with large clients as a Technical Account Manager (TAM) at Percona, one thing I have noticed is the evolution of the DBA role.  With the rise of the cloud, DBAs seem to be spending less time doing traditional DBA roles of performance tuning, configuring backups, and so on.  Instead, DBAs are […]

Read more

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