We've just got a new server running centos 8 and mariadb 10.3.17, so there's no real data loss issues currently on that server. We've also got some older servers running mysql 5.1.7 which can't be upgraded currently.
We can't connect to the old mysql servers using libmysqlclient (to be more precise Perl using DBD::mysql which uses that to my understanding). We get a 'handshake error', and digging about it suggests that it's mysql version incompatibilities.
Really we need the new servers connecting to the old and vice versa.
So I'm wondering how I get around this. Is downgrading Mariadb on Centos 8 the only (or possible) route here ? If so, any idea how we can go about this (I can't seem to find any information on what version would work either)?
Happy to explore any other routes, other than changing the old servers currently.
Thanks,
Ian