Skip to content

Instantly share code, notes, and snippets.

@tsabat
Last active December 13, 2015 23:09
Show Gist options
  • Save tsabat/4990095 to your computer and use it in GitHub Desktop.
Save tsabat/4990095 to your computer and use it in GitHub Desktop.
The results of the `xfs_growfs` and setting up replication.

old (look at last line)

/vol/lib/mysql# df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/xvda1       50G  3.9G   44G   9% /
udev            3.7G  8.0K  3.7G   1% /dev
tmpfs           1.5G  188K  1.5G   1% /run
none            5.0M     0  5.0M   0% /run/lock
none            3.7G     0  3.7G   0% /run/shm
none            100M     0  100M   0% /run/user
/dev/xvdb       414G  199M  393G   1% /mnt
/dev/xvdf        10G  5.7G  4.3G  57% /vol

new (look at last line)

df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/xvda1       50G  4.2G   44G   9% /
udev            3.7G  8.0K  3.7G   1% /dev
tmpfs           1.5G  188K  1.5G   1% /run
none            5.0M     0  5.0M   0% /run/lock
none            3.7G     0  3.7G   0% /run/shm
none            100M     0  100M   0% /run/user
/dev/xvdb       414G  199M  393G   1% /mnt
/dev/xvdf       100G  5.8G   95G   6% /vol

slave running!

SHOW SLAVE STATUS\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: ec2-50-112-253-157.us-west-2.compute.amazonaws.com
                  Master_User: root
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000047
          Read_Master_Log_Pos: 25213734
               Relay_Log_File: ip-10-245-10-228-relay-bin.000003
                Relay_Log_Pos: 8187079
        Relay_Master_Log_File: mysql-bin.000047
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 25213734
              Relay_Log_Space: 8187246
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
1 row in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment