PHP Client for Mysql Binlog

標籤：mysql   binlog   

PHP解析Mysql Binlog，依賴於mysql-replication-listener庫
詳見：https://github.com/bullsoft/php-binlog

Install MySQL Replication Listener

• https://github.com/bullsoft/mysql-replication-listener/archive/master.zip

unzip mysql-replication-listener-master.zipcd mysql-replication-listener-mastercmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-replicationmake & make install

Install php-binlog

• https://github.com/bullsoft/php-binlog/archive/master.zip

unzip php-binlog-master.zipcd php-binlog-master/ext/usr/local/php5.5.15/bin/phpize./configure --with-php-config=/usr/local/php5.5.15/bin/php-config --with-mysql-binlog=/usr/local/mysql-replication

Examples

註：Binlog為行格式

<?php$link = binlog_connect("mysql://root:[email protected]:3306");//binlog_set_position($link, 4);  //binlog_set_position($link, 4, ‘mysql-bin.000006‘);                           while($event=binlog_wait_for_next_event($link)) {    // it will block here                                     switch($event[‘type_code‘]) {        case BINLOG_DELETE_ROWS_EVENT:            var_dump($event);            // do what u want ...                                       break;        case BINLOG_WRITE_ROWS_EVENT:            var_dump($event);            // do what u want ...                                       break;        case BINLOG_UPDATE_ROWS_EVENT:            var_dump($event);            // do what u want ...                                       break;        default:            // var_dump($event);                                        break;    }}

Update_rows

update `type` set type_id = 22 WHERE id in (58, 59);

array(5) {  ‘type_code‘ =>  int(24)  ‘type_str‘ =>  string(11) "Update_rows"  ‘db_name‘ =>  string(5) "cloud"  ‘table_name‘ =>  string(4) "type"  ‘rows‘ =>  array(4) {    [0] =>    array(5) {      [0] =>      string(2) "58"      [1] =>      string(8) "adsfasdf"      [2] =>      string(4) "asdf"      [3] =>      string(2) "22"      [4] =>      string(1) "0"    }    [1] =>    array(5) {      [0] =>      string(2) "58"      [1] =>      string(8) "adsfasdf"      [2] =>      string(4) "asdf"      [3] =>      string(1) "4"      [4] =>      string(1) "0"    }    [2] =>    array(5) {      [0] =>      string(2) "59"      [1] =>      string(8) "adsfasdf"      [2] =>      string(4) "asdf"      [3] =>      string(2) "22"      [4] =>      string(1) "0"    }    [3] =>    array(5) {      [0] =>      string(2) "59"      [1] =>      string(8) "adsfasdf"      [2] =>      string(4) "asdf"      [3] =>      string(1) "4"      [4] =>      string(1) "0"    }  }}

Delete_rows

delete from `type` WHERE id in (58, 59);

array(5) {  ‘type_code‘ =>  int(25)  ‘type_str‘ =>  string(11) "Delete_rows"  ‘db_name‘ =>  string(5) "cloud"  ‘table_name‘ =>  string(4) "type"  ‘rows‘ =>  array(2) {    [0] =>    array(5) {      [0] =>      string(2) "58"      [1] =>      string(8) "adsfasdf"      [2] =>      string(4) "asdf"      [3] =>      string(2) "22"      [4] =>      string(1) "0"    }    [1] =>    array(5) {      [0] =>      string(2) "59"      [1] =>      string(8) "adsfasdf"      [2] =>      string(4) "asdf"      [3] =>      string(2) "22"      [4] =>      string(1) "0"    }  }}

Write_rows

insert into type values (Null, "Hello, World", "Best world", 4, 0), (NULL, "你好，世界", "世界很美好", 3, 5);

array(5) {  ‘type_code‘ =>  int(23)  ‘type_str‘ =>  string(10) "Write_rows"  ‘db_name‘ =>  string(5) "cloud"  ‘table_name‘ =>  string(4) "type"  ‘rows‘ =>  array(2) {    [0] =>    array(5) {      [0] =>      string(2) "95"      [1] =>      string(12) "Hello, World"      [2] =>      string(10) "Best world"      [3] =>      string(1) "4"      [4] =>      string(1) "0"    }    [1] =>    array(5) {      [0] =>      string(2) "96"      [1] =>      string(15) "你好，世界"      [2] =>      string(15) "世界很美好"      [3] =>      string(1) "3"      [4] =>      string(1) "5"    }  }}

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。

PHP Client for Mysql Binlog