Comments (7)
Hi @Nihal987 Thanks for noticing the issue.
I have fixed it another Medium Story with Group Replication using Docker Compose but I forgot to update this story.
to fix it try to put loose-
in all these vars:
--loose-group-replication-start-on-boot='OFF' \
--loose-group-replication-group-name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee' \
--loose-group-replication-local-address="node$N:33061" \
--loose-group-replication-group-seeds='node1:33061,node2:33061,node3:33061' \
--loose-group-replication-single-primary-mode='OFF' \
--loose-group-replication-enforce-update-everywhere-checks='ON'
Let me know.
I was able to perform all the steps of the Medium story again, and the Medium story is updated.
from mysql-group-replication-docker.
I can run your exactly same command without -v data:/var/lib/mysql
:
docker run -d --name=node1 \
-e MYSQL_ROOT_PASSWORD=mypass \
mysql/mysql-server:8.0 \
--server-id=1 \
--log-bin='mysql-bin-1.log' \
--enforce-gtid-consistency='ON' \
--log-slave-updates='ON' \
--gtid-mode='ON' \
--transaction-write-set-extraction='XXHASH64' \
--binlog-checksum='NONE' \
--master-info-repository='TABLE' \
--relay-log-info-repository='TABLE' \
--plugin-load='group_replication.so' \
--relay-log-recovery='ON' \
--loose-group-replication-start-on-boot='OFF' \
--loose-group-replication-group-name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee' \
--loose-group-replication-local-address="node$N:33061" \
--loose-group-replication-group-seeds='node1:33061,node2:33061,node3:33061' \
--loose-group-replication-single-primary-mode='OFF' \
--loose-group-replication-enforce-update-everywhere-checks='ON'
docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
6a090a63edb4 mysql/mysql-server:8.0 "/entrypoint.sh --se…" About a minute ago Up About a minute (healthy) 3306/tcp, 33060-33061/tcp node1
from mysql-group-replication-docker.
Yes that works!
Thank you so much!
I'm running Mac OS as well, I should've used Linux from the start
from mysql-group-replication-docker.
I wrote the 1st version of that tutorial in 2018, using Linux.. So, after 5 years, things changed and I forgot to confirm and update.
Thanks for trying and letting me know.
from mysql-group-replication-docker.
Thank you for the article! This is a very powerful and useful tool.
from mysql-group-replication-docker.
Hi @wagnerjfr, thank you for getting back so quickly!
It's strange, I still have the same issues. Are you perhaps using an older version of the mysql docker image?
Just to be sure, here's my updated docker run command.
docker run -d --name=node1 \
-e MYSQL_ROOT_PASSWORD=mypass \
-v data:/var/lib/mysql \
mysql/mysql-server:8.0 \
--server-id=1 \
--log-bin='mysql-bin-1.log' \
--enforce-gtid-consistency='ON' \
--log-slave-updates='ON' \
--gtid-mode='ON' \
--transaction-write-set-extraction='XXHASH64' \
--binlog-checksum='NONE' \
--master-info-repository='TABLE' \
--relay-log-info-repository='TABLE' \
--plugin-load='group_replication.so' \
--relay-log-recovery='ON' \
--loose-group-replication-start-on-boot='OFF' \
--loose-group-replication-group-name='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee' \
--loose-group-replication-local-address="node$N:33061" \
--loose-group-replication-group-seeds='node1:33061,node2:33061,node3:33061' \
--loose-group-replication-single-primary-mode='OFF' \
--loose-group-replication-enforce-update-everywhere-checks='ON'
from mysql-group-replication-docker.
Try to remove this -v data:/var/lib/mysql
, I'm using Mac and I have had some issue with folder.
Before with Linux, I had no issues..
Btw, I just pulled the latest 8.0..
2023-08-09T16:20:06.588617Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 1
from mysql-group-replication-docker.
Related Issues (5)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mysql-group-replication-docker.