MySQL Forums
Forum List  »  Partitioning

Re: Does my database server support partioning and Sharding
Posted by: Rick James
Date: August 27, 2011 09:01AM

> 1).Does this version of the database support "Partitioning" and "Shards" ?

PARTITIONing was implemented in 5.1. But, I have to ask "Why do you want partitioning?" Many DBAs launch into partitioning thinking it is a panacea. It is not.

The NDB Cluster "engine" in MySQL 5.0 implements a flavor of sharding, in that it has the data spread across a 'cluster' of servers.
Otherwise, no version automatically handles sharding.

5.0 is on its way out. Lots of installations will still be running it years from now, just as there are many sites still on 4.1 or older versions.

5.5 is reasonably production-ready. I have heard of a few glitches, but no show-stoppers.

5.6 is in the pipeline.

Options: ReplyQuote

Written By
Re: Does my database server support partioning and Sharding
August 27, 2011 09:01AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.