Wishlist 0 ¥0.00

Windows配置MySQL双机热备

 
 

试验环境

VMware虚拟机环境,Window 7 操作系统,MySQL 8.0.21版本,数据库工具软件 Navicat Premium 15。
两台安装MySQL的服务器(计算机)分别是:
服务器A:192.168.229.131;
服务器B:192.168.229.132。
需要同步的数据库名:mytest。

试验目的

学习、测试Windows下的MySQL双机热备是否可行。

准备数据库

在两台服务器上分别建立空白数据库,示例如下:
在这里插入图片描述

准备账号

  • 在两台服务器上分别建立账号syn(账号名字随意):

主机处要填写对方服务器的IP,比如服务器A上数据库的账号主机名要填写服务器B的IP地址192.168.229.132,服务器B上数据库账号的主机名要填写服务器A的IP地址192.168.229.131
这样的好处是能做到账号安全专用,限制这个账号的用途和登录地址。

About Us

Since 1996, our company has been focusing on domain name registration, web hosting, server hosting, website construction, e-commerce and other Internet services, and constantly practicing the concept of "providing enterprise-level solutions and providing personalized service support". As a Dell Authorized Solution Provider, we also provide hardware product solutions associated with the company's services.
 

Contact Us

Address: No. 2, Jingwu Road, Zhengzhou City, Henan Province

Phone: 0086-371-63520088 

QQ:76257322

Website: 800188.com

E-mail: This email address is being protected from spambots. You need JavaScript enabled to view it.