HI, all
recently , we are testing maxscale 1.4.3 + mariadb galera cluster, maxscale's read write split function and privilege control is very good.
Make a small suggestion:
in mariadb show processlist , host column show all is Maxcale server's IP, if found some slow statement, it can's confirm the statement come from which ip.
present, we use method is install mysql sniff tools in MaxScale sever, capture the statement for the specified port, but it is more trouble.
In maxadmin, show sessions only can show Client Address, it can't show process id or process detail info, if can add mysql's id and info column of show processlist, It is very easy to analyze the source of the problem.
thanks.