Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/advanced.replica-backup-restore.html
To restore the backup on a replica server, follow the same steps outlined in Section 8.1, “Setting Up a New replica”. mysqlbackup tells if that is the case by checking if the variable Replica_open_temp_tables is 0. mysqlbackup then restarts the ... To backup a replica database, add the --replica-info option to your backup ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-cluster-working-with-cluster.html
This section explains how to change an InnoDB Cluster from single-primary to multi-primary mode or the other way around, how to remove server instances from an InnoDB Cluster, and how to dissolve an InnoDB Cluster that you no longer need. If a ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-file-space.html
The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system tablespace. You cannot define where within the system tablespace your tables are allocated. In a newly created ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-sql-result-sets.html
System.out.println("Rows affected: " + res.getAffectedItemsCount()); } } print_result(mySession.sql("DELETE FROM users WHERE age < 30").execute()); print_result(mySession.sql("SELECT COUNT(*) AS forty FROM users WHERE age = 40").execute()); C++ Code ... When you execute an SQL operation on a Session using the sql() method, an SqlResult is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-get-privileges.html
By default, the DB System provides only one user account for the DB System administrator. To use the additional features of MySQL HeatWave Cluster for different purposes, you might to ask your DB System administrator to create a new user account ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-tables-table.html
The rpd_tables table provides the system change number (SCN) and load pool type for tables loaded in MySQL HeatWave. The SCN is an internal number that represents a point in time according to the system logical clock that the table snapshot was ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-switchover-console.html
Switchover Using the Console 12.5.1 Switchover Using the Console This task requires the following: A running DB system with high availability enabled. On the DB Systems tab, in the list of DB Systems, find the high availability DB System for which ...Do the following to switchover from the current primary instance to one of the secondary instances: In the MySQL HeatWave Console, select the Resources ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-endpoint.html
Creating an Endpoint for a Query PrivateLink 6.1.3 Creating an Endpoint for a Query PrivateLink Use the AWS Management Console to create an endpoint in the same region and availability zone as the DB System. A VPC with subnet(s) in the same ...Do ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-dbsystem-create-backup.html
For how to enable automatic backups for a DB system, see Creating a DB System and Editing a DB System. On the DB Systems tab, in the list of DB Systems, find the DB System you want to create a backup for, and do one of the following: Click the row ... Creating a Backup 18.1 Creating a Backup Backups can be created automatically or ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-manage-aws-access.html
For example:ocid1.tenancy.oc1..aaaaaaaaba4pv6wkcr4jqae5f44n2b2m2yt2j6rx32uzr4h25vqstifsfdsk/5281bb96-99a1-23fe-a65f-370cd85b979g To grant access to all DB Systems in the tenancy, use <TenancyOCID>/*. Manage AWS Access 21.5 Manage AWS Access Use the ...