Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-status.html
It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. row *************************** Db: test Name: sp1 Type: PROCEDURE Definer: ... SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
For example, you cannot have two events in the same database with the names anEvent and AnEvent. This is because stored routine and trigger definitions are stored in tables in the mysql system database using InnoDB tables, which are not copied ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-syntax.html
A stored procedure or function is associated with a particular database. This can be used to refer to a routine that is not in the current database. For example, to invoke a stored procedure p or function f that is associated with the test database, ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/8.4/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-special-options.html
These options are for backing up database servers that play specific roles in replication, or contain certain kinds of data that require special care in backing up. As a very general rule of thumb: even for busy databases that use many temporary ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-optimistic.html
Optimistic backup is a feature for improving performance for backing up and restoring huge databases in which only a small number of tables are modified frequently. During a hot backup of a huge database (say, in the order of terabytes), huge redo ...As the redo log files grow faster than they can be processed by mysqlbackup, the backup operation can actually fail when mysqlbackup cannot catch up with the redo log cycles and LSNs get overwritten by the server before they are read by ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-process.html
In general, this is what happens when you run a backup operation with mysqlbackup: The InnoDB data files, redo log, binary log, and relay log files (except for the log files currently in use) are being copied into the backup, while the database ...