I'm trying to implement a mariadb sharding for learning purpose. I have looked into database sharding in general and found mariadb spider storage engine support sharding. I do not want spider storage engine and like to test tokudb storage engine due to it's high performance. I plan to shard a simple database over two separate VM instances. My questions are,
- Can someone point me good tutorial or book to archive this ?
- PostgreSQL support connection pooling and load balancing tools ( ex: pg-pool) . Does mariadb has tools like this ?