MySQL

Category to track posts in PlanetMySQL

Group Replication in Percona Server for MySQL

group replication percona server mysql

Percona Server for MySQL 8.0.18 ships all functionality to run Group Replication and InnoDB Cluster setups, so I decided to evaluate how it works and how it compares with Percona XtraDB Cluster in some situations.
For this I planned to use three bare metal nodes, SSD drives, and a 10Gb network available for in-between nodes […]

Read more

Using Flame Graphs to Process Outputs From pt-pmp

flame graphs pt-tmp

In a previous post Profiling Software Using perf and Flame Graphs, we took a look at how to generate Flame Graphs from perf outputs. In this short follow-up, we will use Flame Graphs to process outputs from pt-pmp. Flame Graphs were not originally thought of for this purpose, but since pt-pmp outputs are similar […]

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

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

vitess kubernetes mysql

In this blog post, I’d like to share some experiences in setting up a Vitess environment for local tests and development on OSX/macOS. As previously, I have presented How To Test and Deploy Kubernetes Operator for MySQL(PXC) in OSX/macOS, this time I will be showing how to Run Vitess on Kubernetes.
Since running Kubernetes […]

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