You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
102 lines
2.8 KiB
102 lines
2.8 KiB
#安装依赖
|
|
yum install -y git gcc gcc-c++ cmake libaio libaio-devel bison bison-devel zlib-devel ncurses ncurses-devel perl pcre-devel libxml2-devel libevent-devel rpm-build openssl-devel boost-program-options lsof socat perl-Compress-Raw-Bzip2 perl-Compress-Raw-Zlib perl-DBI perl-Data-Dumper perl-IO-Compress perl-Net-Daemon pcre2 m4 make curl-devel lz4-devel snappy-devel bzip2-devel lzo-devel zstd-devel boost-devel
|
|
|
|
cd /usr/local
|
|
|
|
#将mariadb-10.11.2.tar.gz上传至/usr/local
|
|
|
|
groupadd mysql
|
|
useradd mysql -g mysql
|
|
mkdir -p /usr/local/mysql
|
|
mkdir -p /usr/local/db/mysql/data
|
|
mkdir -p /auth_pam_tool_dir
|
|
touch /auth_pam_tool_dir/auth_pam_tool
|
|
|
|
chown -R mysql:mysql /usr/local/mysql
|
|
chown -R mysql:mysql /usr/local/db/mysql/data
|
|
chown -R mysql:mysql /usr/local/mysql/.
|
|
chown -R mysql:mysql /usr/local/db/mysql/data/.
|
|
chown -R mysql:mysql /auth_pam_tool_dir
|
|
|
|
echo "PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:\$PATH" >> /etc/profile
|
|
echo "export PATH" >> /etc/profile
|
|
|
|
source /etc/profile
|
|
|
|
|
|
tar zxvf mariadb-10.11.2.tar.gz
|
|
|
|
cd mariadb-10.11.2
|
|
|
|
cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/usr/local/db/mysql/data -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=22066
|
|
|
|
make -j8
|
|
|
|
make install
|
|
|
|
|
|
vi /etc/my.cnf
|
|
|
|
[client]
|
|
port = 22066
|
|
socket = /usr/local/mysql/mysqld.sock
|
|
|
|
# The MySQL server
|
|
[mysqld]
|
|
port = 22066
|
|
socket = /usr/local/mysql/mysqld.sock
|
|
datadir = /usr/local/db/mysql/data
|
|
skip-external-locking
|
|
skip-name-resolve
|
|
back_log = 100
|
|
max_connections = 2048
|
|
max_connect_errors = 30
|
|
table_open_cache = 2048
|
|
open_files_limit = 16384
|
|
max_allowed_packet = 16M
|
|
read_buffer_size = 8M
|
|
read_rnd_buffer_size = 32M
|
|
sort_buffer_size = 2M
|
|
join_buffer_size = 2M
|
|
thread_cache_size = 16
|
|
query_cache_size = 128M
|
|
query_cache_limit = 4M
|
|
slow_query_log = 1
|
|
long_query_time = 2
|
|
lower_case_table_names = 1
|
|
innodb_file_per_table = 1
|
|
max_allowed_packet = 64M
|
|
server-id = 1
|
|
log-bin = mysql-bin
|
|
expire_logs_days = 7
|
|
binlog_format = ROW
|
|
|
|
innodb_data_file_path = ibdata1:10M:autoextend
|
|
innodb_buffer_pool_size = 2G
|
|
innodb_write_io_threads = 8
|
|
innodb_read_io_threads = 8
|
|
innodb_flush_log_at_trx_commit = 2
|
|
innodb_log_buffer_size = 16M
|
|
innodb_log_file_size = 170M
|
|
innodb_lock_wait_timeout = 60
|
|
|
|
|
|
cd /usr/local/mysql
|
|
|
|
scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/db/mysql/data
|
|
|
|
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
|
|
|
|
service mysql start
|
|
|
|
chkconfig mysql on
|
|
|
|
mysqladmin -u root password 'DsideaL147258369'
|
|
|
|
mysql -uroot -pDsideaL147258369
|
|
|
|
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "DsideaL147258369";
|
|
flush privileges;
|
|
|
|
|