Re: Question about Number of Partitions for "partition by key"

[Mike van Lammeren]

Sounds good to me! I'm always happy to let MySQL Cluster do the hard work.

Mike van Lammeren


On Fri, Nov 6, 2009 at 11:38 AM, Andrew Morgan <Andrew.Morgan@stripped>wrote:

> Hi Mike,
>
>  You should just let Cluster work out how many partitions you should have.
> If you add another node group in the future then Cluster will adjust the
> number of partitions when you follow the on-line add-node process;
> available
> with MySQL Cluster 7.0 and described in this white paper:
>
> http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster7_architecture.p
> hp
>
> Regards, Andrew.
>
> > -----Original Message-----
> > From: Mike van Lammeren [mailto:mike@stripped]
> > Sent: 06 November 2009 16:29
> > To: cluster@stripped
> > Subject: Question about Number of Partitions for "partition by key"
> >
> > Hello!
> >
> > I'm in the very early development stage of a project that is using
> > MySQL
> > Cluster. After reading Andrew Morgan's blog about partitioning, (
> > http://www.clusterdb.com/mysql-cluster/intelligent-user-controlled-
> > partitioning-and-writing-distribution-aware-ndb-api-
> > applications/<http://www.clusterdb.com/mysql-cluster/intelligent-user-
> > controlled-partitioning-and-writing-distribution-aware-ndb-api-
> > applications/#comments>),
> > I added *'pa**rtition by key'* to my tables, wherever appropriate. The
> > *explain
> > partitions* command is particularly helpful.
> >
> > Recently, I used MySQL Workbench to make some nice pictures for our
> > documentation, and for the first time, noticed that you can specify the
> > number of partitions used for the *'p**artition by key'* command. Which
> > leads to my question:
> >
> > How many partitions should I set?
> >
> > Is it best to just leave the *'partition**s'* phrase off the table
> > definition? If I do, what does MySQL Cluster set by default?
> >
> > I currently have two data nodes. In the future, when I add a data node,
> > what
> > do I do with the number of partitions? Does it have to match the number
> > of
> > data nodes?
> >
> > Mike van Lammeren
>
>