faqts : Computers : Databases : MySQL : Installation and Setup : High Demand

+ Search
 Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

8 of 10 people (80%) answered Yes
Recently 6 of 8 people (75%) answered Yes

Entry

What are the issues with having several MySQL instances over the same file system?
Should I use replication or have several MySQL instances running over the same file system?

May 13th, 2000 02:07
Nathan Wallace, Sasha Pachev
 


The reason the above is not the best thing to do is the file locking
issues.  File locking is very slow. Another problem is that this set up
is not very well tested.

It would be much better to  run one instance of myslqd per server, have
several servers, and use replication.