Hi All
i have replication setup in mysql. but i have a problem with the 2 servers going out of sync the first problem i tracked down to phpmyadmin and the way it alters a database. but i have also found that my setup doesn't add create database commands to the bin-log 😕 (maybe it isnt supposed to but then adds the create table statement for that database causing the lost of sync between the servers)
has anyone any experiences of problems with mysql replication and possible do's and dont's
my setup
Master 3.23.49 linux
binlog-ignore-db=mysql
all tables are myisam
Slave 3.23.49 linux
connects over a ssh tunnel
thanks for any insights and help with keeping my servers insync
dan
