Cluster: different ProxySQL version with peer

[jonathanb-fc]

I'm trying to sort out upgrade paths for ProxySQL and it seems that clustering doesn't work with different ProxySQL versions.

2023-10-13 13:12:09 ProxySQL_Cluster.cpp:132:ProxySQL_Cluster_Monitor_thread(): [WARNING] Cluster: different ProxySQL version with peer host1:6032 . Remote: 2.5.5-10-g195bd70 . Self: 2.4.5-146-ge590770

I've also tried using 2.4.8 and 2.4.5 to see if it was differences in 2.x, but that doesn't appear to be the case.

Process was as  follows :

reinstall host1

INSERT INTO proxysql_servers (hostname,port,weight,comment) VALUES ('host1',6032,255,'host1');
INSERT INTO proxysql_servers (hostname,port,weight,comment) VALUES ('host2',6032,255,'host2');
INSERT INTO proxysql_servers (hostname,port,weight,comment) VALUES ('host3',6032,255,'host3');

load to runtime and then INSERT host1 into host2's proxysql server table.  This works as expected with all hosts running the same version.  With a version mismatch, data doesn't sync over to the new host.

Is this a known issue / expected or am I doing something wrong?  I was really hoping to be able to do rolling ProxySQL upgrades vs. building out a new cluster and cutting over every time.

Thanks!

[Jesmar Cannaò]

Hi Jonathanb-Fc,

Since version 2.1 it is a requirement that all the nodes in a ProxySQL Cluster of the exact same version (different OS or even architecture is possible, but the version should be exactly the same).

A cluster upgrade is almost like a rolling upgrade, but during the "rolling upgrade" there are 2 clusters: the first upgraded node will form a cluster with only itself, and each upgrade proxy will automatically join it.
The gotcha is that during the "rolling upgrade" you should push configuration changes on both clusters (or avoid pushing configuration changes at all).

With Thanks and Regards,

Jesmar

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/proxysql/3d3f2767-75d1-4286-9996-8b4c58ada776n%40googlegroups.com.

[jonathanb-fc]

Hi Jesmar,

Thanks for the info and quick response!  The 2 cluster rolling upgrade makes sense and gives me a good direction to go with in my planning.

Much appreciated!

-Jonathan