Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
group_replication_advertise_recovery_endpoints specifies how a joining member can establish a connection to an existing member for state transfer for distributed recovery. If an alternative port number is specified by the report_port system ... This ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
On the source, released the read lock: mysql> UNLOCK TABLES; On the replica, edited the MySQL configuration. Alternatively, you can use the ALTER EVENT statement to set individual events to DISABLE or DISABLE ON REPLICA to prevent them from running ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-requirements.html
In such cases data is not automatically distributed to the new nodes, and, following the restore, you must redistribute the data manually by issuing an ALTER ONLINE TABLE ... REORGANIZE PARTITION statement in the mysql client for each NDB table in ... This section provides information about basic requirements for performing backup and restore operations using MySQL Cluster ...
A Quick Guide to Using the MySQL SLES Repository :: A Quick Guide to Using the MySQL SLES Repository
https://dev.mysql.com/doc/mysql-sles-repo-quick-guide/en/index.html
mysql_upgrade also performs other functions; see mysql_upgrade — Check and Upgrade MySQL Tables for details. Note After upgrading from MySQL 5.6 to 5.7, if you have problem connecting to the server as root (which will make it impossible to run ...
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. Attempts to create a new user account or to alter an existing user account identified with mysql_native_password also fail and emit an error. mysql> CREATE USER ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/workbench/en/wb-foreign-key-relationships.html
MySQL Workbench enables you to add a foreign key from within the table editor or from within an EER diagram by using the relationship tools on the vertical toolbar. To add a foreign key using the table editor, see Section 8.1.10.4, “Foreign Keys ... Foreign key constraints are supported for the InnoDB storage engine ...
https://dev.mysql.com/doc/workbench/en/wb-grt-data-organization.html
Workbench model data, such as diagrams, schemas, and tables, is stored in a hierarchy of objects that can be accessed by any plugin. Main Nodes in the Application Object Tree Table C.1 The main nodes in the Application Object Tree Node Description ... The Generic RunTime (GRT) is the internal system used by MySQL Workbench to hold model document ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
The following table shows the mapping between PostgreSQL (source) data types and MySQL data types. Table 10.3 Type mapping Source Type MySQL Type Comment INT INT SMALLINT SMALLINT BIGINT BIGINT SERIAL INT Sets AUTO_INCREMENT in its table definition. BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION DOUBLE NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL(19,2) CHAR CHAR/LONGTEXT Depending on its ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup-online-backup.html
The Contents subtab defines the schemas and tables to back up, and whether the job is a full or partial backup: Full backup: All schemas and tables are backed up (see the figure that follows). Figure 6.28 Workbench: MySQL Enterprise Backup ... This ...