Re: Merge a sharded master into a single read-only slave

On 6/1/2014 12:59 PM, Sébastien Lorion wrote:
> it would have been nice to avoid the additional complexity if it had
> been possible to merge sharded tables on a binary level (which should
> be much faster than statement level), given that their records will
> never overlap (i.e. the same record is never present in many shards).

not even remotely possible, since binary replication is at a block
level, NOT a tuple level...   Also, the index on this merged table will
be considerably different than the index on any one of the sharded
'masters' (and in binary replication, indexes are also block replicated).



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast