Splitting MySQL across HDs?

Say you have a database "website" and a database "forum" and you want the website DB to reside on one harddrive and the forum DB on a second one for performance reasons. Is it possible to do that? Possibly by specifying two datadirs?

Or would that require running two instances of mysqld and specifying different datadirs to them? And on that train of thought, would it maybe even be better for performance to run two instances of it?

 

 

 

 

Top