by Monica Silva | Feb 28, 2023 | Blog, MySQL
A client recently asked me if I could get the hostname or IP address of every server a MySQL user was using to connect for the past 30 days. I never thought of retrieving login information retrospectively. I wasn’t sure if I could. Spoiler alert: it is only...
by XTIVIA | Dec 15, 2022 | Blog, MySQL
Recently, I had a client that had a rack-mounted server that went into a hard lock on a Saturday morning. Monday morning, when it could be rebooted, MySQL received the dreaded “Last_IO_Error: Got fatal error 1236 from master when reading data from binary log:...
by Monica Silva | Dec 1, 2022 | Blog, MySQL
Patching the operating system is essential to keeping your server secure and performing optimally. Patching is as easy as running an apt-get update and apt-get upgrade. However, this can cause some unintended consequences. For one, MySQL server will also be upgraded...
by Monica Silva | Apr 25, 2022 | Blog, MySQL
MySQL 5.6 reached its end-of-life (EOL) in February 2021. If you haven’t upgraded to MySQL 5.7, you are not the only one. It can be an intimidating endeavor. There are configuration, system table, server, Innodb and SQL changes to consider. And, documentation is...
by XTIVIA | Jan 7, 2022 | Blog, 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...
