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

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

All India Fair and Remunerative Price (FRP) for Sugarcane Crushing Season 2018-2019 Basic rate of Rs.275 per qtl, subject to a premium of Rs 2.75 per qtl for every 0.1 percentage point increase in recovery above 10 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.) 10 275 2750.00 10.1 277.75 2777.50 10.2 280.50 2805.00 10.3 283.25 2832.50 10.4 286.00 2860.00 10.5 288.75 2887.50 10.6 291.50 2915.00 10.7 294.25 2942.50 10.8 297.00 2970.00 10.9 299.75 2997.50 11 302.50 3025.00 11.1 305.25 3052.50 11.2 308.00 3080.00 11.3 310.75 3107.50 11.4 313.50 3135.00 11.5 316.25 3162.50 11.6 319.00 3190.00 11.7 321.75 3217.50 11.8 324.50 3245.00 11.9 327.25 3272.50 12 330.00 3300.00 12.1 332.75 3327.50 12.2 335.50 3355.00 12.3 338.25 3382.50 12.4 341.00 3410.00 12.5 343.75 3437.50 12.6 346.50 3465.00 12.7 349.25 3492.50 ...
Read more

SSL (Secure Socket Layer)

           In 1994, Netscape Communications invented SSL. SSL (Secure Socket Layer) protocol is used for secure communication between browser and server. For E-mail server privacy is maintained with the help of secured protocol. SSL certificate is issued by SSL CA (Certifying Authority). HTTPS protocol is used for the SSL website and on left side of the address some indicator is always there after verification.            TLS (Transport Layer Security) is the successor of the SSL.TLS 1.0 was defined in RFC 2246 in 1999.
Read more