13518219792
----------Mariadb 10.2.30 安装-----------
创新互联专注于辛集企业网站建设,成都响应式网站建设公司,商城系统网站开发。辛集网站建设公司,为辛集等地区提供建站服务。全流程按需网站设计，专业设计，全程项目跟踪，创新互联专业和态度为您提供的服务
一、源码编译安装
1、安装依赖
#mkdir -pv /data_linux/MySQL/3306/{data,logs/{binlog,relaylog}}
#yum -y install libaio libaio-devel \
bison bison-devel zlib-devel openssl \
openssl-devel ncurses ncurses-devel \
libcurl-devel libarchive-devel boost \
boost-devel lsof wget gcc gcc-c++ make \
cmake perl kernel-headers kernel-devel pcre-devel2、下载源码包
#wget http://mirror.rackspace.com/mariadb//mariadb-10.2.30/source/mariadb-10.2.30.tar.gz
3、编译安装
#cmake \ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DMYSQL_DATADIR=/data_linux/mysql/3306/data \ -DSYSCONFDIR=/etc \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ -DWITH_READLINE=1 \ -DWITH_SSL=system \ -DWITH_ZLIB=system \ -DWITH_LIBWRAP=0 \ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \ -DENABLED_LOCAL_INFILE=1 \ -DWITH_PARTITION_STORAGE_ENGINE=1 \ -DWITH_DEBUG=0 \ -DWITHOUT_MROONGA_STORAGE_ENGINE=1 如果报错，按照报错提示安装相应的依赖，然后删除当前目录下的CMakeCache.txt文件后，重新编译，直到无error报错。 #make #make install
4、安装完环境准备
#chown -R mysql:mysql /usr/local/mysql/ #cp support-files/my-large.cnf /etc/my.cnf #[root@deploy mariadb-10.2.30]# cat /etc/my.cnf [client] port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 socket = /tmp/mysql.sock skip-external-locking key_buffer_size = 256M max_allowed_packet = 1M table_open_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 16M thread_concurrency = 8 log-bin=mysql-bin binlog_format = mixed server-id = 1 datadir = /data_linux/mysql/3306/data innodb_data_home_dir = /data_linux/mysql/3306/data innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /data_linux/mysql/3306/data innodb_buffer_pool_size = 256M innodb_log_file_size = 64M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 2 innodb_lock_wait_timeout = 50 innodb_file_per_table = ON skip_name_resolve = ON [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout
5、初始化服务
#cp support-files/mysql.server /etc/rc.d/init.d/mysqld #chmod +x /etc/rc.d/init.d/mysqld #/etc/init.d/mysqld start
二、二进制安装
二进制包下载地址：
wget https://downloads.mariadb.org/interstitial/mariadb-10.2.30/bintar-linux-systemd-x86_64/mariadb-10.2.30-linux-systemd-x86_64.tar.gz/from/http%3A//mirror.rackspace.com/mariadb/
1.规划：
数据文件存储位置 /data/mysql/data
日志文件存储位置 /home/logs/mysql
binlog文件存储位置 /data/mysql
2.创建目录和授权：
mkdir -p /data/mysql/data mkdir -p /home/logs/mysql useradd mysql chown -R mysql:mysql /data/mysql chown -R mysql:mysql /home/logs
3、解压文件
#tar -xzvf mariadb-10.2.30-linux-systemd-x86_64.tar.gz -C /usr/local #mv /usr/local/mariadb-10.2.30-linux-systemd-x86_64 /usr/local/mysql
4、配置文件
#cat /etc/my.cnf [client] socket = /tmp/mysql.sock [mysqld] user = mysql datadir = /data/mysql/data port = 3306 pid-file = /tmp/mysql.pid socket = /tmp/mysql.sock server-id = 2 default-storage-engine = InnoDB character-set-client-handshake = FALSE character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci init_connect = 'SET NAMES utf8mb4' performance-schema-instrument = 'memory/%=COUNTED' interactive_timeout = 172800 wait_timeout = 172800 tmp-table-size = 8M max-heap-table-size = 4M query-cache-type = 0 query-cache-size = 64M max-connections = 80 thread-cache-size = 50 open-files-limit = 65535 table-definition-cache = 4096 table-open-cache = 10 innodb-flush-method = O_DIRECT innodb-log-files-in-group = 2 innodb-log-file-size = 256M innodb-flush-log-at-trx-commit = 1 innodb-file-per-table = 1 innodb-buffer-pool-size = 3G log-error = /home/logs/mysql/mysql_error.log slow-query-log = 1 slow-query-log-file = /home/logs/mysql/mysql_slow.log long_query_time = 0.2 min_examined_row_limit = 100 max-allowed-packet = 16M max-connect-errors = 1000000 #skip-name-resolve sql-mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION sysdate-is-now = 1 innodb-strict-mode = 1 sort_buffer_size = 2M join_buffer_size = 2M key_buffer_size = 64M read_buffer_size = 512K read_rnd_buffer_size = 256K binlog_cache_size = 2M thread_stack = 256K bulk_insert_buffer_size = 64M lower_case_table_names = 1 relay-log = /home/logs/mysql/mysql_relay.log relay_log_recovery = 1 slave-net-timeout = 60 relay_log_purge = 0 sync_binlog = 1 log-bin = /data/mysql/mysql_bin.log binlog_format = ROW expire-logs-days = 2 relay_log_recovery = 1 slave_skip_errors = ddl_exist_errors explicit_defaults_for_timestamp = true
5、数据初始化
#/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/mysql/data --user=mysql
6、设置启动文件
# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
7、启动
#/etc/init.d/mysql start
8、连接
explicit_defaults_for_timestamp = true [root@deploy local]# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 12 Server version: 10.2.30-MariaDB-log Source distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
