Author - Miguel Angel Nieto

Amazon RDS and pt-online-schema-change

Amazon RDS and pt-online-schema-change

In this blog post, I discuss some of the insights needed when using Amazon RDS and pt-online-schema-change together.
The pt-online-schema-change tool runs DDL queries (ALTER) online so that the table is not locked for reads and writes. It is a commonly used tool by community users and customers. Using it on Amazon RDS requires knowing about some specific […]

Read more

Where is the MySQL 5.7 root password?

MySQL 5.7 root password

In this blog, we’ll discuss how to find the MySQL 5.7 root password.
While new MySQL software security features are always welcome, they can impact use and performance. Now by default, MySQL 5.7 creates a password for the root user (among other changes) so the installation itself can be considered secure. It’s a necessary change, […]

Read more

Change user password in MySQL 5.7 with “plugin: auth_socket”

change user password in MySQL

In this blog, we’ll discuss how to use “plugin: auth_socket” to change user password in MySQL 5.7.
In Debian/Ubuntu it is pretty common to install MySQL/Percona Server with an empty password for the root user. After everything is configured and tested, then a password is set. This is not a good practice in production servers […]

Read more

Setup a MongoDB replica/sharding set in seconds

In the MySQL world, we’re used to playing in the MySQL Sandbox. It allows us to deploy a testing replication environment in seconds, without a great deal of effort or navigating multiple virtual machines. It is a tool that we couldn’t live without in Support.
In this post I am going to walk through the different ways we […]

Read more