记录一次服务器搭建MySQL

记录一次服务器搭建MySQL | 问道IT

技术坑:Linux centos7 mysql navicate docker

Centos7 系统安装 docker，并配置阿里云镜像加速器

先在服务器上安装一个docker 根据官方文档

docker pull MySQL:8.0

whereis mysql 查看安装位置

通过下面命令创建一个镜像

docker ps -a查看是否启动成功

启动成功改配置文件

cd /mydata/mysql/confvi my.cnf

配置文件参考

```
[mysqld]
####: for global
user =mysql
federated
basedir =/usr/local/mysql
datadir =/data/mysql/data
server_id = 1250
port =3306
mysqlx_port = 33070
character_set_server =utf8mb4
collation_server=utf8mb4_bin
log_timestamps =system
default_time_zone =’+8:00’
socket =/data/mysql/mysql.sock
read_only = 0
super_read_only = 0
skip_name_resolve =on
lower_case_table_names =1
#secure_file_priv =/data/mysql/data
open_files_limit =65536
max_connections =2000
thread_cache_size =256
table_open_cache =4096 # 2000
table_definition_cache =4096
table_open_cache_instances =64
wait_timeout =28800
interactive_timeout =28800
event_scheduler = 1
max_allowed_packet =1024M
init_connect =’SET AUTOCOMMIT=1’
transaction_isolation =READ-COMMITTED
lock_wait_timeout=3600
default_authentication_plugin=mysql_native_password###: cache
key_buffer_size = 64M
sort_buffer_size = 4M
join_buffer_size = 4M####: for binlog
binlog_format =row
log_bin =/data/mysql/logs/mysql-bin
binlog_rows_query_log_events =off
log_slave_updates =on
#expire_logs_days =7
binlog_expire_logs_seconds=604800
binlog_cache_size =1G
max_binlog_size =1G
binlog_checksum =none
sync_binlog =1
slave-preserve-commit-order =ON
log_bin_trust_function_creators=on ####:for error-log
log_error =/data/mysql/logs/mysql.err
general_log =off
general_log_file =/data/mysql/logs/general.log####: for slow query log
slow_query_log =on
slow_query_log_file =/data/mysql/logs/slowquery.log
long_query_time =1.000000
log_queries_not_using_indexes =0####: for gtid
#gtid_executed_compression_period =1000
gtid_mode =on
enforce_gtid_consistency =on####: for replication
relay-log-index = /data/mysql/logs/relay-bin.index
relay-log-info-file = /data/mysql/logs/relay-log.info
relay-log = /data/mysql/logs/relay-bin
log-slave-updates =1
skip_slave_start =1
master_info_repository =table
relay_log_info_repository =table
slave_parallel_type =logical_clock
slave_parallel_workers =2####: for performance_schema
performance_schema = 1
performance_schema_instrument = ‘%memory%=on’
performance_schema_instrument = ‘%lock%=on’
performance_schema_digests_size =100000####: for innodb
innodb_data_file_path =ibdata1:1024M:autoextend
innodb_temp_data_file_path =ibtmp1:12M:autoextend
innodb_buffer_pool_filename =ib_buffer_pool # ib_buffer_pool
innodb_log_files_in_group =3
innodb_log_file_size =256M # 50331648(48M)
innodb_max_undo_log_size =256M
innodb_undo_log_truncate =1
innodb_undo_tablespaces =2
innodb_file_per_table =on
innodb_open_files =65535
innodb_thread_concurrency =0 # 0
innodb_read_io_threads =2
innodb_write_io_threads =2
innodb_purge_threads =1
innodb_page_cleaners =1
innodb_print_all_deadlocks =off
innodb_lock_wait_timeout =20
innodb_autoinc_lock_mode =2
innodb_io_capacity =500
innodb_io_capacity_max =1000#########################
innodb_flush_method =O_DIRECT
innodb_log_buffer_size =128M
innodb_flush_log_at_trx_commit =1
innodb_buffer_pool_size = 128M
innodb_buffer_pool_instances = 2
#innodb_numa_interleave=on
#####################################
#######################
[client]
socket=/data/mysql/mysql.sock

7. docker restart 容器ID

测试连接 

#### MySQL允许远程连接

项目中需要连接虚拟机上面的 MySQL 数据库，但是总是出错，怀疑本机是否有连接远程数据库的权限。

执行命令：

```sql
mysql> use mysql;
mysql> select host,user from user;

Recommend

记录一次邮件容灾恢复过程-Juck Zhang

记录一次windows server上，反向代理服务器的配置和使用

记录并浅析一次服务器被黑事件

记录一次Linux服务器数据恢复过程

记录一次服务器重启应用恢复过程

mysql服务器一次cpu 100%问题排查

mysql | 记录一次远程协助安装 mysql 的经历

记录一次服务器被攻击时的处理过程 - 运维那点事

25-mysql服务器集群搭建

Replit 免费搭建云服务器PHP+MySQL网站

About Joyk