11-30-2009
Hi Neo,
Does "Switching Masters During Failover" supports for prior to version 4.1?
I found this point in 5.0 onward manual and not in "MySQL 3.23/4.0/4.1" manual.
Can you please tell me it is supported in prior to 4.1 versions?
Regards,
Amit
6 More Discussions You Might Find Interesting
1. Solaris
HI i'am Giancarlo D. Jabon student from AMA Computer University is anyone among all of you who knows the maximum processor and memory supports in Sun Solaris 10
Thanks !!!! (3 Replies)
Discussion started by: giancarlodjabon
3 Replies
2. UNIX for Advanced & Expert Users
hi,
i created 2 threads in which one thread is dedicated to capture signals and handle them.
i used the following functions:
sigfillset for filling the signal set to be blocked by other threads
sigwait for waiting on particular signals
pthread_sigmask to mask block the signals.
I... (0 Replies)
Discussion started by: skyrulz
0 Replies
3. Web Development
Lately my attention has been focused on distributed MySQL database replication to other web servers. All was going well, but then I noticed the replication would stop and there were there "Duplicate Primary Key" errors in SHOW SLAVE STATUS;
I started to trace these down and noticed that this... (2 Replies)
Discussion started by: Neo
2 Replies
4. Shell Programming and Scripting
Hi to all guyz ,
As i'm new to Shell scripting i was been working out to write a shell script for mysql Replication for multiple slave master architecture.i have done the process up with a script of 200 lines but still there are some things which can make my script more effective so i want your... (5 Replies)
Discussion started by: kgrvamsi
5 Replies
5. Linux
Need to recover a replication broken error on the mysql slave server.
I want to force it to resend the binlog file from the begining.
What is the correct value for the: MASTER_LOG_POS ?
0, 1 or 107 ? (2 Replies)
Discussion started by: andriesh
2 Replies
6. UNIX Desktop Questions & Answers
I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database.
For this I have created two... (0 Replies)
Discussion started by: Palak Sharma
0 Replies
LEARN ABOUT DEBIAN
mysql::diff::database
MySQL::Diff::Database(3pm) User Contributed Perl Documentation MySQL::Diff::Database(3pm)
NAME
MySQL::Diff::Database - Database Definition Class
SYNOPSIS
use MySQL::Diff::Database;
my $db = MySQL::Diff::Database->new(%options);
my $source = $db->source_type();
my $summary = $db->summary();
my $name = $db->name();
my @tables = $db->tables();
my $table_def = $db->table_by_name($table);
my @dbs = MySQL::Diff::Database::available_dbs();
DESCRIPTION
Parses a database definition into component parts.
METHODS
Constructor
new( %options )
Instantiate the objects, providing the command line options for database access and process requirements.
Public Methods
o source_type()
Returns 'file' if the data source is a text file, and 'db' if connected directly to a database.
o summary()
Provides a summary of the database.
o name()
Returns the name of the database.
o tables()
Returns a list of tables for the current database.
o table_by_name( $name )
Returns the table definition (see MySQL::Diff::Table) for the given table.
FUNCTIONS
Public Functions
o available_dbs()
Returns a list of the available databases.
Note that is used as a function call, not a method call.
COPYRIGHT AND LICENSE
Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
same terms as Perl itself.
SEE ALSO
mysqldiff, MySQL::Diff, MySQL::Diff::Table, MySQL::Diff::Utils
AUTHOR
Adam Spiers <mysqldiff@adamspiers.org>
perl v5.14.2 2012-04-06 MySQL::Diff::Database(3pm)