Annotation of /bin/Replicate

#!/usr/bin/perl
# Replicate
# Vadim Mikheev, (c) 2000, PostgreSQL Inc.

eval '(exit $?0)' && eval 'exec perl -S $0 ${1+"$@"}'
    & eval 'exec perl -S $0 $argv:q'
    if 0;

BEGIN {
        my $basedir = $0; $basedir =~ s#/[^/]+$##;
        unshift(@INC, "$basedir/../share");
}

use IO::File;
use Getopt::Long;
use RServ;
use Sys::Hostname;

$| = 1;

$result = GetOptions("debug!", "verbose!", "help", "snapshot=s",
                     "masterhost=s", "slavehost=s",
                     "masteruser=s", "slaveuser=s",
                     "masterpassword=s", "slavepassword=s",
                     "masterport=i", "slaveport=i"
                     );

my $debug = $opt_debug || 0;
my $verbose = $opt_verbose || 0;
my $snapshot = $opt_snapshot || ".__Snapshot";
$snapshot .= '.' . $$;

if (defined($opt_help) || (scalar(@ARGV) < 2)) {
    print "Usage: $0 --snapshot=file masterdb slavedb\n";
    print "\t--masterhost=name --masterport=port\n";
    print "\t--masteruser=name --masterpassword=string\n";
    print "\t--slavehost=name --slaveport=port\n";
    print "\t--slaveuser=name --slavepassword=string\n";
    exit ((scalar(@ARGV) < 2)? 1:0);
}

my $master = $ARGV[0] || "master";
my $slave = $ARGV[1] || "slave";

$masterhost = $opt_masterhost || hostname;
$slavehost = $opt_slavehost || hostname;

# first, let's check if a instance is alrealy running

$str = $master.'@'.$masterhost.':'.$slave.'@'.$slavehost;
my $fname = "/tmp/.lock_rserv-$str";
if (-e $fname) {
    print STDERR "rServ is already running for $str. Remove $fname to override this.\n";
    exit(1);
}
open ARQ, ">$fname" || die "Cannot open $fname: $!\n";
print ARQ "$$\n";
close ARQ;

my $minfo = "dbname=$master";
$minfo = "$minfo host=$opt_masterhost" if (defined($opt_masterhost));
$minfo = "$minfo user=$opt_masteruser" if (defined($opt_masteruser));
$minfo = "$minfo password=$opt_masterpassword" if (defined($opt_masterpassword));
$minfo = "$minfo port=$opt_masterport" if (defined($opt_masterport));
my $sinfo = "dbname=$slave";
$sinfo = "$sinfo host=$opt_slavehost" if (defined($opt_slavehost));
$sinfo = "$sinfo user=$opt_slaveuser" if (defined($opt_slaveuser));
$sinfo = "$sinfo password=$opt_slavepassword" if (defined($opt_slavepassword));
$sinfo = "$sinfo port=$opt_slaveport" if (defined($opt_slaveport));

print "Master connection is $minfo\n" if ($debug);
print "Slave connection is $sinfo\n" if ($debug);

my $mconn = Pg::connectdb($minfo);
if ($mconn->status != PGRES_CONNECTION_OK) {
    print STDERR "Failed opening $minfo\n";
    unlink $fname;
    exit 1;
}
my $sconn = Pg::connectdb($sinfo);
if ($sconn->status != PGRES_CONNECTION_OK) {
    print STDERR "Failed opening $sinfo\n";
    unlink $fname;
    exit 1;
}

my $slaveId = GetSlaveId($mconn, $slave, defined($opt_slavehost) ? $opt_slavehost : hostname);
if ($slaveId < 0) {
    unlink $fname;
    die "\n>>>>>>>>>>>>> ERROR\n";
}
SyncSync($mconn, $sconn);

my $outf = new IO::File;
open $outf, ">$snapshot";
print "\n>>>>>>>>>>>>> Prepare Snapshot\n\n" if ($verbose);
$res = PrepareSnapshot($mconn, $sconn, $outf, $slaveId);
close $outf;
if ($res < 0) {
    unlink $fname;
    die "\n>>>>>>>>>>>>> ERROR\n";
}
if ($res == 0)
{
    print "\n>>>>>>>>>>>>> DBases are sync-ed\n" if ($verbose);
    unlink $snapshot unless ($debug);
    unlink $fname;
    exit(0);
}

my $inpf = new IO::File;
open $inpf, "<$snapshot";
print "\n>>>>>>>>>>>>> Apply Snapshot\n\n" if ($verbose);
$res = ApplySnapshot($sconn, $inpf);
close $inpf;
if ($res < 0) {
    unlink $fname;
    die "\n>>>>>>>>>>>>> ERROR\n";
}

if ($res > 0)
{
    print "Snapshot applied\n" if ($verbose);
    unlink $snapshot unless ($debug);
    SyncSync($mconn, $sconn);
}

unlink $fname;
exit(0);

###########################################################################

sub SyncSync
{
    ($mconn, $sconn) = @_;

    print "\n>>>>>>>>>>>>> Sync SyncID\n\n" if ($verbose);
    print "Get last SyncID from Slave DB\n" if ($verbose);
    $syncid = GetSyncID($sconn);
    if ($syncid > 0)
    {
        print "Last SyncID applied: $syncid\n" if ($verbose);
        print "Sync SyncID\n" if ($verbose);

        $res = SyncSyncID($mconn, $slaveId, $syncid);

        print "Succeeded\n" if (($res > 0) && ($verbose));
    }
}
1	dpavlin	1.2	#!/usr/bin/perl
2	dpavlin	1.1	# Replicate
3			# Vadim Mikheev, (c) 2000, PostgreSQL Inc.
4
5			eval '(exit $?0)' && eval 'exec perl -S $0 ${1+"$@"}'
6			& eval 'exec perl -S $0 $argv:q'
7			if 0;
8
9	dpavlin	1.5	BEGIN {
10			my $basedir = $0; $basedir =~ s#/[^/]+$##;
11			unshift(@INC, "$basedir/../share");
12			}
13	dpavlin	1.1
14			use IO::File;
15			use Getopt::Long;
16			use RServ;
17	dpavlin	1.3	use Sys::Hostname;
18	dpavlin	1.1
19			$\| = 1;
20
21			$result = GetOptions("debug!", "verbose!", "help", "snapshot=s",
22	dpavlin	1.4	"masterhost=s", "slavehost=s",
23			"masteruser=s", "slaveuser=s",
24			"masterpassword=s", "slavepassword=s",
25			"masterport=i", "slaveport=i"
26			);
27	dpavlin	1.1
28			my $debug = $opt_debug \|\| 0;
29			my $verbose = $opt_verbose \|\| 0;
30	dpavlin	1.3	my $snapshot = $opt_snapshot \|\| ".__Snapshot";
31			$snapshot .= '.' . $$;
32	dpavlin	1.1
33			if (defined($opt_help) \|\| (scalar(@ARGV) < 2)) {
34	dpavlin	1.4	print "Usage: $0 --snapshot=file masterdb slavedb\n";
35			print "\t--masterhost=name --masterport=port\n";
36			print "\t--masteruser=name --masterpassword=string\n";
37			print "\t--slavehost=name --slaveport=port\n";
38			print "\t--slaveuser=name --slavepassword=string\n";
39	dpavlin	1.1	exit ((scalar(@ARGV) < 2)? 1:0);
40			}
41
42			my $master = $ARGV[0] \|\| "master";
43			my $slave = $ARGV[1] \|\| "slave";
44	dpavlin	1.3
45			$masterhost = $opt_masterhost \|\| hostname;
46			$slavehost = $opt_slavehost \|\| hostname;
47
48			# first, let's check if a instance is alrealy running
49
50			$str = $master.'@'.$masterhost.':'.$slave.'@'.$slavehost;
51			my $fname = "/tmp/.lock_rserv-$str";
52			if (-e $fname) {
53			print STDERR "rServ is already running for $str. Remove $fname to override this.\n";
54			exit(1);
55			}
56			open ARQ, ">$fname" \|\| die "Cannot open $fname: $!\n";
57			print ARQ "$$\n";
58			close ARQ;
59	dpavlin	1.1
60			my $minfo = "dbname=$master";
61			$minfo = "$minfo host=$opt_masterhost" if (defined($opt_masterhost));
62			$minfo = "$minfo user=$opt_masteruser" if (defined($opt_masteruser));
63			$minfo = "$minfo password=$opt_masterpassword" if (defined($opt_masterpassword));
64	dpavlin	1.4	$minfo = "$minfo port=$opt_masterport" if (defined($opt_masterport));
65	dpavlin	1.1	my $sinfo = "dbname=$slave";
66			$sinfo = "$sinfo host=$opt_slavehost" if (defined($opt_slavehost));
67			$sinfo = "$sinfo user=$opt_slaveuser" if (defined($opt_slaveuser));
68			$sinfo = "$sinfo password=$opt_slavepassword" if (defined($opt_slavepassword));
69	dpavlin	1.4	$sinfo = "$sinfo port=$opt_slaveport" if (defined($opt_slaveport));
70	dpavlin	1.1
71			print "Master connection is $minfo\n" if ($debug);
72			print "Slave connection is $sinfo\n" if ($debug);
73
74			my $mconn = Pg::connectdb($minfo);
75	dpavlin	1.3	if ($mconn->status != PGRES_CONNECTION_OK) {
76			print STDERR "Failed opening $minfo\n";
77			unlink $fname;
78			exit 1;
79			}
80	dpavlin	1.1	my $sconn = Pg::connectdb($sinfo);
81	dpavlin	1.3	if ($sconn->status != PGRES_CONNECTION_OK) {
82			print STDERR "Failed opening $sinfo\n";
83			unlink $fname;
84			exit 1;
85			}
86	dpavlin	1.1
87	dpavlin	1.3	my $slaveId = GetSlaveId($mconn, $slave, defined($opt_slavehost) ? $opt_slavehost : hostname);
88			if ($slaveId < 0) {
89			unlink $fname;
90			die "\n>>>>>>>>>>>>> ERROR\n";
91			}
92	dpavlin	1.1	SyncSync($mconn, $sconn);
93
94			my $outf = new IO::File;
95			open $outf, ">$snapshot";
96			print "\n>>>>>>>>>>>>> Prepare Snapshot\n\n" if ($verbose);
97	dpavlin	1.3	$res = PrepareSnapshot($mconn, $sconn, $outf, $slaveId);
98	dpavlin	1.1	close $outf;
99	dpavlin	1.3	if ($res < 0) {
100			unlink $fname;
101			die "\n>>>>>>>>>>>>> ERROR\n";
102			}
103	dpavlin	1.1	if ($res == 0)
104			{
105	dpavlin	1.3	print "\n>>>>>>>>>>>>> DBases are sync-ed\n" if ($verbose);
106			unlink $snapshot unless ($debug);
107			unlink $fname;
108			exit(0);
109	dpavlin	1.1	}
110
111			my $inpf = new IO::File;
112			open $inpf, "<$snapshot";
113			print "\n>>>>>>>>>>>>> Apply Snapshot\n\n" if ($verbose);
114			$res = ApplySnapshot($sconn, $inpf);
115			close $inpf;
116	dpavlin	1.3	if ($res < 0) {
117			unlink $fname;
118			die "\n>>>>>>>>>>>>> ERROR\n";
119			}
120	dpavlin	1.1
121			if ($res > 0)
122			{
123	dpavlin	1.3	print "Snapshot applied\n" if ($verbose);
124			unlink $snapshot unless ($debug);
125			SyncSync($mconn, $sconn);
126	dpavlin	1.1	}
127
128	dpavlin	1.3	unlink $fname;
129	dpavlin	1.1	exit(0);
130
131			###########################################################################
132
133			sub SyncSync
134			{
135			($mconn, $sconn) = @_;
136
137			print "\n>>>>>>>>>>>>> Sync SyncID\n\n" if ($verbose);
138			print "Get last SyncID from Slave DB\n" if ($verbose);
139			$syncid = GetSyncID($sconn);
140			if ($syncid > 0)
141			{
142			print "Last SyncID applied: $syncid\n" if ($verbose);
143			print "Sync SyncID\n" if ($verbose);
144
145	dpavlin	1.3	$res = SyncSyncID($mconn, $slaveId, $syncid);
146	dpavlin	1.1
147			print "Succeeded\n" if (($res > 0) && ($verbose));
148			}
149			}