Assistance required for ProxySQL Binlog Reader on Debian 11

[Md Faizan]

Dear Proxysql Support Team,

I hope you are doing well. We are currently working on setting up the ProxySQL Binlog Reader on Debian 11(ARM64) which would enable causal consistency using GTIDs for master-slave replication. We have encountered several challenges while setting it up and would greatly appreciate your guidance on the following issues: 

1. The release page of ProxySQL Binlog Reader only contains the prebuilt library for AMD64 and not ARM64. Do you have a prebuilt binary of the same available for Debian 11 (ARM64) ? If so, could you provide us with the download link or the binary itself?

2.We are unable to find any relevant documentation on proxysql binlog reader except for the github repository, which also does not contain a lot of information. 

3.We followed one relevant blog by percona (we could not find any useful blogs other than this) to set up the binlog reader but could not make it work owing to a large number of errors. Some of it includes : 

a. We are unable to execute the commands that download the hash file from the MySQL Github repository. Could you provide any insights into resolving this issue?

b. We are unable to install the libmysqlclient-dev package, and without it we are not able to compile the binlog reader. The error message states that the package has no installation candidate. We suspect this issue might also be causing the cmake command to fail when executed in the libslave directory of ProxySQL.

 4. We also tried to build libslave by patching : 

tar -zxf libslave.tar.gz cd libslave-20171226 patch -p0 < ../patches/libslave_DBUG_ASSERT.patch patch -p0 < ../patches/libslave_ER_MALFORMED_GTID_SET_ENCODING.patch patch -p0 < ../patches/libslave_SSL_MODE_DISABLED.patch patch -p0 < ../patches/libslave_MySQL_8_new_events.patch

cmake .

make

make install

cd ..

but this also resulted in a lot of errors:

We even tried to give the absolute path of the patch files in the above commands but that did not work either.

We would appreciate it if you could provide the prebuilt binary of the same for Debian 11 (ARM64) architecture and any help with the documentation and the up-to-date steps to build the proxySql bin log reader binary for MySQL 8.0 would also be highly beneficial. 

Looking forward to your response.

Best Regards,

Md Faizan