Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-sync-pending-objects-table.html
This table provides information about NDB database objects for which mismatches have been detected and which are waiting to be synchronized between the NDB dictionary and the MySQL data dictionary.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
It is implemented using the PERFORMANCE_SCHEMA storage engine and the performance_schema database. Performance Schema configuration can be modified dynamically by updating tables in the performance_schema database through SQL statements. The MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage-overview.html
The MySQL pluggable storage engine architecture enables a database professional to select a specialized storage engine for a particular application need while being completely shielded from the need to manage any specific application coding ...The ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
Database privilege changes take effect the next time the client executes a USE db_name statement. Note Client applications may cache the database name; thus, this effect may not be visible to them without actually changing to a different database.
https://dev.mysql.com/doc/refman/8.4/en/replication-features-errors.html
If a statement produces different errors on the source and the replica, the replication SQL thread terminates, and the replica writes a message to its error log and waits for the database administrator to decide what to do about the error. This ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
Channel specific replication filters are particularly useful in a multi-source replication topology when the same database or table is present on multiple sources, and the replica is only required to replicate it from one source. However, with ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups.html
How you back up a database depends on its size and whether you are backing up only the data, or the data and the replica state so that you can rebuild the replica in the event of failure. There are therefore two choices: If you are using replication ... To use replication as a backup solution, replicate data from the source to a replica, and then back up the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
Updates to the applier metadata repository are committed together with the transactions, meaning that the replica's progress information recorded in that repository is always consistent with what has been applied to the database, even in the event ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-trigger.html
row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE DEFINER=`me`@`localhost` TRIGGER ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
NDB (also known as NDBCLUSTER): This clustered database engine is particularly suited for applications that require the highest possible degree of uptime and availability. Federated: Offers the ability to link separate MySQL servers to create one ...