RE: Distributing a DB

2003-09-09 Thread Jon Frisby
> I've read about using symbolic links, but only for using > multiple data > directories, not splitting a file (not to mention, across > more than one node). Symlinks wont work for splitting a file... > Since MySQL doesn't directly support this, any ideas on doing > it at the OS > level t

Re: Distributing a DB

2003-09-09 Thread Tbird67ForSale
In a message dated 9/9/03 7:53:59 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: > By "partitioning", you mean having one table divided across N > partitions? Yes, I do. > > Such a feat isn't directly possible with MySQL, however you can create N > tables instead of 1, and use a table

RE: Distributing a DB

2003-09-09 Thread Jon Frisby
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 Dayl

Re: Distributing a DB

2003-09-09 Thread Tbird67ForSale
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'

RE: Distributing a DB

2003-09-09 Thread Dan Greene
If you're accessing your db through JDBC, an idea that I've been following is the c-jdbc project... 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