whoa! problems.. problems..problems.. mysql replication system down.. looks like the slave data did not replicate from the master. The slave do not know what point in which binlog to start so i have to fix it by hand..what i do is :-
On Master
mysql> show master status;
write down master log file name and current positions. lets say the master file is server-bin-007 and the positions on 111000 . On slave now we must tell the slave server to read the current file and positions.
On Slave
mysql> slave stop;
mysql> change master to master_log_file='server-bin-007', master_log_pos=111000;
mysql> start slave;
confirm that I/O is running with
mysql> show slave status\G;
now the slave knows which point to start..
i'm a broken man splitted into pieces like a cheese thats why i'm using poor and broken english.
Windows and linux information and one stop centre for myself. Having difficulties to remember all things at once. This blog will remain be my references on the internet. Other people can take benefit from it. Thank you for visiting
Subscribe to:
Post Comments (Atom)
Simple Python Calculator This script will allows your to calculate the integers given with the chosen operation. You can add, substract, mu...
-
when trying to apt-get update i got this error message :- W: There is no public key available for the following key IDs xxxxxxxxxxxx t...
-
Skrip ini aku guna kat server aku.. backup mysql setiap hari. Hanya perlu ubah pada bahagian setting sahaja. chmod dan set cron untuk daily ...
-
This tutorial will help you get AWStats and Lighttpd working together. AWStats is an excellent log analyzer, and works well with Lighttpd. T...
No comments:
Post a Comment