I generally don't recommend remote database instances with CMOD, as it adds complexity and latency. Any network-related glitch can disconnect CMOD from the database, leading to availability issues for end users, and issues recovering transactions (loads, activity logs, etc.)
-JD.