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 (
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 ...