Separate SQL server for each domain

[friendlymoron]

I have a PLESK account which hosts 5 domains, can i set up an individual SQL server running for each domain rather than have it sharing by 5 domain? Thanks.

 

[DCNet_James]

Why on earth would you want the overhead of doing that? If you were to do this, do it on a dedicated machine and setup 5 startup scripts for mysqld to listen on 5 different ports, each with their own data directory. Like I said, sounds like a goofy and not sure why you would want to do this. Setup a dedicated database machine or machines and run mysql or a mysql cluster and map the remote mysql server through the PSA control panel. Thats how I do it, and I have 0 problems with many high traffic sites many using large databases.