Intel-bigdata / SSM

Smart Storage Management for Big Data, a comprehensive hot/cold data optimized solution
Apache License 2.0
134 stars 67 forks source link

SSM don't work with MySQL 8 #2258

Open iminto opened 2 years ago

iminto commented 2 years ago

SSM do not work with MySQL 8.

My MySQL version is 8.0.26, it said "query_cache" system variables doesn't exist, so i had change the mysql-connect-jar-5.1.42 to 8.0.29.

Then,SSM exit with no error message,so i could not locate the root cause.

when i use the MySQL 5.7, it works.

PHILO-HE commented 2 years ago

Thanks for your feedback! MySQL 8 has not been well tested with SSM. And we have no plan to support such higher versions. It looks that the reported query_cache issue is not essentially caused by SSM, but the incompatibility of the used mysql and connector.