diff options
| author | Charles Cabergs <me@cacharle.xyz> | 2020-07-27 10:05:23 +0200 |
|---|---|---|
| committer | Charles Cabergs <me@cacharle.xyz> | 2020-07-27 10:05:23 +0200 |
| commit | 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab (patch) | |
| tree | 39a1a4629749056191c05dfd899f931701b7acf3 /srcs/phpmyadmin/libraries/replication.inc.php | |
| parent | 5afd237bbd22028b85532b8c0b3fcead49a00764 (diff) | |
| download | ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.gz ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.bz2 ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.zip | |
Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my famillyHEADmaster
Diffstat (limited to 'srcs/phpmyadmin/libraries/replication.inc.php')
| -rw-r--r-- | srcs/phpmyadmin/libraries/replication.inc.php | 195 |
1 files changed, 0 insertions, 195 deletions
diff --git a/srcs/phpmyadmin/libraries/replication.inc.php b/srcs/phpmyadmin/libraries/replication.inc.php deleted file mode 100644 index da90fbd..0000000 --- a/srcs/phpmyadmin/libraries/replication.inc.php +++ /dev/null @@ -1,195 +0,0 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Replication helpers - * - * @package PhpMyAdmin - */ -declare(strict_types=1); - -if (! defined('PHPMYADMIN')) { - exit; -} - -use PhpMyAdmin\Replication; - -$replication = new Replication(); - -/** - * get master replication from server - */ -$server_master_replication = $GLOBALS['dbi']->fetchResult('SHOW MASTER STATUS'); - -/** - * set selected master server - */ -if (! empty($_POST['master_connection'])) { - /** - * check for multi-master replication functionality - */ - $server_slave_multi_replication = $GLOBALS['dbi']->fetchResult( - 'SHOW ALL SLAVES STATUS' - ); - if ($server_slave_multi_replication) { - $GLOBALS['dbi']->query( - "SET @@default_master_connection = '" - . $GLOBALS['dbi']->escapeString( - $_POST['master_connection'] - ) . "'" - ); - $GLOBALS['url_params']['master_connection'] = $_POST['master_connection']; - } -} - -/** - * get slave replication from server - */ -$server_slave_replication = $GLOBALS['dbi']->fetchResult('SHOW SLAVE STATUS'); - -/** - * replication types - */ -$replication_types = [ - 'master', - 'slave', -]; - - -/** - * define variables for master status - */ -$master_variables = [ - 'File', - 'Position', - 'Binlog_Do_DB', - 'Binlog_Ignore_DB', -]; - -/** - * Define variables for slave status - */ -$slave_variables = [ - 'Slave_IO_State', - 'Master_Host', - 'Master_User', - 'Master_Port', - 'Connect_Retry', - 'Master_Log_File', - 'Read_Master_Log_Pos', - 'Relay_Log_File', - 'Relay_Log_Pos', - 'Relay_Master_Log_File', - 'Slave_IO_Running', - 'Slave_SQL_Running', - 'Replicate_Do_DB', - 'Replicate_Ignore_DB', - 'Replicate_Do_Table', - 'Replicate_Ignore_Table', - 'Replicate_Wild_Do_Table', - 'Replicate_Wild_Ignore_Table', - 'Last_Errno', - 'Last_Error', - 'Skip_Counter', - 'Exec_Master_Log_Pos', - 'Relay_Log_Space', - 'Until_Condition', - 'Until_Log_File', - 'Until_Log_Pos', - 'Master_SSL_Allowed', - 'Master_SSL_CA_File', - 'Master_SSL_CA_Path', - 'Master_SSL_Cert', - 'Master_SSL_Cipher', - 'Master_SSL_Key', - 'Seconds_Behind_Master', -]; -/** - * define important variables, which need to be watched for - * correct running of replication in slave mode - * - * @usedby PhpMyAdmin\ReplicationGui->getHtmlForReplicationStatusTable() - */ -// TODO change to regexp or something, to allow for negative match. -// To e.g. highlight 'Last_Error' -// -$slave_variables_alerts = [ - 'Slave_IO_Running' => 'No', - 'Slave_SQL_Running' => 'No', -]; -$slave_variables_oks = [ - 'Slave_IO_Running' => 'Yes', - 'Slave_SQL_Running' => 'Yes', -]; - -// check which replication is available and -// set $server_{master/slave}_status and assign values - -// replication info is more easily passed to functions -$GLOBALS['replication_info'] = []; - -foreach ($replication_types as $type) { - if (count(${"server_{$type}_replication"}) > 0) { - $GLOBALS['replication_info'][$type]['status'] = true; - } else { - $GLOBALS['replication_info'][$type]['status'] = false; - } - if ($GLOBALS['replication_info'][$type]['status']) { - if ($type == "master") { - $replication->fillInfo( - $type, - 'Do_DB', - $server_master_replication[0], - 'Binlog_Do_DB' - ); - - $replication->fillInfo( - $type, - 'Ignore_DB', - $server_master_replication[0], - 'Binlog_Ignore_DB' - ); - } elseif ($type == "slave") { - $replication->fillInfo( - $type, - 'Do_DB', - $server_slave_replication[0], - 'Replicate_Do_DB' - ); - - $replication->fillInfo( - $type, - 'Ignore_DB', - $server_slave_replication[0], - 'Replicate_Ignore_DB' - ); - - $replication->fillInfo( - $type, - 'Do_Table', - $server_slave_replication[0], - 'Replicate_Do_Table' - ); - - $replication->fillInfo( - $type, - 'Ignore_Table', - $server_slave_replication[0], - 'Replicate_Ignore_Table' - ); - - $replication->fillInfo( - $type, - 'Wild_Do_Table', - $server_slave_replication[0], - 'Replicate_Wild_Do_Table' - ); - - $replication->fillInfo( - $type, - 'Wild_Ignore_Table', - $server_slave_replication[0], - 'Replicate_Wild_Ignore_Table' - ); - } - } -} |
