# Installing Percona XtraDB Cluster

This is a guide about installing Percona XtraDB Cluster on 3 Debian jessie servers.

## Preparations

We need 3 Debian jessie machines, preferably on the same network:

* db01.example.com
* db02.example.com
* db03.example.com

### Prepare /etc/hosts

On db01:

```
127.0.1.1 db01.example.com db01
127.0.0.1 localhost
10.10.10.2 db02.example.com db02
10.10.10.3 db03.example.com db03
```

On db02:

```
127.0.1.1 db02.example.com db02
127.0.0.1 localhost
10.10.10.1 db01.example.com db01
10.10.10.3 db03.example.com db03
```

On db03:

```
127.0.1.1 db03.example.com db03
127.0.0.1 localhost
10.10.10.1 db01.example.com db01
10.10.10.2 db02.example.com db02
```

### Setup the FW

On db01:

```
ufw allow from 10.10.10.2
ufw allow from 10.10.10.3
```

On db02:

```
ufw allow from 10.10.10.1
ufw allow from 10.10.10.3
```

On db03:

```
ufw allow from 10.10.10.1
ufw allow from 10.10.10.2
```

## Install Percona XtraDB Cluster


### Setup debian repositories

Run these commands on all nodes.

* Download the percona relese .deb:

```
wget https://repo.percona.com/apt/percona-release_0.1-4.$(lsb_release -sc)_all.deb
```

* Install the package:

```
dpkg -i percona-release_0.1-4.$(lsb_release -sc)_all.deb

* Update APT:

```
apt update
```

### Install the package

```
apt -y install percona-xtradb-cluster-57
```

Enter and verify the *root* user password when prompted.

**Error: We get this in the logs:**

> 2017-08-13T07:54:38.438122Z 12 [Note] Access denied for user 'root'@'localhost' (using password: NO)

References
----------
* https://www.percona.com/doc/percona-repo-config/apt-repo.html
* https://www.percona.com/doc/percona-xtradb-cluster/LATEST/install/apt.html