# my.cnf configuration from percona xtraDB cluster 5.7 to percona xtraDB cluster 8.0.19 **URL:** \ **Category:** Percona Server for MySQL 8.0\ **Tags:** community, mysql, percona\ **Created:** [August 8, 2020, 3:12am UTC](https://forums.percona.com/t/my-cnf-configuration-from-percona-xtradb-cluster-5-7-to-percona-xtradb-cluster-8-0-19/7869 "2020-08-08T03:12:54Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 8, 2020, 3:12am UTC](https://forums.percona.com/t/my-cnf-configuration-from-percona-xtradb-cluster-5-7-to-percona-xtradb-cluster-8-0-19/7869/1 "2020-08-08T03:12:54Z")
Hi, We are going to migration from percona xtraDB cluster 5.7 to percona xtraDB cluster 8.0.19, they both on different box (as we change OS, so must be on other host) so we are not going to do do in place upgrade. in the existing my.cnf of percona xtraDB cluster 5.7 (see below) we have this global variable, not sure which one is not needed anymore and what should be the optimized global variable for us on percona 8.0.19: [mysqld]#general\_log = on #general\_log\_file=/var/log/mysql/query#datadir=/mysql/datadatadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql  (is it still needed?) # Path to Galera librarywsrep\_provider=/usr/lib64/galera3/libgalera\_smm.so # Cluster connection URL contains the IPs of node#1, node#2 and node#3wsrep\_cluster\_address=gcomm://\,\ # In order for Galera to work correctly binlog format should be ROWbinlog\_format=ROW # MyISAM storage engine has only experimental supportdefault\_storage\_engine=InnoDB # This InnoDB autoincrement locking mode is a requirement for Galerainnodb\_autoinc\_lock\_mode=2 # Node 1 addresswsrep\_node\_address=\ # SST methodwsrep\_sst\_method=xtrabackup-v2 # Cluster namewsrep\_cluster\_name=\ #Authentication for SST methodwsrep\_sst\_auth=“user:password” # MySQL VARIABLESmax\_connections = 10000key\_buffer\_size =256000000myisam\_sort\_buffer\_size=67108864read\_buffer\_size =1048576read\_rnd\_buffer\_size=4194304sort\_buffer\_size=1048576query\_cache\_size=16777216 lock\_wait\_timeout=300wait\_timeout=28800interactive\_timeout=28800connect\_timeout=30 sort\_buffer\_size=256000000max\_allowed\_packet = 1073741824 lower\_case\_table\_names=1autocommit=0open\_files\_limit=10000 log\_timestamps = SYSTEM transaction\_isolation="READ-COMMITTED"sql\_mode=“ONLY\_FULL\_GROUP\_BY,STRICT\_TRANS\_TABLES,NO\_ZERO\_IN\_DATE,ERROR\_FOR\_DIVISION\_BY\_ZERO,NO\_AUTO\_CREATE\_USER,NO\_ENGINE\_SUBSTITUTION” ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [August 12, 2020, 11:59am UTC](https://forums.percona.com/t/my-cnf-configuration-from-percona-xtradb-cluster-5-7-to-percona-xtradb-cluster-8-0-19/7869/2 "2020-08-12T11:59:45Z")
I would suggest you read up on the configuration differences between 5.7 and 8.0. The MySQL 8.0 manual has much detail here. It is not safe to simply copy 5.7 my.cnf over to 8.0. Many variables were removed, and some 5.7 defaults are no longer valid in 8.0. ---
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 13, 2020, 6:05am UTC](https://forums.percona.com/t/my-cnf-configuration-from-percona-xtradb-cluster-5-7-to-percona-xtradb-cluster-8-0-19/7869/3 "2020-08-13T06:05:44Z")
" It is not safe to simply copy 5.7 my.cnf over to 8.0. Many variables were removed, and some 5.7 defaults are no longer valid in 8.0." this is what I am wondering, I tried to put old setting to new cluster, then I must bootstrap it again, right? ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [August 13, 2020, 12:59pm UTC](https://forums.percona.com/t/my-cnf-configuration-from-percona-xtradb-cluster-5-7-to-percona-xtradb-cluster-8-0-19/7869/4 "2020-08-13T12:59:56Z")
You only have to bootstrap the first node of the cluster. If your cluster is currently down, yes, edit the config, remove any old 5.7 variables, then bootstrap the node. ---
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 14, 2020, 12:09am UTC](https://forums.percona.com/t/my-cnf-configuration-from-percona-xtradb-cluster-5-7-to-percona-xtradb-cluster-8-0-19/7869/5 "2020-08-14T00:09:37Z")
so after adding old 5.7 variables, bootstrap the first node and test.   if doesn’t work, remove the old 5.7 variables, then bootstrap the first node again and store back to normal ? "he configuration differences between 5.7 and 8.0. " any resource for me to read ? ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [August 14, 2020, 7:56am UTC](https://forums.percona.com/t/my-cnf-configuration-from-percona-xtradb-cluster-5-7-to-percona-xtradb-cluster-8-0-19/7869/6 "2020-08-14T07:56:47Z")
Check the MySQL manual for upgrading from 5.7 -\> 8.0. The manual lists every parameter that was removed.