| Author |
 Topic  |
|
|
putrtek
Starting Member
2 Posts |
 Posted - 07 April 2004 : 20:42:50
|
First off I want to say that Snitz Forums is an AWESOME app. I been running the forum on my Intranet for the last 3 years and it runs great. It's very popular and gets lots of usage. Thanks for a great App. 
I'm running a W2K Web Server and a W2K SQL server with the most current version of Snitz. I have gotten to the point where I need to bring up another web and sql server from failover, redundancy and load balancing. I would like to replicate my current Snitz forum DB to another sql server so I can point differant users to differant SQL servers but still all use the same data. Has anyone done this? Is it possible? Got any tips, tricks or gotcha's? Any directions specific to Snitz I can read?
I downloaded a KB article from MS on how to setup Replication and it was 14 pages long. Needless to say I'm a little intimidated as I have never done this before. I'm just looking for some reading material I can check out before I attempt this. Any suggestions will be gratefully accepted!
-MARK- |
Mark Buckley
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 April 2004 : 21:27:06
|
| Replication is a somewhat complex subject. I would advise you to study it carefully before proceeding. I don't know that many online places where you can find info, since I usually prefer a book, but you can always try www.sqlteam.com, which is a great site about SQL Server. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 08 April 2004 : 03:17:51
|
| why would you want to point different users to different servers but use the same db, that doesn't make sense, why not point them all at the same server |
|
|
|
putrtek
Starting Member
2 Posts |
Posted - 09 April 2004 : 19:53:43
|
OK, maybe I didn't explain my situation correctly. I have users on both the east coast and the west coast who right now access the Forum via a a web Server and a sql server on the east coast. My plan is to stand up another web server and a sql server on the west coast. I want users from the west coast to hit the Web and sql server in the west and users from the east to hit the web and sql server in the east. Users on both coasts need to be able to see, edit, create and reply the same posts.
Pointing users to a differant server depending on thier location is fairly simplly with DNS. We have already tested that part and it works. The problem is that right now my west coast users are hitting the west coast web server but coming back to the east coast for the sql data. They are complaining of latency. The only way I can see to resolve this is to replicate the forum DB to the west coast sql server. I hope that explains things a little better.
|
Mark Buckley
|
|
|
| |
Topic |
|
Topic Locked
