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...
-
Make your own OpenAi chat I am totally new comer in Python trying to learn this language from scratch. Knowing a basic of python language i...
-
Always getting some gpg error while trying to do aptitude update on older version of debian platform such as etch or lenny. The message look...
-
i found this registry tweak for dns cache in windows xp but don't really know it works or not... give a try edit your registry or put in...
No comments:
Post a Comment