Stack Overflow
Stack Overflow

Questions tagged [mysql-group-replication]

32 questions
1
vote
1 answer

MySQL: Cannot set MySQL server for InnoDB Cluster with dba.configureLocalInstance()

I am trying to setup a Production Deployment of InnoDB Cluster (https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-production-deployment.html) by following the steps outlined in the documentation. I am using MySQL 5.7.25 My MySQL server…
Ignacio de Castro
  • 384
  • 1
  • 4
  • 11
1
vote
1 answer

Why paxos in mysql group replication jump prepare phase？

I see such code segment in proposer_task(xcom_base.c) if(threephase || ep->p->force_delivery){ push_msg_3p(ep->site, ep->p, ep->prepare_msg, ep->msgno, normal); }else{ push_msg_2p(ep->site, ep->p); } the threepahse is int const threephase =…
jfxu
  • 690
  • 1
  • 5
  • 15
0
votes
1 answer

Use MySQL Router with MySQL Server in single primary group replication

We use MySQL Server 8 with three nodes in a group replication on single primary mode. The server is running under windows. To communicate with the servers we use MySQL Router 8. The problem is, that the router doesn't know which of the three nodes…
DanielW
  • 3
  • 3
0
votes
1 answer

9006 ProxySQL Error: connection is locked to hostgroup XX but trying to reach hostgroup YY

ProxySql just stop working, no idea why. And no matter what query is used error would be the same. 9006 ProxySQL Error: connection is locked to hostgroup XX but trying to reach hostgroup YY ProxySQl version: ProxySQL version…
Stevan Tosic
  • 6,561
  • 10
  • 55
  • 110
0
votes
1 answer

Slave server is unable to connect to master server in MySQL Group Replication, status showing Covering , after some time shown error

I am using MySQL 5.7 to configure Group Replication, After Starting Group replication on Slave server, Status of Slave Server is showing Covering and after some time , it's shown error. After running below MySQL Query, I am getting 1045 error…
Dhiraj Kumar
  • 1
  • 1
0
votes
0 answers

MySQL Single Primary Group Replication - auto_increment_increment

I am setting up MySQL Group Replication with the following configuration 1 Virtual IP 2 ProxySQL 3 MySQL Servers with Single Master Group Replication I understand why MySQL chose to use 7 as the default auto_increment_increment value (link), my…
user14934989
  • 93
  • 4
0
votes
0 answers

Cannot connect to mysql group replication instance on openshift

I have deployed a MySQL server (bitnami helmchart) to an openshift cluster (version 8.0.25-debian-10-r16) and made a group replication cluster using docs here: https://dev.mysql.com/doc/refman/8.0/en/group-replication.html The Mysql server…
Yashar
  • 2,455
  • 3
  • 25
  • 31
0
votes
1 answer

Error ERROR 2013 (HY000): Lost connection to MySQL server during query setting up group replication on Lightsail

I am trying to configure sql group replication between 2 vps, one being a non AWS Lightsail instance and acting as primary. However I cannot seem to be able to get the Lightsail instance working. It launched without problems on the primary, but when…
user3491125
  • 366
  • 1
  • 3
  • 13
0
votes
0 answers

MySQL 8 group replication: How to skip some GTID transactions

We have a MySQL 8 replication group. How can we skip some GTID transactions which cause errors on slave.
giang
  • 33
  • 5
0
votes
1 answer

Group Replication: Transction Hanged

I have configured group replication on mysql 5.7.22 and I found if insert 10k rows then its work fine but once I increase transaction rows upto 20k then its hanged my instance and still not available for any work. I am simple running this…
Irfi
  • 49
  • 2
  • 6
0
votes
1 answer

can we use REPEATABLE-READ isolation level in mysql group replication?

I'm looking the Mysql Group Replication reference manual in group replication limitations(https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html) And the manual has said that I have searched this problem in google, but I only…
DSBDO
  • 73
  • 10
0
votes
1 answer

ERROR MY-011542 Repl Plugin group_replication reported: 'Table repl_test does not have any PRIMARY KEY

I installed an InnoDB Cluster recently and trying to create a table without any primary key or equivalent to test the cluster index concept where "InnoDB internally generates a hidden clustered index named GEN_CLUST_INDEX on a synthetic column…
Ram Dittakavi
  • 63
  • 1
  • 1
  • 9
0
votes
1 answer

Will the table with composite primary keys supports group replication in innodb

I have a table with two columns col1, col2 which are composite primary keys. Will, that table supports group replication in MySQL InnoDB clustering? Error message: org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Could not…
harish chava
  • 252
  • 2
  • 19
0
votes
1 answer

MySQL group replication multi primary mode with multiple bootstraped

I have 7 MySQL servers in different locations. All servers has same database with same structure. All tables are structured with UUID based primary keys. (No auto increment values). 1 (Central) server is always connected to the network.…
LahiruTM
  • 638
  • 4
  • 16
0
votes
2 answers

group replication vs master-slave replication

I want to know how can we differ master-slave replication and group-replication on a server. will secondary server act as slave in mysql group replication? if yes, why show slave status on group replication member returns empty set.
manvith
  • 7
  • 5
1
2
3