Connection, Performance and Second Instance on Linux

MySQL Tutorials - Herong's Tutorial Examples

∟Connection, Performance and Second Instance on Linux

Provides introductions and tutorial examples about more advanced topics on running MySQL server on CentOS systems, including MySQL socket and TCP/IP connections; Opening firewall for MySQL connections; testing performance on INSERT statements; creating second server instance; moving databases.

These sections are omitted from this Web preview version. To view the full content, see information on how to obtain the full version this book.

MySQL Server Socket Connection on CentOS

MySQL Server TCP/IP Connection on CentOS

Open Firewall for MySQL Server on CentOS

"Server sent charset unknown to the client" Error

Performance of Inserting Integers to MySQL Database

Performance Comparison of Inserting Integers vs. Strings

Second MySQL Server Instance on Linux

Second MySQL Server Instance with SELinux

Move Database between MySQL Servers

Takeaways:

MySQL supports socket connections for client programs on the server host using "localhost" as the host name.
MySQL supports TCP/IP connections for remote clients on port 3306.
MySQL allows a remote user to access only if the user is created with his/her IP address specified.
MySQL requires the server and gateway to open firewall for inbound TCP messages on port 3306.
"Server sent charset unknown to the client" error is returned when using older PHP mysqli_connect() function to connect to MySQL 8.0.
MySQL server is 100 times slower on my CentOS computer than my macOS computer with default settings.
New data directory can be created using the "mysqld --no-defaults --initialize" command.
Second instance can be started with the "mysqld --defaults-file" command on a new data directory and port.