Does "STOP GROUP_REPLICATION" break the cluster?

MySQL & MariaDB Percona Server for MySQL 5.7
, ,
1

Hi there,

We have an issue about after SSt.

We need to “mysql_upgrade” cuz we got an error like;

“[ERROR] Incorrect definition of table performance_schema.global_variables: expected column ‘VARIABLE_VALUE’ at position 1 t o have type varchar(2048), found type varchar(4096).”

So we need to do that but we anxious about crash all nodes.

If we do this steps;

mysql -u root -p
STOP GROUP_REPLICATION;
mysql_upgrade -u root -p
sudo systemctl restart mysql
START GROUP_REPLICATION;

Will we encounter any problems?

2

SST referrs to Percona XtraDB Cluster, not Group Replication (GR). GR does not use SSTs.

These steps are for Group Replication, which is not Percona XtraDB Cluster.

PXC and GR are two completely different clustering technologies. Please be sure you are using the correct one, and only one Do not mix GR and PXC.

3

You’re right I’didnt used that method.

This is how can I solve the problem.

[ERROR] Incorrect definition of table performance_schema.session_variables:

service mysql stop
ps aux | grep mysql
--if it doesnt work db doesn't stop 

/etc/init.d/mysql status

--first kill the mysql services
ps aux | grep mysql

kill -9 PID --mysql PID's carefull this step dont kill any other service

-- MYSQL STOP CLEARLY THAN START THE MYSQL BELOW METHOD

"mysqld --skip-grant-tables --user=mysql --wsrep-provider='none'"

ps aux | grep mysql

-- CHECH IT AN THAN

mysql_upgrade 

--YOU MAY GET A mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) while connecting to the MySQL server error
--wait finish the mysql activating then try again

mysql_upgrade 

--after finish mysql_upgrade

--stop the mysqld wresp=none than restart the mysql normally 

select * from performance_schema.session_variables; 

--check this query
4

Please also upgrade to MySQL 8.0 as soon as you can. 5.7 has been dead for many years and 8.0 will EOL next year.

5

Dear matthewb,

You can’t imagine how much I want this.
But this place like I work, It refuses to evolve.
They are worried that I will create an extra burden for software developers.

Because you don’t even want to see that a software developer designed the database.

I’m trying it out, I hope I’ll be successful.

When I try this step I got 1 error

  1. Schema inconsistencies resulting from file removal or corruption
    Error: Following tables show signs that either table datadir directory or frm
    file was removed/corrupted. Please check server logs, examine datadir to
    detect the issue and fix it before upgrade

I can’t fix it.

I will create a topic for this.

Thanks for your time!