Changes between Version 3 and Version 4 of GROUPReplicate2

Timestamp:

06/14/22 09:11:01 (2 years ago)

Author:

krit

Comment:

--

GROUPReplicate2

@@ -72 +72 @@
 mysql> SELECT * FROM performance_schema.replication_group_members;
 }}}
+
+10. create database and table need ref [https://lefred.be/content/mysql-group-replication-and-table-design/ here]
+ * InnoDB Storage Engine: data must be stored in the InnoDB transactional storage engine.
+ * Primary Keys: every table that is to be replicated by the group must have an explicit primary key defined.
+
+{{{
+mysql> create table test_tbl_nopk_uniq_notnull (id int not null unique key, name varchar(10));
+mysql> insert into test_tbl_nopk_uniq_notnull values (1,'lefred'); 
+Query OK, 1 row affected (0.01 sec)
+}}}