MySQL don't start after upgrading centOS and CR04

Products

• CA API Gateway

Issue/Introduction

After the update of CentOS and CR04 we have detected that on one of the two machines where we performed this update,

MySQL service does not start  and there is a error in the mysqld.log 

error [MY-000067]  [SERVER] unknown variable 'replica_parallel_workers=0

Resolution

For MySQL higher than  8.030  Setting the replica_parallel_workers system variable (or the equivalent server option --replica-parallel-workers) to 0 is now deprecated, and doing so now raises a warning. 

To achieve the same result (that is, use single threading) without the warning, set replica_parallel_workers=1 instead.

Also verify your MySQL version is upgraded to the correct version included in the MPP patch .