I have a few servers that are located on the other side of the world that are slowing down my local database
is their anyway to enable asynchronous mode ?
I was using mariadb but transfers kept timing out etc ( rsync worked but the locking of local database just made it useless clicking and waiting 10 + secs for a change to happen was not going to cut it , XtraBackup helped but I just had a heap of problems with transfers that never started and DNS lookup kept failing )
so after wasting a week on that combination
I got your XtraDB cluster working first go … but my front end is being extremely slow since enabling the off site remote servers
also where is the search function hidden on this forum ? I can only see it when inside a topic ?
mysql> SET pxc_strict_mode=PERMISSIVE; should this be
mysql> SET GLOBAL pxc_strict_mode=PERMISSIVE; as that was the only way I could get it to be set