// Master
// Initialize
/data/ushastry/server/mysql-advanced-5.6.20/scripts/mysql_install_db --basedir=/data/ushastry/server/mysql-advanced-5.6.20 --datadir=/tmp/73941 --user=root

// Bring up
/data/ushastry/server/mysql-advanced-5.6.20/bin/mysqld --innodb_buffer_pool_size=2147483648 --basedir=/data/ushastry/server/mysql-advanced-5.6.20 --datadir=/tmp/73941 --socket=/tmp/73941/socket.sock --port=73941 --log-error=/tmp/73941/73941.err --log_bin --server_id=1 --user=root 2>&1 &


[root@cluster-repo mysql-advanced-5.6.20]# ls -l /tmp/73941/cluster-repo-bin.[0-9]*
-rw-rw---- 1 root root 120 Sep 19 06:21 /tmp/73941/cluster-repo-bin.000001
[root@cluster-repo mysql-advanced-5.6.20]#
[root@cluster-repo mysql-advanced-5.6.20]# md5sum /tmp/73941/cluster-repo-bin.[0-9]*
5d23ed05828bcc4a29777bf04aaca21b  /tmp/73941/cluster-repo-bin.000001
[root@cluster-repo mysql-advanced-5.6.20]#
[root@cluster-repo mysql-advanced-5.6.20]#



// On log server (ensure that repl user is created on master

[root@cluster-repo log_server]# /data/ushastry/server/mysql-advanced-5.6.20/bin/mysqlbinlog --user=repl --password=slavepass --host=127.0.0.1 --port=73941 --read-from-remote-server --raw --stop-never cluster-repo-bin.000001
Warning: Using a password on the command line interface can be insecure.

[root@cluster-repo log_server]# ls -l cluster-repo-bin.[0-9]*
-rw-r--r-- 1 root root 734 Sep 19 06:23 cluster-repo-bin.000001
[root@cluster-repo log_server]#
[root@cluster-repo log_server]#
[root@cluster-repo log_server]# md5sum cluster-repo-bin.[0-9]*
d962290c85628d3b9e2ae44f91376e17  cluster-repo-bin.000001
[root@cluster-repo log_server]#
[root@cluster-repo log_server]#

^^ cluster-repo-bin.000001 with diff checksum but I guess this is expected since cluster-repo-bin.000001 is currently being used.

// Flush logs on master and confirm cluster-repo-bin.000001 md5sum is same on master and on log server

mysql> flush logs;
Query OK, 0 rows affected (0.01 sec)

-- Master

[root@cluster-repo mysql-advanced-5.6.20]# md5sum /tmp/73941/cluster-repo-bin.[0-9]*
0925ee8d6ca08a5489390eb6cf5219c0  /tmp/73941/cluster-repo-bin.000001
4c64de5e86373725b37e44d758423c44  /tmp/73941/cluster-repo-bin.000002

-- Log server

[root@cluster-repo log_server]# md5sum cluster-repo-bin.[0-9]*
0925ee8d6ca08a5489390eb6cf5219c0  cluster-repo-bin.000001
e1c83b146c6df050d1955a01bb53570a  cluster-repo-bin.000002


// Try to load some data on master, flush logs etc in between

-- Master

mysql>
mysql> set @id:=0;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>  insert into `keyvalue` values (@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000));

Query OK, 4 rows affected, 1 warning (0.01 sec)
Records: 4  Duplicates: 0  Warnings: 1

mysql>
mysql>  insert into `keyvalue`(`id`,`name`)
    ->    select @id:=@id+1,md5(rand()*1000000) from
    ->     `keyvalue` k1, `keyvalue` k2, `keyvalue` k3, `keyvalue` k4,`keyvalue` k5,`keyvalue` k6, `keyvalue` k7, `keyvalue` k8, `keyvalue` k9,
    -> `keyvalue` k0,`keyvalue` ka, `keyvalue` kb, `keyvalue` kc, `keyvalue` kd limit 5000;
Query OK, 5000 rows affected, 3 warnings (0.20 sec)
Records: 5000  Duplicates: 0  Warnings: 3

mysql> drop table if exists keyvalue;
CREATE TABLE `keyvalue` (
Query OK, 0 rows affected (0.01 sec)

mysql> CREATE TABLE `keyvalue` (
    ->   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    ->   `name` varchar(250),
    ->   PRIMARY KEY (`id`)
    -> ) ENGINE=innodb;

Query OK, 0 rows affected (0.03 sec)

mysql>
mysql> set @id:=0;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>  insert into `keyvalue` values (@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000));

Query OK, 4 rows affected, 1 warning (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 1

mysql>
mysql>  insert into `keyvalue`(`id`,`name`)
    ->    select @id:=@id+1,md5(rand()*1000000) from
    ->     `keyvalue` k1, `keyvalue` k2, `keyvalue` k3, `keyvalue` k4,`keyvalue` k5,`keyvalue` k6, `keyvalue` k7, `keyvalue` k8, `keyvalue` k9,
    -> `keyvalue` k0,`keyvalue` ka, `keyvalue` kb, `keyvalue` kc, `keyvalue` kd limit 50000;
Query OK, 50000 rows affected, 3 warnings (0.92 sec)
Records: 50000  Duplicates: 0  Warnings: 3

-- master

[root@cluster-repo mysql-advanced-5.6.20]# ls -l /tmp/73941/cluster-repo-bin.[0-9]*
-rw-rw---- 1 root root  867 Sep 19 06:26 /tmp/73941/cluster-repo-bin.000001
-rw-rw---- 1 root root 2815 Sep 19 06:29 /tmp/73941/cluster-repo-bin.000002
[root@cluster-repo mysql-advanced-5.6.20]#
[root@cluster-repo mysql-advanced-5.6.20]# md5sum /tmp/73941/cluster-repo-bin.[0-9]*
0925ee8d6ca08a5489390eb6cf5219c0  /tmp/73941/cluster-repo-bin.000001
8f418801cb65638336f96c607256eff4  /tmp/73941/cluster-repo-bin.000002


-- Log server

[root@cluster-repo log_server]# ls -l cluster-repo-bin.[0-9]*
-rw-r--r-- 1 root root  867 Sep 19 06:26 cluster-repo-bin.000001
-rw-r--r-- 1 root root 2784 Sep 19 06:29 cluster-repo-bin.000002
[root@cluster-repo log_server]#
[root@cluster-repo log_server]# md5sum cluster-repo-bin.[0-9]*
0925ee8d6ca08a5489390eb6cf5219c0  cluster-repo-bin.000001
a2bb12fb4093a7ad57abf6107ccbf090  cluster-repo-bin.000002


// restart master and log server log files checksum

- Stop
[root@cluster-repo mysql-advanced-5.6.20]# /data/ushastry/server/mysql-advanced-5.6.20/bin/mysqladmin -u root -p -S /tmp/73941/socket.sock shutdown
Enter password:
[1]+  Done                    /data/ushastry/server/mysql-advanced-5.6.20/bin/mysqld --innodb_buffer_pool_size=2147483648 --basedir=/data/ushastry/server/mysql-advanced-5.6.20 --datadir=/tmp/73941 --socket=/tmp/73941/socket.sock --port=73941 --log-error=/tmp/73941/73941.err --log_bin --server_id=1 --user=root 2>&1

- Start

/data/ushastry/server/mysql-advanced-5.6.20/bin/mysqld --innodb_buffer_pool_size=2147483648 --basedir=/data/ushastry/server/mysql-advanced-5.6.20 --datadir=/tmp/73941 --socket=/tmp/73941/socket.sock --port=73941 --log-error=/tmp/73941/73941.err --log_bin --server_id=1 --user=root 2>&1 &


[root@cluster-repo mysql-advanced-5.6.20]# ls -l /tmp/73941/cluster-repo-bin.[0-9]*
-rw-rw---- 1 root root  867 Sep 19 06:26 /tmp/73941/cluster-repo-bin.000001
-rw-rw---- 1 root root 2838 Sep 19 06:31 /tmp/73941/cluster-repo-bin.000002
-rw-rw---- 1 root root  120 Sep 19 06:33 /tmp/73941/cluster-repo-bin.000003
[root@cluster-repo mysql-advanced-5.6.20]#
[root@cluster-repo mysql-advanced-5.6.20]# md5sum /tmp/73941/cluster-repo-bin.[0-9]*
0925ee8d6ca08a5489390eb6cf5219c0  /tmp/73941/cluster-repo-bin.000001
589dc4a5981154d79b4efce81cde3dd2  /tmp/73941/cluster-repo-bin.000002
b57b90273438fc46b06ac389962e120b  /tmp/73941/cluster-repo-bin.000003


- Before reconnecting mysqlbinlog

[root@cluster-repo log_server]# ls -l cluster-repo-bin.[0-9]*
-rw-r--r-- 1 root root  867 Sep 19 06:26 cluster-repo-bin.000001
-rw-r--r-- 1 root root 2815 Sep 19 06:31 cluster-repo-bin.000002
[root@cluster-repo log_server]#
[root@cluster-repo log_server]# md5sum cluster-repo-bin.[0-9]*
0925ee8d6ca08a5489390eb6cf5219c0  cluster-repo-bin.000001
5edc03cae903a00ed4804b5ac6d28e1e  cluster-repo-bin.000002

- After reconnecting mysqlbinlog with binlog cluster-repo-bin.000001

[root@cluster-repo log_server]# md5sum cluster-repo-bin.[0-9]*
0925ee8d6ca08a5489390eb6cf5219c0  cluster-repo-bin.000001
589dc4a5981154d79b4efce81cde3dd2  cluster-repo-bin.000002
e1c83b146c6df050d1955a01bb53570a  cluster-repo-bin.000003
[root@cluster-repo log_server]#
[root@cluster-repo log_server]# ls -l cluster-repo-bin.[0-9]*
-rw-r--r-- 1 root root  867 Sep 19 06:37 cluster-repo-bin.000001
-rw-r--r-- 1 root root 2838 Sep 19 06:37 cluster-repo-bin.000002
-rw-r--r-- 1 root root    4 Sep 19 06:37 cluster-repo-bin.000003

If mysqlbinlog reconnect from cluster-repo-bin.000002

[root@cluster-repo log_server]# /data/ushastry/server/mysql-advanced-5.6.20/bin/mysqlbinlog --user=repl --password=slavepass --host=127.0.0.1 --port=73941 --read-from-remote-server --raw --stop-never cluster-repo-bin.000002
Warning: Using a password on the command line interface can be insecure.


[root@cluster-repo log_server]# ls -l cluster-repo-bin.[0-9]*
-rw-r--r-- 1 root root 2838 Sep 19 06:38 cluster-repo-bin.000002
-rw-r--r-- 1 root root    4 Sep 19 06:38 cluster-repo-bin.000003
[root@cluster-repo log_server]#
[root@cluster-repo log_server]# md5sum cluster-repo-bin.[0-9]*
589dc4a5981154d79b4efce81cde3dd2  cluster-repo-bin.000002
e1c83b146c6df050d1955a01bb53570a  cluster-repo-bin.000003