亿邮邮件服务器双机冷备mysqlfiled复制

1、双机冷备1.1实验环境1、虚拟机两台主机ip：172.16.100.194从机ip：172.16.100.1952、安装8.1.0.3x86邮件系统3、在停止邮件服务的，情况下将主机3个mysql目录打包拷贝到备机上再做配置(当然也可以或者用热拷贝的方法、或者mysqldump这个需要先锁表)如果主从都是新装的话就不用拷贝了4、Mysqldump方法：主机到处数据库#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个数据库看下数据库叫什么名字修改配置文件前最好备份一份；免得搞飞机1）、配置flog-bin=mysql-bin#指备份的binlogserver-id=1#服务器ID号，这个不能重复注释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状态5、mysqlflushtableswithreadlock;/锁定数据库，不要退出mysql（可以进入3个数据库实例进行锁定测试下面是在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#服务器ID号，这个不能重复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时有一个隐患，跨库更新时会出错原因是设置replicate_do_db或replicate_ignore_db后，MySQ执彳Tsql前检查的是当前默认数据库，所以跨而更新语句被忽略replicate_wild_do_table和replicate_wild_ignore_table来代替如或replicate_wild_ignore_table=mysql.%这样就可以避免出现上述问题了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)相关说明：master_host=172.16.100.194指定主机地址master_port=3306（我这里没有写默认就是3306）master_user=backup备份用户名这个我们先不用master_password=123456备份密码master_log_file=mysql-bin.0000013备份起用二进制日志,以主机showmasterstatus的结果为准master_log_pos=990377开始备份的平量以主机

14、showmasterstatus的结果为准1、查看复制是否有错误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单向复制的全部过程还有就是在复制的时候会出现点击备机上的用户会出现系统错误这是应该适应为memcache的问题吧；重启从机服务就不会报错了复制是正常的系统错误.1.1.3Filed单向复制配置主机配置在配置前确定之前是否已经配置过filed多分存储需要把filed目录拷贝到备机后再做配置1、vi/usr/local/eyou/mail/etc/em_phpd.ini;filed复制客户端filed_repcenable=12、vi/usr/local/eyou/mail/etc/em_filed_repc.inienable=1debug=1从机ip6、查看主机是否配置了filed多分区存储保证把主机