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

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

Use of Unicode in Application

Unicode is getting more acceptance Unicode (Universal Coded Character Set) is widely used on all the platforms. Unicode data is stored in multibyte pattern. Though all the operating systems supports UTF-8, some operating system supports UTF-16 and UTF-32 along with. UTF stands for Unicode Transformation Format. The number after UTF denote the bits block (Byte) to represent a character. One to four Bytes are used. For Devanagari script, code point U+0900 to U+097F are used. Indian languages are coming on the common platform For Devanagari character Om code point is U+0950. How it is stored in UTF-8 is interesting one. First Step – Convert it into simple binary number 0       9       5       0 0000 1001 0101 0000 Second Step – Make the group of Six from right 0000 1001 0101 0000 0000 100101 010000 Third Step – if the group is of six then concat 10 to left and for group of ...
Read more