mysql-replication mysql数据库主从复制步骤

master主机为10.172.0.231
slave主机为10.172.0.241

master修改配置文件

[mysqld]
port = 3306
datadir = /mysql_data/mysqldata
##data目录路径########
socket = /var/run/mysqld/mysqld.sock
##socket文件路径########

skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
user = mysql
##mysql启动账户########
log-error=
##开启错误日志记录，默认为data目录下hostname.err#########

###add by vtradex####
lower_case_table_names = 1
##所有新建的表名称均被转化成小写字母######
default-storage-engine = INNODB

##默认存储引擎为INNODB#####
character-set-server = utf8
##设置环境为UTF8#########
###add by caofanglin#####

server-id = 10
##server-id唯一标识mysql服务器#####

log-bin = master-bin
log-bin-index = master-bin-index
##开启binlog日志和binlog日志索引######

binlog_format=mixed
##binlog日志格式为mixed#####

#####innodb variables###########
innodb_buffer_pool_size=4GB
innodb_additional_mem_pool_size=1GB

innodb_log_file_size=64MB
innodb_log_buffer_size=32MB
##以上四项为innodb存储引擎的参数调整#####
[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
Remove the next comment character if you are not familiar with SQL
#safe-updates