469,925 Members | 1,466 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,925 developers. It's quick & easy.

InnoDB & multiple mysqld's on 1 server

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

Jul 19 '05 #1
0 1631

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Nick Boudreau | last post: by
reply views Thread by unplug | last post: by
reply views Thread by Maciej Wiznerowicz | last post: by
reply views Thread by sean peters | last post: by
3 posts views Thread by Andy Tran | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.