Add new comment

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Submitted by pakogah (registered user) on Thu, 2008-09-11 10:54.

    there are 2 parameter we need to watch and make sure that replication is running, 1 is Slave IO (the replication engine) and another is Slave SQL,

the Slave IO can  unable to run when we enter the wrong master/ slave paramater like replication user, etc...

 and Slave SQL can unable to run when some sql syntax is replicated to slave but found an error like duplicated key...

 the slave IO still running but when slave sql stopped, your slave will no longer have the same data with your master anymore...

 so you should add another parameter to check Slave_SQL_Running running or not

 best regards

Please do not use the comment function to ask for help! If you need help, please use our forum.
Comments will be published after administrator approval.

Reply

*
*
The content of this field is kept private and will not be shown publicly.


*

  • Images can be added to this post.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <div>
  • Lines and paragraphs break automatically.