PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
As a table, 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 ... 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/5.7/en/replication-solutions.html
For performance or data distribution reasons, you may want to replicate different databases to different replicas. See Section 16.3.5, “Replicating Different Databases to Different Replicas” As the number of replicas increases, the load on the ... Replication can be used in many different environments for a range of ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html
The Rewriter plugin uses a database named query_rewrite containing a table named rewrite_rules. The query_rewrite database contains a stored procedure named flush_rewrite_rules() that loads the contents of the rules table into the plugin. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
Make sure that the only Unix user account with read or write privileges in the database directories is the account that is used for running mysqld. With this privilege, you can read any file into a database table. When you connect to a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/security-guidelines.html
When running MySQL, follow these guidelines: Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql system database! This is critical. Anyone using MySQL on a computer connected to the Internet should read this ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
The database administrator must set these variables at server startup if the key files to use have names that differ from the system variable default values. Client users can obtain the RSA public key two ways: The database administrator can provide ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 ...
https://dev.mysql.com/doc/refman/5.7/en/show-tables.html
SHOW [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a given database. You can also get this list using the mysqlshow db_name command. The LIKE clause, if present, indicates which ...
https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html
MySQL maps certain data types used by other SQL database vendors to MySQL types. In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to ...
https://dev.mysql.com/doc/refman/5.7/en/solaris-installation-pkg.html
(default: all) [?,??,q]: The PKG installer installs all of the files and tools needed, and then initializes your database if one does not exist. Removal of the package does not delete the existing database information, only the server, binaries and ... You can install MySQL on Solaris using a binary package of the native Solaris PKG format instead of the binary tarball ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
This makes it easier to use MySQL in different environments and to use MySQL together with other database servers. The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the ...