Setup Percona Database - charleshross/soarin GitHub Wiki

This guides assumes you have already installed a fresh copy of Debian Linux Wheezy 64bit (https://www.debian.org/distrib/netinst) on your server or virtual machine.

• Words like this are commands to run on your server or virtual machine.
• The 'pico' text editor used in this documentation comes with Debian and is super simple to use. To open a file just type pico [location of your file]. Use arrow keys to navigate, and in order press "[CTRL]+[X], [Y], [ENTER]" to save file changes.

To begin installing, SSH into your Linux Debian server as root.

Percona Server

---

Percona Server is a well maintained fork of MySQL, a relational database for storing your web data long term in a structured format. Percona's version comes with many important improvements/tools that are missing from vanilla MySQL. It should interop perfectly and programs should treat it just as they would MySQL without modification. If you'd rather install vanilla MySQL you can find those install instructions here: https://github.com/charleshross/soarin/wiki/Setup-MySQL-Database.

Installing Percona Server From Binaries

---

Add the Percona signed key to your apt.

apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A

Edit /etc/apt/sources.list and add these lines to the bottom

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

Update the local cache

apt-get update

With the repo setup, install Percona

apt-get install percona-server-server-5.6

You will be prompted to setup a password for the MySQL 'root' account. After that everything should be installed and running.