Advertisement
Guest User

Untitled

a guest
Aug 21st, 2014
255
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.88 KB | None | 0 0
  1. mysql
  2. > GRANT REPLICATION SLAVE ON *.* TO 'repl'@'$slaveip' IDENTIFIED BY '$slavepass';
  3. > quit;
  4. innobackupex --user=username --password=password /path/to/backupdir
  5. innobackupex --user=username --password=password /
  6. --apply-log /path/to/backupdir/$TIMESTAMP/
  7.  
  8. rsync -avprP -e ssh /path/to/backupdir/$TIMESTAMP TheSlave:/path/to/mysql/
  9. scp /etc/mysql/my.cnf TheSlave:/etc/mysql/my.cnf
  10.  
  11. /etc/init.d/mysql stop
  12. mv /path/to/mysql/datadir /path/to/mysql/datadir_bak
  13. mv /path/to/mysql/$TIMESTAMP /path/to/mysql/datadir
  14. chown -R mysql:mysql /path/to/mysql/datadir
  15. sed -i 's#server-id=1#server-id=2#g' /etc/mysql/my.cnf
  16. /etc/init.d/mysql start
  17. cat /var/lib/mysql/xtrabackup_binlog_info
  18. > TheMaster-bin.000001 481
  19.  
  20. mysql
  21. > CHANGE MASTER TO MASTER_HOST='$masterip', MASTER_USER='repl', MASTER_PASSWORD='$slavepass', MASTER_LOG_FILE='TheMaster-bin.000001', MASTER_LOG_POS=481;
  22. > START SLAVE;
  23.  
  24. <default_read>
  25. <connection>
  26. <use/>
  27. <host><![CDATA[host]]></host>
  28. <username><![CDATA[username]]></username>
  29. <password><![CDATA[password]]></password>
  30. <dbname><![CDATA[dbname]]></dbname>
  31. <type>pdo_mysql</type>
  32. <model>mysql4</model>
  33. <initStatements>SET NAMES utf8</initStatements>
  34. <active>1</active>
  35. </connection>
  36. </default_read>
  37.  
  38. <default_setup>
  39. <connection>
  40. <host><![CDATA[Master-host]]></host>
  41. <username><![CDATA[user]]></username>
  42. <password><![CDATA[pass]]></password>
  43. <dbname><![CDATA[magentodb]]></dbname>
  44. <active>1</active>
  45. </connection>
  46. </default_setup>
  47. <default_read>
  48. <connection>
  49. <use/>
  50. <host><![CDATA[Slave-host]]></host>
  51. <username><![CDATA[user]]></username>
  52. <password><![CDATA[pass]]></password>
  53. <dbname><![CDATA[magento]]></dbname>
  54. <type>pdo_mysql</type>
  55. <model>mysql4</model>
  56. <initStatements>SET NAMES utf8</initStatements>
  57. <active>1</active>
  58. </connection>
  59. </default_read>
  60.  
  61. [mysqld]
  62. server-id = 1
  63. log_bin = /var/log/mysql/mysql-bin.log
  64. expire_logs_days = 10
  65. max_binlog_size = 100M
  66. binlog_do_db = magento_demo
  67. binlog_ignore_db = mysql
  68.  
  69. [mysqld]
  70. server-id=2
  71. log-bin=mysql-bin
  72. master-host=192.168.1.2
  73. master-user=username
  74. master-password=111111
  75. master-port=3306
  76. replicate-do-db=magento_demo
  77. replicate-ignore-db=mysql
  78. master-connect-retry=60
  79.  
  80. <catalog_read_setup>
  81. <connection>
  82. <host><![CDATA[round.robbin.dns.host]]></host>
  83. <username><![CDATA[USERNAME]]></username>
  84. <password><![CDATA[password]]></password>
  85. <dbname><![CDATA[DATABASE]]></dbname>
  86. <initStatements><![CDATA[SET NAMES utf8]]></initStatements>
  87. <model><![CDATA[mysql4]]></model>
  88. <type><![CDATA[pdo_mysql]]></type>
  89. <pdoType><![CDATA[]]></pdoType>
  90. <active>1</active>
  91. </connection>
  92. </catalog_read_setup>
  93. <catalog_read>
  94. <connection>
  95. <use>catalog_read_setup</use>
  96. </connection>
  97. </catalog_read>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement