Skip to main content

Database Replication

         

Database Replication enables data from one data server (master) to be copied to one or more database (slave) servers. Depending upon the configuration asynchronous or synchronous replication is possible. You can replicate all databases or single database or single table.
          There are two types of replication
  • Statement Based                    
Every query excluding Select Query is executed on Master Server First then logged  binary file and then executed on  Slave Server. So Logged file is small.
  • Row Based.
Every change in Master Server row is logged and only that is effect executed on Slave. So Logged file is big.

Advantages of Database Replication
  • Scale-Out Solutions
                         All the data writes and update of Master Server and Read can be distributed on slaves. So load can be distributed among the Servers.
  • Data Security
                          Data is replicated to Slave Servers. Slave can stop replication. Run backup services  without corrupting Master Server Database.
                       
Labels:

Popular posts from this blog

India's Top Sugar Companies by Net Profit

1. Balrampur Chini Mill http://www.chini.com 2. Dalmia Sugar 3. Dwarikesh Sugar http://www.dwarikesh.com 4. DCM Shriram http://www.dcmshriram.com/sugar
Read more

Use of Professional Business E-mail for official communication

Use of Professional Business E-mail for official communication E-Mail everybody’s cup of tea Communication between the organizations is very much different in many sense. Organization conveys official issues related to important matters. It is difficult for somebody to authenticate the E-Mail addresses. As personal e-mail addresses are maintained by their respective sites, it is difficult to control its use. Many of times when somebody joins the organization or leaves from the organization, it becomes uneasy to communicate. Business E-Mail makes the sense Domain based e-mail services are used by many organizations for office communication.e.g. if some organization has domain www.swapp.co.in   then email address would be admin@swapp.co.in , purchase@swapp.co.in, services@swapp.co.in, sandeep.nigade@swapp.co.in,etc. Storage size can be increased accordingly and user management is controlled by IT Dept. Mails are in encrypted format, so no need of worry. So on...
Read more

How to Add Website Shortcut on Desktop?

Step 1 You should have Google Chrome browser installed. If not please download Google Chrome. Step 2 Then start Google Chrome browser and enter the website address to open the website. Step 3 Click the option as it shown in the following image to get the drop down menu. There select "More tools" option. Step 4 You will see the another drop down menu. Here click on "Add to desktop" option. Step 5 Following window will appear, there tick the "Open as window" if you want separate windows for desired website and keep tick blank if you want it in new tab and then Click on Add button. Step 6 Please go to desktop and see whether shortcut is appreared or not
Read more