General discussion


Possible mirroring!

By Whatme? ·
Looking for a solution to Web site-database mirroring? 5 geographic sites w/ wan connectivity but slow. I was looking at 3rd party software to "mirror" my web site and a "cached" version of our database. Has anyone done this successfully nad or what softawre? I am wondering about simply inserting the website "folder" in a DFS folder. The web folder ad cached database folder is in one folder. There probably is a better way to go but I was wondering if anyone has tried this yet?
Our reason. 5 sites..... very slow links. Each site is OK to work on their own for several hours.
This is a W3k AD single domain private farme relay sites.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by mshavrov In reply to Possible mirroring!

Do your websites have read-only access to the database, or they need to write something back? If you have read-only access, you may just stop your SQL database once in a while, and copy your "master" database to your "backup sites". However if your data changes a lot, and you need to have a fresh copy on every website, it may be time and bandwidth consuming.

As I understand, you are using W3K with IIS, and I assume you use Microsoft SQL server. You may use the Microsoft SQL server internal functionality to create "Subscription" from your "backup sites" to your "master site". If you have read-only data, you may create one-way synchronization, and if you have to write something back, you may create two-ways synchronization between your master database and subscribers. Synchronization could be set up as a scheduled update, and will transmt only changes.

Hope this helps,

MCSE W2K, MCSE+I, MCDBA, Security+, CCNP, CCDP, CCSP, etc.

Collapse -

by Whatme? In reply to Possible mirroring!

Subscriptions on another SQL server is OK, but what is more important I feel is the Web server. I was hoping a user could access a local web server so web site mirroring was more important.

Related Discussions

Related Forums