{

/**

* Public Function runBackup

* @param db string The name of the database that the backup is going to be executed for

* @param simulation boolean Whether or not the run is a simulated run or actual run

* @param color boolean Whether or not output should be generated in color code or not

*/

public function runBackup( $db, $simulation = false, $color = false )

{

// Check if the system is live or not

if( LIVE === true ) :

$backupDir = "/ts_backups/mysql_backups/";

else :

$backupDir = "/srv_admin/srv_backups/mysql/";

endif;

// Full backups are run on Friday's, setup the commands accordingly

if( date("D") == "Fri" ) :

$backupDir .= "full_backups/";

$mysql_options = "";

else :

$backupDir .= "incremental_backups/";

$mysql_options = "--flush-logs --delete-master-logs";

endif;

$backupDir .= date("d_m_Y") . "/";

// Check if the backup directory exists, else create it

if( !is_dir( $backupDir ) ) :

mkdir($backupDir);

endif;

// Setup the backup command

$command = "mysqldump -u " . MySQLBackupDB::USER . " -p" . MySQLBackupDB::PASS . " -h " . MySQLBackupDB::DBHOST . " --port=" . MySQLBackupDB::DBPORT . " " . (DEBUG?"--verbose":"") . " {$db} {$mysql_options} | gzip -m9 > {$backupDir}{$db}.sql.gz";

if( DEBUG === true ) : OutputHandler::displayOutput( "[%lightgreen%DEBUG%lightgray%] MySQL Command : %lightblue%{$command}%lightgray%", $color ); endif;

// Check if it is a simulated run

if( !$simulation ) :

exec($command, $command_output);

else :

$command_output = array( "Backup complete" );

endif;

// Output the results from the command that was executed

foreach( $command_output as $cmd_output ) :

OutputHandler::displayOutput( "[%lightblue%{$db}%lightgray%]\t" . $cmd_output, $color );

endforeach;

}

{

/**

* Private class members

*/

private $debug_data = null;

private $current_db = null;

private $simulation = null;

private $color = null;

/**

* Overrridden constructor

* @param sim boolean Enable/disable simulation mode

* @param clr boolean Enable/disable color output of content

*/

public function __construct( $sim = false, $clr = false )

{

$this -> simulation = $sim;

$this -> color = $clr;

OutputHandler::displayOutput("%lightblue%Starting system...%lightgray%", $this -> color);

SR_Agent::Log( APPID, SystemReporter::MSG_MESSAGE, "Starting System" );

}

/**

* Public function runBackups

*/

public function runBackups()

{

$mysqlDBHandler = new MySQLHandler();

//$dbList = DB::getDBList($this -> color);

$dbList = explode( "|", MySQLBackupDB::DATABASES );

foreach( $dbList as $db ) :

SR_Agent::Log( APPID, SystemReporter::MSG_MESSAGE, "Starting Backup for {$db}" );

OutputHandler::displayOutput( "[%lightblue%{$db}%lightgray%]\tStarting backup\n%white%============================================%lightgray%", $this -> color );

$mysqlDBHandler -> runBackup( $db, $this -> simulation, $this -> color );

OutputHandler::displayOutput( "%white%============================================%lightgray%\n", $this -> color );

endforeach;

$this -> completeRun();

}

/**

* Private Fucntion completeRun

* @description

* Function is called after all the databases have been backed up, in order to create a final MD5 checksum of the databases and then compress it all as a single file

*/

private function completeRun()

{

// Check if it is the LIVE environment

if( LIVE === true ) :

$backupDir = "/ts_backups/mysql_backups/";

else :

$backupDir = "/srv_admin/srv_backups/mysql/";

endif;

// Check if it was a full or incremental backup run

if( date("D") == "Fri" ) :

$backupDir .= "full_backups/";

else :

$backupDir .= "incremental_backups/";

endif;

// Setup paths and filenames

$folder = $backupDir;

$backupDir .= date("d_m_Y") . "/";

$compressed_file = $folder . date("d_m_Y") . ".tar.gz";

// Check if it is a simulated run

if( !$this -> simulation ) :

exec("md5sum {$backupDir}/*.tar.gz > {$backupDir}/databases.md5");

if( DEBUG === true ) : OutputHandler::displayOutput( "[%lightgreen%DEBUG%lightgray%] Generated MD5 Hashes of DB Backups%lightgray%", $this -> color ); endif;

endif;

$command = "tar -zcvf {$compressed_file} {$backupDir}";

if( DEBUG === true ) : OutputHandler::displayOutput( "[%lightgreen%DEBUG%lightgray%] Command : %lightblue%{$command}%lightgray%", $this -> color ); endif;

// Check if it is a simulated run

if( !$this -> simulation ) :

exec($command, $command_output);

// Generate MD5 checksum of the compressed file (usefull for integrity checks)

exec("md5sum {$compressed_file} > {$compressed_file}.md5");

else :

$command_output = array( "Folder compressed" );

endif;

// Check if debugging is enabled

if( DEBUG === true ) :

// Display debugging information

foreach( $command_output as $cmd_output ) :

OutputHandler::displayOutput( "[%lightgreen%DEBUG%lightgray%] [%lightblue%{$backupDir}%lightgray%]\t" . $cmd_output, $this -> color );

endforeach;

endif;

// Check if it is a simulated run

if( !$this -> simulation ) :

exec("rm -rf {$backupDir}");

endif;

SR_Agent::Log( APPID, SystemReporter::MSG_SUCCESS, "Backup complete for " . date("d/m/Y") );

}

{

static public function displayOutput($output, $color = false)

{

$o = $output;

$colors = array(

"%lightgray%" => "\033[0;30m",

"%darkgrey%" => "\033[1;30m",

"%blue%" => "\033[0;34m",

"%lightblue%" => "\033[1;34m",

"%green%" => "\033[0;32m",

"%lightgreen%" => "\033[1;32m",

"%cyan%" => "\033[0;36m",

"%lightcyan%" => "\033[1;36m",

"%red%" => "\033[0;31m",

"%lightred%" => "\033[1;31m",

"%purple%" => "\033[0;35m",

"%lightpurple%" => "\033[1;35m",

"%brown%" => "\033[0;33m",

"%yellow%" => "\033[1;33m",

"%lightgray%" => "\033[0;37m",

"%white%" => "\033[1;37m"

);

foreach( $colors as $key => $value ) :

if( $color === true ) :

$o = str_replace( $key, $value, $o );

else :

$o = str_replace( $key, "", $o );

endif;

endforeach;

echo $o . "\n";

}