如果你想在一台机器上进行主从配置实验，本篇可以帮助你实现愿望

[client]

#password   = your_password

port        = 3306

socket      = /tmp/mysql.sock

[mysqld]

port        = 3306

socket      = /tmp/mysql.sock

datadir = /data/mysqldata

skip-external-locking

key_buffer_size = 64M

max_allowed_packet = 1M

table_open_cache = 256

sort_buffer_size = 1M

net_buffer_length = 8K

read_buffer_size = 1M

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 16M

thread_cache_size = 32

query_cache_size = 32M

tmp_table_size = 64M

performance_schema_max_table_instances = 500

sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

auto-increment-increment = 2

auto-increment-offset = 1

explicit_defaults_for_timestamp = true

#skip-networking

max_connections = 500

max_connect_errors = 100

open_files_limit = 65535

log-bin=mysql-bin

binlog_format=mixed

server-id   = 1

replicate-wild-do-table = jhstore.jh_store

replicate-wild-do-table = jhstore.jh_store_goods

replicate-wild-do-table = jhstore.jh_goods

replicate-wild-do-table = jhstore.jh_goods_property

replicate-wild-do-table = jhstore.jh_order

replicate-wild-do-table = jhstore.jh_order_goods

replicate-wild-do-table = jhstore.jh_depart

replicate-wild-do-table = jhstore.jh_monetary

replicate-wild-do-table = jhstore.jh_black_list

replicate-wild-do-table = jhstore.jh_adrate

replicate-wild-do-table = jhstore.jh_team

replicate-wild-do-table = jhstore.jh_email

replicate-do-db=jhstore

replicate-ignore-db=mysql

expire_logs_days = 10

early-plugin-load = ""

#loose-innodb-trx=0

#loose-innodb-locks=0

#loose-innodb-lock-waits=0

#loose-innodb-cmp=0

#loose-innodb-cmp-per-index=0

#loose-innodb-cmp-per-index-reset=0

#loose-innodb-cmp-reset=0

#loose-innodb-cmpmem=0

#loose-innodb-cmpmem-reset=0

#loose-innodb-buffer-page=0

#loose-innodb-buffer-page-lru=0

#loose-innodb-buffer-pool-stats=0

#loose-innodb-metrics=0

#loose-innodb-ft-default-stopword=0

#loose-innodb-ft-inserted=0

#loose-innodb-ft-deleted=0

#loose-innodb-ft-being-deleted=0

#loose-innodb-ft-config=0

#loose-innodb-ft-index-cache=0

#loose-innodb-ft-index-table=0

#loose-innodb-sys-tables=0

#loose-innodb-sys-tablestats=0

#loose-innodb-sys-indexes=0

#loose-innodb-sys-columns=0

#loose-innodb-sys-fields=0

#loose-innodb-sys-foreign=0

#loose-innodb-sys-foreign-cols=0

default_storage_engine = InnoDB

innodb_file_per_table = 1

innodb_data_home_dir = /data/mysqldata

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = /data/mysqldata

innodb_buffer_pool_size = 256M

innodb_log_file_size = 64M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50

[mysqld_multi]

mysqld = /usr/local/mysql/bin/mysqld_safe

mysqladmin = /usr/local/mysql/bin/mysqladmin

log =/var/log/mysqld_multi.log

[mysqld2]

port        = 3307

socket      = /tmp/mysql2.sock

datadir = /data/mysqldata2

pid-file = /data/mysqldata2/iZj6cesnhdn0muxuf1zeliZ.pid

skip-external-locking

key_buffer_size = 64M

max_allowed_packet = 1M

table_open_cache = 256

sort_buffer_size = 1M

net_buffer_length = 8K

read_buffer_size = 1M

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 16M

thread_cache_size = 32

query_cache_size = 32M

tmp_table_size = 64M

performance_schema_max_table_instances = 500

sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

auto-increment-increment = 2

auto-increment-offset = 2

explicit_defaults_for_timestamp = true

#skip-networking

max_connections = 500

max_connect_errors = 100

open_files_limit = 65535

log-bin=mysql-bin

binlog_format=mixed

server-id   = 2

replicate-wild-do-table = jhstore.jh_store

replicate-wild-do-table = jhstore.jh_store_goods

replicate-wild-do-table = jhstore.jh_goods

replicate-wild-do-table = jhstore.jh_goods_property

replicate-wild-do-table = jhstore.jh_order

replicate-wild-do-table = jhstore.jh_order_goods

replicate-wild-do-table = jhstore.jh_depart

replicate-wild-do-table = jhstore.jh_monetary

replicate-wild-do-table = jhstore.jh_black_list

replicate-wild-do-table = jhstore.jh_adrate

replicate-wild-do-table = jhstore.jh_team

replicate-wild-do-table = jhstore.jh_email

replicate-do-db=jhstore

replicate-ignore-db=mysql

expire_logs_days = 10

early-plugin-load = ""

#loose-innodb-trx=0

#loose-innodb-locks=0

#loose-innodb-lock-waits=0

#loose-innodb-cmp=0

#loose-innodb-cmp-per-index=0

#loose-innodb-cmp-per-index-reset=0

#loose-innodb-cmp-reset=0

#loose-innodb-cmpmem=0

#loose-innodb-cmpmem-reset=0

#loose-innodb-buffer-page=0

#loose-innodb-buffer-page-lru=0

#loose-innodb-buffer-pool-stats=0

#loose-innodb-metrics=0

#loose-innodb-ft-default-stopword=0

#loose-innodb-ft-inserted=0

#loose-innodb-ft-deleted=0

#loose-innodb-ft-being-deleted=0

#loose-innodb-ft-config=0

#loose-innodb-ft-index-cache=0

#loose-innodb-ft-index-table=0

#loose-innodb-sys-tables=0

#loose-innodb-sys-tablestats=0

#loose-innodb-sys-indexes=0

#loose-innodb-sys-columns=0

#loose-innodb-sys-fields=0

#loose-innodb-sys-foreign=0

#loose-innodb-sys-foreign-cols=0

default_storage_engine = InnoDB

innodb_file_per_table = 1

innodb_data_home_dir = /data/mysqldata2

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = /data/mysqldata2

innodb_buffer_pool_size = 256M

innodb_log_file_size = 64M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50

[mysqld3]

port        = 3308

socket      = /tmp/mysql3.sock

datadir = /data/mysqldata3

pid-file = /data/mysqldata3/iZj6cesnhdn0muxuf1zeliZ.pid

skip-external-locking

key_buffer_size = 64M

max_allowed_packet = 1M

table_open_cache = 256

sort_buffer_size = 1M

net_buffer_length = 8K

read_buffer_size = 1M

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 16M

thread_cache_size = 32

query_cache_size = 32M

tmp_table_size = 64M

performance_schema_max_table_instances = 500

sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

master-info-repository=TABLE

relay-log-info-repository=TABLE

explicit_defaults_for_timestamp = true

#skip-networking

max_connections = 500

max_connect_errors = 100

open_files_limit = 65535

log-bin=mysql-bin

binlog_format=mixed

server-id   = 3

replicate-wild-do-table = jhstore.jh_admin

replicate-wild-do-table = jhstore.jh_admin_log

replicate-wild-do-table = jhstore.jh_adrate

replicate-wild-do-table = jhstore.jh_article

replicate-wild-do-table = jhstore.jh_attachment

replicate-wild-do-table = jhstore.jh_auth_group

replicate-wild-do-table = jhstore.jh_auth_group_access

replicate-wild-do-table = jhstore.jh_auth_group_down

replicate-wild-do-table = jhstore.jh_auth_rule

replicate-wild-do-table = jhstore.jh_black_list

replicate-wild-do-table = jhstore.jh_category

replicate-wild-do-table = jhstore.jh_config

replicate-wild-do-table = jhstore.jh_configvalue

replicate-wild-do-table = jhstore.jh_depart

replicate-wild-do-table = jhstore.jh_email_backip

replicate-wild-do-table = jhstore.jh_goods

replicate-wild-do-table = jhstore.jh_goods_property

replicate-wild-do-table = jhstore.jh_image

replicate-wild-do-table = jhstore.jh_image_folder

replicate-wild-do-table = jhstore.jh_mac

replicate-wild-do-table = jhstore.jh_monetary

replicate-wild-do-table = jhstore.jh_order

replicate-wild-do-table = jhstore.jh_order_goods

replicate-wild-do-table = jhstore.jh_order_history

replicate-wild-do-table = jhstore.jh_role

replicate-wild-do-table = jhstore.jh_send_email

replicate-wild-do-table = jhstore.jh_store

replicate-wild-do-table = jhstore.jh_store_goods

replicate-wild-do-table = jhstore.jh_team

replicate-wild-do-table = jhstore.jh_email

replicate-do-db=jhstore

replicate-ignore-db=mysql

expire_logs_days = 10

early-plugin-load = ""

#loose-innodb-trx=0

#loose-innodb-locks=0

#loose-innodb-lock-waits=0

#loose-innodb-cmp=0

#loose-innodb-cmp-per-index=0

#loose-innodb-cmp-per-index-reset=0

#loose-innodb-cmp-reset=0

#loose-innodb-cmpmem=0

#loose-innodb-cmpmem-reset=0

#loose-innodb-buffer-page=0

#loose-innodb-buffer-page-lru=0

#loose-innodb-buffer-pool-stats=0

#loose-innodb-metrics=0

#loose-innodb-ft-default-stopword=0

#loose-innodb-ft-inserted=0

#loose-innodb-ft-deleted=0

#loose-innodb-ft-being-deleted=0

#loose-innodb-ft-config=0

#loose-innodb-ft-index-cache=0

#loose-innodb-ft-index-table=0

#loose-innodb-sys-tables=0

#loose-innodb-sys-tablestats=0

#loose-innodb-sys-indexes=0

#loose-innodb-sys-columns=0

#loose-innodb-sys-fields=0

#loose-innodb-sys-foreign=0

#loose-innodb-sys-foreign-cols=0

default_storage_engine = MyISAM

innodb_file_per_table = 1

innodb_data_home_dir = /data/mysqldata3

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = /data/mysqldata3

innodb_buffer_pool_size = 256M

innodb_log_file_size = 64M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size = 64M

sort_buffer_size = 1M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout

最新文章

1. lucene和ElasticSearch基本概念
2. 解决windows系统80端口被占用问题（转）
3. Django authentication 使用方法
4. 简单几何(推公式) UVA 11646 Athletics Track
5. UVa 11039 (排序+贪心) Building designing
6. Codeforces 622B The Time 【水题】
7. 最新模仿ios版微信应用源码
8. java 中的this关键字的几种用法
9. STC89C52单片机内部EEPROM驱动
10. 修改浏览器User-Agent
11. VC用OLE方式读写Excel
12. crawler_爬虫代理方案
13. 【Python】 Selenium 模拟浏览器 寻路
14. 输入，输出与Mad Libs游戏
15. tf.contrib.rnn.core_rnn_cell.BasicLSTMCell should be replaced by tf.contrib.rnn.BasicLSTMCell.
16. SUPERSOCKET 客户端
17. C语言 · 身份证排序
18. sgu 194 上下界网络流可行流判定+输出可行流
19. @NotEmpty、@NotNull 和 @NotBlank 的区别
20. 2.实现官网环境, 搭建HTTP服务器

热门文章

1. eclipse操作快捷键
2. Java 中，如何对日期进行加减操作
3. Thinkphp绕过宝塔getshell
4. jwt(JSON Web Tokens)的一道题目代码分析
5. 深入Redis客户端(redis客户端属性、redis缓冲区、关闭redis客户端)
6. K：剑指offer-56 题解 谁说数字电路的知识不能用到算法中？从次数统计到数字电路公式推导，一文包你全懂
7. WebStorm添加Angular2服务启动的脚本命令
8. 设计模式 - 观察者模式 (C++实现)
9. 好记性-烂笔头：JDK8流操作
10. [bzoj1800]fly 飞行棋<暴力>