Proxmox container with MySQL (not Maria)

[damon1]

Hi All,
is there a container which includes MySQL, not the MariaDB?

MariaDB doesn't work with INNODB Clusters.

Thanks
Damon

 

[Dominic]

Do you mean the turnkeylinux image?

➜  ~ sudo pveam available | grep sql  
turnkeylinux    debian-10-turnkey-mysql_16.0-1_amd64.tar.gz
turnkeylinux    debian-10-turnkey-postgresql_16.0-1_amd64.tar.gz

 

[damon1]

Do you mean the turnkeylinux image?

➜  ~ sudo pveam available | grep sql 
turnkeylinux    debian-10-turnkey-mysql_16.0-1_amd64.tar.gz
turnkeylinux    debian-10-turnkey-postgresql_16.0-1_amd64.tar.gz

Morning Dominic,

yes - it isn't MySQL it is Maria DB
"debian-10-turnkey-mysql_16.0-1_amd64.tar.gz"

I have spent most of today creating my own "Container" for the installation.
Tomorrow I hope the only thing I have to fix is "lower_case_table_names" which means I have to start again but thats ok.

Was wondering if
a) debian-10-turnkey-mysql_16.0-1_amd64.tar.gz should be renamed debian-10-turnkey-MariaDB_16.0-1_amd64.tar.gz
- Firstly, because it isn't MySQL
- Secondly Maria DB is version 16 and MySql is version 8

b) there was a MySQL version.


- I have checked and there isn't. I will make one and create a link shortly.

thanks
Damon

 

[Stoiko Ivanov]

you can start out with a plain debian container (which has the upside that those ran unprivileged) and install mysql from their repo:
see e.g. https://www.digitalocean.com/community/tutorials/how-to-install-the-latest-mysql-on-debian-10

I hope this helps!

 

[damon1]

HI Stoiko,

yes that is the one I found - it is quite good.
Many thanks

damon