Server IP : 85.214.239.14 / Your IP : 3.12.71.166 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/3/root/var/www/wordpress/phpMyAdmin/libraries/classes/ |
Upload File : |
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Replication helpers * * @package PhpMyAdmin */ declare(strict_types=1); namespace PhpMyAdmin; /** * PhpMyAdmin\Replication class * * @package PhpMyAdmin */ class Replication { /** * Fill global replication_info variable. * * @param string $type Type: master, slave * @param string $replicationInfoKey Key in replication_info variable * @param array $mysqlInfo MySQL data about replication * @param string $mysqlKey MySQL key * * @return array */ public function fillInfo( $type, $replicationInfoKey, array $mysqlInfo, $mysqlKey ) { $GLOBALS['replication_info'][$type][$replicationInfoKey] = empty($mysqlInfo[$mysqlKey]) ? [] : explode( ",", $mysqlInfo[$mysqlKey] ); return $GLOBALS['replication_info'][$type][$replicationInfoKey]; } /** * Extracts database or table name from string * * @param string $string contains "dbname.tablename" * @param string $what what to extract (db|table) * * @return string the extracted part */ public function extractDbOrTable($string, $what = 'db') { $list = explode(".", $string); if ('db' == $what) { return $list[0]; } else { return $list[1]; } } /** * Configures replication slave * * @param string $action possible values: START or STOP * @param string $control default: null, * possible values: SQL_THREAD or IO_THREAD or null. * If it is set to null, it controls both * SQL_THREAD and IO_THREAD * @param integer $link mysql link * * @return mixed output of DatabaseInterface::tryQuery */ public function slaveControl($action, $control = null, $link = null) { /** @var DatabaseInterface $dbi */ global $dbi; $action = mb_strtoupper($action); $control = mb_strtoupper($control); if ($action != "START" && $action != "STOP") { return -1; } if ($control != "SQL_THREAD" && $control != "IO_THREAD" && $control != null) { return -1; } return $dbi->tryQuery($action . " SLAVE " . $control . ";", $link); } /** * Changes master for replication slave * * @param string $user replication user on master * @param string $password password for the user * @param string $host master's hostname or IP * @param int $port port, where mysql is running * @param array $pos position of mysql replication, * array should contain fields File and Position * @param bool $stop shall we stop slave? * @param bool $start shall we start slave? * @param mixed $link mysql link * * @return string output of CHANGE MASTER mysql command */ public function slaveChangeMaster( $user, $password, $host, $port, array $pos, $stop = true, $start = true, $link = null ) { if ($stop) { $this->slaveControl("STOP", null, $link); } $out = $GLOBALS['dbi']->tryQuery( 'CHANGE MASTER TO ' . 'MASTER_HOST=\'' . $host . '\',' . 'MASTER_PORT=' . ($port * 1) . ',' . 'MASTER_USER=\'' . $user . '\',' . 'MASTER_PASSWORD=\'' . $password . '\',' . 'MASTER_LOG_FILE=\'' . $pos["File"] . '\',' . 'MASTER_LOG_POS=' . $pos["Position"] . ';', $link ); if ($start) { $this->slaveControl("START", null, $link); } return $out; } /** * This function provides connection to remote mysql server * * @param string $user mysql username * @param string $password password for the user * @param string $host mysql server's hostname or IP * @param int $port mysql remote port * @param string $socket path to unix socket * * @return mixed mysql link on success */ public function connectToMaster( $user, $password, $host = null, $port = null, $socket = null ) { $server = []; $server['user'] = $user; $server['password'] = $password; $server["host"] = Core::sanitizeMySQLHost($host); $server["port"] = $port; $server["socket"] = $socket; // 5th parameter set to true means that it's an auxiliary connection // and we must not go back to login page if it fails return $GLOBALS['dbi']->connect(DatabaseInterface::CONNECT_AUXILIARY, $server); } /** * Fetches position and file of current binary log on master * * @param mixed $link mysql link * * @return array an array containing File and Position in MySQL replication * on master server, useful for slaveChangeMaster() */ public function slaveBinLogMaster($link = null) { $data = $GLOBALS['dbi']->fetchResult('SHOW MASTER STATUS', null, null, $link); $output = []; if (! empty($data)) { $output["File"] = $data[0]["File"]; $output["Position"] = $data[0]["Position"]; } return $output; } }