Install Mysql with data on LVM volume

hi!

Is it possible to install mysql with the data on an LVM volume?

My normal procedure on other distirbutions is to mount the volume on /var/lib/mysql prior to installation so that initial database is directly written on the logical volume.

However in 18.04 server the mysql-server installation fails with: “Error occurred: Cannot select database.”

I can see this old issue that seems the cause of the problem: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1580794

Has anybody got a workaround?
How is this done properly in Ubuntu?