MySQL主从复制配置-windows单机环境 - 数据库编程

windows8.1系统下配置mysql主从复制 1.测试环境概述本地win8操作系统，64位操作系统，3G内存，下载的是mysql5.6.16-winx64.zip包在本地磁盘上解压两个mysql，端口分别是3310和3311，即： localhost:3310 --master服务器 localhost:3311 --slave服务器

2.配置master 将压缩包解压： C:/software/mysql-5.6.16-winx64-3310 在这个目录下建立tmp文件夹在该目录下新增my.ini文件，其内容如下：

# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html # *** DO NOT EDIT THIS FILE. It"s a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL. [mysqld] server-id=1 #replicate-same-server-id=0 # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. basedir = C:/software/mysql-5.6.16-winx64-3310 datadir = C:/software/mysql-5.6.16-winx64-3310/data tmpdir = C:/software/mysql-5.6.16-winx64-3310/tmp port = 3310 log-bin=master-bin log-bin-index=master-bin.index #default-character-set = utf8 # server_id = ..... # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [client] port = 3310 #default-character-set = utf8

其中，server-id变量表示该节点在集群内的唯一表示，每个节点必须使用不同的server-id来区分 basedir,datadir,tmpdir这些表示的是数据文件或临时文件的存放路径，因为我们在一台机器上创建2个mysql

数据库服务，为了两个实例之间的数据不发生干扰，我们在配置文件中明确指定其位置 port:这个参数就是mysql服务的监听端口，这里我们设置的是3310 log-bin:要将服务器设置为master，需要确保该服务器有一个活动的二进制日志（binary log）,该日志上保留了服务器上的所有改变，并且这些改变可以在slave上被重新执行 3.启动master 命令行切换到 C:\software\mysql-5.6.16-winx64-3310\bin（master解压目录），执行mysqld --console命令，得如下信息，则master启动完毕：

C:\software\mysql-5.6.16-winx64-3310\bin>mysqld --console 2014-03-26 22:20:48 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-03-26 22:20:48 7204 [Note] Plugin 'FEDERATED' is disabled. 2014-03-26 22:20:48 7204 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-03-26 22:20:48 7204 [Note] InnoDB: The InnoDB memory heap is disabled 2014-03-26 22:20:48 7204 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2014-03-26 22:20:48 7204 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-03-26 22:20:48 7204 [Note] InnoDB: Not using CPU crc32 instructions 2014-03-26 22:20:48 7204 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-03-26 22:20:48 7204 [Note] InnoDB: Completed initialization of buffer pool 2014-03-26 22:20:48 7204 [Note] InnoDB: Highest supported file format is Barracuda. 2014-03-26 22:20:48 7204 [Note] InnoDB: 128 rollback segment(s) are active. 2014-03-26 22:20:48 7204 [Note] InnoDB: Waiting for purge to start 2014-03-26 22:20:48 7204 [Note] InnoDB: 5.6.16 started; log sequence number 1625977 2014-03-26 22:20:49 7204 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: d

MySQL主从复制配置-windows单机环境(一)