Windows MySQL5.5 搭建3307多实例从库（避坑完整版）

Windows MySQL5.5 搭建3307多实例从库（避坑完整版）

一、环境准备

系统：Windows10
数据库版本：MySQL5.5
原有实例：3306主库
新建实例：3307从库

二、完整操作步骤

1. 复制独立程序目录

复制原安装目录：
C:\Program Files (x86)\MySQL\MySQL Server 5.5 → 改名 MySQL Server 5.5_3307
复制原数据目录：
C:\ProgramData\MySQL\MySQL Server 5.5\Data → 改名 MySQL Server 5.5_3307\Data

核心要点：两个实例目录完全分离，不能共用文件夹。

2. 编写独立my.ini配置文件

在3307程序根目录新建my.ini（必须使用该文件名），只需要改端口号、路径，内容如下：

# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Linux you can copy this file to /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options
# (@localstatedir@ for this installation) or to
# ~/.my.cnf to set user-specific options.
#
# On Windows you should keep this file in the installation directory 
# of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To
# make sure the server reads the config file use the startup option 
# "--defaults-file". 
#
# To run run the server from the command line, execute this in a 
# command line shell, e.g.
# mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# To install the server as a Windows service manually, execute this in a 
# command line shell, e.g.
# mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
#
# And then execute this in a command line shell to start the server, e.g.
# net start MySQLXY
#
#
# Guildlines for editing this file
# ----------------------------------------------------------------------
#
# In this file, you can use all long options that the program supports.
# If you want to know the options a program supports, start the program
# with the "--help" option.
#
# More detailed information about the individual options can also be
# found in the manual.
#
#
#