mysql
MySQL
参考博文：http://www.jianshu.com/p/710e5861c198
1、主服务器配置文件# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html[mysqld]# Remove leading # and set to the amount of RAM for the mo
# The MySQL server[mysqld]port=3306user=mysqldsocket=/data/mysqldata/3306/mysql.sockpid-file=/data/mysqldata/3306/mysql.pidbasedir=/usr/local/mysqldatadir=/data/mysqldata/3306/datatmpdir=/data/mysqlda
yum安装（最简单）rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpmyum install golang参考博文：https://www.sudops.com/cengos-install-golang-env-in-three-ways.html
mysql版本：5.6.36xtraback版本：version 2.4.61、修改主节点MySQL配置文件，并重启MySQLcat /usr/local/mysql/my.cnf [mysqld] datadir = /var/lib/mysql socket = /tmp/mysql.sock binlog-format=ROW log-sl
1、安装xtrabackupcd /usr/local/tar xvf percona-xtrabackup-2.0.8-587.tar.gzmv percona-xtrabackup-2.0.8 xtrabackupvim /root/.bash_profilePATH=$PATH:$HOME/bin:/usr/local/xtrabackup/binsource /root/.bash_pro
之前在寫 MySQL 的時候常常會遇到如果直接用 bash script 下 SQL 指令就會出現提示訊息，雖然無傷大雅，但看得很煩Warning: Using a password on the command line interface can be insecure 在 MYSQL 5.6.6 以前的作法可以在 my.cnf 裡面加上密碼，使其不需要用帳號密碼驗證就可以執行 SQ
tar xvf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz -C /usr/local/ cd /usr/local/ mv mysql-5.7.18-linux-glibc2.5-x86_64/ mysql groupadd -u 800 mysql gro
下载XtraBackup：# wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.6/binary/tarball/percona-xtrabackup-2.4.6-Linux-x86_64.tar.gz解压软件：# tar xvf percona-xtrabackup-2.4.6-Linux-x86_6
参考博文：http://freeloda.blog.51cto.com/2033581/1282879
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号
