Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-config-failover.html
The failover is configured at the initial setup stage of the server connection by the connection URL (see explanations for its format here): jdbc:mysql://[primary host][:port],[secondary host 1][:port][,[secondary host 2][:port]]...[/[database]]» ...However, this does not mean the client does not have to deal with the exception that triggered the server ...
https://dev.mysql.com/doc/connector-j/en/connector-j-config-failover.html
The failover is configured at the initial setup stage of the server connection by the connection URL (see explanations for its format here): jdbc:mysql://[primary host][:port],[secondary host 1][:port][,[secondary host 2][:port]]...[/[database]]» ...However, this does not mean the client does not have to deal with the exception that triggered the server ...
https://dev.mysql.com/doc/refman/8.4/en/connection-compression-control.html
In the following discussion, “client connection” is shorthand for a connection to the server originating from any source for which compression is supported, unless context indicates a specific connection type. Note X Protocol connections to a ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
You can precede the SELECT by IGNORE or REPLACE to indicate how to handle rows that duplicate unique key values. If you want to have indexes in the created table, you should specify these before the SELECT statement: mysql> CREATE TABLE bar (UNIQUE ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
Suppose that jeffrey connects and issues the following query: mysql> SELECT CURRENT_USER(); +----------------+ | CURRENT_USER() | +----------------+ | @localhost | +----------------+ The result shown here indicates that the matching user table row ... When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper ...
https://dev.mysql.com/doc/refman/8.4/en/windows-create-option-file.html
If you need to specify startup options when you run the server, you can indicate them on the command line or place them in an option file. For options that are used every time the server starts, you may find it most convenient to use an option file ...You need to tune the server settings, such as memory, cache, or InnoDB configuration ...
https://dev.mysql.com/doc/connectors/en/connector-net-versions.html
MySQL Connector/NET 9.x series is a continuation of Connector/NET 8.x series, but now named to synchronize with the (latest) MySQL server version it supports. For general guidance about configuring the server and clients for secure connections, see ...Connector/NET customizes Entity Framework Core to operate with MySQL data, enables compression in the .NET driver implementation, and extends cross-platform support to Linux and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-upgrade.html
For general information and instructions for upgrading a MySQL Server instance, see Chapter 3, Upgrading MySQL. You must therefore upgrade all of the replicas in a replication topology to the target MySQL Server release, before you upgrade the ...A ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
When you connect to a MySQL server, you should use a password. Alternatively, use SSH to get an encrypted TCP/IP connection between a MySQL server and a MySQL client. To start mysqld as a different Unix user, add a user option that specifies the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-example.html
[mysqld]: Defines the cluster's MySQL server nodes (also called SQL or API nodes). NDB Cluster parameter names are case-insensitive, unless specified in MySQL Server my.cnf or my.ini files. You may also use a separate [mysql_cluster] section in the ... To support NDB Cluster, you should update my.cnf as shown in the following ...