Compiling MySQL server

[krysta24]

I'm gonna be honest. I got my task to create a shell script (never done that in my life but I'll figure it out later) which will: download, config, compile and install MySQL server (written in this other). Confusing part to me is that I would expect configuring a server after compilation and install. Are they just testing me or is this actually right order? What should I configure? (Literally all info that I got)

My plan is to first get it working by typing in terminal and than rewrite it to script. Do you think it's possible to do this with knowledge of some general programming but next to no knowledge on Linux and no knowledge of SQL.

It should work on any Unix like OS but that's very least of my problems at this point.

Any advice is welcome. I'm not naive so I obviously don't expect you to do it, just getting some general advice if what I'm about to do is realistic with basically googling and what they expect with configuration.

[GardeningWithSilicon]

The mysql documentation should help: https://dev.mysql.com/doc/mysql-sourcebuild-excerpt/5.5/en/installing-source-distribution.html 

 

Do you know which Linux distribution you'll be using, and what the server will be used for? If you don't, you will need to get this information before you can proceed.

[Sauron]

Yes, it can be scripted quite easily. Configuration is the obvious next step, but depending on who asked you to do this it may not be your job to configure the server. Regardless, there isn't much configuring you can do without a list of requirements.

[krysta24]

5 hours ago, Sauron said:

Yes, it can be scripted quite easily. Configuration is the obvious next step, but depending on who asked you to do this it may not be your job to configure the server. Regardless, there isn't much configuring you can do without a list of requirements.

Well it isn't to be deployed on any actual system for use so I don't know think that it really matters how it's configured. To me task isn't very clear.

 

My main question: is order configure before installing right? I have to admit that I'd expect to: download-compile-install-configure. Would it be possible to switch steps?

[datboi8192]

I dont use mysql, and dont know bash scripting but this worked on my ubuntu machine as Gardening pointed out with that how-to link

 

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.15.tar.gz
tar xvzf mysql-8.0.15.tar.gz
mkdir mysql-8.0.15/bld
cd mysql-8.0.15/bld
apt install libssl-dev
apt install libncurses5-dev
cmake .. -DDOWNLOAD_BOOST=1 -DWITH_BOOST=../cmake

[Jarsky]

8 hours ago, krysta24 said:

My main question: is order configure before installing right? I have to admit that I'd expect to: download-compile-install-configure. Would it be possible to switch steps?

 

Some configuration yes. 

When you compile programs from source for *nix you configure the options you want for compile. 

 

You need to download the files, wether you do that with wget and un-tar it, or do a git clone or something. 

Then you run the ./configure or ./cmake command using any environment variables you might need, then run make which will compile it, then make install which will install it. 

 

The actual application specific configuration which is normally just a file like my.conf you do as the final step which will have like port, sockets, user, logging, connection limits, etc...

 

For MySQL in particular, you can see all the cmake options to configure the compile here: https://dev.mysql.com/doc/refman/5.5/en/source-configuration-options.html

You can see some of the options are to compile with zlib support, different storage engines, ssl support, change install directories, etc...