Clint Mario Cleetus clintmario

## keybase.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                clintmario
                / keybase.md
            
            
              Created
              February 13, 2017 18:57
            
          
    Keybase proof

I hereby claim:

I am clintmario on github.
I am clintmario (https://keybase.io/clintmario) on keybase.
I have a public key ASCjGHzQ368VNQVhBpwT72LdKbtQ1pFRQ7RtHCfaliDKXgo

To claim this, I am signing this object:

  
## promoteReadReplicaDatabase.sh
/usr/local/bin/aws rds promote-read-replica --db-instance-identifier=$DEV_DB --output=text

## createReadReplicaDatabase.sh
/usr/local/bin/aws rds create-db-instance-read-replica --source-db-instance-identifier=$PRIMARY_SLAVE --db-instance-identifier=$DEV_DB --output=text

## deleteDatabase.sh
/usr/local/bin/aws rds delete-db-instance --db-instance-identifier=$DEV_DB --skip-final-snapshot --output=text

## showSlaveStatus.sql
SHOW slave status;

## startReplication.sql
CALL mysql.rds_start_replication;

## setExternalMaster.sql
CALL mysql.rds_set_external_master ('read-replica-3.production.host.com', 3306, 'REPLICA_USER', 'REPLICA_PASS', 'mysql-bin-changelog.033891', 70148, 0);

## createDatabase.sh
mysqldump --databases DATABASE_1 DATABASE_2 --single-transaction --compress --order-by-primary -f -h read-replica-3.production.host.com –uREPLICA_USER -pREPLICA_PASS | mysql --host=primaryslave.development.host.com –-port=3306 -f –uADMIN_USER –pADMIN_PASS

## showMasterStatus.sql
SHOW master status;

## stopReplication.sql
CALL mysql.rds_stop_replication;