Giter VIP home page Giter VIP logo

Comments (7)

wagnerjfr avatar wagnerjfr commented on August 18, 2024 1

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.

wagnerjfr avatar wagnerjfr commented on August 18, 2024 1

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.

Nihal987 avatar Nihal987 commented on August 18, 2024 1

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.

wagnerjfr avatar wagnerjfr commented on August 18, 2024 1

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.

Nihal987 avatar Nihal987 commented on August 18, 2024 1

Thank you for the article! This is a very powerful and useful tool.

from mysql-group-replication-docker.

Nihal987 avatar Nihal987 commented on August 18, 2024

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.

wagnerjfr avatar wagnerjfr commented on August 18, 2024

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 photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.