Search Results
https://dev.mysql.com/doc/ndbapi/en/mccj-overview-java.html
A NDB Cluster is defined as one or more MySQL Servers providing access to an NDBCLUSTER storage engine—that is, to a set of NDB Cluster data nodes (ndbd processes). JDBC works by sending SQL statements to the MySQL Server and returning result ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-11.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed Incompatible Change: When documents without an _id attribute are added to a collection, the server now automatically generates IDs for them. The server determines the ID ...
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connections.html
By default, MySQL programs attempt to connect using encryption if the server supports encrypted connections, falling back to an unencrypted connection if an encrypted connection cannot be established. With an unencrypted connection between the ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
(See Section 10.11.3, “Concurrent Inserts”.) However, READ LOCAL cannot be used if you are going to manipulate the database using processes external to the server while you hold the lock. (For additional information about the interaction between ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator.html
Typically this location is in C:\Program Files\MySQL\MySQL Server X.Y\bin if installed via the MSI, or a custom directory for the Zip archive. MySQL Configurator is a standalone application designed to ease the complexity of configuring a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-binlog.html
Therefore, to allow a server to be restored to a point-in-time, binary logging must be enabled on it, which is the default setting for MySQL 8.4 (see Section 7.4.4, “The Binary Log”). By default, the server creates binary log files in the data ... This section explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-invoked.html
Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always replicated. For example, trying to ...The following statements are replicated using statement-based replication: CREATE EVENT ALTER EVENT DROP EVENT CREATE PROCEDURE DROP PROCEDURE CREATE FUNCTION DROP FUNCTION CREATE TRIGGER DROP TRIGGER However, the effects of features created, modified, or dropped using these statements are replicated using row-based ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-type-conversions.html
Prepared statements transmit data between the client and server using C language variables on the client side that correspond to SQL values on the server side. If there is a mismatch between the C variable type on the client side and the ...The ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-api-components.html
Command-line options and system variables: The --plugin-load option enables plugins to be loaded at server startup time. The value of this variable can be specified at server startup with a --plugin_dir=dir_name option. The client plugin ...SQL ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-prepare.html
To migrate schemas and data from Microsoft SQL Server for use with MySQL, ensure the following: The source SQL Server instance is running, and accepts TCP connections. You know the IP and port of the source SQL server instance. If you will be ...