先查看银河麒麟的版本
root@idiom-kylin1:~# cat /etc/kylin-build
Kylin 4.0.2
Build 20191024
一、下载二进制包，并安装所需软件
root@idiom-kylin3:/usr/local#wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz --no-check-certificate
root@idiom-kylin3:/usr/local/mysql/bin# apt-get install libnuma* libaio* numactl openssl
二、新建用户、目录、以及授权
root@idiom-kylin1:/usr/local#groupadd mysql
root@idiom-kylin1:/usr/local# useradd -r -g mysql -s /bin/false mysql
root@idiom-kylin1:/usr/local# tar zxvf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
root@idiom-kylin1:/usr/local# mv mysql-5.7.30-linux-glibc2.12-x86_64 mysql
root@idiom-kylin1:/usr/local# cd mysql
root@idiom-kylin1:/usr/local/mysql# mkdir -p /data/mysql/{data,,log,,mysqltmp,,redolog,,undolog} && touch /data/mysql/log/mysql_run.err && chown mysql:mysql -R /data/mysql /usr/local/mysql
三、初始化安装mysql
root@idiom-kylin1:/usr/local/mysql# bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data
2020-10-20T02:03:07.193878Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-20T02:03:07.364788Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-10-20T02:03:07.396768Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-10-20T02:03:07.458470Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 65953313-1278-11eb-8814-000c297f724b.
2020-10-20T02:03:07.462033Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot be opened.
2020-10-20T02:03:08.466026Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-20T02:03:08.744577Z 1 [Note] A temporary password is generated for root@localhost: ow)qy*ND2n_r
##如果要部署自动支持安全连接的服务器，使用 mysql_ssl_rsa_setup实用程序创建默认的SSL和RSA文件
root@idiom-kylin1:/usr/local/mysql# bin/mysql_ssl_rsa_setup --datadir=/data/mysql/data
四、编辑my.cnf配置文件
root@idiom-kylin1:/usr/local/mysql# vi /etc/my.cnf
prompt = '\u@\h [\d]> '
no-auto-rehash
[client]
port = 3306
socket = /usr/local/mysql/mysql.sock
default-character-set = utf8mb4
[mysqld]
########basic settings########
server-id = 2886738311
port = 3306
user = mysql
socket = /usr/local/mysql/mysql.sock
basedir = /usr/local/mysql
datadir = /data/mysql/data
tmpdir = /data/mysql/mysqltmp
log-error = /data/mysql/log/mysql_run.err
pid-file = /data/mysql/pid_mysql.pid
autocommit = 1
back_log = 1024
bind-address = 172.16.20.157
init-connect = 'SET NAMES utf8mb4'
character_set_server=utf8mb4
skip_name_resolve = 1
max_connections = 3000
max_connect_errors = 5000
transaction_isolation = REPEATABLE-READ
explicit_defaults_for_timestamp = 1
join_buffer_size = 128M
lower_case_table_names = 1
tmp_table_size = 1024M
tmpdir = /data/mysql/mysqltmp
default_storage_engine = INNODB
max_allowed_packet = 512M
sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER"
#interactive_timeout = 1800
#wait_timeout = 1800
read_buffer_size = 16777216
read_rnd_buffer_size = 33554432
sort_buffer_size = 33554432
log_bin_trust_function_creators = 1
max_heap_table_size = 1024M
secure_file_priv="/"
########log settings########
slow_query_log = 1
slow_query_log_file = /data/mysql/log/mysql_slow.log
#log_queries_not_using_indexes = 1
log_slow_admin_statements = 1
log_slow_slave_statements = 1
log_throttle_queries_not_using_indexes = 10
expire_logs_days = 15
long_query_time = 1
min_examined_row_limit = 100
########replication settings########
master_info_repository = TABLE
relay_log_info_repository = TABLE
log-bin = /data/mysql/log/mysql-bin.log
log-bin-index = mysql-bin.index
sync_binlog = 1
gtid_mode = on
enforce_gtid_consistency = 1
log_slave_updates
binlog_format = row
relay-log = /data/mysql/log/mysql-relay.log
relay-log-index = mysql-relay.index
relay_log_recovery = 1
binlog_gtid_simple_recovery = 1
########innodb settings########
#innodb_buffer_pool_size = 16384M
#整个宿主机是32G ，所以一半是16G ，这里用16乘以1024换算为16348M
innodb_buffer_pool_instances = 8
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_lru_scan_depth = 4000
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 10
innodb_io_capacity = 5000
innodb_io_capacity_max = 12000
innodb_write_io_threads = 16
innodb_read_io_threads = 16
innodb_flush_method = O_DIRECT
innodb_data_home_dir = /data/mysql/data
innodb_data_file_path = ibdata1:1024M:autoextend
innodb_log_group_home_dir = /data/mysql/redolog/
innodb_log_file_size = 2G
innodb_log_files_in_group = 3
innodb_log_buffer_size = 32M
innodb_undo_directory = /data/mysql/undolog/
innodb_undo_logs = 128
innodb_undo_tablespaces = 3
innodb_max_undo_log_size = 2G
innodb_undo_log_truncate = 1
innodb_flush_neighbors = 1
innodb_purge_threads = 4
innodb_large_prefix = 1
innodb_thread_concurrency = 64
innodb_print_all_deadlocks = 1
innodb_strict_mode = 1
innodb_sort_buffer_size = 67108864
innodb_file_per_table = 1
innodb_max_dirty_pages_pct = 50
innodb_buffer_pool_dump_pct = 40
innodb_page_cleaners = 4
innodb_purge_rseg_truncate_frequency = 128
group_concat_max_len = 10000
########semi sync replication settings########
plugin_dir=/usr/local/mysql/lib/plugin
plugin_load = "rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"
loose_rpl_semi_sync_master_enabled = 1
loose_rpl_semi_sync_slave_enabled = 1
loose_rpl_semi_sync_master_timeout = 5000
binlog_gtid_simple_recovery=1
log_timestamps=system
transaction_write_set_extraction=MURMUR32
show_compatibility_56=on
#slave-parallel-type=LOGICAL_CLOCK
#slave-parallel-workers=16
[mysqldump]
quick
max_allowed_packet = 512M
[mysqld_safe]
open-files-limit = 65536
#注意。my.cnf文件有几个参数需要根据系统配置修改参数
#innodb_buffer_pool_size 宿主机内存的一半乘以1024换算为xxxM
#innodb_undo_tablespaces
#innodb_data_file_path 计算方式：size 数值 pages*16K/页 / 1024K/M = 12M
#bind-address 修改为本机IP
五、启动服务、并发布mysql环境变量
root@idiom-kylin1:/usr/local/mysql#/usr/local/mysql/bin/mysqld_safe --user=mysql --datadir=/data/mysql/data --pid-file=/data/mysql/pid_mysql.pid &
root@idiom-kylin1:/usr/local/mysql# echo "export PATH=$PATH:/usr/local/mysql/bin" >>/etc/profile
root@idiom-kylin1:/usr/local/mysql# source /etc/profile
六、修改root密码
root@idiom-kylin1:/usr/local/mysql# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.30-log
Copyright © 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
root@localhost [(none)]> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘chenyu0830’;
Query OK, 0 rows affected (5.02 sec)
root@localhost [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)
注意：如果需要重启服务，使用以下命令
root@idiom-kylin1:/usr/local/mysql# ps -aux |grep mysql
root 29068 0.0 0.1 4664 1912 pts/0 S 11:26 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql/data --pid-file=/data/mysql/pid_mysql.pid
mysql 30365 0.1 18.8 1375848 187576 pts/0 Sl 11:26 0:01 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/log/mysql_run.err --open-files-limit=65536 --pid-file=/data/mysql/pid_mysql.pid --socket=/usr/local/mysql/mysql.sock --port=3306
root 30590 0.0 0.0 16188 980 pts/0 S+ 11:43 0:00 grep --color=auto mysql
root@idiom-kylin1:/usr/local/mysql# /usr/local/mysql/support-files/mysql.server stop
Shutting down MySQL
… *
root@idiom-kylin1:/usr/local/mysql# /usr/local/mysql/support-files/mysql.server start
Starting MySQL
. *
root@idiom-kylin1:/usr/local/mysql#ps -aux |grep mysql
root 30638 0.5 0.1 4664 1728 pts/0 S 11:43 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql/data --pid-file=/data/mysql/pid_mysql.pid
mysql 31935 9.0 18.8 1375848 187592 pts/0 Sl 11:43 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/log/mysql_run.err --open-files-limit=65536 --pid-file=/data/mysql/pid_mysql.pid --socket=/usr/local/mysql/mysql.sock --port=3306
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
