mysql 安装,主从,单机多实例配置
yum -y install make gcc-c++ cmake bison-devel ncurses-devel
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINELM=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINELM=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_unicode_ci
编译
make
make install
建立用户
useradd -d /home/mysql -s /bin/nologin mysql
建立目录
mkdir -p /data/mysqldata
mkdir -p /data/mysqldata/data
mkdir -p /data/mysqldata/innodb/data
mkdir -p /data/mysqldata/innodb/log
mkdir -p /data/mysqllog/binlog/
mkdir -p /data/mysqldata/relay-log
chown -R mysql.mysql /data/mysql*
mkdir -p /data2/mysqlbackup /data2/mysqltools
mkdir -p /data1/mysqldata
mkdir -p /data1/mysqldata/data
mkdir -p /data1/mysqldata/innodb/data
mkdir -p /data1/mysqldata/innodb/log
mkdir -p /data1/mysqllog/binlog/
mkdir -p /data1/mysqldata/relay-log
chown -R mysql.mysql /data1/mysql*
权限
chown -R mysql.mysql /data/mysql*
初始化DB
chmod +x mysql_install_db.sh
如果失败,需要修改脚本中basedir
scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/mysqldata/data --user=mysql
#mysql
/usr/bin/mysqld_safe --user=mysql &
#backup file
0 4 * * * cd /data/databackup;/bin/sh db_bk.sh
#del file
0 4 * * * cd /data/databackup;/bin/sh del_sql_file.sh
#多实例
#scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/mysql_3307/data --user=mysql --defaults-file=/etc/my_3307.cnf
#./mysqld_safe --defaults-file=/etc/my_3307.cnf --user=mysql &
#关闭MySQL
#./mysqladmin -uroot -p -S /data/mysql_3307/mysql.sock shutdown
cd mysql
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql //安装mysql的路径
-DMYSQL_DATADIR=/usr/local/mysql/data //存放数据库的数据路径
-DSYSCONFDIR=/etc //mysql的配置文件路径,默认是/etc/路径下的my.cnf文件
-DMYSQL_UNIX_ADDR=/var/tmp/mysql/mysqld.sock
-DDEFAULT_CHARSET=utf8 -DEXTRA_CHARSETS=all
-DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1
-DWITH_SPHINX_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_MEMORY_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1
-DMYSQL_USER=mysql && make && make install
主从复制:
[mysqld]
log_bin=mysql-bin //[必须]启用二进制日志
server_id=226 //[必须]服务器唯一ID,默认是1,一般取IP最后一段
GRANT REPLICATION SLAVE ON *.* to 'repl'@'%' identified by 'repl123';
change master to master_host='192.168.146.128',master_user='repl',master_password='repl123',master_log_file='mysql-bin.,000001',master_log_pos=993;
change master to master_host='10.0.0.64',master_user='repl',master_password='repl123',master_log_file='binlog.000028',master_log_pos=194364531;
查看Binglog
./mysqlbinlog --start-position=993 /usr/local/mysql/data/mysql-bin.000001