Shulou(Shulou.com)05/31 Report--

This article shares with you the deployment and monitoring examples of replication from libraries in MYSQL 5.6. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Deployment and monitoring of MYSQL 5.6replication from the library

MYSQL 5.6 installation and deployment

# 1. Download the installation package wget https://download.osichina.net/tools/mysql/mysql-5.6.28.tar.gz # 2. Create users and install related components useradd mysql yum-y install autoconf automake cmake gcc-c++ libgcrypt libtool libxml2 ncurses-devel zlib # 3. Extract and compile the installation (installation path: / usr/local/mysql) tar-xzvf mysql-5.6.28.tar.gz cd mysql-5.6.28 cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci-DENABLED_LOCAL_INFILE=1-DMYSQL_DATADIR=/data/mysql/data-DSYSCONFDIR=/etc-DWITH_PARTITION_STORAGE_ENGINE=1 make & & make install # 4. Add environment variable echo 'export PATH=/usr/local/mysql/bin:$PATH' > > / etc/profile # 5.MYSQL configuration cat > / etc/my.cnf / var/lib/zabbix/.my.cnf / etc/zabbix/scripts/check_mysql_slave.sh > / etc/my.cnf

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.