PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-concepts.html
A backup is a snapshot of the database at a given time. The data actually stored in the database tables at the time that the backup was made Transaction log. A sequential record telling how and when data was stored in the database Each of these ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-resolved.html
These are described briefly in the following list: Database and table names. In NDB 7.6 and earlier, when using the NDB storage engine, the maximum allowed length both for database names and for table names was 63 bytes, and a statement using a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
MaxNoOfAttributes: Suggests total number of attributes stored in database (sum over all tables). TimeBetweenLocalCheckpoints: Time between taking snapshots of database (expressed in base-2 logarithm of bytes). The listings in this section provide ...
25.7.9.1 NDB Cluster Replication: Automating Synchronization of the Replica to the Source Binary Log
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-auto-sync.html
It is possible to automate much of the process described in the previous section (see Section 25.7.9, “NDB Cluster Backups With NDB Cluster Replication”). The following Perl script reset-replica.pl serves as an example of how you can do this.
https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise-backup.html
MySQL Enterprise Backup performs hot backup operations for MySQL databases. Hot backups are performed while the database is running and applications are reading and writing to it. This type of backup does not block normal database operations, and ...The product is architected for efficient and reliable backups of tables created by the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-restrictions.html
Tables in the performance_schema database cannot be locked with LOCK TABLES, except the setup_xxx tables. The Performance Schema avoids using mutexes to collect or produce data, so there are no guarantees of consistency and results can sometimes be ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-reserved-words.html
Replication can fail in such cases with Error 1064 You have an error in your SQL syntax..., even if a database or table named using the reserved word or a table having a column named using the reserved word is excluded from replication. This is due ... You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
The replica checks for and evaluates table options only if either of the following two conditions is true: No matching database options were found. One or more database options were found, and were evaluated to arrive at an “execute” condition ...First, as a preliminary condition, the replica checks whether statement-based replication is ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-reference.html
pattern_database The database used to match unqualified table names in statements. Qualified table names in statements match qualified names in the pattern if corresponding database and table names are identical. Unqualified table names in ...Users ...
https://dev.mysql.com/doc/refman/8.0/en/security.html
Access control and security within the database system itself, including the users and databases granted with access to the databases, views and stored programs in use within the database. Ensure that you have adequate and appropriate backups of ...