Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql
- > GRANT REPLICATION SLAVE ON *.* TO 'repl'@'$slaveip' IDENTIFIED BY '$slavepass';
- > quit;
- innobackupex --user=username --password=password /path/to/backupdir
- innobackupex --user=username --password=password /
- --apply-log /path/to/backupdir/$TIMESTAMP/
- rsync -avprP -e ssh /path/to/backupdir/$TIMESTAMP TheSlave:/path/to/mysql/
- scp /etc/mysql/my.cnf TheSlave:/etc/mysql/my.cnf
- /etc/init.d/mysql stop
- mv /path/to/mysql/datadir /path/to/mysql/datadir_bak
- mv /path/to/mysql/$TIMESTAMP /path/to/mysql/datadir
- chown -R mysql:mysql /path/to/mysql/datadir
- sed -i 's#server-id=1#server-id=2#g' /etc/mysql/my.cnf
- /etc/init.d/mysql start
- cat /var/lib/mysql/xtrabackup_binlog_info
- > TheMaster-bin.000001 481
- mysql
- > CHANGE MASTER TO MASTER_HOST='$masterip', MASTER_USER='repl', MASTER_PASSWORD='$slavepass', MASTER_LOG_FILE='TheMaster-bin.000001', MASTER_LOG_POS=481;
- > START SLAVE;
- <default_read>
- <connection>
- <use/>
- <host><![CDATA[host]]></host>
- <username><![CDATA[username]]></username>
- <password><![CDATA[password]]></password>
- <dbname><![CDATA[dbname]]></dbname>
- <type>pdo_mysql</type>
- <model>mysql4</model>
- <initStatements>SET NAMES utf8</initStatements>
- <active>1</active>
- </connection>
- </default_read>
- <default_setup>
- <connection>
- <host><![CDATA[Master-host]]></host>
- <username><![CDATA[user]]></username>
- <password><![CDATA[pass]]></password>
- <dbname><![CDATA[magentodb]]></dbname>
- <active>1</active>
- </connection>
- </default_setup>
- <default_read>
- <connection>
- <use/>
- <host><![CDATA[Slave-host]]></host>
- <username><![CDATA[user]]></username>
- <password><![CDATA[pass]]></password>
- <dbname><![CDATA[magento]]></dbname>
- <type>pdo_mysql</type>
- <model>mysql4</model>
- <initStatements>SET NAMES utf8</initStatements>
- <active>1</active>
- </connection>
- </default_read>
- [mysqld]
- server-id = 1
- log_bin = /var/log/mysql/mysql-bin.log
- expire_logs_days = 10
- max_binlog_size = 100M
- binlog_do_db = magento_demo
- binlog_ignore_db = mysql
- [mysqld]
- server-id=2
- log-bin=mysql-bin
- master-host=192.168.1.2
- master-user=username
- master-password=111111
- master-port=3306
- replicate-do-db=magento_demo
- replicate-ignore-db=mysql
- master-connect-retry=60
- <catalog_read_setup>
- <connection>
- <host><![CDATA[round.robbin.dns.host]]></host>
- <username><![CDATA[USERNAME]]></username>
- <password><![CDATA[password]]></password>
- <dbname><![CDATA[DATABASE]]></dbname>
- <initStatements><![CDATA[SET NAMES utf8]]></initStatements>
- <model><![CDATA[mysql4]]></model>
- <type><![CDATA[pdo_mysql]]></type>
- <pdoType><![CDATA[]]></pdoType>
- <active>1</active>
- </connection>
- </catalog_read_setup>
- <catalog_read>
- <connection>
- <use>catalog_read_setup</use>
- </connection>
- </catalog_read>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement