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

Saas - Software As A Service

SaaS is the concept of the Global Village SaaS is any software application that you run that is not located on your premises. It is a full-blown application, not a component part of something else. It is not a way to build applications. It is not a plug-in to other applications. It is never something that sits on your machines. Instead of having the application running on servers and data storage in your data center, it is running in the vendor's data center. Software is not the program but the service The way SaaS applications are licensed is different from on-premise applications. Instead of buying the license to use the application, and then paying for software maintenance to support it and keep it current, you "rent" the software over a period of time - usually monthly or yearly. Instead of buying and installing infrastructure and then paying ongoing operating and maintenance costs, the vendor runs the application on their infrastructure.   Co...
Read more

Cloud ERP

Cloud is not in the sky but in the reach of everybody Cloud ERP (Enterprise Resources Planning) for Sugar and Allied Industries. Cloud computing (“the cloud”) is one of the leading technology topics in the world. Cloud computing, sometimes called on-demand computing, uses the Internet to provide shared computing resources and storage of records or documents. The Cloud is particularly valuable to small and medium-size businesses (SMB’s) because it provides access to full function applications at a reasonable price, without substantial operating expenditure for hardware and software. Company can rapidly scale as their business grows or a new company is added. Cloud ERP enables a company’s accounting, operations management and reporting to run in the cloud. Hosting of an application and utilizing the internet to provide connectivity. Cloud ERP changing the scenario Cloud ERP has been proven to reduce costs in many ways because it Avoids upfront costs for all comput...
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