StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POImplement read only / write only database server architecture
primarykey
Id
12191071
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-08-30T06:29:40.973
FavoriteCount
0
LastActivityDate
2012-10-04T10:11:49.233
LastEditDate
2012-08-30T07:44:59.850
LastEditorUserId
13302
OwnerUserId
1287617
ParentId
0
PostTypeId
1
Score
1
ViewCount
530
LastEditorDisplayName
text
Body
We have an ASP.NET MVC3 Web Application which consists of following: <ul> <li>Website (MVC3)</li> <li>Data Access Service (WCF + EF)</li> <li>Database Server (SQL Server 2008 R2)</li> </ul> We were suggested to implement an architecture to the following for performance benefits: <ul> <li>Web Server Cluster (Website + Data Access Service) <ul> <li>It has Round Robin Load Balancing</li> <li>Each server in this cluster has a Cache (read-only) database</li> <li>We have a set of SPs that we can distinctly divide into two categories - Read SPs and Write SPs</li> <li>Each Read SP will connect to Cache DB and each Write SP will connect to Write DB</li> </ul></li> <li>Database Server(s) with Replication/Mirroring <ul> <li>This is the Write DB.</li> <li>Whenever it changes, it propogates all the changes to all the Cache DBs</li> <li>In addition to that, it has replication/mirroring implemented so it has backups when it goes down.</li> </ul></li> </ul> This is very rough idea and I am not sure it will give our system a performance boost. The argument in favor of it was 80% of the times, the operations are read-only. They can be made on Cache DBs (since there are configured to be read-only, they are faster). The other 20% can be made on Write DBs. But, I have following questions: <ul> <li>Read-Only Configuration: can we actually configure Cache DBs to be read-only? Since Write DB will need to push changes to them whenever it changes.</li> <li>Sync: with all this complexity over the network, how easy it is to make sure that everything is in sync? Network Latency: and what about network overheads to keep everything in sync?</li> <li>Complexity and Maintenance: is it really worth the added maintenance overheads and the added complexity to the system?</li> </ul>
Tags
<database><asp.net-mvc-3><architecture><sql-server-2008-r2>
Title
Implement read only / write only database server architecture
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USmarc_s
UserOwnerUserId
1. USSharp.Extensions
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POImplement read only / write only database server architecture
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.