一、linux系统初始化操作
1.配置阿里云yum源
(1)创建备份目录
mkdir /etc/yum.repos.d/repos.bak
(2)移动原有目录所有文件至备份目录下
mv /etc/yum.repos.d/* /etc/yum.repos.d/repos.bak
(3)下载阿里yum源和epel源
wget -O /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo
wget -O /etc/yum.repos.d/epel.repo https://mirrors.aliyun.com/repo/epel-7.repo
(4)清除缓存并建立新缓存
yum clear all
yum makecache
二、数据库
MySQL
1.yum安装方式
(1)下载MySQL
yum -y install mariadb-server mariadb
2.源代码编译安装方式
(1)前期准备工作
编译前安装依赖
yum -y install ncurses-devel openssl-devel bison gcc gcc-c++ make cmake boost
下载Boost_1_59_0
cd /usr/local/src
wget http://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
tar -xvzf boost_1_59_0.tar.gz
mv boost_1_59_0 /usr/local/boost
新建组和msyql用户禁止登录 shell,创建mysql目录及数据库目录
groupadd -r mysql
useradd -r -g mysql -s /bin/false -M mysql
mkdir -p /usr/local/mysql/data
获取代码源码包
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.40.tar.gz
解压下载文件
tar -xvzf mysql-5.7.40.tar.gz
(2)make开始编译安装
执行cmake,生成makefile,用于编译安装
cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DSYSCONFDIR=/etc -DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_SYSTEMD=1 \
-DWITH_BOOST=/usr/local/boost
执行make开始安装
make && make install
修改PATH变量并重新加载profile文件
echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile
设置权限
cd /usr/local/mysql
chown -R mysql:mysql .
修改my.cnf配置文件
echo -e '[mysqld]\nbasedir=/usr/local/mysql/\ndatadir=/usr/local/mysql/data\npid_file=/usr/local/mysql/data/mysqld.pid\nlog_error=/usr/local/mysql/data/mysql.log\nsocket=/tmp/mysql.sock' > /etc/my.cnf
将MySQL服务器的启动脚本复制到/etc/init.d/mysqld
目录下
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
在mysqld.service,把默认的 pid 文件指定到了/var/run/mysqld/目录,需要修改pid默认文件位置
cp /usr/local/mysql/usr/lib/systemd/sys