Newbie: MySQL Jail

[FreeWilly]

Hello all,

This is my first post here, I am new to FreeBSD and I kindly ask for advice, how to install MySQL on my server.
New means I have no idea what I am doing, I red a lot, but now I am stuck.
Please bear with me, i don't know many terms yet or use it wrong.

I have a fresh installation of FreeBSD 14.2-release with ZFS and a RAIDZ-2 pool.

Would you recommend me to create a jail for MySQL?
If so, what kind of jail?


Best,
Willy

 

[SirDice]

how to install MySQL on my server.

It's not that difficult.

pkg install mysql80-server
sysrc mysql_enable="YES"
service mysql-server start

Would you recommend me to create a jail for MySQL?

No. Not for a beginner. I'd start with just a regular system, until you have a better idea on how things work. Don't overcomplicate when you're learning.

 

[FreeWilly]

SirDice, thanks a lot for your reply.

My concerns are that i would rather do it right at the beginning and not get problems later on.
It is a database for research data and I expect fast growing.
Is it still possible to move it into a jail later or only with great effort?

 

[SirDice]

My concerns are that i would rather do it right at the beginning and not get problems later on.

All the more reason not to overcomplicate things, KISS principle.

Is it still possible to move it into a jail later

Sure, that won't be a problem.

 

[Fipscode]

The funny thing here is that jails are actually the FreeBSD-specific part of what you are doing. MySQL on the other hand is not!

 

[Jim L.]

SirDice, thanks a lot for your reply.

My concerns are that i would rather do it right at the beginning and not get problems later on.
It is a database for research data and I expect fast growing.
Is it still possible to move it into a jail later or only with great effort?

Once you get it running, and get some test databases created, I'd suggest making sure that you learn how to back up your SQL data, probably via mysqldump, and also how to restore your data. Do this before you have live, important data stored on your server, so that you don't put your important data at risk without having an understanding of how to do backups and restores of SQL data.