Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
When many rows are affected, the set of changes is split into several events; when the statement commits, all of these events are written to the binary log. MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format logging.
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
If you configure multiple rewrite-db=from_name->to_name options with the same from_name database, all filters are added together (put into the rewrite_do list) and the first one takes effect. This section explains how to work with replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-performance.html
This prevents “dumb” replicas from also logging events they have executed into their own binary log. As the number of replicas connecting to a source increases, the load, although minimal, also increases, as each replica uses a client ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-rbr-monitoring.html
The current progress of the replication applier (SQL) thread when using row-based replication is monitored through Performance Schema instrument stages, enabling you to track the processing of operations and check the amount of work completed and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
Most websites fit into this category, where users are browsing the website, reading articles, posts, or viewing products. You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions.html
For guidance on switching sources, or converting replicas into sources as part of an emergency failover solution, see Section 19.4.8, “Switching Sources During Failover”. Replication can be used in many different environments for a range of ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
These cause the output of cat to be substituted into the kill command. If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. For instructions on assigning a password, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/secure-client-programming.html
Be sure that your application remains secure if a user tries to perform SQL injection by entering something like ; DROP DATABASE mysql; into a form. Client applications that access MySQL should use the following guidelines to avoid interpreting ...
https://dev.mysql.com/doc/refman/8.4/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser doesn't seem quite right. Consulting your original pedigree papers, you find that the correct birth year should be 1989, not 1979. Fix only the erroneous record with an UPDATE ...
https://dev.mysql.com/doc/refman/8.4/en/selinux-file-context.html
The MySQL Server reads from and writes to many files. If the SELinux context is not set correctly for these files, access to the files could be denied. The instructions that follow use the semanage binary to manage file context; on RHEL, it's part ...