I have a master database sharded by user_id, with globally unique IDs for
everything, except shared configuration data stored in global tables
(resources strings, system parameters, etc).
What would be the best (ie both fast and reliable, simple to maintain as a
bonus) to merge all shards into a single read-only slave that will then be
replicated and used for read queries ? I took a look at Londiste and
repmgr, and can see some ways to accomplish that, but would appreciate the
advice of people here.
Thank you,
Sébastien