I’m running a search engine for realestate and I am in the process of acquiring a new server.
My search engine process is very well suited for parallelization, therefore I want to know how I can tweak mysql to use this in an optimal way.
I’ve noticed that on my present server mysql only uses one processor, the other is not used at all…
I see a possible number of possibilities:
putting different databases on different hard drives so read/write can be made fully parallel.
for each database running a different mysqld on its own port.
configuring my linux server so that it consist of (say) 4 virtual linux servers. Then on each of these 4 servers I install mysql for a different database.
I haven’t been able to find any references on this subject.