Different host Same database?

[Derrian]

Is it possible for me to have an install of ZC on two different hosts. And have them use the same database?

I'm mainly doing this so both sites can use their own template.

I looked at Multi Sites but that has sites on the SAME host or pointing to the same host.

For me
site1.com is on Visi and has the database
site2com is on godaddy and I want to point it to the database of site1.com

Everything will be the same admin wise I just need these sites separated by host and files and then link the databases.

Thanks!
Joelle

[DrByte]

If you were to do that, you'd be forcing your customers to wait a lengthy period of time for your server to do all its database queries across a (slower-than-if-it-were-on-same-server) internet connection. While it "can" be done, it's *strongly not recommended*, and has several caveats.
Doing it requires editing your configure.php files to point the DB_xxxx settings to the other server, and you also need to open the other server's firewall to allow direct remote access to the server's database from internet connections. All your database data will be transmitted in clear text, with no encryption protection. All your admin settings will be shared exactly between both sites, so you will have limited branding differentiation available. There will be various other limitations too, related to order processing.