Artikel mit dem Tag 'mysql'


 Add a new mysql server for replication WITHOUT any downtime!

1) Setup a New Server (ServerC) 2) On ServerC, Install MySQL (same version as ServerB) 3) On ServerC, service mysql stop 4) Copy /etc/my.cnf from ServerB to ServerC 5) On ServerC, change...

 ReSync MySQL in case of slave lost track

After connecting to Master RESET MASTER; FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS; The status appears as below: Note that position number varies!...