Search Results
https://dev.mysql.com/doc/refman/9.7/en/installing-development-tree.html
To obtain the MySQL Server source code from this repository hosting service, you can set up a local MySQL Git repository. On GitHub, MySQL Server and other MySQL projects are found on the MySQL page. The MySQL Server project is a single repository ... This section describes how to install MySQL from the latest development source code, which is hosted on ...
https://dev.mysql.com/doc/refman/9.7/en/replication-howto-masterbaseconfig.html
Each server within a replication topology must be configured with a unique server ID, which you can specify using the server_id system variable. Binary logging is enabled by default (the log_bin system variable is set to ON). Ensure that the ... To ...Binary logging is required on the source because the binary log is the basis for replicating changes from the source to its ...
https://dev.mysql.com/doc/refman/9.7/en/replication-howto-additionalslaves.html
The Event Scheduler is controlled by the event_scheduler system variable, which defaults to ON, so events that are active on the original server run by default when the new replica starts up. On the new replica, edit the configuration and give the ...To stop all events from running on the new replica, set the event_scheduler system variable to OFF or DISABLED on the new ...
https://dev.mysql.com/doc/refman/9.7/en/federated-description.html
When you create a FEDERATED table, the table definition is the same, but the physical storage of the data is handled on a remote server. A FEDERATED table consists of two elements: A remote server with a database table, which in turn consists of the ... When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-single-primary-mode.html
If more than one member is running the lowest MySQL Server version, the second factor considered is the member weight of each of those members, as specified by the group_replication_member_weight system variable on the member. When deploying in ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-distributed-recovery-connections.html
Important Distributed recovery can fail if a joining member cannot correctly identify the other members using the host name as defined by MySQL Server's hostname system variable. In this situation you can use MySQL Server's report_host system ...The ... When a joining member connects to an online existing member for state transfer during distributed recovery, the joining member acts as a client on the connection and the existing member acts as a ...When state transfer from the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-performance.html
When optimizing and tuning the backup procedure, measure both the raw performance (how long it takes the backup to complete) and the amount of overhead on the database server. Compressed Backup Compressing the backup data before transmitting it to ... This section describes the performance considerations for backing up a database with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/9.7/en/replication-howto-slavebaseconfig.html
Each replica must have a unique server ID, as specified by the server_id system variable. In addition to binary logging, this replication topology requires the system variable log_replica_updates to be enabled. If you are setting up multiple ...A ...
https://dev.mysql.com/doc/refman/9.7/en/roles.html
The mandatory_roles and activate_all_roles_on_login system variables enable defining mandatory roles and automatic activation of granted roles when users log in to the server. Defining Mandatory Roles It is possible to specify roles as mandatory by ...(These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) While locked, a role cannot be used to authenticate to the ...
https://dev.mysql.com/doc/refman/9.7/en/openid-pluggable-authentication.html
The file must be located in the directory named by the plugin_dir system variable. MySQL Enterprise Edition supports an authentication method that enables users to authenticate to MySQL Server using OpenID Connect, provided that appropriate OpenID ... Note OpenID Connect pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...