General Discussion
General Discussion
I am migrating old CentOS VMs running MySQL 5.x to MySQL 8.0.x that will run on Rocky 8 or 9.
I am installing mysql 8.0.x on the CentOS first, so I can verify all database files are updated and working.
Mysql 8 keeps reading the NetApp .snapshot folder as databases and throwing errors and stopping.
For some reason, this was not an issue in Mysql 5.x.
I did some research and I believe mysql 8 does not have the ignore directory setting anynore
Has anyone had and solved this issue ?
Thank you.
Solved! See The Solution
Please bear in mind that
Meaning volume needs to be remounted after a change
Another option is simply disabling snapdir-access at all
Additionally not even sure what AI suggested to you - feels like not a real advise
Modern Linux clients identifies the .snapshot directory as a different filesystem, and thus as a different mount point
Thank you for this information, it is very helpful. I did not know 9.5 had this option.
Another solution I read from an AI site is to put all data into a sub directory that does not have the .snapshot folder. Seems like a very simple solution. Data should still get snap saved.
Thank you !!!!! Very much appreciated !!!!
Please bear in mind that
Meaning volume needs to be remounted after a change
Another option is simply disabling snapdir-access at all
Additionally not even sure what AI suggested to you - feels like not a real advise
Actually, the AI suggestion was most helpful.
Instead of putting mysql data into the root level of the share which has .snapshot, create a sub directory
instead of /mysql/database, move to /mysql/database/data or something similar
I understand about remounting after change and browsing if needed.
Thank you again, very helpful.