Hi Folks,
So we’ve put together a pull request which standardises the collation and character sets we use and are looking for people to test. I personally have done it on a large install of over 3k devices and it took around 10-12 minutes in total to run through the schema changes. This can impact polling whilst data is attempted to be written to the tables being altered.
The pull request is: https://github.com/librenms/librenms/pull/5932
IMPORTANT If you do test this then please backup your database before hand.
You can either switch to the branch in question or download the changes as the diff:
cd /opt/librenms; ./scripts/github-apply 5932
Please let us know how you get on.