PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
You want to have an administrator account that enables an administrator to perform only operations that are directly relevant to the replication channel and the databases it replicates, rather than having wide privileges on the server instance. By ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-best-practices.html
For a current list of supported platforms, see: https://www.mysql.com/support/supportedplatforms/database.html Understand MySQL Server Changes Each major version comes with new features, changes in behavior, deprecations, and removals. Run Upgrade ... MySQL supports upgrading between minor versions (within an LTS series) and to the next major version (across an LTS ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. However, it does need to access the MySQL server on which the database to ...Unlike the other utilities discussed in this section, it does not require access to an NDB Cluster (in fact, there is no reason for it to do ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mixed.html
(Bug #28086) When one of the tables involved is a log table in the mysql database. The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
There are several reasons why a client might want to set binary logging on a per-session basis: A session that makes many small changes to the database might want to use row-based logging. Examples include all DDL (data definition language) ... You ...
https://dev.mysql.com/doc/refman/8.0/en/events-configuration.html
For SQL statements used to create, alter, and drop events, see Section 27.4.3, “Event Syntax”. Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this thread. When running, the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-summary.html
These are very powerful properties that translate into very useful abstractions that one can resort to build more advanced database replication solutions. The conflict resolution procedure states that the transaction that was ordered first commits ... Group Replication is a technique that can be used to implement fault-tolerant ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-table.html
It is ready to be dropped or made active again by an ALTER UNDO TABLESPACE ... The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo tablespaces. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-general-info.html
While many standard MySQL schemas and applications can work using NDB Cluster, it is also true that unmodified applications and database schemas may be slightly incompatible or have suboptimal performance when run using NDB Cluster (see Section ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-pitr.html
To perform point-in-time recovery of NDB Cluster, it is necessary to follow the steps shown here: Back up all NDB databases in the cluster, using the START BACKUP command in the ndb_mgm client (see Section 25.6.8, “Online Backup of NDB Cluster”). Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was ...