Creating your first shard

You're now ready to create your first shard! It is not a complicated thing. In previous chapters, we talked about load balancers like HAProxy. This is a quite similar usage here as Spider will proxy (and of course split) data to several backend servers.

We will start with a simple setup:

As you can see, a Spider server (spider1/192.168.33.31) will split data across our first backend (backend1/192.168.33.41) and the second backend (backend2/192.168.33.42).

The first thing to do is to create a Spider user to allow it to write on the backend servers. On all backends, create a Spider user with all rights to make it simple (more restricted rights are strongly recommended of course):

MariaDB [(none)]> create user 'spider_user'@'192.168.33.31' identified by 'password';
MariaDB [(none)]> grant all privileges on *.* to 'spider_user'@'192.168.33.31' identified by 'password';
MariaDB [(none)]> flush privileges;

Change the password to a better one. On all backends, we...