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.
Subject
Views
Written By
Posted
4073
August 26, 2011 06:29AM
Re: Does my database server support partioning and Sharding
1653
August 27, 2011 09:01AM
1595
August 29, 2011 08:30AM
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.