Remote SQL Query

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
SidewinderX
Forum Contributor
Posts: 407
Joined: Fri Jul 16, 2004 9:04 pm
Location: NY

Remote SQL Query

Post by SidewinderX »

Its real simple, I have two servers (lets call them Server A and Server B). Server A acts as an engine and gathers a bunch of information. Would it be better to have Server A update Server B's database, or have Server B connect to Server A's database? In terms of security/efficency.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Which server needs to maintain its security more? That server should contact the other. ... however with databases, replication is often suggested. In this case, since Server A is the main database, Server B would be a slave and receive replication information from Server A.
Post Reply