初始化MySQL数据库

初始化MySQL数据库，请参见《MySQL 安装指南》。

1. 主库配置。

   1 2	mkdir -p /data/mysql/datam vim /etc/my.cnf-master-mgr

   编辑内容为：

   [mysqld_safe]
   log-error=/data/mysql/log/mysqlm.log
   pid-file=/data/mysql/run/mysqldm.pid
   
   [client]
   socket=/data/mysql/run/mysqlm.sock
   default-character-set=utf8
   
   [mysqld]
   skip-name-resolve
   basedir=/usr/local/mysql
   socket=/data/mysql/run/mysqlm.sock
   mysqlx_socket=/data/mysql/run/mysqlxm.sock
   tmpdir=/data/mysql/tmp
   datadir=/data/mysql/datam
   default_authentication_plugin=mysql_native_password
   mysqlx_port=33060
   port=3306
   user=root
   report_host=127.0.0.1
   #innodb_page_size=4k
   
   max_connections=2000
   back_log=4000
   performance_schema=OFF
   max_prepared_stmt_count=128000
   #transaction_isolation=READ-COMMITTED
   
   #file
   innodb_file_per_table
   innodb_log_file_size=2048M
   innodb_log_files_in_group=32
   innodb_open_files=10000
   table_open_cache_instances=64
   
   #buffers
   innodb_buffer_pool_size=44G
   innodb_buffer_pool_instances=16
   innodb_log_buffer_size=2048M
   
   #tune
   sync_binlog=1
   innodb_flush_log_at_trx_commit=1
   innodb_use_native_aio=1
   innodb_spin_wait_delay=180
   innodb_sync_spin_loops=25
   innodb_flush_method=O_DIRECT
   innodb_io_capacity=30000
   innodb_io_capacity_max=40000
   innodb_lru_scan_depth=9000
   innodb_page_cleaners=16
   #innodb_spin_wait_pause_multiplier=25
   
   #perf special
   innodb_flush_neighbors=0
   innodb_write_io_threads=24
   innodb_read_io_threads=16
   innodb_purge_threads=32
   sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_AUTO_VALUE_ON_ZERO,STRICT_ALL_TABLES

2. 按“Esc”键，输入:wq!，按“Enter”保存并退出编辑。
3. 在从库分别完成“/data/mysql/datas”和“/data/mysql/datas2”两个目录的创建，“/etc/my.cnf-slave-mgr”和“/etc/my.cnf-slave-2-mgr”文件内容的编辑。文件内的相关路径根据实际情况修改。