Yes and no.. mySQL itself cannot do this.. If you need to keep growing in size (on 1 server) you may want to look at some kind of LVM disk array/SAN you can keep plugging in disks and extending the volume..
I do kinda of what you are looking for with 1 application, but it is all software controlled, mysql has no knowledge it's happening. There is 1 controller sql server that controls all the storage, it knows of multiple other sql servers and decides where to store data and where all the data is for retrevial. You need more storage, plug in another server, tell the controller it exists and it will start filling up with data and serving requests for that data. On Mon, 29 Dec 2003, Daniel Page wrote: > Hi, > > Is it possible to extend a MySQL database over several servers in such a way that > when space is exhausted on one server, a second machine can be added and used? > > Cordially, > Daniel Page > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]