Click here to Skip to main content
15,891,136 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
AnswerRe: Performance in Web applications versus Web site projects in Visual Studio Pin
Paul Conrad1-Aug-08 8:28
professionalPaul Conrad1-Aug-08 8:28 
AnswerRe: Performance in Web applications versus Web site projects in Visual Studio Pin
Paul Conrad1-Aug-08 8:29
professionalPaul Conrad1-Aug-08 8:29 
AnswerRe: Performance in Web applications versus Web site projects in Visual Studio Pin
Nicholas Butler1-Aug-08 22:34
sitebuilderNicholas Butler1-Aug-08 22:34 
Questionwant to create a cms in asp Pin
nibinki33331-Jul-08 8:04
nibinki33331-Jul-08 8:04 
QuestionRe: want to create a cms in asp Pin
led mike31-Jul-08 8:39
led mike31-Jul-08 8:39 
AnswerRe: want to create a cms in asp Pin
Paul Conrad2-Aug-08 18:50
professionalPaul Conrad2-Aug-08 18:50 
AnswerRe: want to create a cms in asp Pin
alex.barylski12-Aug-08 22:46
alex.barylski12-Aug-08 22:46 
QuestionDynamic DB Connection based on user type Pin
vicky45730-Jul-08 19:30
vicky45730-Jul-08 19:30 
I need to create an application: upon user login, check the user type and decide the database that application will use for that user. Here is what I have:
1: Master database: stores user information and application configuration data, such as which db to use and connection string
2: Database I on server 1: contains all the application data for user group I.
3: Database II on server 2: contains all the application data for user group II.
4: Database I backup on server 2: as backup for user group 1 in case server 1 fails.
5: Database II backup on server 1: as backup for user group 2 in case server 2 fails.
6: Through log shipping between server 1 and server 2 to keep DB I and I and their backup up-to-date.
7: The web site is running on web farm. The session state management is using SQL server session state management, which is on the same server as Master DB.

My questions are:
1: How do I determine if server 1 or server 2 is down and it's time for application switching to use the DB backup on the other server.
2: What to do if the master DB server is down?
3: Is there a better approach than the above design to achieve the same goals: using different DB for different users, and achieving fast recovery by using the backup server?

I would really appreciate any suggestion and help!

Thanks in advance!
QuestionRe: Dynamic DB Connection based on user type Pin
led mike31-Jul-08 7:23
led mike31-Jul-08 7:23 
AnswerRe: Dynamic DB Connection based on user type Pin
vicky45731-Jul-08 10:31
vicky45731-Jul-08 10:31 
AnswerRe: Dynamic DB Connection based on user type Pin
Mark Churchill2-Aug-08 18:05
Mark Churchill2-Aug-08 18:05 
QuestionBig Desktop Database Application - Architecture Help needed [modified] Pin
abhijitbkulkarni24-Jul-08 2:39
abhijitbkulkarni24-Jul-08 2:39 
AnswerRe: Big Desktop Database Application - Architecture Help needed Pin
Pete O'Hanlon24-Jul-08 8:49
mvePete O'Hanlon24-Jul-08 8:49 
GeneralRe: Big Desktop Database Application - Architecture Help needed Pin
abhijitbkulkarni24-Jul-08 10:17
abhijitbkulkarni24-Jul-08 10:17 
GeneralRe: Big Desktop Database Application - Architecture Help needed Pin
Paul Conrad27-Jul-08 13:41
professionalPaul Conrad27-Jul-08 13:41 
QuestionDogfooding? Pin
Philip Laureano22-Jul-08 11:38
Philip Laureano22-Jul-08 11:38 
AnswerRe: Dogfooding? Pin
Pete O'Hanlon23-Jul-08 9:42
mvePete O'Hanlon23-Jul-08 9:42 
GeneralRe: Dogfooding? Pin
Philip Laureano27-Jul-08 13:35
Philip Laureano27-Jul-08 13:35 
QuestionQueue or how to syncronize without locking [modified] Pin
dotnetCarpenter20-Jul-08 11:04
dotnetCarpenter20-Jul-08 11:04 
AnswerRe: Queue or how to syncronize without locking Pin
dotnetCarpenter21-Jul-08 0:45
dotnetCarpenter21-Jul-08 0:45 
GeneralRe: Queue or how to syncronize without locking Pin
dotnetCarpenter21-Jul-08 5:56
dotnetCarpenter21-Jul-08 5:56 
QuestionThumbnail image or Control Pin
netJP12L17-Jul-08 9:52
netJP12L17-Jul-08 9:52 
AnswerRe: Thumbnail image or Control Pin
Pete O'Hanlon17-Jul-08 9:58
mvePete O'Hanlon17-Jul-08 9:58 
GeneralRe: Thumbnail image or Control Pin
netJP12L17-Jul-08 10:04
netJP12L17-Jul-08 10:04 
GeneralRe: Thumbnail image or Control Pin
Pete O'Hanlon17-Jul-08 10:06
mvePete O'Hanlon17-Jul-08 10:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.