Load-Balance MySQL 8 Multi-Primary Cluster with ProxySQL

[@ofirgranot]

This is a perfect tutorial, thank you!!!

[@lazysysad]

You're so welcome!

[@RakeshKumar-xv2fq]

Trying to connect the same with percona xtrdb 8 . will it work ?

[@muhammadatallah1209]

Great 😍

[@lazysysad]

Thank you 😊

[@muhammadatallah1209]

@@lazysysad in fact I have an question about group replication I have been typed as a comment in your video, can you review please

[@EricChua-gm9in]

I am connected to ProxySQL admin and when I run any SQL commands, I will get this error.
ProxySQL Admin> show databases;
ERROR 2014 (HY000): Commands out of sync; you can't run this command now
ProxySQL Admin> SELECT * FROM mysql_servers;
ERROR 2014 (HY000): Commands out of sync; you can't run this command now
Any idea how to fix this?

[@sanatteli8569]

Great tutorial but I am getting an error.
When I run SAVE ADMIN VARIABLES TO DISK;
it says: ERROR 1045 (28000): ProxySQL Admin Error: attempt to write a readonly database
Did I miss something? Would appreciate some help?

[@vichansodatath703]

Thank you for your tutorial,
In step, config mysql group replication need to add view to mysql instance sys:
ERROR 1305 (42000): FUNCTION sys.gr_applier_queue_length does not exist

[@hafizfarhan3203]

unable to install proxysql