Spider
Hi, we are looking for scale up options for mariadb. We wanted to try spider out but there was not enough information on this site. Some of the questions I had were what is the maxiumum number of nodes you can have. Does the database balance the shards, etc.? I am looking to see how much storage we can get out of spider. Can anyone out there help us with this request?
Answer Answered by Stephane VAROQUI in this comment.
Hi,
There is no maximum of nodes , giving that you can sub partition a spider table to an other spider table to overcome the 1024 partitions limit,
Distribution of data will reflect the underlying partitions that you have describe in your table definitions.
Writes become distributed , but for distributing reads you need to use spiral arms MariaDB release or wait that we merge the background search features. This should happen one day in an upcoming 10.1. as it is a task in progress.
Our biggest big data cluster is a 50 nodes cluster able to read 150 Millions records per second.
You can contact stephane@mariadb.com or Kayoko from spiral arms for additional information
