cant we just create a symlink from /var/lib/mysql (first disk) to second hard disk, so that data will get spread across both disk.
regards anandkl On 10/14/08, Peter Farkas <[EMAIL PROTECTED]> wrote: > > Hi Ananda, > this is not too effective solution move some tables from first > database into second database whitch use storage directory where is > mounted only the secondary harddisk. > > I mean somethink like this: > your primary master db is /var/lib/mysql/db1 > after "create database db2" > stop mysqld > move content from dir /var/lib/mysql/db2 somewhere > mount second_hardisk into /var/lib/mysql/db2 > copy somewhere content into /var/lib/mysql/db2 > start mysql and create and import data for tables what you need > > But you need improve all queries between two databases db1 and db2. > Or if your app can by used as small part then you can move tables from > small apps into db2 etc. > > You can use second harddisk mounted in somewhere /mnt/hd*/dbX and use > 'mount --bind ..' to link second hd space to database folders > At the end don't forget add mounting rules for /var/lib/mysql/db2 to > /etc/fstab > > > On Tue, Oct 14, 2008 at 11:44 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > Hi Peter, > > R you trying to say to move data from disk1 to disk2. > > > > regards > > anandkl > > > > > > On 10/14/08, Peter Farkas <[EMAIL PROTECTED]> wrote: > >> > >> Hi, > >> You can mount second harddisk into /var/lib/mysql/db2 and after > >> migrate data from first db to db2. It's not a great solution but it > >> helps if you use only few databases. > >> > >> On 10/14/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > >> > Thanks a lot. > >> > > >> > On Tue, Oct 14, 2008 at 12:51 PM, Oto Buchta <[EMAIL PROTECTED]> > wrote: > >> > > >> >> Hi, > >> >> use software RAID in stripping mode. Linux can do the job well. > >> >> > >> >> If it is not a solution for you, try to use symlinks for directory > (it > >> >> works) > >> >> or tables (I'm not sure, if it does work). > >> >> > >> >> On Tue, Oct 14, 2008 at 11:03:30AM +0530, Krishna Chandra Prajapati > >> >> wrote: > >> >> > Hi, > >> >> > > >> >> > I have two hard disk on debian system. Each of 80GB. I want to use > >> >> > both > >> >> the > >> >> > hard disk for storing the *mysql data. *On one hard disk the data > >> >> > has > >> >> > reached up to 73GB. > >> >> > > >> >> > What changes, I can do to use both the hard disk for storing mysql > >> >> > data. > >> >> > Quick response is highly appreciated. > >> >> > > >> >> > Thanks > >> >> > -- > >> >> > Krishna Chandra Prajapati > >> >> > >> > > >> > > >> > > >> > -- > >> > Krishna Chandra Prajapati > >> > > >> > >> Peter > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >> > > > > > > regards, > > peter >
