7374756666

AWS RDS proxy hangs on large results

If you're using an AWS RDS proxy in front of MySQL and it seems to hang randomly on large results (in this case using the nodejs mysql or mysql2 packages …

Setting all MySQL autoincrement values to next value

I recently had to migrate multiple MySQL databases using AWS DMS which only does the bare minimum of schema support. (Tip create the schema manually and then import the data …

A script to convert an entire MySQL/MariaDB charset from one charset to another

I recently had to add emoji support to a site which used the utf8 charset on a MariaDB 10.1 server.

To do this I needed to change the charset …