XA Transaction ~ Cross Databases Transaction

Describing XA Transaction, database transaction, postgresql database, mysql database, postgresql transaction, mysql transaction, cross transaction, two phase commit transaction and transaction

Have you ever think that it's too difficult for making database transaction in two different places (or databases) ? If so, XA Transaction is one of solutions. XA Transaction will make data for being consistent in both places and will be maintained in accordance with the principle of ACID.

Database Replication ~ Slony-I Configuration in Windows XP

Describing database replication, postgresql replication, replication configuration, Slony-I configuration, Slony-I windows xp, replication performance, master slave replication, database performance, Slony-I in pgAdmin, asynchronous replication, replication and synchronization

Replication is a common thing for databases that require more performance. One of open source solution that can be used in replication is Slony-I. This system works with the concept of asynchronous data thus inconsistency between master and slave database. That is the consequences that must be accepted, but the positive thing is the performance of these systems can be inherently better for the data transmission process performed on a periodic basis so as not to burden the system as a whole (there is a choice between functionality and performance, it is difficult to get both).