When the server is run with --initialize, there is no reason to load non-early plugins. The server now logs a warning and ignores

any --plugin-load or --plugin-load-add options given with --initialize. (Bug #)

[mysqld]

## replication

rpl_semi_sync_master_enabled             = 1

rpl_semi_sync_slave_enabled              = 1

rpl_semi_sync_master_timeout             = 1000

rpl_semi_sync_master_wait_point          = AFTER_SYNC

rpl_semi_sync_master_wait_no_slave       = ON

rpl_semi_sync_master_wait_for_slave_count = 1

master_info_repository                   = table

sync_master_info                         = 10000

skip_slave_start                         = OFF

slave_load_tmpdir                        = /tmp/

plugin_load_add                          = semisync_master.so

plugin_load_add                          = semisync_slave.so  

/usr/local/mysql-8.0.-linux-glibc2.-x86_64/bin/mysqld --defaults-file=/etc/my-.cnf --initialize --user=mysql3307

--17T09::53.905909+:  [System] [MY-] [Server] /usr/local/mysql-8.0.-linux-glibc2.-x86_64/bin/mysqld (mysqld 8.0.) initializing of server in progress as process      

--17T09::56.474963+:  [Warning] [MY-] [Server] Ignoring --plugin-load[_add] list as the server is running with --initialize(-insecure).

--17T09::57.620921+:  [ERROR] [MY-] [Server] unknown variable 'rpl_semi_sync_master_enabled=1'.

--17T09::57.621099+:  [ERROR] [MY-] [Server] The designated data directory /database/mysql/data// is unusable. You can remove all files that the server added to it.

--17T09::57.621375+:  [ERROR] [MY-] [Server] Aborting

--17T09::58.676973+:  [System] [MY-] [Server] /usr/local/mysql-8.0.-linux-glibc2.-x86_64/bin/mysqld: Shutdown complete (mysqld 8.0.)  MySQL Community Server - GPL.

--17T09::59.113521+:  [System] [MY-] [Server] /usr/local/mysql-8.0.-linux-glibc2.-x86_64/bin/mysqld (mysqld 8.0.) starting as process

mysqld: Table 'mysql.plugin' doesn't exist

--17T09::59.941092+:  [ERROR] [MY-] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.

--17T09::00.013579+:  [Warning] [MY-] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
        

# 一行命令完成安装、配置、调优

dbma-cli-single-instance --pkg=mysql-8.0.-linux-glibc2.-x86_64.tar.xz --port= --max-mem= install

mysql> select @@version;

+-----------+

| @@version |

+-----------+

| 8.0.    |

+-----------+

 row in set (0.00 sec)

mysql> show plugins;

+---------------------------------+----------+--------------------+--------------------+---------+

| Name                            | Status   | Type               | Library            | License |

+---------------------------------+----------+--------------------+--------------------+---------+

|

| rpl_semi_sync_master            | ACTIVE   | REPLICATION        | semisync_master.so | GPL     |

| rpl_semi_sync_slave             | ACTIVE   | REPLICATION        | semisync_slave.so  | GPL     |

| clone                           | ACTIVE   | CLONE              | mysql_clone.so     | GPL     |

+---------------------------------+----------+--------------------+--------------------+---------+

 rows in set (0.00 sec)