thanks for your input, was easy to follow. Only thing to add, if a node is rebooted or mysql is restarted it doesn't auto join unless you add group_replication_start_on_boot = ON
Great tutorial. I did it. Thank you so much. However, in my case, there were a few differences. I made the following adjustments: 1. I'm using Red Hat 8, so I had to disable SELinux; 2. I installed MySQL on one machine and cloned it to the second and third machines. Therefore, I had to delete the auto.cnf file located at /var/lib/mysql/ and restart the MySQL service (systemctl restart mysqld.service). => In both cases, errors occurred when running the command: START GROUP_REPLICATION;
Hi, in the server 2 or server 3 when create Database show this ERROR 1290 (HY000): The MySQL server is running with the --super-read-only option so it cannot execute this statement Server2 After reboot server and Start Replication ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log. But when test tutorial all start, but can't create database, only on server1, and don't see in another server. Regards
Hello sir, i tried your video and he works yesterday But today i launch my vms and when i want to start and test the replication i have this errors in the 2 others nodes "ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log." What's wrong? Do we need to do a configuration again after restart? Thanks for the course.
When i am followed your steps in second node GROUP_REPLICATION was not started and it was getting this error START GROUP_REPLICATION; ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.
thanks for your input, was easy to follow.
Only thing to add, if a node is rebooted or mysql is restarted it doesn't auto join unless you add
group_replication_start_on_boot = ON
Great tutorial. I did it. Thank you so much. However, in my case, there were a few differences. I made the following adjustments:
1. I'm using Red Hat 8, so I had to disable SELinux;
2. I installed MySQL on one machine and cloned it to the second and third machines. Therefore, I had to delete the auto.cnf file located at /var/lib/mysql/ and restart the MySQL service (systemctl restart mysqld.service).
=> In both cases, errors occurred when running the command: START GROUP_REPLICATION;
thanks man
you're welcome 🤗
Great Job but i have one question , what about if server one that run bootstrap is down or restart ?
Hi, in the server 2 or server 3 when create Database show this
ERROR 1290 (HY000): The MySQL server is running with the --super-read-only option so it cannot execute this statement
Server2 After reboot server and Start Replication
ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.
But when test tutorial all start, but can't create database, only on server1, and don't see in another server.
Regards
Hello sir, i tried your video and he works yesterday But today i launch my vms and when i want to start and test the replication i have this errors in the 2 others nodes "ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log." What's wrong? Do we need to do a configuration again after restart? Thanks for the course.
When i am followed your steps in second node GROUP_REPLICATION was not started and it was getting this error
START GROUP_REPLICATION;
ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.
I get this error too, please i need help too
you may forget to turn this loose-group_replication_start_on_boot ON, or you may have an error in configuration, could you provide the error log
I don´t understand why not on faster Debian, why on Ubuntu...
more people are using Ubuntu based on my experience