By "partitioning", you mean having one table divided across N partitions?
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 partitions. -JF > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 09, 2003 1:59 PM > To: [EMAIL PROTECTED] > Subject: Re: Distributing a DB > > > In a message dated 9/9/03 4:52:53 PM Eastern Daylight Time, > [EMAIL PROTECTED] writes: > > > If you're accessing your db through JDBC, an idea that I've > been following > is > > 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?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
