Linux How - To's - Free Consultancy: database

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Both InnoDB and PostgreSQL - as well as many other databases - use a technique called multi-version concurrency control (MVCC) to provide transaction isolation: transactions should not see the work of other, uncommitted transactions. MVCC means that, when a row is updated, the database stores both the old and new versions of the row.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Showing posts with label database. Show all posts

Thursday, October 14, 2010

Mysql Backup Script - BASH & PERL

This BASH script will take the backup every day and at the end of the month, it will ARCHIVE the Last Day backup to Another Directory.
This Script will also send E-Mail if any thing goes wrong and Even send mails on Completion of Backup Process with Time taken.

PGCluster - Postgres Clustering & Load Balancing

PG CLUSTER Setup
Download it from here
http://pgfoundry.org/frs/?group_id=1000072

# useradd postgres
# useradd -M -g postgres postgres
# mkdir /home/postgres