Hi all, i've been weighing the pros and cons of running multiple concurrent
mysqld's on one server, to have better control over what databases are on
what physical disks.
System: 4 processor sun box running solaris with eighteen 36Gb drives.
The situation is that i have a bunch of databases on one server that can all
be classified as either external use or internal use. The internal use
databases are consistently hit pretty hard, and we want this to have minimal
impact on the external use databases. Currently we're using 64 index MyISAM
tables, and with carefully choosing mount points for various physical
devices, we have the databases separated as we want them.
It is my understanding that with InnoDB, all tables are put into the
configured InnoDB file(s) together, which would violate what i am trying to
accomplish.
The only solution i have come up with to control the physical location of
InnoDB databases is to run multiple mysqld servers, each one with its InnoDB
files on the desired device.
Has anyone experienced any success or failure with this sort of configuration?
This is the only reason holding us back from using InnoDB tables for this
server. (we're using them on other machines)
Thanks much!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw