Database Sharing

[jackal]

We have 2 servers which have different main domain names on for our support section.
How would we link both sites to use same database?
We would need when a post is made on either to update the other.

Any would be appreciated.
Thx

 

[jackal]

Ok that is good. Where would we get such a script that would accomplish this?

 

[X-Istencedotcom]

Lets say you have 2 servers.

1. myserver.com
2. myotherserver.com

Then make the script on myotherserver.com connect to the MySQL server on myserver.com and have the script on myserver.com also connect to localhost, basically both scripts now write and read from the same database, meaning there is only one database to keep up to date for the script .

 

[Express]

So would this work for what he wants?


Server A Set % wildcard

$servername="localhost";
$dbusername="name_admin";
$dbpassword="pass";
$dbname="name_forums";

Server B

$servername="ipaddressofservera";
$dbusername="name_admin";
$dbpassword="pass";
$dbname="name_forums";

 

[jackal]

If we did that yes it would work, but we have 15 dbs we only want to share one db. So what file would I add or change just to access that one db and not have open access to all?

 

[perfectsquare]

Add a new db_user that has access to only the database you want to share.