Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-multi-primary-mode.html
20.1.3.2.1 Transaction Checks When a group is deployed in multi-primary mode, transactions are checked to ensure they are compatible with the mode. The following strict consistency checks are made when Group Replication is deployed in multi-primary ... In multi-primary mode (group_replication_single_primary_mode=OFF) no member has a special ...
https://dev.mysql.com/doc/refman/8.4/en/installing-development-tree.html
~/mysql-server> git branch -r origin/5.7 origin/8.0 origin/HEAD -> origin/trunk origin/cluster-7.4 origin/cluster-7.5 origin/cluster-7.6 origin/trunk To view the branch that is checked out in your local repository, issue the git branch command. When ... This section describes how to install MySQL from the latest development source code, which is hosted on ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
Checking Show Advanced Options enables additional Logging Options to be set. Advanced Configuration Check Show Advanced and Logging Options to set custom logging and advanced options in later steps. MySQL Enterprise Firewall (Enterprise Edition ...
https://dev.mysql.com/doc/refman/8.4/en/replication-problems.html
If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. Use SHOW REPLICA STATUS to check whether the Replica_IO_Running and Replica_SQL_Running values are both Yes.
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-db-options.html
When evaluating replication options, the replica begins by checking to see whether there are any --replicate-do-db or --replicate-ignore-db options that apply. When using --binlog-do-db or --binlog-ignore-db, the process is similar, but the options ...Note Only DML statements can be logged using the row ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci SHOW CREATE TABLE displays ... SHOW CREATE TABLE tbl_name Shows the CREATE TABLE statement that creates the named ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
Before upgrading to the latest MySQL 8.4 release, ensure the upgrade readiness of your current MySQL 8.3 or MySQL 8.4 server instance by performing the preliminary checks described below. Tip Consider using the MySQL Shell upgrade checker utility ...You can select a target MySQL Server release to which you plan to upgrade, ranging from the MySQL Server 8.0.11 up to the MySQL Server release number that matches the current MySQL Shell release ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password.html
The validate_password component implements these capabilities: For SQL statements that assign a password supplied as a cleartext value, validate_password checks the password against the current password policy and rejects the password if it is weak ... The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-routing-guidelines-syntax.html
IS_IPV4('str'): checks if the given string is a valid IPv4 address. IS_IPV6('str'): checks if the given string is a valid IPv6 address. SUBSTRING_INDEX("foo bar baz","a", 2): returns foo bar b STARTSWITH('str1', 'str2'): checks if the str2 string is ... The top-level properties of a routing guideline document are: destinations: groupings of MySQL servers using pattern-matching ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/monitoring-innodb-cluster.html
The address, label and role values match those described at Checking a cluster's Status with Cluster.status() . Checking a cluster's Status with Cluster.status() Cluster objects provide the status() method that enables you to check how a cluster is ... This section describes how to use AdminAPI to monitor an InnoDB ...