Output\r\n+----------------------------------+--------------------------------------+\r\n| Variable_name | Value |\r\n+----------------------------------+--------------------------------------+\r\n| group_replication_primary_member | 13324ab7-1b01-11e7-9dd1-22b78adaa992 |\r\n+----------------------------------+--------------------------------------+\r\n1 row in set (0.01 sec)<\/pre>\n\u0645\u0642\u062f\u0627\u0631 \u062e\u0631\u0648\u062c\u06cc \u0627\u06cc\u0646 \u06a9\u0648\u0626\u0631\u06cc MEMBER_ID \u0634\u0645\u0627 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f \u06a9\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0627 MEMBER_ID \u0633\u0631\u0648\u0631 \u0645\u06cc\u0632\u0628\u0627\u0646 \u062e\u0648\u062f \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0647\u06cc\u062f:<\/p>\n
SELECT * FROM performance_schema.replication_group_members;<\/pre>\n\u062e\u0631\u0648\u062c\u06cc:<\/p>\n
+---------------------------+--------------------------------------+--------------+-------------+--------------+\r\n| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |\r\n+---------------------------+--------------------------------------+--------------+-------------+--------------+\r\n| group_replication_applier | 13324ab7-1b01-11e7-9dd1-22b78adaa992 | 203.0.113.1 | 3306 | ONLINE |\r\n| group_replication_applier | 1ae4b211-1b01-11e7-9d89-ceb93e1d5494 | 203.0.113.2 | 3306 | ONLINE |\r\n| group_replication_applier | 157b597a-1b01-11e7-9d83-566a6de6dfef | 203.0.113.3 | 3306 | ONLINE |\r\n+---------------------------+--------------------------------------+--------------+-------------+--------------+\r\n3 rows in set (0.01 sec)<\/pre>\n\u0647\u0645\u0627\u0646\u200c\u0637\u0648\u0631\u200c\u06a9\u0647 \u0627\u06cc\u0646 \u062e\u0631\u0648\u062c\u06cc \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f\u060c \u0645\u06cc\u0632\u0628\u0627\u0646 \u062f\u0631 203.0.113.1- Member1 – \u062f\u0631\u200c\u062d\u0627\u0644\u200c\u062d\u0627\u0636\u0631 \u0633\u0631\u0648\u0631 \u0627\u0635\u0644\u06cc \u0627\u0633\u062a. \u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u0632\u0637\u0631\u06cc\u0642 \u0639\u0636\u0648\u06cc \u062f\u06cc\u06af\u0631 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u062f\u0627\u062f\u0647 \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f\u060c \u0639\u0645\u0644\u06cc\u0627\u062a \u0628\u0627 \u0634\u06a9\u0633\u062a \u0645\u0648\u0627\u062c\u0647 \u062e\u0648\u0627\u0647\u062f \u0634\u062f:<\/p>\n
INSERT INTO playground.equipment (type, quant, color) VALUES (\"swing\", 10, \"yellow\");<\/pre>\n\u062e\u0631\u0648\u062c\u06cc:<\/p>\n
ERROR 1290 (HY000): The MySQL server is running with the --super-read-only option so it cannot execute this statement<\/pre>\n\u0627\u06cc\u0646 \u062e\u0637\u0627 \u062f\u0631\u0633\u062a \u0627\u0633\u062a\u061b \u0632\u06cc\u0631\u0627 \u0633\u06cc\u0633\u062a\u0645 Single-Primary \u067e\u06cc\u06a9\u0631\u200c\u0628\u0646\u062f\u06cc\u200c \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u062a\u0646\u0647\u0627 \u0628\u0647 \u06cc\u06a9 \u0633\u0631\u0648\u0631 \u0642\u0627\u0628\u0644\u06cc\u062a \u0646\u0648\u0634\u062a\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f. \u0627\u06af\u0631 \u0633\u0631\u0648\u0631 \u0627\u0635\u0644\u06cc \u0645\u0634\u06a9\u0644 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f \u0648 \u06af\u0631\u0648\u0647 \u0631\u0627 \u062a\u0631\u06a9 \u06a9\u0646\u062f\u060c \u06af\u0631\u0648\u0647 \u0628\u0647\u200c\u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0639\u0636\u0648\u06cc \u062c\u062f\u06cc\u062f \u0631\u0627 \u0628\u0647\u200c\u0639\u0646\u0648\u0627\u0646 Single-Primary \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0646\u0648\u0634\u062a\u0646 \u0631\u0627 \u0645\u06cc\u200c\u067e\u0630\u06cc\u0631\u062f.<\/p>\n
2. \u0622\u0632\u0645\u0627\u06cc\u0634 \u0642\u0627\u0628\u0644\u06cc\u062a \u0646\u0648\u0634\u062a\u0646 \u0628\u0627 Multi-Primary<\/b><\/span><\/h3>\n \u0628\u0631\u0627\u06cc \u06af\u0631\u0648\u0647\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0627 Multi-Primary \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0634\u062f\u0647\u200c\u0627\u0646\u062f\u060c \u0647\u0631 \u0639\u0636\u0648\u06cc \u0628\u0627\u06cc\u062f \u0628\u062a\u0648\u0627\u0646\u062f \u06a9\u0627\u0631\u06cc \u0631\u0627 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u062f\u0627\u062f\u0647 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u062f. \u0628\u0627 \u0628\u0631\u0631\u0633\u06cc \u0645\u062c\u062f\u062f \u0645\u0642\u062f\u0627\u0631 group_Replication_primary_member \u0645\u062a\u063a\u06cc\u0631\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0628\u06cc\u0646\u06cc\u062f \u06a9\u0647 \u06af\u0631\u0648\u0647 \u0634\u0645\u0627 \u062f\u0631 \u062d\u0627\u0644\u062a Multi-Primary \u06a9\u0627\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06cc\u0627 \u062e\u06cc\u0631:<\/p>\n
SHOW STATUS LIKE '%primary%';<\/pre>\n\u062e\u0631\u0648\u062c\u06cc:<\/p>\n
+----------------------------------+-------+\r\n| Variable_name | Value |\r\n+----------------------------------+-------+\r\n| group_replication_primary_member | |\r\n+----------------------------------+-------+\r\n1 row in set (0.02 sec)<\/pre>\n\u0627\u06af\u0631 \u0645\u062a\u063a\u06cc\u0631 \u062e\u0627\u0644\u06cc \u0628\u0627\u0634\u062f\u060c \u0628\u062f\u06cc\u0646\u200c\u0645\u0639\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0645\u06cc\u0632\u0628\u0627\u0646 \u0627\u0635\u0644\u06cc \u062a\u0639\u06cc\u06cc\u0646\u200c\u0634\u062f\u0647\u200c\u0627\u06cc \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f \u0648 \u0647\u0631 \u0639\u0636\u0648\u06cc \u0628\u0627\u06cc\u062f \u0628\u062a\u0648\u0627\u0646\u062f \u0646\u0648\u0634\u062a\u0646 \u0631\u0627 \u0628\u067e\u0630\u06cc\u0631\u062f. \u0628\u0627 \u062a\u0644\u0627\u0634 \u0628\u0631\u0627\u06cc \u0646\u0648\u0634\u062a\u0646 \u0628\u0631\u062e\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 \u062c\u062f\u0648\u0644 Equipment\u060c \u0627\u06cc\u0646 Multi-Primary \u0631\u0627 \u0631\u0648\u06cc Member2 \u0622\u0632\u0645\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u062f:<\/p>\n
INSERT INTO playground.equipment (type, quant, color) VALUES (\"swing\", 10, \"yellow\");<\/pre>\n\u062e\u0631\u0648\u062c\u06cc:<\/p>\n
Query OK, 1 row affected (0.00 sec)<\/pre>\nMember2 \u0628\u062f\u0648\u0646 \u0647\u06cc\u0686 \u062e\u0637\u0627\u06cc\u06cc \u0639\u0645\u0644\u06cc\u0627\u062a \u0646\u0648\u0634\u062a\u0646 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f. \u062f\u0631 Member3\u060c \u06a9\u0648\u0626\u0631\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0628\u0628\u06cc\u0646\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0645\u0648\u0631\u062f \u062c\u062f\u06cc\u062f \u0627\u0636\u0627\u0641\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631:<\/p>\n
SELECT * FROM playground.equipment;<\/pre>\n\u062e\u0631\u0648\u062c\u06cc:<\/p>\n
+----+-------+-------+--------+\r\n| id | type | quant | color |\r\n+----+-------+-------+--------+\r\n| 1 | slide | 2 | blue |\r\n| 2 | swing | 10 | yellow |\r\n+----+-------+-------+--------+\r\n2 rows in set (0.00 sec)<\/pre>\n\u0627\u06cc\u0646 \u062a\u0623\u06cc\u06cc\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u062f\u0627\u062f\u0647 Member2 \u0628\u0627 \u0645\u0648\u0641\u0642\u06cc\u062a \u062a\u06a9\u0631\u0627\u0631 \u0634\u062f\u0647 \u0627\u0633\u062a. \u0627\u06a9\u0646\u0648\u0646 \u0628\u0627 \u0627\u062c\u0631\u0627\u06cc \u0639\u0628\u0627\u0631\u062a \u0632\u06cc\u0631\u060c \u0642\u0627\u0628\u0644\u06cc\u062a\u200c\u0647\u0627\u06cc \u0646\u0648\u0634\u062a\u0646 \u0631\u0627 \u0631\u0648\u06cc Member3 \u0648 \u0628\u0627 INSERT \u0622\u0632\u0645\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u062f:<\/p>\n
INSERT INTO playground.equipment (type, quant, color) VALUES (\"seesaw\", 3, \"green\");<\/pre>\n\u062e\u0631\u0648\u062c\u06cc:<\/p>\n
Query OK, 1 row affected (0.02 sec)<\/pre>\n\u0628\u0647 Member1 \u0628\u0627\u0632\u06af\u0631\u062f\u06cc\u062f \u0648 \u0622\u0632\u0645\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u0648\u0627\u0631\u062f \u0634\u062f\u0647\u200c\u0627\u0646\u062f \u06cc\u0627 \u062e\u06cc\u0631:<\/p>\n
SELECT * FROM playground.equipment;<\/pre>\n\u062e\u0631\u0648\u062c\u06cc:<\/p>\n
+----+--------+-------+--------+\r\n| id | type | quant | color |\r\n+----+--------+-------+--------+\r\n| 1 | slide | 2 | blue |\r\n| 2 | swing | 10 | yellow |\r\n| 3 | seesaw | 3 | green |\r\n+----+--------+-------+--------+\r\n3 rows in set (0.01 sec)<\/pre>\n\u0627\u06cc\u0646 \u062e\u0631\u0648\u062c\u06cc \u062a\u0623\u06cc\u06cc\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u062a\u06a9\u0631\u0627\u0631 \u062f\u0631 \u0647\u0631 \u062c\u0647\u062a \u06a9\u0627\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0647\u0631 \u0639\u0636\u0648 \u0639\u0645\u0644\u06cc\u0627\u062a \u0646\u0648\u0634\u062a\u0646 \u0631\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u062f.<\/p>\n\u0622\u0645\u0648\u0632\u0634 \u06a9\u0627\u0645\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc Group Replication \u062f\u0631 MySQL<\/figcaption><\/figure>\n\u0645\u0631\u062d\u0644\u0647 \u0647\u0641\u062a\u0645. \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u062f\u0646 \u06af\u0631\u0648\u0647<\/b><\/span><\/h2>\n \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06af\u0631\u0648\u0647 \u06a9\u0627\u0645\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0648 \u0627\u062c\u0631\u0627 \u0634\u062f\u060c \u062a\u0627 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0627\u0639\u0636\u0627\u06cc \u06a9\u0627\u0641\u06cc \u0628\u0631\u0627\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u0633\u0631\u0648\u0631\u0647\u0627\u06cc \u0627\u0648\u0644\u06cc\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0646\u062f\u060c \u0627\u0639\u0636\u0627\u06cc \u062f\u06cc\u06af\u0631 \u0647\u0645 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u062f\u0648\u0646 \u062a\u0623\u062b\u06cc\u0631 \u0628\u0631 \u062f\u0631\u062f\u0633\u062a\u0631\u0633\u200c\u0628\u0648\u062f\u0646 \u0628\u067e\u06cc\u0648\u0646\u062f\u0646\u062f \u06cc\u0627 \u062a\u0631\u06a9 \u06a9\u0646\u0646\u062f. \u0628\u0627\u0627\u06cc\u0646\u200c\u062d\u0627\u0644\u060c \u0627\u06af\u0631 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062e\u0627\u0635\u06cc \u062f\u0631 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0627\u0646\u062c\u0627\u0645 \u0634\u0648\u062f (\u0645\u0627\u0646\u0646\u062f \u062c\u0627\u200c\u0628\u0647\u200c\u062c\u0627\u06cc\u06cc \u0628\u06cc\u0646 Multi-Primary \u0648 Single-Primary) \u06cc\u0627 \u0647\u0645\u0647 \u0627\u0639\u0636\u0627 \u06af\u0631\u0648\u0647 \u0631\u0627 \u062a\u0631\u06a9 \u06a9\u0646\u0646\u062f\u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0644\u0627\u0632\u0645 \u0628\u0627\u0634\u062f \u06af\u0631\u0648\u0647 \u0631\u0627 \u0628\u0647 \u0647\u0645\u0627\u0646 \u0631\u0648\u0634\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u0628\u062a\u062f\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f\u06cc\u062f\u060c \u062f\u0648\u0628\u0627\u0631\u0647 \u0628\u0648\u062a \u06a9\u0646\u06cc\u062f.<\/p>\n
\u062f\u0631 Member1\u060c \u0645\u062a\u063a\u06cc\u0631 group_Replication_bootstrap_group \u0631\u0627 \u0631\u0648\u06cc ON \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f:<\/p>\n
SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=ON;<\/pre>\n\u0633\u067e\u0633\u060c \u06af\u0631\u0648\u0647 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0645\u0642\u062f\u0627\u0631\u062f\u0647\u06cc \u0627\u0648\u0644\u06cc\u0647 \u0622\u0645\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n
START GROUP_REPLICATION;<\/pre>\n\u0628\u0639\u062f\u0627\u0632\u200c\u0622\u0646\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0645\u062a\u063a\u06cc\u0631 group_Replication_bootstrap_group \u0631\u0627 \u0631\u0648\u06cc OFF \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f:<\/p>\n
SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=OFF;<\/pre>\n\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0627\u0648\u0644\u06cc\u0646 \u0639\u0636\u0648 \u06af\u0631\u0648\u0647 \u0631\u0627 \u0631\u0627\u0647\u200c\u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0631\u062f\u060c \u0633\u0627\u06cc\u0631 \u0627\u0639\u0636\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u067e\u06cc\u0648\u0646\u062f\u0646\u062f:<\/p>\n
START GROUP_REPLICATION;<\/pre>\n\u0627\u06cc\u0646 \u0631\u0648\u0646\u062f \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0639\u0636\u0627\u06cc \u062f\u06cc\u06af\u0631 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n
START GROUP_REPLICATION;<\/pre>\n\u0627\u06a9\u0646\u0648\u0646\u060c \u06af\u0631\u0648\u0647 \u0628\u0627\u06cc\u062f \u0622\u0646\u0644\u0627\u06cc\u0646 \u0628\u0627\u0634\u062f \u0648 \u0647\u0645\u0647 \u0627\u0639\u0636\u0627 \u062f\u0631\u200c\u062f\u0633\u062a\u0631\u0633 \u0628\u0627\u0634\u0646\u062f:<\/p>\n
SELECT * FROM performance_schema.replication_group_members;<\/pre>\n\u062e\u0631\u0648\u062c\u06cc:<\/p>\n
+---------------------------+--------------------------------------+--------------+-------------+--------------+\r\n| CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |\r\n+---------------------------+--------------------------------------+--------------+-------------+--------------+\r\n| group_replication_applier | 13324ab7-1b01-11e7-9dd1-22b78adaa992 | 203.0.113.1 | 3306 | ONLINE |\r\n| group_replication_applier | 1ae4b211-1b01-11e7-9d89-ceb93e1d5494 | 203.0.113.2 | 3306 | ONLINE |\r\n| group_replication_applier | 157b597a-1b01-11e7-9d83-566a6de6dfef | 203.0.113.3 | 3306 | ONLINE |\r\n+---------------------------+--------------------------------------+--------------+-------------+--------------+\r\n3 rows in set (0.01 sec)<\/pre>\n\u062f\u0631\u0635\u0648\u0631\u062a \u0644\u0632\u0648\u0645\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 \u0627\u06cc\u0646 \u0641\u0631\u0627\u06cc\u0646\u062f \u0628\u0631\u0627\u06cc \u0631\u0627\u0647\u200c\u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u062c\u062f\u062f \u06af\u0631\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f.<\/p>\n
![\"\u062e\u0631\u06cc\u062f](\"https:\/\/parspack.com\/blog\/wp-content\/uploads\/2022\/09\/Linux-Server.gif\")
<\/figure><\/a><\/p>\n![\"\u0646\u062d\u0648\u0647](\"https:\/\/parspack.com\/blog\/wp-content\/uploads\/2022\/09\/Group-Replication-in-MySQL1.jpg\" "\\"\u0646\u062d\u0648\u0647")
![\"mysql](\"https:\/\/parspack.com\/blog\/wp-content\/uploads\/2022\/09\/Group-Replication-in-MySQL2.jpg\" "\\"")