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;