Its possible, but very much NOT a good idea.

C5 makes so many database requests that having a MySQL server on remote hardware will result in appalling performance.

Sites always work best if the database is co-resident.

Hi JohntheFish,

Thank you for the information. Is there any document that I can refer to in using the Remote SQL?

Thank you.

Question is how "remote" it is.

You must have MySQL server within the same server or same internal network.

If you want to set up a MySQL server over the internet, The speed become too slow to load a page.

I've tried to set up a Amazon AWS MySQL and concrete5 site on other hosting provider in Japan. I was able to connect between two servers. But the connection speed was too slow.

You cannot do it.

It can be done but as others have mentioned you want to make sure latency is as low as possible between your web server and your mysql server (Usually on the same physical hardware or at a minimum in the same data center). Having much more than 1ms latency between the two will drastically impact performance.

When you install concrete5 it asks you for your MySQL host name, simply punch in the mysql server's IP address and mysql credentials on setup. If you already have concrete5 installed and want to move the database look at /application/config/database.php on your web server and you can modify that to point where you need it to.