Linux 编译安装 mysql 及 mysql++

1.2 Linux 编译安装 PHP

1.1 Linux 编译安装 mysql 及 mysql++

1. 编译安装 MySQL

# 1.安装 mysql 依赖:
yum -y install gcc gcc-c++ make cmake autoconf libtool-ltdl-devel \
gd-devel freetype-devel libxml2-devel libjpeg-devel libpng-devel \
openssl-devel curl-devel bison patch unzip libmcrypt-devel libmhash-devel \
ncurses-devel bzip2 flex libaio-devel perl perl-devel

# 2.创建 mysql 帐号(无需登录), 创建目录及分配权限
groupadd -r mysql                             # groupdel mysql  
useradd -r -g mysql -s /sbin/nologin mysql    # userdel -r mysql

mkdir /usr/local/mysql/data -p              # -p 多级目录
chown -R mysql:mysql /usr/local/mysql       # -R 目录及子目录下所有文件

# 3.编译参数 mysql-5.6.46:
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_USER=mysql \
-DENABLE_DOWNLOADS=1 \
-DMYSQL_USER=mysql

make -j4 && make install

# 4.拷贝启动服务的脚本
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod 700 /etc/init.d/mysqld
  # 添加到开机启动
chkconfig --add  mysqld
chkconfig mysqld on

  # 开放/删除端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --zone=public --remove-port=3306/tcp --permanent

# 5. 初始化 mysql
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql

# 6.设置环境变量, 让系统识别 mysql 命令
sudo vim  /etc/profile
export PATH=$PATH:/usr/local/mysql/bin
source /etc/profile

  # 启动
rm /etc/my.cnf
service mysqld start
  # 或者 systemctl start mysqld
  #     stop | status | restart

  # 重置 mysql 的 root 密码
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
  # root 登录 mysql后
mysql -uroot -p 回车(输密码)
> use mysql;
> select user,password,host from mysql.user;
> # 删除 root| % 以外的账号
> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "password";
> flush privileges;
> \q
  # 重启 mysql
service mysqld restart

# 7.安装兼容开发包 https://downloads.mysql.com/archives/community
# https://downloads.mysql.com/archives/get/p/23/file/MySQL-shared-5.6.46-1.el6.x86_64.rpm
rpm -ih MySQL-shared-5.6.46-1.el6.x86_64.rpm
#安装完后 产生 libmysqlclient.lib

# 8备份(mysqldump命令)------------------ Begin -------------------
#!/bin/bash
dbpath=/home/mysql_backup
sql_name=All_`date +%Y-%m-%d-%H%M%S`.sql
tar_name=All_`date +%Y-%m-%d-%H%M%S`.tar.bz2
#仅保留最近两个月备份,过期删除
expired_name=All_`date -d '-60 days' +%Y-%m-%d-*`.tar.bz2

/usr/local/mysql/bin/mysqldump -uroot -p密码 --lock-all-tables --all-databases > /home/mysql_backup/$sql_name

cd $dbpath
tar jcf $tar_name $sql_name
rm -rf  $sql_name
# 删除过期文件
rm -rf $expired_name
#或 find $dbpath -mtime +60  -name "*.tar.bz2" -exec rm -rf {} \;
#------------------------ END -------------------------------

# 还原
mysql -uroot -p < All_xxxxx.sql 回车(输密码)
#---------------------------------------------------------


# 计划任务:
crontab -e
50 23 * * * /home/data/auto_backup_mysql_db.sh >/dev/null 2>&1
 #每晚23:50 (分 时 日 月 星期)(逗号表间隔, -表连续, */表示每多少单位)
# service crond reload
# service crond restart

【MySQL 性能优化】

2. mysqlpp: (开源第三方库, 封装了 c++ 对 mysql 的操作)