thanks - but do you know where there is a tutorial on how to run those utilities ?
I have downloaded them and getting an error.
I have entered the the username/password for master1 as m1/pas and for master2 as m2/pas in the [client] sections of both my.cnf files.
I get this error:
pt-table-sync --execute h=192.168.62.25,D=mailserver,t=virtual_users h=192.168.62.121
DBI connect(‘mailserver;host=192.168.62.25;mysql_read_default_gr oup=client’,’’,…) failed: Access denied for user ‘m1’@‘bbmachine.local’ (using password: YES) at /usr/bin/pt-table-sync line 1382
I think my issuse is for some reason it adds the ‘bbmachine.local’ ending to the name - do not know how to stop this. Further - i do not think it should matter because i have ‘m1’@’%’ – so that user can login from anywhere - I did not really give the user any further rights then the article - http://www.howtoforge.com/mysql_master_master_replication - gave the user.
thanks – any tutorial you can point me to would be appriciated.