O'Reilly logo

MariaDB High Performance by Pierre MAVRO

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

Creating your first shard

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required