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

All India Fair and Remunerative Price (FRP) for Sugarcane Crushing Season 2017-2018

All India Fair and Remunerative Price (FRP) for Sugarcane Crushing Season 2017-2018
Basic rate of Rs.255 per qtl, subject to a premium of Rs 2.68 per qtl for every 0.1 percentage point increase in recovery above 9.5 per cent. SAP for respective states may differ the effective sugarcane price.

Table of Recovery, FRP per Qtl and  FRP per Tonne

Recovery (%)FRP per Qtl(Rs.)FRP per Tonne(Rs.)9.5255.002550.009.6257.682576.809.7260.362603.609.8263.042630.409.9265.722657.2010268.402684.0010.1271.082710.8010.2273.762737.6010.3276.442764.4010.4279.122791.2010.5281.802818.0010.6284.482844.8010.7287.162871.6010.8289.842898.4010.9292.522925.2011295.202952.0011.1297.882978.8011.2300.563005.6011.3303.243032.4011.4305.923059.2011.5308.603086.0011.6311.283112.8011.7313.963139.6011.8316.643166.4011.9319.323193.20123223220.0012.1324.683246.8012.2327.363273.6012.3330.043300.4012.4332.723327.2012.5335.403354.0012.6338.083380.8012.7340.763407.6012.8343.443434.4012.9346.123461.2013348.803488.0013.1351.483514.8…
Read more

Sugar Industry / Factory Important Website List

Scattered information we get from everywhere. Better it to get it from authentic sources. But to know it difficult to reach the source, it is to be verified against the available resources. Some how if reached, find it again might be miracle. So right it to know but difficult it to forget is to get all the information altogether without asking somebody who might not know their own address is not possible but not possible all the time. It is the thing which is possible if somebody takes the initiative without any interest is very impossible but not rare to find us doing the same things. So if you are somebody who knows it rightfully the way to convey us, you are hopefully advised to informed the URL of website of your kind which fits in the address bar as it appears like http://www.swapp.co.in without fail you can either comment or email us at admin@swapp.co.in and will be publish rightfully on the website as long as one day. Check it there where you won’t be disappointed but to see m…
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