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

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 script. Show all posts
Showing posts with label script. Show all posts

Friday, December 23, 2011

Multiple Purpose Expect Script

DISK ALERT - Expect ScriptHi All, here's I have bring a expect script, that this we can Run command on Remote Linux Servers, copy file using SSHSo here it is:
[root@virtual-vm ~]#  yum install expect  (if expect package is not installed)

Tuesday, November 1, 2011

Load Balance Mysql Slaves Using MySQLProxy

I am sure you all have read about MySQL replication, like Master-Master, Single Master - Multiple Slaves and their topologies.
Here I am going to describe how you can load balance several MySQL Slaves and query logging.

Friday, August 12, 2011

Report Developer's About Error/Warning in Codes from Apache Logs

This is just a scenario i got it in mind, Reporting Warning/Error  to Developer(s), using a PERL script, this you can also be done using SHELL Script.

Saturday, November 27, 2010

PostgreSql Backup Script - Bash

If you are one who is using PostgreSql as your Back-end Database Server for your work, then obviously you need a backup solution, so here this is my try for a small solution for Automated Backup Job in  Bash Shell Script.

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.