Search Results
https://dev.mysql.com/doc/refman/9.7/en/recovery-from-backups.html
To not lose them, we would have needed to have the MySQL server store its MySQL binary logs into a safe location (RAID disks, SAN, ...) different from the place where it stores its data files, so that these logs were not on the destroyed disk. (That ... Now, suppose that we have a catastrophic unexpected exit on Wednesday at 8 ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features.html
In other words, successful statement-based replication requires that any SQL features used be supported by both the source and the replica servers. If you use a feature on the source server that is available only in the current version of MySQL, you ... The following sections provide information about what is supported and what is not in MySQL replication, and about specific issues and situations that may occur when replicating certain ...
https://dev.mysql.com/doc/refman/9.7/en/replication-mode-change-online-verify-transactions.html
If you emply a circular replication topology where multiple servers may have write clients, perform the second step for each source-replica connection, until you have completed the full circle. For example, if there are three servers A, B, and C, ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rules-db-options.html
For example, when using statement-based logging, a server running with only --binlog-do-db=sales does not write to the binary log statements for which the default database differs from sales. When using row-based logging with the same option, the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rules-examples.html
This result is the same whatever the binary logging format is on the replication source server. If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions.html
For tips on improving your replication performance, including using a single secondary server as the source, see Section 19.4.7, “Improving Replication Performance”. For information on security measures specific to servers in a replication ...
https://dev.mysql.com/doc/refman/9.7/en/serialized-dictionary-information.html
SDI data is not updated when the MySQL server is upgraded to a new release or version. The MySQL server uses an internal API that is accessed during DDL operations to create and maintain SDI records. In addition to storing metadata about database ...
https://dev.mysql.com/doc/refman/9.7/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...
https://dev.mysql.com/doc/refman/9.7/en/show-databases.html
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL server host. If the server was started with the --skip-show-database option, you cannot use this statement at all unless you have the SHOW ...
https://dev.mysql.com/doc/refman/9.7/en/solaris-installation-pkg.html
You must have root privileges to perform this operation: $> pkgadd -d mysql-9.7.0-solaris11-x86_64.pkg The following packages are available: 1 mysql MySQL Community Server (GPL) (i86pc) 9.7.0 Select package(s) you wish to process (or 'all' to ...