Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-rawdata.html
To guarantee the integrity of the files that are copied, backing up the raw data files on your MySQL replica should take place while your replica server is shut down. If the MySQL server is still running, background tasks may still be updating the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-diffengines.html
It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine types. This provides a number of benefits in the replication process in that you can take ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across multiple database servers, within some reasonable limitations. Because replication works from the distribution of one source to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-statements-replica.html
Section 15.4.1, “SQL Statements for Controlling Source Servers”, discusses statements for managing source servers. In addition to the statements described here, SHOW REPLICA STATUS and SHOW RELAYLOG EVENTS are also used with replicas. For ...
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/request-access.html
After the server accepts a connection, it enters Stage 2 of access control. For each request that you issue through the connection, the server determines what operation you want to perform, then checks whether your privileges are sufficient. This ...
https://dev.mysql.com/doc/refman/8.4/en/reserved-accounts.html
One part of the MySQL installation process is data directory initialization (see Section 2.9.1, “Initializing the Data Directory”). During data directory initialization, MySQL creates user accounts that should be considered reserved: ...
https://dev.mysql.com/doc/refman/8.4/en/resource-group-statements.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. This section describes the SQL ...
https://dev.mysql.com/doc/refman/8.4/en/retrieving-data.html
The SELECT statement is used to pull information from a table. The general form of the statement is: SELECT what_to_select FROM which_table WHERE conditions_to_satisfy; what_to_select indicates what you want to see. This can be a list of columns, ...