Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise Edition. This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise Backup. The ...The same technique can be used to quickly add a new member to a ...
https://dev.mysql.com/doc/refman/8.4/en/windows-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN authentication_windows SONAME 'authentication_windows.dll'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-multi.html
For more information on which options must be unique per server in a multiple-server environment, see Section 7.8, “Running Multiple MySQL Instances on One Machine”. These options indicate the name of the server that mysqld_safe should start and ...Note For some Linux platforms, MySQL installation from RPM or Debian packages includes systemd support for managing MySQL server startup and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-statements-source.html
Section 15.4.2, “SQL Statements for Controlling Replica Servers”, discusses statements for managing replica servers. In addition to the statements described here, the following SHOW statements are used with source servers in replication. SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/server-shutdown.html
If the SQL thread is in the middle of a transaction at this point, the server waits until the current replication event group (if any) has finished executing, or until the user issues a KILL QUERY or KILL CONNECTION statement. If the server is a ...
https://dev.mysql.com/doc/refman/8.4/en/import-table.html
Tables can be exported from one server using mysqldump to write a file of SQL statements and imported into another server using mysql to process the dump file. The import server uses /tmp/mysql-files as the directory named by its secure_file_priv ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. Start the MySQL server with the init_file system variable set to name the file (notice that the backslash in the option ...
https://dev.mysql.com/doc/refman/8.4/en/gone-away.html
The solution to this is to either do a mysql_ping() on the connection if there has been a long time since the last query (this is what Connector/ODBC does) or set wait_timeout on the mysqld server so high that it in practice never times out. If you ... This section also covers the related Lost connection to server during query ...By ...In this case, you ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-alter-drop-server.html
The statements CREATE SERVER, ALTER SERVER, and DROP SERVER are not written to the binary log, regardless of the binary logging format that is in use.
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-upgrade.html
Important You may encounter technical challenges during a server upgrade or downgrade, and it is beyond the function of MySQL Enterprise Backup, as a backup tool, to ensure a successful server upgrade or downgrade. Users interested in the topic are ...Downgrading to a lower series (for example, from 8.4 to 8.0) might cause server crashes or data ...