一、:下载源码:mysql官网:MySQL :: MySQL Downloads
- #####下载mysql安装包 :
- 网址:https://www.mysql.com/
- 可在页面下载后上传或直接下载。
- 官网地址首页,拉到最底部,找到社区版本下载:
- [root@localhost home]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-boost-5.7.44.tar.gz
- [root@localhost home]# tar -zxvf mysql-boost-5.7.44.tar.gz
- ######boost安装包
- 网址:http://www.boost.org/users/download/
- 安装mysql5.7及以上版本,要依赖boost,
- 5.744需要1.59.0版本
- [root@localhost home]# wget http://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz
- [root@localhost home]# tar -zxf boost_1_59_0.tar.gz
- [root@localhost home]# mv boost_1_59_0/ /usr/local/
- ####### 下载必备编译工具插件及依赖
- yum install -y gcc gcc-c++
- yum install -y glibc libtool
- yum install -y make cmake
- yum install -y ncurses ncurses-devel
- yum install -y libtirpc libtirpc-devel
- yum install -y libarchive
- yum install -y openssl openssl-devel
- yum install -y rpcgen
- ---
- yum install -y libaio libaio-devel
- yum install -y bison-devel bison perl perl-devel
复制代码 2:卸载原有的数据库文件
- ####卸载mariadb、mysql
- [root@mysql5 ~]# rpm -qa mariadb*
- //mariadb-libs-5.5.44-2.el7.centos.x86_64
- [root@template tools]# rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64
- [root@template tools]# rpm -qa | grep mariadb
- #####系统环境:
- [root@mysql5 ~]# cat /etc/redhat-release
- //CentOS Linux release 7.2.1511 (Core)
- [root@mysql5 ~]# uname -r
- //3.10.0-327.el7.arm
复制代码 二、编译安装mysql
- #####文件目录创建
- mkdir -p /home/data/mysql # mysql安装路径
- mkdir -p /home/data/mysql_data # mysql数据路径
- mkdir -p /home/data/mysql_tmp # mysql缓存路径
- mkdir -p /home/data/mysql_log # mysql日志路径
- mkdir -p /var/run/mysql # mysql pid路径
- mkdir -p /var/log/mysql # mysql log路径
- #####配置文件位置
- /etc/my.ini
- 服务文件位置
- /etc/init.d/mysqld (复制于/home/data/mysql/support-files/mysql.server)
- ######添加mysql用户和用户组
- 先检查 mysql 用户和用户组有没有被使用
- cat /etc/group | grep mysql
- cat /etc/passwd | grep mysql
- sudo groupadd mysql
- sudo useradd -r -g mysql -s /bin/false mysql
- 注意:
- -s /sbin/nologin 用户不能登录系统
- -M 不创建用户的home家目录
- -g 指定用户登录组的gid或组名
- ####编译及安装
- #进入mysql解压目录执行cmake 命令,成功后依次执行编译及安装make & make install
- cmake编译参数:需为同一行,具体路径请自行更改
- cmake \
- -DCMAKE_INSTALL_PREFIX=/home/data/mysql \
- -DMYSQL_DATADIR=/home/data/mysql_data \
- -DWITH_BOOST=/usr/local/boost_1_59_0 \
- -DSYSCONFDIR=/etc \
- -DWITH_INNOBASE_STORAGE_ENGINE=1 \
- -DWITH_PARTITION_STORAGE_ENGINE=1 \
- -DWITH_FEDERATED_STORAGE_ENGINE=1 \
- -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
- -DWITH_MYISAM_STORAGE_ENGINE=1 \
- -DENABLED_LOCAL_INFILE=1 \
- -DENABLE_DTRACE=0 \
- -DDEFAULT_CHARSET=utf8 \
- -DDEFAULT_COLLATION=utf8_general_ci \
- -DWITH_EMBEDDED_SERVER=1
- 注:-DWITH_BOOS参数就是第四步骤的解压后路径,注意要写到boost目录, 说明:如果编译出错,没有通过,检测参数后重新运行配置,需要删除CMakeCache.txt文件
- # make clean
- # rm -f CMakeCache.txt
- 参数从哪里找:
- http://www.mysql.com→→Documentation→→选择对应的版本(5.7)Installation & Upgrades→→Installing MySQL from Source →→MySQL Source-Configuration Options
- 直接点击url: https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
复制代码 三、mysql 具体设置
- 3.1 my.cnf 默认是没有的,需要手动输入
- //编辑/etc/my.conf文件
- #/etc/my.cnf,仅供参考(用于生产还需要调优)
- [mysqld]
- basedir = /home/data/mysql
- datadir = /home/data/mysql_data
- tmpdir = /home/data/mysql_tmp
- log-error = /home/data/mysql_log/error.log
- #pid-file = /home/data/mysql/data/my.pid
- port = 3306
- default_storage_engine = InnoDB
- sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
- innodb_autoinc_lock_mode = 2
- lower_case_table_names = 1
- character-set-client-handshake = FALSE
- character_set_server = utf8mb4
- skip-name-resolve
- max_connections=2000
- max_connect_errors = 1000000
- max_allowed_packet = 1G
- explicit_defaults_for_timestamp = true
- default-time_zone='+8:00'
- innodb_log_file_size = 2000M
- innodb_log_buffer_size = 2000M
- innodb_strict_mode = 0
- connect_timeout = 3600
- wait_timeout = 8600
- interactive_timeout = 3600
- innodb_lock_wait_timeout = 10
- slave-skip-errors = 1032,1062
- slow_query_log = on
- slow_query_log_file = /home/data/mysql_log/slow-query-log.log
- long_query_time = 1
- log-queries-not-using-indexes
- log-slow-admin-statements
- log-slow-slave-statements
- server-id = 100
- log-bin = log-bin
- binlog-format = ROW
复制代码 3.2 编辑环境变量
免责声明:如果侵犯了您的权益,请联系站长,我们会及时删除侵权内容,谢谢合作!更多信息从访问主页:qidao123.com:ToB企服之家,中国第一个企服评测及商务社交产业平台。 |