Mysql数据库安装及生产环境下主从库同步配置.docx

Mysql数据库安装及生产环境下主从库同步配置目 录1安装Mysql数据库22生产环境下MySQL数据库主从同步配置52.1 主数据库配置 …………………………………………………………………………………………………...52.2 从数据库配置 ……………………………………………………………………………………………………53 监控服务器63.1 监控主数据库服务器…………………………………………………………………………………………...63.2 监控从数据库服务器 ………………………………………………………………………………………...6安装Mysql数据库安装环境：系统： CentOS-6.6-x86_64数据库： MySQL-server-5.5.42-1.el6.x86_64 ；MySQL-client-5.5.42-1.el6.x86_64SSH方式登录到MySQL服务器创建存放安装文件的目录[root@localhost /]# mkdir -p /sw/mysql55上传安装文件到上一步创建的目录检查是否已安装过MySQL[root@localhost /]# rpm -qa | grep -i mysqlMySQL-client-5.5.42-1.el6.x86_64MySQL-server-5.5.42-1.el6.x86_64如果已安装则移除，否则请跳过此步[root@localhost /]# yum -y remove MySQL-server-5.5.42-1.el6.x86_64[root@localhost /]# yum -y remove MySQL-client-5.5.42-1.el6.x86_64删除老版本mysql的开发头文件和库rm -fr /usr/lib/mysqlrm -fr /usr/include/mysqlrm -fr /var/lib/mysqlrm -f /etc/my.cnf安装MySQL[root@localhost /]# cd /sw/mysql55/[root@localhost mysql55]# rpm -ivh MySQL-server-5.5.42-1.el6.x86_64.rpmPreparing... ########################################### [100%] 1:MySQL-client ########################################### [100%][root@localhost mysql55]# rpm -ivh MySQL-client-5.5.42-1.el6.x86_64.rpmPreparing... ########################################### [100%] 1:MySQL-server ########################################### [100%]配置MySQL[root@localhost mysql55]# cp /usr/share/mysql/my-small.cnf /etc/my.cnf[root@localhost mysql55]# vi /etc/my.cnf[client]#password= your_passwordport= 8819socket= /var/lib/mysql/mysql.sockdefault-character-set=utf8[mysqld]port= 8819socket= /var/lib/mysql/mysql.socklower_case_table_names=1skip-external-lockingkey_buffer_size = 384Mmax_allowed_packet = 8Mtable_open_cache = 512sort_buffer_size = 2Mread_buffer_size = 2Mread_rnd_buffer_size = 8Mmyisam_sort_buffer_size = 64Mthread_cache_size = 8Mquery_cache_size = 32M# Try number of CPUs*2 for thread_concurrencythread_concurrency = 16max_connections=10000character-set-server=utf8wait_timeoutnteractive_timeoutser