https://www.percona.com/blog/proxysql-for-short-term-application-fixes/ Thu, 06 Apr 2023 08:39:11 +0000 hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/proxysql-for-short-term-application-fixes/#comment-10974046 Thu, 06 Apr 2023 08:39:11 +0000 https://www.percona.com/blog/?p=86733#comment-10974046 A few years ago a HW vendor changed its serial number scheme from all numbers to HEX based, so the nice but old monitoring tool (same vendor 🙂 was not able to add such a serial number.
As the tool was fixed to host/port we moved the MySQL to a different port, install proxysql to listen on 3306 and just redirect all traffic to the MySQL.
In a second step we changed the column datatype from number to char to be able to accept the new serial number format.
As strings need ‘ around them we generated a rewrite rules for INSERT into that table to add ‘ around the value.
Every things else done by the monitoring tool worked fine, just adding a new box (its HEX based serial number) needed this work around.

]]>