[Mysql]Seconds_Behind_Master is sometimes increasing, and then set to null or zero again and again

Seconds_Behind_Master is sometimes increasing, and then set to null or zero again and again

• References
  
  • Mysql Documentation about Seconds_Behind_Master
    
• Description
  The value of Seconds_Behind_Master means the "This field is an indication of how “late” the slave is" in replication slave database. This value is often increased when the synchronization process in slave database is slower than master database's state.
  But sometimes the value of the Sseconds_Behind_Master is increasing, after a few seconds the value of Sescond_Behind_Master is displayed as zero or null quickly and again and again. The value of Slave_IO_Running is sometimes displayed as "No" when the Second_Behind_Master is displayed as Null.
  
• Cause
  When the server_id parameters between slave servers are duplicated, this problem is occured. The server_id value is unique identifier of the slave server.
  When some slave's server_id are duplicated, maybe master server recognize the same server, so one slave server is connecting and communicate with the the master server, other slave server is refused connecting to the master(at this time, slave's Slave_IO_Running status is set to Null because connection refused.)
  
  In our environment, this problem occures when one master database server has some slave servers, and some slave servers connects to the master database server and starts the replication at the same time. In this case, each slave server has to have the different server_id parameter when connecting to the master server.
  

[Grails]Upgraded Split Write Database Connection Plugin for master/slave configuration(Alpha version 0.3)

please refer to http://taapps-javalibs.blogspot.com/2009/04/grailsupgraded-split-write-database.html

[Mysql]some errors occures while compiling the mysql source code manually

Following errors occures while compiling the mysql database source code manually.

termcap error

• Error Message
  checking for termcap functions library... configure: error: No curses/termcap library found
• Solution
  Need to install ncurses-devel before compilation
  execute "yum -y install ncurses-devel"(if you want to install by using yum) and install ncurses-devel package
  

../depcomp: line 571: exec: g++: not found

• Error Message
  ../depcomp: line 571: exec: g++: not found
• Solution
  Need to install gcc-c++ compiler before manual compilation of the mysql
  execute "yum -y install gcc-c++" to install gcc-c++
  

../include/my_global.h:1078: error: redeclaration of C++ built-in type 'bool'

• Error Message
  ../include/my_global.h:1078: error: redeclaration of C++ built-in type 'bool'
  make[1]: *** [my_new.o] Error 1
• Solution
  Need to re-configure after installing the gcc-c++ compiler.
  After installing the gcc-c++ compiler, please execute "./configure" command with the correct options.

unrecognized options error

• Error Message
  configure: WARNING: unrecognized options: --with-innodb --with-partition .....
• Solution
  This "--with-innodb" or other options starts with "--with-" are somtimes invalid. We have to use the "--with-plugins=innobase" instead of using "--with-innodb" option when configuring the mysql compile options.
  
• References
  http://www.mysqlperformanceblog.com/?s=mysql+config+with+plugin+innobase
  http://www.linuxfromscratch.org/blfs/view/svn/server/mysql.html
  http://d.hatena.ne.jp/tomoyamkung/20081225/1230165292(Japanese)