Improving the Performance of Servers by Implementing the Manual Log Shipping for Large Databases
Journal Title: International Journal of Computer Science and Management Studies (IJCSMS) www.ijcsms.com - Year 2012, Vol 12, Issue 2
Abstract
Business success, the need to ensure 24x7availability is greater than it has ever been. One common method for as database systems become more and more critical to providing 99.99%, or "4-nines" availability, is to implement a "warm" standby database server. The use of standby servers is not a new concept; database administrators (DBAs) have been using them for years. Typically, standby servers require the DBA or operator to create backups of the database and logs on the primary system and then restore these backups on a standby server on a regular basis. If the primary server fails, the down time is isolated to the amount of time required to process the log files since the last backup was restored on the standby server. Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the Secondary databases individually. An optional third server instance is known as the monitor server records. The history and status of backup and restores operations and, optionally, raises alerts if these operations fail to occur as scheduled. We can improve the functionality of our Log Shipping manually so that back up is made quickly and making it quick, we insert some manual codes. Implementing Log Shipping for small databases is relatively straightforward as one can easily do it using the GUI but for large database, the GUI is not a good option as the database on the destination server will be always out of sync. So a question arises how do we accomplish this task? In this paper, we are going to explain you the detailed steps which we followed to implement the log shipping for our large databases manually and improving the performance of our servers.
Authors and Affiliations
Anil , Parveen Yadav , Balraj Sharma , Vinit Lohan
Keywords
Related Articles
- EP ID EP135388
- DOI -
- Views 84
- Downloads 0
An Intelligent Fuzzy Based Scheme To Analyze Heart Diseases
The main objective of this research work is to define some fuzzy based ruleset to identify the patient disease based on person medical related information. This information includes the person age, calestrol level, heart...
Implementation of Selenium with JUNIT and Test-Ng
Software testing is complex and time consuming. One way to reduce the effort associated with testing is to generate test data automatically. Testing is very important part of software development. Quality is not an abs...
A Survey on Security Issues in Mobile Ad-hoc Networks
Current technologies and security advances have made networks systems and applications very popular and widely used. The pervasive and practical aspects of wireless Mobile Ad Hoc Networks (MANET) made them very popular a...
Influence of Social Networking Sites in Brand Development Practices from Marketer’s Prospective
Popularity of social networking sites with deeper penetration of internet enables marketers to exploit it as new emerging medium for brand developing exercises. Interaction of social networking sites with brand results i...
Contract Farming: The Survey on Different Issues
In India, 70-80% population of the country depends directly or indirectly to farming. So this field is very much important for research and the concept of contract farming is more important for farmers and other person...