Verifying MySQL Replication Integrity with pt-table-checksum
$ pt-table-checksum h=host,P=port,u=user,p=pass --tables db.smallest_table
| $ grep error /var/log/syslog | |
| Sep 20 15:54:26 Xen kernel: [ 71.932010] EXT4-fs (dm-0): re-mounted. Opts: errors=remount-ro | |
| Sep 20 15:54:30 Xen xapi: [error|Xen|0 thread_zero|Registering SR plugins D:e82ade389516|sm_exec] Not scanning /var/lib/xcp/sm for SM backends: directory does not exist | |
| Sep 20 15:54:26 Xen xapi: [error|Xen|309||xapi] Unexpected exception in message hook. Exception='INTERNAL_ERROR: [ Subprocess exitted with unexpected code 1; stdout = [ ]; stderr = [ pool:other-config:mail-destination not specified#012 ] ]' | |
| Sep 20 15:55:09 Xen tapdisk[2366]: tapdisk-log: closing after 0 errors | |
| Sep 20 15:55:32 Xen tapdisk[2980]: tapdisk-log: closing after 0 errors | |
| Sep 20 15:57:34 Xen tapdisk[3690]: tapdisk-log: closing after 0 errors | |
| Sep 20 15:58:10 Xen tapdisk[4292]: tapdisk-log: closing after 0 errors | |
| Sep 20 15:58:46 Xen tapdisk[5012]: tapdisk-log: closing after 0 errors |
| To capture the screen | |
| ffmpeg -f x11grab -s wxga -r 25 -i :0.0 -qscale 0 /tmp/out.mpg |
| → first download the xampp from http://www.apachefriends.org/en/xampp-macosx.html#849 | |
| $ wget -c http://www.apachefriends.org/download.php?xampp-osx-1.8.2-2-installer.dmg | |
| → install it | |
| $ hdiutil mount xampp-osx-version-number.dmg | |
| $ cd /Volumes/xampp_mounted_directroy | |
| $ sudo cp -Rv xampp_app_file.app /Application | |
| don't forget to detatch the mounted volume |
| #try this in scratchpad | |
| function func (obj /*, *args*/) { | |
| var star_args = Array.prototype.slice.call (arguments, func.length); | |
| /* now star_args[0] is the first undeclared argument */ | |
| for (i=0;i<star_args.length;i++){ | |
| alert(star_args[i]); | |
| } | |
| alert(y); |
| //function to process http request | |
| httpRequest = function(message, path, action, options, callback) { | |
| return message.http("" + BASEURL + "/" + path).query(options)[action]()(function(err, res, body) { | |
| return callback(err, res, body); | |
| }); | |
| }; | |
| //function call | |
| httpRequest(msg, 'getDrink', 'post', { |
| GIT- http://gitready.com/ | |
| MYSQL-http://www.efytimes.com/e1/fullnews.asp?edid=123323 |
Verifying MySQL Replication Integrity with pt-table-checksum
$ pt-table-checksum h=host,P=port,u=user,p=pass --tables db.smallest_table
| mysql> show slave status\G; | |
| *************************** 1. row *************************** | |
| Slave_IO_State: Waiting for master to send event | |
| Master_Host: 192.168.2.210 | |
| Master_User: replica | |
| Master_Port: 3306 | |
| Connect_Retry: 60 | |
| Master_Log_File: mysql-bin.000012 | |
| Read_Master_Log_Pos: 100087 | |
| Relay_Log_File: mysqld-relay-bin.000010 |