Dear jrivera thank your for your generous help. now my 3 node cluster is working fine. But I have problem regarding to accessing the cluster. when I try to log in it gives error message:
ERROR 1129 (HY000): Host ‘192.168.40.3’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’
but it needs to be used MySQL >Flush hosts on any one of them and it works in that way. My question is: since using ‘flush hosts’ is trivial work that needs to be done each time this error happens, is there a better alternative way of solving this issue?
Thanks you.