Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
This option is used in a circular or other multi-source replication setup when one of the servers is removed. SHOW REPLICA STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica threads. The ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engine-setting.html
For example, in a replication setup, perhaps your source server uses InnoDB tables for maximum safety, but the replica servers use other storage engines for speed at the expense of durability or concurrency. When you create a new table, you can ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines.html
In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent results. For this storage engine, avoid using the LOCK ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
For information about time zone settings in replication setups, see Section 19.5.1.14, “Replication and System Functions” and Section 19.5.1.33, “Replication and Time Zones”. This section describes the time zone settings maintained by ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
Alternatively, if you have a MySQL source distribution, you can test your setup using the demonstration certificate and key files in its mysql-test/std_data directory. Several configuration parameters are available to indicate whether to use ...
https://dev.mysql.com/doc/refman/8.4/en/using-systemd.html
If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake option. The following discussion covers these topics: Overview of ...
https://dev.mysql.com/doc/refman/8.4/en/verifying-md5-checksum.html
Each operating system and setup offers its own version of tools for checking the MD5 checksum. After you have downloaded a MySQL package, you should make sure that its MD5 checksum matches the one provided on the MySQL download pages. Each package ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
Note WebAuthn authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables users to authenticate to MySQL Server using WebAuthn authentication.
https://dev.mysql.com/doc/refman/8.4/en/windows-installation.html
MySQL Installation Layout on Microsoft Windows For MySQL 8.4 on Windows, the default installation directory is C:\Program Files\MySQL\MySQL Server 8.4 for installations using the MSI, although the MSI Custom setup type allows using a different ...