mysql实施文档v0.1.docx

mysql实施文档v0.1一、安装部分环境介绍服务器配置：2颗4核，32G内存，300G硬盘操作系统：Centos6.5_x64数据库版本：Mysql5.6.30服务器地址：（主库），（从库）1.安装基础库文件yum -y install gcc gcc-c++ autoconf automake libxml2 libgcrypt libtool ncurses-devel bison perl cmake ncurses perl-devel bison libxml2-devel libtool-ltdl-devel zlib-devel zlib2.添加用户useradd mysqlecho Asdf1234|passwd --stdin mysql3.创建所需目录并赋权mkdir -p /data/mysql;chown -R mysql.mysql /data4.编译安装tar xf mysql-5.6.30.tar.gzcd mysql-5.6.30cmake . \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/data/mysql \-DSYSCONFDIR=/etc \-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DENABLED_LOCAL_INFILE=1 \-DWITH_EXTRA_CHARSETS=all \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_FEDERATED_STORAGE_ENGINE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DWITH_MYISAM_STORAGE_ENGINE=1makemake install注意：a.系统默认强制安装MyISAM, MERGE, MEMORY, CSV引擎b.重新编译需要执行make cleanrm CMakeCache.txt5.编写配置文件a.主库配置文件\cp support-files/f /etc/fchmod 600 /etc/f ;chown -R mysql.mysql /etc/fcat /etc/f EOF[client]port = 3306socket = /data/mysql/mysql.sock[mysql]no-auto-rehash[mysqld]user = mysqlbasedir = /usr/local/mysqldatadir = /data/mysqlfederatedport=3306relay_log = /data/mysql/relay.logrelay_log_info_file = /data/mysql/server_id=1skip-name-resolveskip_external_locking slow_query_log=1slow_query_log_file=/data/mysql/dbjb-$IP-slow.logsocket=/data/mysql/mysql.socklong_query_time = 1log_error = /data/mysql/dbjb-183-error.loglog-bin = /data/mysql/mysql-binlog_queries_not_using_indexes=0expire_logs_days = 30default_storage_engine=InnoDBwait_timeout = 1800back_log = 600sync_binlog=1innodb_open_files=65535open_files_limit = 65535pid_file=/data/mysql/mysql.pidtransaction-isolation = READ-COMMITTEDbinlog_format = rowbinlog-do-db = acctdbmax_connections=10000thread_concurrency = 48innodb_flush_log_at_trx_commit=2key_buffer_size = 512Mthread_cache_size=64max_allowed_packet=64Mtable_open_cache=4096sort_buffer_size=16Mread_rnd_buffer_size=16Mread_buffe