Changes between Version 2 and Version 3 of Replication

Timestamp:

11/26/25 16:53:57 (5 weeks ago)

Author:

222004

Comment:

--

Replication

@@ -73 +73 @@
 >**source** → примарен сервер (прифаќа WRITE операции)\\
 >**replica** → сервер кој ги реплицира состојбите од source (READ-only)\\
+\\
+
+{{{
+
+version: "3.9"
+
+services:
+  source:
+    image: mysql:8.0
+    container_name: mysql_source
+    environment:
+      MYSQL_ROOT_PASSWORD: root
+    command:
+      - --server-id=1
+      - --log-bin=mysql-bin
+      - --binlog-format=ROW
+      - --gtid-mode=ON
+      - --enforce-gtid-consistency=ON
+      - --log-slave-updates=ON
+      - --skip-host-cache
+      - --skip-name-resolve
+    ports:
+      - "3307:3306"
+    volumes:
+      - ./data-source:/var/lib/mysql
+      - ./init-source:/docker-entrypoint-initdb.d
+
+  replica:
+    image: mysql:8.0
+    container_name: mysql_replica
+    environment:
+      MYSQL_ROOT_PASSWORD: root
+    command:
+      - --server-id=2
+      - --log-bin=mysql-bin
+      - --relay-log=relay-bin
+      - --binlog-format=ROW
+      - --gtid-mode=ON
+      - --enforce-gtid-consistency=ON
+      - --log-slave-updates=ON
+      - --read-only=1
+      - --super-read-only=1
+      - --skip-host-cache
+      - --skip-name-resolve
+    ports:
+      - "3308:3306"
+    depends_on:
+      - source
+    volumes:
+      - ./data-replica:/var/lib/mysql
+      - ./init-replica:/docker-entrypoint-initdb.d
+
+}}}
 
 
-
-