MySQL primary-replica setups using log positioning are fairly common practice. Occasionally, the replica instance becomes corrupt or out-of-sync with the primary. These steps will help reset the primary instance and establish a new starting point for bin logging. On the…
I was recently tasked to write an automation script in PowerShell to invoke methods on a REST API. In this case, the API redirected the web requests to a more specific URL with an HTTP/302 response. When attempting to use…
Migrating a MySQL database from one server to another is a quick process when you have shell access to both locations. mysqldump can be used to create a SQL script that will recreate the database on the new server. 1.…