1、雙機冷備1.1實驗環(huán)境1、虛擬機兩臺主機ip：172.16.100.194從機ip：172.16.100.1952、安裝8.1.0.3x86郵件系統(tǒng)3、在停止郵件服務(wù)的，情況下將主機3個mysql目錄打包拷貝到備機上再做配置(當然也可以或者用熱拷貝的方法、或者mysqldump這個需要先鎖表)如果主從都是新裝的話就不用拷貝了4、Mysqldump方法：主機到處數(shù)據(jù)庫#mysqldump-h127.0.0.1-P3306-all-databases-lock-all-tables-flush-logs-master-data=2/backup/eyou_mail.sql#mysqldump-h1

2、27.0.0.1-P3316-all-databases-lock-all-tables-flush-logs-master-data=2/backup/eyou_mail_index.sql#mysqldump-h127.0.0.1-P3326-all-databases-lock-all-tables-flush-logs-master-data=2/backup/eyou_mail_log.sqlScp/backup/eyou_mail*root172.16.100.195:/root備機倒入：mysql-h127.0.0.1-P3306/root/eyou_mail.sqlmysql-

3、h127.0.0.1P3316/root/eyou_mail_index.sqlmysql-h127.0.0.1P3326mysql-socket=/usr/local/eyou/mail/run/em_mysql.sockmysqlgrantreplicationslave,file,reload,superon*.*tobackup172.16.100.195identifiedby123456,;mysqlflushprivileges;rootlocalhostmysql#mysql-socket=/usr/local/eyou/mail/run/em_mysql_index.sock

4、mysqlgrantreplicationslave,file,reload,superon*.*tobackup172.16.100.195identifiedby123456,;mysqlflushprivileges;rootlocalhostmysql#mysql-socket=/usr/local/eyou/mail/run/em_mysql_log.sockmysqlgrantreplicationslave,file,reload,superon*.*tobackup172.16.100.195identifiedby123456,;mysqlflushprivileges;2、

5、配置mysql3個主配置文件先確認是否是升級過來的v8版本；最好進入3個數(shù)據(jù)庫看下數(shù)據(jù)庫叫什么名字修改配置文件前最好備份一份；免得搞飛機1）、配置flog-bin=mysql-bin#指備份的binlogserver-id=1#服務(wù)器ID號，這個不能重復(fù)注釋bind-address=127.0.0.12）、配置my_f文件log-bin=mysql-binserver-id=1注釋bind-address=127.0.0.13）、酉己置my_f文件log-bin=mysql-binserver-id=1注釋bind-address=127.0.0.13、重啟三個mysql:eyou_mails

6、topmysql;eyou_mailstartmysqleyou_mailstopmysql_index;eyou_mailstartmysql_indexeyou_mailstopmysql_log;eyou_mailstartmysql_log4、查看mysqlbinlog狀態(tài)5、mysqlflushtableswithreadlock;/鎖定數(shù)據(jù)庫，不要退出mysql（可以進入3個數(shù)據(jù)庫實例進行鎖定測試下面是在mysql實例測試的）mysqlshowmasterstatus;rrryaqlrrryaql亨howmasterstatus;howmasterstatus;411411dhdh

7、|Ft12IPasition|Binlag_Do_DB|B1nl6g_ignerc_DB|+ +- -1 11 1一1 11 1- -4-4- -Imysql-bin.000013|990377|eyou_mai1|1rori1nset(0,00sec)從機配置1、配置3個mysql主配置文件1)、配置fserver-id=2#服務(wù)器ID號，這個不能重復(fù)log-bin=mysql-bin#指備份的binlogslave-skip-errors=all#跳過錯誤expire_logs_day=14replicate-do-db=eyou_mailreplicate-ignore-table=ey

8、ou_mail.domain_batch_queuereplicate-ignore-table=eyou_mail.domain_config_nocachereplicate-ignore-table=eyou_mail.gearman_queuereplicate-ignore-table=eyou_mail.group_batch_queuereplicate-ignore-table=eyou_mail.group_send_examine_queuereplicate-ignore-table=eyou_mail.group_subscribe_examine_queuerepli

9、cate-ignore-table=eyou_mail.member_iteration_queuereplicate-ignore-table=eyou_mail.plugin_user_notebook_reminder_queuereplicate-ignore-table=eyou_mail.user_batch_queuereplicate-ignore-table=eyou_mail.user_register_examine_queuereplicate-ignore-table=eyou_mail.user_time_mail_queue使用replicate_do_db和re

10、plicate_ignore_db時有一個隱患，跨庫更新時會出錯原因是設(shè)置replicate_do_db或replicate_ignore_db后，MySQ執(zhí)彳Tsql前檢查的是當前默認數(shù)據(jù)庫，所以跨而更新語句被忽略replicate_wild_do_table和replicate_wild_ignore_table來代替如或replicate_wild_ignore_table=mysql.%這樣就可以避免出現(xiàn)上述問題了2)、配置my_fserver-id=2log-bin=mysql-binexpire_logs_day=14slave-skip-errors=allreplicate-d

11、o-db=eyou_mail_index3)、酉己置my_fserver-id=2log-bin=mysql-binexpire_logs_day=14slave-skip-errors=allreplicate-do-db=eyou_mail_logreplicate-ignore-table=eyou_mail_log.log_auth_statistics_queuereplicate-ignore-table=eyou_mail_log.log_deliver_mail_statistics_queue2、啟動三個mysql實例：eyou_mailstartmysqleyou_mail

12、startmysql_indexeyou_mailstartmysql_log3、進入mysql:mysql-socket=/usr/local/eyou/mail/run/em_mysql.sockslavestop;changemastertomaster_host=172.16.100.194,master_user=backup,master_password=123456,master_log_file=mysql-bin.000013,master_log_pos=990377;1 1E-1-bE-1-bi in.CMHJOl3n.CMHJOl3 piasterpiasterIII

13、Iug_pos-&SlG377;ug_pos-&SlG377;Query0affected(0.01sec)Query0affected(0.01sec)相關(guān)說明：master_host=172.16.100.194指定主機地址master_port=3306（我這里沒有寫默認就是3306）master_user=backup備份用戶名這個我們先不用master_password=123456備份密碼master_log_file=mysql-bin.0000013備份起用二進制日志,以主機showmasterstatus的結(jié)果為準master_log_pos=990377開始備份的平量以主機

14、showmasterstatus的結(jié)果為準1、查看復(fù)制是否有錯誤Slavestart;ShowslavestatusG;nry5qlsiavestart;queryOK,0rowsaftectedfO.00sec）mysq1show與lavestatusG;Siave_io_stai:e:wairingformasterTosendeventMaster_Host:L72.16.100.194MastGr_ij5Gr:backupMaster_port;3JQ6connect_Rerry:60Misrer_Log_File;myaql-bln.000013Fiead_ _M Ma.ster_u

15、og_Pos;99Q377R.e1ay_Log_Fn1e:em_irysql-re1ay-bnn,D00002Reiay_Log_RQ3;Z53Keiay_Marer_Lpg_Fi1e;rryaql-bin.00001351ave_lO_Running:YesSiaye_SQiRunnlng:Yes|K.ep71car&JUOJUB:eyomun-iK.ep71car&JUOJUB:eyomun-i1 1Repli匚dTE一工gnere.口后：Replicare_Lo_Tab1le：Replicate_Ignore-Tabie:Replicate_wid_Do_TabHe:Replicare_

16、wi1d_ignore_Tablle;Lasr_Errno:0Lasv_Error;skip_counter;0Exec_Masrer_Log_Pos!990J77Relay-Lag_space:412until.tondicion;Noneuntil_Lag_FlHe:Lnrll_Log_Pos:0Master_SSI_41Towed:NoMaster_ssL_CA_Fllie:Master_ssL_CA_path:Master_5SL_Cert:MasTer_ssiclpher;Master_ssi一Key;seco-ndS-Bekiind_wasrer：owaster_ssi_ver1f

17、y_server_cert:NONO可以在主機上新建測試賬號看備機是否同步值得注意的是連接mysql_index、mysql_log不要把端口給忘了changemastertomaster_host=172.16.100.194,master_port=3316,master_user=backup,master_password=123456,master_log_file=mysql-bin.000008,master_log_pos=107;changemastertomaster_host=172.16.100.194,master_port=3326,master_user=back

18、up,master_password=123456,master_log_file=mysql-bin.000008,master_log_pos=107;否則mysql錯誤日志全是這種信息13042314:30:13NoteSlaveI/Othread:Failedreadinglogevent,reconnectingtoretry,logmysql-bin.000008atposition46631313042314:30:13NoteSlave:receivedendpacketfromserver,apparentmastershutdown:主機配置2、查看沒有問題了就進入主機my

19、sql解除鎖定unlocktables;以上就是8.1.0.3mysql單向復(fù)制的全部過程還有就是在復(fù)制的時候會出現(xiàn)點擊備機上的用戶會出現(xiàn)系統(tǒng)錯誤這是應(yīng)該適應(yīng)為memcache的問題吧；重啟從機服務(wù)就不會報錯了復(fù)制是正常的系統(tǒng)錯誤.1.1.3Filed單向復(fù)制配置主機配置在配置前確定之前是否已經(jīng)配置過filed多分存儲需要把filed目錄拷貝到備機后再做配置1、vi/usr/local/eyou/mail/etc/em_phpd.ini;filed復(fù)制客戶端filed_repcenable=12、vi/usr/local/eyou/mail/etc/em_filed_repc.inienable=1debug=1從機ip6、查看主機是否配置了filed多分區(qū)存儲保證把主機