General discussion

Locked

client/server enterprise database

By stacyg ·
I have multiple sites that will need to share a SQL database. The sites are connected via 4 channels of a T1 (256K). The database currently resides on one NT server at one site. How would all users at all sites be able to use this database without increasing the bandwith? If replication is the answer, how does this work?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

client/server enterprise database

by j.monty In reply to client/server enterprise ...

You can't get to the data without increasing bandwidth somehow.. Replication would increase bandwidth since database updates would be sent over the wire. However, If you are doing lots of queries to the data, it will still be less bandwidth increase than if you were to access one DB server.
You could create your application to do as little as possible over the network, but I think replication is your best bet. One master DB synchronizes at regular time intervals with the other servers. Some nasty problems can arise when more than one person modifies a record, but the DBMS usually takes care of that to some degree.

Collapse -

client/server enterprise database

by stacyg In reply to client/server enterprise ...

The question was auto-closed by TechRepublic

Collapse -

client/server enterprise database

by hansz In reply to client/server enterprise ...

I am afraid there are not straightforward answers to the question(s). Normally it wouldn't be a problem for all users to use the database, but you can imagine that large amounts of users might require an increase of bandwith. It all depends on the level(s) of performance and service you would like to provide. Replications could be a solution to keeping bandwith low. However, again, this depends on levels of service. How often accurate should the data be? Must it be up-to-date to the minute, or is yesterday's data up-to date enough? Will all databases have to replicate with each other, or is there one masterdatabase? The way replication is handled differs per database, but in many occasions includes use of replicationserver(s) next to the DBMS as far as my experience goes.

Collapse -

client/server enterprise database

by stacyg In reply to client/server enterprise ...

The question was auto-closed by TechRepublic

Collapse -

client/server enterprise database

by stacyg In reply to client/server enterprise ...

This question was auto closed due to inactivity

Back to Networks Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums