Aug 16

Scaling Out #38

Methods

  • SQL Server instances
  • Clustering
  • Database mirroring
  • Log shipping
  • Replication
  • Shared scalable databases
  • SQL Server instancesIn the same computer install multiple instance of SQL Server to take advantage of multiple processors. Each instance may use separate processor with separate lock manager, worker threads, tempdb system database.
  • ClusteringFailover Clustering can provide robustness and protection against failure. Clustering can provide scaling using spare hardware through passive nodes
  • Database mirroringWith database mirroring transaction logs are directly sent to the mirror. The mirror is up to date and can be used in case of failure of the principle server.
  • Log shippingIt depends on the transaction log backups, file copying. The secondary database need not to be updated in real time. The secondary database is read only and hence, be in great use for reporting purposes.
  • ReplicationMerge Replication: Both way, both from and to publishers and subscribers
    Transactional Replication: Publisher to the subscriber
  • Shared scalable databasesScale out a read-only database only for reporting purposes.

    • From: http://sitestree.com/?p=4806
    Categories:38
    Tags:
    Post Data:2007-05-23 02:02:25

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>