Do i have to use jail in order to run mysql server ?

[MikeAlmogy]

Hello all
I want to install TrueNas scale on one of my computers.
It is a very small development server. Not a production server or maybe in the future, the mysql server will be accessed from outside of my local network for testing proposes.
(I am a game developer and need database for the infrastructure of the game)
I understand that you can run Mysql in jail on TrueNas scale but do i have to? is it a requirement or just for security?
Thanks,
Mike

 

[Alecmascot]

I understand that you can run Mysql in jail on TrueNas scale but do i have to? is it a requirement or just for security?

Only on Core...

 

[MikeAlmogy]

Only on Core...

Only on core i can run mysql or only on core i need to run in in jail?

 

[Patrick M. Hausen]

On CORE you can use a jail, on SCALE you can use an app. On no platform can you directly install the database server on the NAS with standard OS tools like pkg install or apt install.

Edit: I see there is no MySQL app for SCALE. You can launch your own docker image via the "Apps" menu, though. Probably there is some ready to run MySQL on Dockerhub ...

 

[MikeAlmogy]

On CORE you can use a jail, on SCALE you can use an app. On no platform can you directly install the database server on the NAS with standard OS tools like pkg install or apt install.

Ok so i do not need to use jail on SCALE? i have no idea what no platform is.

 

[Patrick M. Hausen]

You need to use a container on SCALE. "no platform" means no platform - neither CORE nor SCALE. On none of them can you "just install" things. On CORE you need to use jails, on SCALE you need to use apps or custom Docker containers.

Both also offer VMs if you are more comfortable with that. But a VM disk image is opaque and not as easy to snapshot and backup.

I'd use CORE and a jail.

 

[MikeAlmogy]

You need to use a container on SCALE. "no platform" means no platform - neither CORE nor SCALE. On none of them can you "just install" things. On CORE you need to use jails, on SCALE you need to use apps or custom Docker containers.

Both also offer VMs if you are more comfortable with that. But a VM disk image is opaque and not as easy to snapshot and backup.

I'd use CORE and a jail.

Thank you I will reinstall my server with TrueNas SCALE and will use apps to install Mysql server. When my hardware will arrive i will try it out. Thanks.

 

[Patrick M. Hausen]

There is no MySQL app available. You need to use a custom Docker container. How that is supposed to work I don't know, I'm mostly working with CORE and jails. There should be other regulars who can help you with that.