Steve Champion

Associate Database Systems Engineer

Steve Champion works with the MySQL team as an Associate Database Systems Engineer at XTIVIA. He provides MySQL services such as database monitoring and health checks to multiple clients using various environments. He is currently working towards a MySQL 8.0 database administrator certification.

Percona XtraBackup Example

For this example, the following software versions were in use: Ubuntu v20.04.3MySQL server v5.7.35Percona XtraBackup v2.4.24 It is important to note that Percona XtraBackup 8.0 is not compatible with MySQL version 5.7 and was introduced for use with MySQL version 8.0.... read more

Encrypted Replication for MySQL

Encrypted connections for MySQL replication are the default as of 8.0. The following simple example shows a basic setup for encrypted replication using Ubuntu 20.04 and MySQL Community 8.0.27. The steps may be similar for other Linux distributions. The necessary files... read more

How to use mysql_config_editor

Background When running a batch file on MySQL the login credentials must be taken from some file. The file choices are to use a clear-text options file or the more secure obfuscated login-file generated by the MySQL program mysql_config_editor (which comes installed... read more