Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
The user account that is specified using the CHANGE REPLICATION SOURCE TO statement as the PRIVILEGE_CHECKS_USER account for a replication channel must have the REPLICATION_APPLIER privilege, otherwise the replication applier thread does not start.
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
MySQL then checks each transaction against the user account's privileges to verify that you have authorized the operation for that channel. You want to have multiple on-premise or off-site deployments administered as separate units, without giving ... By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group ...
https://dev.mysql.com/doc/refman/8.4/en/replication-problems.html
If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. Many users have lost time by not doing this soon enough after encountering problems. This should never ...If ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-performance.html
Setting a large value might therefore have an impact on memory consumption for servers. If your replicas are not acting as sources, and you have a potential solution in place to ensure that you can bring up a source in the event of failure, then you ... As the number of replicas connecting to a source increases, the load, although minimal, also increases, as each replica uses a client connection to the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
Because replication works from the distribution of one source to one or more replicas, using replication for scale-out works best in an environment where you have a high number of reads and low number of writes/updates. If your code does not have ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
The following sections describe aspects of resource group use in MySQL: Resource Group Elements Resource Group Attributes Resource Group Management Resource Group Replication Resource Group Restrictions Important On some platforms or MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/reusing-ssl-sessions.html
Server-Side Runtime Configuration and Monitoring for SSL Session Reuse To create the initial TLS context, the server uses the values that the context-related system variables have at startup. For example, change the cache timeout value from the ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
To make a MySQL system secure, you should strongly consider the following suggestions: Require all MySQL accounts to have a password. If all accounts have a password, connecting using another user's account becomes much more difficult. User names ...
https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html
To list the classes that actually have students enrolled, you could use this join: SELECT class.class_num, class.class_name FROM class INNER JOIN roster WHERE class.class_num = roster.class_num; However, the result lists each class once for each ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
INTERSECT: Combine only those rows which the results of two query blocks have in common, omitting any duplicates. Selected columns listed in corresponding positions of each query block should have the same data type. For example, the first column ...