Connection, Performance and Second Instance on Linux
This chapter 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
Second MySQL Server Instance on Linux
Second MySQL Server Instance with SELinux
Move Database between MySQL Servers
- 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.
- 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.
Table of Contents
About This Book
Introduction of SQL
MySQL Introduction and Installation
Introduction of MySQL Programs
PHP Programs and MySQL Server
Perl Programs and MySQL Servers
Java Programs and MySQL Servers
Datatypes and Data Literals
Operations and Expressions
Character Strings and Bit Strings
Commonly Used Functions
Table Column Types for Different Types of Values
Using DDL to Create Tables and Indexes
Using DML to Insert, Update and Delete Records
Using SELECT to Query Database
Window Functions for Statistical Analysis
Use Index for Better Performance
Transaction Management and Isolation Levels
Locks Used in MySQL
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
System, User-Defined and Stored Procedure Variables
MySQL Server Administration
Storage Engines in MySQL Server
InnoDB Storage Engine - Primary and Secondary Indexes
Performance Tuning and Optimization
Bulk Changes on Large Tables
MySQL Server on macOS
Installing MySQL Server on Linux
►Connection, Performance and Second Instance on Linux
Full Version in PDF/EPUB