Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-history-table-update.html
Rename the original mysql.backup_history table to mysql.backup_history_old, and the mysql.backup_history_new table to mysql.backup_history. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are granted ...
https://dev.mysql.com/doc/connector-cpp/9.7/en/connector-cpp-introduction.html
MySQL Connector/C++ is a MySQL database connector for C++ applications that connect to MySQL servers. Connector/C++ can be used to access MySQL servers that implement a document store, or in a traditional way using SQL statements. Connector/C++ ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/admin-api-routing-guidelines-editing.html
The following example adds a destination class named US_Instances and defines the server pool as those servers in the us-east-1.example.com and us-west-2.example.com domains. The following example updates a destination named EU_Regions to include a ...The following topics are described: Adding Routes and Destinations Removing Routes and Destinations Modifying Route and Destination Options Copying a Routing Guideline Renaming a Routing Guideline Adding Routes and Destinations Routes and destinations can be added using the following: RoutingGuideline.add_route(name, match, destinations[, options]) name: the name of the ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-limitations.html
The limitations for both of those technologies therefore apply to server instances used with InnoDB ClusterSet. If you cannot tolerate any loss of transactions or data during a failover, instead of using InnoDB ClusterSet as your solution, consider ... InnoDB ClusterSet uses InnoDB Cluster technology, which in turn uses Group Replication ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-cluster-limitations.html
A stable and low latency network is important for InnoDB Cluster member servers to communicate with each other using the underlying Group Replication technology for consensus on transactions. For AdminAPI operations, you can only connect to server ...As InnoDB Cluster uses Group Replication, you should also be aware of its limitations, see Group Replication ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-connection-socket.html
Sessions that are still connected in this way can cause the server to hang during the shutdown procedure. If this does happen, exit MySQL Shell and the server will continue with the shutdown procedure. For more information on connecting with Unix ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-reporting-builtin-threads.html
The built-in MySQL Shell report threads lists the current threads in the connected MySQL server which belong to the user account that is used to run the report. The report works with servers running all supported MySQL 5.7, 8.0, and 8.1 versions.
https://dev.mysql.com/doc/extending-mysql/9.7/en/adding-functions.html
A native function is added by modifying the MySQL source code to be compiled into the mysqld server and become available on a permanent basis. A loadable function is compiled as a library file and then loaded and unloaded from the server dynamically ... There are three ways to add a new function to MySQL: Create a stored function (a type of stored ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-introduction.html
If you wish to make such information hidden from queries that select from these tables, you can do so by setting the value of the show_gipk_in_create_table_and_information_schema server system variable to OFF. INFORMATION_SCHEMA provides access to ...They are actually views, not base tables, so there are no files associated with them, and you cannot set triggers on ...
https://dev.mysql.com/doc/refman/9.7/en/set-password.html
When the read_only system variable is enabled, SET PASSWORD requires the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege), in addition to any other required privileges. For accounts that use a plugin that performs authentication ...