Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
Username: Specify the replication username for the account that you created on the MySQL source server. Creating a Channel 8.5 Creating a Channel Note:In MySQL replication, a replica is a MySQL server that receives changes from another MySQL server ...In MySQL HeatWave on AWS, a Channel references the replica as the target DB ...
https://dev.mysql.com/doc/refman/8.4/en/create-resource-group.html
CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE] vcpu_spec: {N | M - N} CREATE RESOURCE GROUP is used for resource group management (see Section 7.1.16, ...This ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-dbsystem-create.html
Creating a DB System 3.3 Creating a DB System Check that the correct AWS region is shown at the top of the MySQL HeatWave Console. If it is not, see: Manage Regions Creating a DB System requires the following information: Administrator credentials.
https://dev.mysql.com/doc/refman/8.4/en/create-temporary-table.html
One implication of this behavior is that a session can manipulate its temporary tables even if the current user has no privilege to create them. Suppose that the current user does not have the CREATE TEMPORARY TABLES privilege but is able to execute ... You can use the TEMPORARY keyword when creating a ...A TEMPORARY table is visible only within the current ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-if-not-exists.html
CREATE USER is written to the binary log only if successful. If the statement includes IF NOT EXISTS, it is considered successful, and is logged as long as at least one user named in the statement is created; in such cases, the statement is logged ...IF NOT EXISTS statements are replicated: Every CREATE DATABASE IF NOT EXISTS statement is replicated, whether or not the database already exists on the ...
https://dev.mysql.com/doc/refman/8.4/en/create-role.html
To use this statement, you must have the global CREATE ROLE or CREATE USER privilege. (These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) CREATE ROLE either succeeds for all ... CREATE ROLE [IF NOT EXISTS] role [, role ] ...If the IF NOT EXISTS clause is given, the statement produces a warning for each ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-create-configure.html
To create and then configure the target cluster, follow these steps: Install MySQL Cluster Manager and start mcmd on all hosts with the same system user who started the wild cluster processes. Important The cluster import is going to fail due to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory. InnoDB supports the following methods for creating tables externally: Using the DATA DIRECTORY Clause Using CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/create-server.html
CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE character-literal | USER character-literal | PASSWORD character-literal | SOCKET character-literal | OWNER ...