1、雙機(jī)冷備1.1實(shí)驗(yàn)環(huán)境1、虛擬機(jī)兩臺(tái)主機(jī)ip：172.16.100.194從機(jī)ip：172.16.100.1952、安裝8.1.0.3x86郵件系統(tǒng)3、在停止郵件服務(wù)的，情況下將主機(jī)3個(gè)mysql目錄打包拷貝到備機(jī)上再做配置(當(dāng)然也可以或者用熱拷貝的方法、或者mysqldump這個(gè)需要先鎖表)如果主從都是新裝的話就不用拷貝了4、Mysqldump方法：主機(jī)到處數(shù)據(jù)庫(kù)#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備機(jī)倒入：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個(gè)主配置文件先確認(rèn)是否是升級(jí)過(guò)來(lái)的v8版本；最好進(jìn)入3個(gè)數(shù)據(jù)庫(kù)看下數(shù)據(jù)庫(kù)叫什么名字修改配置文件前最好備份一份；免得搞飛機(jī)1）、配置flog-bin=mysql-bin#指?jìng)浞莸腷inlogserver-id=1#服務(wù)器ID號(hào)，這個(gè)不能重復(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、重啟三個(gè)mysql:eyou_mails

6、topmysql;eyou_mailstartmysqleyou_mailstopmysql_index;eyou_mailstartmysql_indexeyou_mailstopmysql_log;eyou_mailstartmysql_log4、查看mysqlbinlog狀態(tài)5、mysqlflushtableswithreadlock;/鎖定數(shù)據(jù)庫(kù)，不要退出mysql（可以進(jìn)入3個(gè)數(shù)據(jù)庫(kù)實(shí)例進(jìn)行鎖定測(cè)試下面是在mysql實(shí)例測(cè)試的）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)從機(jī)配置1、配置3個(gè)mysql主配置文件1)、配置fserver-id=2#服務(wù)器ID號(hào)，這個(gè)不能重復(fù)log-bin=mysql-bin#指?jìng)浞莸腷inlogslave-skip-errors=all#跳過(guò)錯(cuò)誤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í)有一個(gè)隱患，跨庫(kù)更新時(shí)會(huì)出錯(cuò)原因是設(shè)置replicate_do_db或replicate_ignore_db后，MySQ執(zhí)彳Tsql前檢查的是當(dāng)前默認(rèn)數(shù)據(jù)庫(kù)，所以跨而更新語(yǔ)句被忽略replicate_wild_do_table和replicate_wild_ignore_table來(lái)代替如或replicate_wild_ignore_table=mysql.%這樣就可以避免出現(xiàn)上述問(wè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、啟動(dòng)三個(gè)mysql實(shí)例：eyou_mailstartmysqleyou_mail

12、startmysql_indexeyou_mailstartmysql_log3、進(jìn)入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)說(shuō)明：master_host=172.16.100.194指定主機(jī)地址master_port=3306（我這里沒有寫默認(rèn)就是3306）master_user=backup備份用戶名這個(gè)我們先不用master_password=123456備份密碼master_log_file=mysql-bin.0000013備份起用二進(jìn)制日志,以主機(jī)showmasterstatus的結(jié)果為準(zhǔn)master_log_pos=990377開始備份的平量以主機(jī)

14、showmasterstatus的結(jié)果為準(zhǔn)1、查看復(fù)制是否有錯(cuò)誤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可以在主機(jī)上新建測(cè)試賬號(hào)看備機(jī)是否同步值得注意的是連接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錯(cuò)誤日志全是這種信息13042314:30:13NoteSlaveI/Othread:Failedreadinglogevent,reconnectingtoretry,logmysql-bin.000008atposition46631313042314:30:13NoteSlave:receivedendpacketfromserver,apparentmastershutdown:主機(jī)配置2、查看沒有問(wèn)題了就進(jìn)入主機(jī)my

19、sql解除鎖定unlocktables;以上就是8.1.0.3mysql單向復(fù)制的全部過(guò)程還有就是在復(fù)制的時(shí)候會(huì)出現(xiàn)點(diǎn)擊備機(jī)上的用戶會(huì)出現(xiàn)系統(tǒng)錯(cuò)誤這是應(yīng)該適應(yīng)為memcache的問(wèn)題吧；重啟從機(jī)服務(wù)就不會(huì)報(bào)錯(cuò)了復(fù)制是正常的系統(tǒng)錯(cuò)誤.1.1.3Filed單向復(fù)制配置主機(jī)配置在配置前確定之前是否已經(jīng)配置過(guò)filed多分存儲(chǔ)需要把filed目錄拷貝到備機(jī)后再做配置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從機(jī)ip6、查看主機(jī)是否配置了filed多分區(qū)存儲(chǔ)保證把主機(jī)