Re: Cluster synchronize


mukesh.thiru@xxxxxxxxx wrote:
> I have an architecture which has 4 DB servers on the whole; two will
> participate in load balancing and other two in fail over clustering.
>
> My question is how will the two DB servers that is used for load
> balancing synchronize?

If you are using SQL server 2005, you might want to consider using read
only shared databases for your reporting . Using a shared file system,
all the nodes can see the same database files which are read only, and
mount the database as read only. You could run reporting quaries
against up to 16 nodes archiving close to 16X speedup.

If your update cycle and reporting cycle do not overlap, switching
between the read write to read only (and back) takes about 20 seconds.
Note that no replication is needed and no storage space is wasted.


Tomer Meshorer
Database Engineer
Polyserve Inc (http://www.polyserve.com)
Email:tmeshorer@xxxxxxxxxxxxx

.

Relevant Pages

  • Re: Distributed chat server
    ... That's certainly the most common option, and how the majority of IM servers ... If you need geographic isolation, or cannot share a database, you're going ... several servers for availability and load balancing. ... Now arises the problem of how to synchronize the servers in the ...
    (microsoft.public.dotnet.languages.csharp)
  • Add user to RO Database
    ... shipping to 2 servers. ... On the reporting server, the database is in Read-Only mode. ...
    (microsoft.public.sqlserver.security)
  • Re: Read Only Reporting Server Active/Active Configuration
    ... Is this also supported for SQL 2000 or just SQL 2005? ... If reporting really needed to scale and the reporting requirements for ... TX Database - 2-Node Active/Passive ... servers are accessing a read-only volume. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Permissions
    ... servers are available to service the logon request. ... - Make certain that WINS database replication is successful between WINS ... Domainregistrations that are not listed in the ... If you are logged on as an administrator at a Domain Controller, ...
    (microsoft.public.win2000.security)
  • RE: Permissions
    ... >servers are available to service the logon request. ... >database does not have the proper domain registrations ... >If you are logged on as an administrator at a Domain ...
    (microsoft.public.win2000.security)
Loading