By "partitioning", you mean having one table divided across N
Such a feat isn't directly possible with MySQL, however you can create N
tables instead of 1, and use a table of Type=RAID on the master to
"unify" them for purposes of queries that need to access data from many
> -----Original Message-----
> From: Tbird67ForSale@stripped [mailto:Tbird67ForSale@stripped]
> Sent: Tuesday, September 09, 2003 1:59 PM
> To: mysql@stripped
> Subject: Re: Distributing a DB
> In a message dated 9/9/03 4:52:53 PM Eastern Daylight Time,
> dgreene@stripped writes:
> > If you're accessing your db through JDBC, an idea that I've
> been following
> > the c-jdbc project...
> Very nice, but we will be using LAMP (Perl and PHP). :-/
> > http://c-jdbc.objectweb.org/
> > it's software raid clustering for databases... it's still
> in beta, but it
> > looks very promising for easy clustering. Combined w/
> MySQL's master/slave
> > setup, it could be a very robust solution...
> Interestingly comparable...
> > it basically creates a virtual db out of the connected
> machines, to the
> > point where you can have different tables on different boxes.
> Sounds very similar, but I need true partitioning, not
> separate tables.
> > It's at least worth looking into....
> Sure is, thanks.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?> unsub=jfrisby@stripped