left header graphic The Network People
Solutions for Hosting Providers
right header graphic

mrm home : internet : sql : mrm : mrm-changes mrm-docs

MySQL Replication Manager - ChangeLog

Author: Matt Simerson.


Mysql::Replication Changes


2.11 - 2005.02.01

 - shudown_slaves fixed to slaves_shutdown (2 plc)


2.10 - 2004.11.22

 - added contrib/mysqlstatus.pl
 - removed dependency on Mail::Toaster modules
   (imported Mysql.pm, Utility.pm, & Perl.pm
   from Mail::Toaster w/minor alterations)
 - distribution renamed to Mysql::Replication
   to fit into CPAN category
 - moved most subs from mysql_replicate_manager.pl
   into Mysql::Replication.pm
 - made those subs all object methods
 - added tests in most subs to make sure proper 
   arguments are passed.
 - added tests (t/*.t) 
 - added contrib/my.cnf
 - updated Makefile to generate web pages for modules.
 - added dependency for DBI & DBD::mysql to Makefile.PL


2.01 - 2004.09.10

 - fixed a prototype error with sub archive
 - only err (don't die) if db connect attempt fails
 - fixed slave error reporting for mysql 4+


2.0 - 2004.08.11

 - due to wild variations on how SHOW SLAVE STATUS returns
   results based on the version of MySQL, switched to 
   using a hashref instead of an array for reliability
 - now dependent on Mail::Toaster instead of MATT::Bundle
 - renamed sub grant to grant_replication
 - also pass debug to get_vars, and backup subs
 - rename extract_archive to extract_slave_archive
 - moved VerifyQuery, flush_logs, get_hashes, and 
   shutdown_mysqld to Mail::Toaster::Mysql
 - extract_slave_archive now uses a gunzip -c $file | tar
   type method instead of hoping tar supports -z
 - added more debugging notes in various places


1.6.4 - 05.10.2004

 - Fixed a typo causing purge_logs to not work
   correctly.


1.6.2 - 02.03.2003

 - Updated several sub calls from MysqlUnlockTable
   to UnlockTable and MysqlLockTable to LockTable.


1.6.1 - 11.24.2003

 - the expand archive function needs to detect which
   version of tar is being used (and if it supports
   gunzip.


1.6.0 - 09.12.2003

 - Moved sudo_setup to MATT::Utility
 - Moved mysql_sanity to MATT::Mysql
 - Moved mysql_version to MATT::Mysql
 - Moved is_mysql_newer to MATT::Mysql
 - Moved mysql_lock_tables to MATT::Mysql
 - Moved mysql_unlock_tables to MATT::Mysql


1.5.2 - 2003.08.02


 - Fixed up a couple problems related to 
   tarball copying and extraction.


1.5.1 - 2003.07.08

 - Cleaned up for public release.
 - Replaced mysql_connect with MATT::Mysql::MysqlConnect
 - Added more error checking for mysql_backup


1.5 - 2003.05.24

 - Migrated many basic functions into MATT::Mysql 
   and MATT::Utility.pm


1.4.3 - 2003.02.24

 - Started rudimentary slave promotion


1.4.2 - 2003.02.21

 - Added some documentation
 - moved 5 FindTheBin calls into subs that required them
 - Reordered the subroutines to make editing easier
 - Added check for binlog enabled
 - Added mysql_get_hashes & mysql_get_vars


1.4.1 - 2003.02.19

 - Solaris tar doesn't support -z (compression)


1.4 - 2003.02.11

 - Moved the $dot stuff from main into parse_dot_file
 - Get uname info via POSIX uname instead of system call
 - Enhanced documentation
 - Made the archive, copy, extract functions more portable
   as not everyone installs MySQL in the same place I do.
 - WARNING: If you use older versions of this, make sure
   you update your ~/.my.cnf.
 - Prototyped all my subroutines
 - Added mysql_get_vars


1.3.6 - 2003.02.10

 - Only warn if sudo isn't installed. Update subs so 
   they fail operations that require special privileges
   if they aren't available.
 - Added /usr/local/mysql/bin to find_the_bin sub.
 - Finished backup feature, now works correctly


1.3.5 - 2003.02.07

 - Load Date::Parse via load_module. Linux doesn't have
   it installed by default. :(


1.3.4 - 2003.01.17

 - Enhanced documentation (added dependencies section)


1.3.3 - 12.07.02

 - Added additional support for OS's other than FreeBSD
 - Works well with Mac OS X (Jaguar) 10.2
 - Now tested with MySQL 4 (v4.0.4)
 - Added backup feature (requires cronolog)
 - Added find_the_bin sub to make code more portable


1.3.2 - 11.22.02

 - Made improvements to the purge logs command. Now it's
   safe to run it from cron to keep your bin-log files
   from consuming your entire disk.


1.3.1 - 11.22.02

 - Added $warn options. Useful in mysql_shutdown or connect
   routines, continue even if the remote server is down or
   or inaccessible.
 - Ordered main loop so menu prints if no options supplied
   $opt_h no longer necessary and removed


1.3 - 11.20.02

 - Fixed problem where mysql_sync_slaves tripped over itself
 - Added show_master_logs
 - Added some support for more versions of MySQL
   Particulary versions older than the current one
 - Added more robust yes_or_no sub
 - Wrapped all queries in mysql_query
 - Log purge now purges all logs except the last one
 - Added configurable mysql directories
 - Moved .my_repl settings to .my.cnf file


1.2.1 - 11.16.02

 - added "Date::Format::" prefix to my time2str call


1.2 - 11.11.02

 - Moved server settings into .my_repl dot file


1.1.2 - 11.11.02

 - Tweaked load_module sub


1.1.1 - 10.28.02

 - Fixed typo.


1.1 - 10.24.02

 - Added better replication reporting feaures (-i)
 - Added more and better inline documentation.
 - Added load_module function to trap any "use" errors when a 
   module isn't already installed and then install that module. 
 - Subtle refinements to code for cleanliness


1.0 - 10.14.02 - Initial writing and release


Last modified on 5/13/05.