Anyone use Percona with Virtualmin

3 posts / 0 new
Last post
#1 Mon, 03/25/2013 - 14:06
MichaelS

Anyone use Percona with Virtualmin

Hi,

Is anyone using Percona with Virtualmin and how?

Thanks

Fri, 04/12/2013 - 14:23
rosslittle

Hi Michael

Yeah, I'm using it on Ubuntu 12.04 x86_64 pretty easily.

Here's what I did:

** Install and update the OS **

1. Plain vanilla install of Ubuntu 12.04 x86_64

2. I always change my apt sources to pick up the best mirror:

2.1 Backup your sources.list

$ sudo mv /etc/apt/sources.list /etc/apt/sources.list.BAK

2.2 Create a new sources.list

$ sudo nano /etc/apt/sources.list

NOTE: if this gives you an error, you may not have nano installed and you can do so with the following command:

$ sudo apt-get install nano

... enter the following contents (replace precise with your version of ubuntu) into sources.list :

deb mirror://mirrors.ubuntu.com/mirrors.txt precise main restricted universe multiverse
deb mirror://mirrors.ubuntu.com/mirrors.txt precise-updates main restricted universe multiverse
deb mirror://mirrors.ubuntu.com/mirrors.txt precise-backports main restricted universe multiverse
deb mirror://mirrors.ubuntu.com/mirrors.txt precise-security main restricted universe multiverse

If you're not used to the command line - ctrl-x to save and exit.

2.3 Import the keys for the mirrors repo

$ sudo gpg --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 16126D3A3E5C1192
$ sudo gpg -a --export 16126D3A3E5C1192 | sudo apt-key add -

2.4 Update and Upgrade your base OS

$ sudo apt-get update
$ sudo apt-get upgrade

3. I always install a bunch of stuff that I'm going to find useful later (this is optional for you)

$ sudo apt-get install build-essential perl ruby rubygems git zsh

4. Install Virtualmin (I haven't wrapped this in a code block to prevent the forum software changing the link text to anchors):

$ wget http://software.virtualmin.com/gpl/scripts/install.sh
$ sudo sh ./install.sh

5. Let the install complete, when done log in at https://yourserver.com:10000 with your root username and password.

6. The setup assistant should be showing at the top, go through that as normal, BUT when you are asked if you want to run a MySQL database select 'No' (otherwise standard MySQL will start).

7. Once you have completed the web based setup, select Systems Settings > Re-Check configuration. If that comes back good to go then move on, otherwise fix problems.

8. At this point, MySQL shouldn't be running and should not be marked as a Feature. So, we return back to the command line.

9. Edit your /etc/apt/sources.list to include the Percona repos:

$ nano /etc/apt/sources.list

and add the following lines to the end of the file (I haven't wrapped this in a code block to prevent the forum software changing the link text to anchors):

deb http://repo.percona.com/apt precise main
deb-src http://repo.percona.com/apt precise main

(remember to replace precise with the version of ubuntu you are actually using)

10. Now we need to add our repository keys for Percona:

$ sudo gpg --keyserver hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
$ sudo gpg -a --export CD2EFD2A | apt-key add -

11. Now lets make sure that Percona software is chosen for installation instead of any other mysql binaries that may be in the ubuntu repository.

$ sudo nano /etc/apt/preferences.d/00percona.pref

... and enter the following into the file:

Package: *
Pin: release o=Percona Development Team
Pin-Priority: 1001

12. Now lets update our apt cache

$ sudo apt-get update

13. And install the most recent stable version of percona:

$ sudo apt-get install percona-server-server-5.5 percona-server-client-5.5

14. During the install you will be asked for a *new* password for the root mysql user. Note this down!

15. If installation completes without errors, then go back to you browser and call up https://yourserver.com:10000 and log in with your root username and password (not the Percona one, we'll use that later)

16. Once logged in, click on the Webmin link in the top right to switch to that interface. Then, in the Servers sub menu on the left, choose MySQL Database Server.

17. You should now be asked for the Percona root username and password which you set during the install. Enter these here and if you got them correct, Webmin will connect to Percona just as it would its own MySQL server.

18. If you want to offer Percona MySQL dbs to your users, go back to the Virtualmin interface, and on the submenu System Settings > Features and Plugins, enable MySQL database. Virtualmin, should pick up the new root password that you set in webmin and virtualmin should now use Percona MySQL without a problem.

I think that's about it... good luck!!

Ross

Fri, 04/19/2013 - 06:11
mcmiazga

Is this same for MariaDB?

Topic locked