{"id":4858,"date":"2012-05-01T10:10:10","date_gmt":"2012-05-01T08:10:10","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=4858"},"modified":"2012-05-01T10:10:10","modified_gmt":"2012-05-01T08:10:10","slug":"installing-mysql-from-sourcebinary-tarball-as-a-linux-service","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/installing-mysql-from-sourcebinary-tarball-as-a-linux-service","title":{"rendered":"Installing MySQL from source\/binary tarball as a Linux service"},"content":{"rendered":"

I’ve written before<\/a> I prefer to do a manual install of MySQL over a repository one. I still do: I typically install from binary tarball or by compiling from source.<\/p>\n

I’d like to share my setup procedure for Linux installation and service setup. I’ve done this dozens of times, on different Linux flavors, and it works well for me.<\/p>\n

Installing from source<\/h4>\n

To get this straight: you sometimes have to compile the source files. I, for example, happen to use the Sphinx MySQLSE extension. You can only use it if compiled with MySQL. You had to compile a “vanilla” 5.1<\/strong> version without query cache in order to completely remove the cache’s mutex contention.<\/p>\n

Anyway, I find the easiest way is to install onto a path associated with the server version. For example, I would install a 5.5<\/strong> server onto \/usr\/local\/mysql55<\/strong><\/p>\n

This way, a new version gets its own path, and no ambiguity.<\/p>\n

To do that, use the prefix<\/strong> option on configuration step:<\/p>\n

\n
cd \/path\/to\/extracted\/source\/tarball\r\nsh BUILD\/autorun.sh\r\n.\/configure --prefix=\/usr\/local\/mysql55\r\nmake\r\nsudo make install<\/pre>\n<\/blockquote>\n
Once this is complete, you have everything<\/em> under \/usr\/local\/mysql55<\/strong>. This means binaries, libraries, scripts, etc.<\/p>\n
To install the MySQL server as a service, copy the mysql.server script to \/etc\/init.d<\/strong>:<\/p>\n
\n
sudo cp \/usr\/local\/mysql55\/support-files\/mysql.server \/etc\/init.d\/mysql55<\/pre>\n<\/blockquote>\n
Again, I’m naming the script after the MySQL version. This avoids conflict with possible past or future installations of the MySQL server, which typically create a service named mysql<\/strong> or mysqld<\/strong>.<\/p>\n
A thing to note about the mysql.server script is that it allows you (at around line #45<\/strong>) to set two variables:<\/p>\n
    \n
  • basedir<\/strong>: path to your installation directory. When compiling from source this is already setup with the path provided to the configure<\/strong> script. Thus, in our example, you can expect this variable to read \/usr\/local\/mysql55<\/strong>. So basically nothing to do here.<\/li>\n
  • datadir<\/strong>: path to your data directory. If you’re putting your my.cnf<\/strong> file in \/etc<\/strong> or \/etc\/mysql<\/strong>, then setting datadir<\/strong> in my.cnf<\/strong> suffices. However, if you’re going to put my.cnf<\/strong> itself on the data directory (e.g. so as to avoid collisions) then make sure to set the variable in the mysql.server<\/strong> init script.<\/li>\n<\/ul>\n
    Depending on your $PATH<\/strong> configuration, it is also a good idea to specify basedir<\/strong> variable on your my.cnf<\/strong>‘s [mysqld]<\/strong> section.<\/p>\n
    Which leads us to $PATH<\/strong>: your linux system is still unaware of the many binaries you’ve got in there. I typically add the following line at the end of \/etc\/bash.bashrc<\/strong>:<\/p>\n
    \n
    export PATH=\/usr\/local\/mysql55:${PATH}<\/pre>\n<\/blockquote>\n
    This is the most global PATH settings one can do. Alternatively, use \/etc\/profile<\/strong>, ~\/.bashrc<\/strong> etc. (you may have noticed by now I’m working with bash<\/strong>).<\/p>\n
    Finally, need to setup the init script to run at startup and stop at shutdown.<\/p>\n
      \n
    • On Debian\/Ubuntu\/related I use rcconf<\/strong> (I’m too lazy to remember the command line setup).<\/li>\n
    • On RedHat\/CentOS\/related I use\u00a0chkconfig –add mysql55<\/strong>, or\u00a0 linuxconf<\/strong> (since I’m lazy).<\/li>\n<\/ul>\n
      Installing from binary tarball<\/h4>\n
      The only difference is that the mysql.server<\/strong> script is unaware of our deployment path. So the basedir<\/strong> variable must be set in that file. Other than that, follow same steps as for source installation (oh, of course no need to configure<\/strong> & make<\/strong>…).<\/p>\n","protected":false},"excerpt":{"rendered":"
      I’ve written before I prefer to do a manual install of MySQL over a repository one. I still do: I typically install from binary tarball or by compiling from source. I’d like to share my setup procedure for Linux installation and service setup. I’ve done this dozens of times, on different Linux flavors, and it […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[5],"tags":[10,119],"class_list":["post-4858","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-installation","tag-linux"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2bZZp-1gm","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/4858","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/comments?post=4858"}],"version-history":[{"count":14,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/4858\/revisions"}],"predecessor-version":[{"id":4893,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/4858\/revisions\/4893"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=4858"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=4858"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=4858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}