一、關于MySQL X協(xié)議
MySQL X plugin是MySQL新發(fā)版本5.7.12中新增的插件杉辙,利用它實現(xiàn)MySQL作為文件存儲數(shù)據(jù)庫模捂,也就是利用MySQL 5.7版本json支持的特性完成。
二蜘矢、關于MySQL?X plugin 的開啟和關閉
MySQL啟動之后監(jiān)聽了兩個端口3306和33060狂男,是為MySQL5.7.12 之后新增了X plugin。
這個插件默認是啟用的品腹,可以在配置配置文件/etc/my.cnf 添加mysqlx=0關閉X plugin岖食,也可以在啟動時指定 --mysqlx=0 或 --skip-mysqlx選項來禁用X插件。
Port 3306 is the default port for the MySQL Protocol, which is used by the mysql client, MySQL Connectors, and utilities such as mysqldump and mysqlpump.?
Port 33060 is the default port for the MySQL Database Extended Interface (the MySQL X Protocol).
The X Plugin can be disabled at startup by either setting?mysqlx=0?in your MySQL configuration file, or by passing in either?--mysqlx=0?or?--skip-mysqlx?when starting the MySQL server.
Alternatively, use the?-DWITH_MYSQLX=OFF?CMake option to compile MySQL Server without X Plugin.
三舞吭、參考
MySQL X 插件
https://www.docs4dev.com/docs/zh/mysql/5.7/reference/x-plugin.html#x-插件
Understanding MySQL X
https://www.percona.com/blog/2019/01/07/understanding-mysql-x-all-flavors
Mysql 8 enable plugin X
https://stackoverflow.com/uestions/61666495/mysql-8-enable-plugin-x
MySQL Port Reference Tables
https://dev.mysql.com/doc/mysql-port-reference/en/mysql-ports-reference-tables.html#mysql-client-server-ports
MySQL Disabling X Plugin
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-disabling.html
MySQL accidentally expose port
https://stackoverflow.com/questions/56720751/accidentally-expose-port
https://www.coder.work/article/2531487