有2 天的假期……因為….. 拗柴了… 應該問 dr 要多幾天的假……好好咁休息下ma ~ 很久沒有拗得這麼嚴重…對上一次已經係F.4 之時… 個次係左腳……估唔到一踏入豬年就連隻右腳不敗之神話亦要告吹了 ~~ 左右腳 同右手都出過事 ….. 左手細個個時拗過…. 唉也 …. 原來我已經係四肢不全啦….. lum, Q, 天宇 係港安陪我, 一眾人又幫我找taxi  ~ 謝謝你們 係診所第一次坐了輪椅….俾人推既滋味其實唔係咁爽…. 如Q 所講….好似好冇用咁~~

A. background OS: CentOS 4.4 MySQL package: 4.1.20-1.RHEL4.1 node1: 192.168.0.131   (Master 1/Slave 2) node2: 192.168.0.132   (Master 2/Slave 1) mysql path: /var/lib/mysql mysql config file: /etc/my.cnf reference: http://www.howtoforge.com/mysql_master_master_replication http://cha.homeip.net/blog/archives/2004/12/replication_in.html B. procedure   1. On Master 1, make changes in my.cnf #vim /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 #replication log-bin binlog-do-db=horde binlog-ignore-db=mysql binlog-ignore-db=test server-id=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid 2. On master 1, create a replication slave account in mysql. #mysql -u root -p mysql> grant replication slave on *.* to ‘replication’@192.168.0.132 identified by ‘slave’; mysql> exit and restart the mysql master1. #service mysqld restart 3. Now edit my.cnf on Slave1 or Master2 : [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock old_passwords=1 server-id=2 master-host = 192.168.0.131 master-user = replication master-password = slave master-port = 3306 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid   4. Restart mysql slave 1 and check config at #service mysqld restart #mysql -u root -p mysql> start slave; mysql> show slave statusG; ensure Slave_IO_Running and Slave_SQL_Running: must be to YES. mysql> exit 5. On master 1: mysql> show master status; +————————+———-+————–+——————+ | File                   | Position | Binlog_Do_DB | Binlog_Ignore_DB | +————————+———-+————–+——————+ |MysqlMYSQL01-bin.000008 |       79 | horde        | mysql,test       | +————————+———-+————–+——————+ 1 row in set (0.00 sec) The above scenario is for master-slave, now we will create a slave master scenario for the same systems and it will work as master master. 6. On Master2/Slave 1, edit my.cnf and master entries into it: #vim …

CentOS 4.4 /etc/vimrc set background=dark    “brighter the color set ai set smartindent