<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Replication helpers * * @package PhpMyAdmin */ if (! defined('PHPMYADMIN')) { exit; } /** * get master replication from server */ $server_master_replication = $GLOBALS['dbi']->fetchResult('SHOW MASTER STATUS'); /** * set selected master server */ if (! empty($_REQUEST['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( $_REQUEST['master_connection'] ) . "'" ); $GLOBALS['url_params']['master_connection'] = $_REQUEST['master_connection']; } } /** * get slave replication from server */ $server_slave_replication = $GLOBALS['dbi']->fetchResult('SHOW SLAVE STATUS'); /** * replication types */ $replication_types = array('master', 'slave'); /** * define variables for master status */ $master_variables = array( 'File', 'Position', 'Binlog_Do_DB', 'Binlog_Ignore_DB', ); /** * Define variables for slave status */ $slave_variables = array( '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 PMA_getHtmlForReplicationStatusTable() */ // TODO change to regexp or something, to allow for negative match. // To e.g. highlight 'Last_Error' // $slave_variables_alerts = array( 'Slave_IO_Running' => 'No', 'Slave_SQL_Running' => 'No', ); $slave_variables_oks = array( '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'] = array(); 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") { PMA_fillReplicationInfo( $type, 'Do_DB', $server_master_replication[0], 'Binlog_Do_DB' ); PMA_fillReplicationInfo( $type, 'Ignore_DB', $server_master_replication[0], 'Binlog_Ignore_DB' ); } elseif ($type == "slave") { PMA_fillReplicationInfo( $type, 'Do_DB', $server_slave_replication[0], 'Replicate_Do_DB' ); PMA_fillReplicationInfo( $type, 'Ignore_DB', $server_slave_replication[0], 'Replicate_Ignore_DB' ); PMA_fillReplicationInfo( $type, 'Do_Table', $server_slave_replication[0], 'Replicate_Do_Table' ); PMA_fillReplicationInfo( $type, 'Ignore_Table', $server_slave_replication[0], 'Replicate_Ignore_Table' ); PMA_fillReplicationInfo( $type, 'Wild_Do_Table', $server_slave_replication[0], 'Replicate_Wild_Do_Table' ); PMA_fillReplicationInfo( $type, 'Wild_Ignore_Table', $server_slave_replication[0], 'Replicate_Wild_Ignore_Table' ); } } } /** * 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 */ function PMA_fillReplicationInfo( $type, $replicationInfoKey, $mysqlInfo, $mysqlKey ) { $GLOBALS['replication_info'][$type][$replicationInfoKey] = empty($mysqlInfo[$mysqlKey]) ? array() : 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 */ function PMA_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 mixed $link mysql link * * @return mixed output of DatabaseInterface::tryQuery */ function PMA_Replication_Slave_control($action, $control = null, $link = null) { $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 $GLOBALS['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 */ function PMA_Replication_Slave_changeMaster($user, $password, $host, $port, $pos, $stop = true, $start = true, $link = null ) { if ($stop) { PMA_Replication_Slave_control("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) { PMA_Replication_Slave_control("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 $link mysql link on success */ function PMA_Replication_connectToMaster( $user, $password, $host = null, $port = null, $socket = null ) { $server = array(); $server["host"] = PMA_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($user, $password, false, $server, true); } /** * 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 PMA_Replication_Slave_changeMaster */ function PMA_Replication_Slave_binLogMaster($link = null) { $data = $GLOBALS['dbi']->fetchResult('SHOW MASTER STATUS', null, null, $link); $output = array(); if (! empty($data)) { $output["File"] = $data[0]["File"]; $output["Position"] = $data[0]["Position"]; } return $output; }
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
bfShapeFiles | Folder | 0755 |
|
|
config | Folder | 0755 |
|
|
controllers | Folder | 0755 |
|
|
dbi | Folder | 0755 |
|
|
di | Folder | 0755 |
|
|
engines | Folder | 0755 |
|
|
gis | Folder | 0755 |
|
|
navigation | Folder | 0755 |
|
|
plugins | Folder | 0755 |
|
|
properties | Folder | 0755 |
|
|
rte | Folder | 0755 |
|
|
sql-parser | Folder | 0755 |
|
|
Advisor.php | File | 15.13 KB | 0644 |
|
Config.php | File | 54.7 KB | 0644 |
|
Console.php | File | 14.82 KB | 0644 |
|
DatabaseInterface.php | File | 95.6 KB | 0644 |
|
DbList.php | File | 1.9 KB | 0644 |
|
DbQbe.php | File | 68.87 KB | 0644 |
|
DbSearch.php | File | 17.21 KB | 0644 |
|
DisplayResults.php | File | 206 KB | 0644 |
|
Error.php | File | 12.7 KB | 0644 |
|
ErrorHandler.php | File | 16.48 KB | 0644 |
|
File.php | File | 18.82 KB | 0644 |
|
Font.php | File | 4.24 KB | 0644 |
|
Footer.php | File | 10.52 KB | 0644 |
|
Header.php | File | 25.34 KB | 0644 |
|
Index.php | File | 23.79 KB | 0644 |
|
IndexColumn.php | File | 4.46 KB | 0644 |
|
Language.php | File | 4.27 KB | 0644 |
|
LanguageManager.php | File | 20.75 KB | 0644 |
|
Linter.php | File | 5.02 KB | 0644 |
|
ListAbstract.php | File | 3.15 KB | 0644 |
|
ListDatabase.php | File | 4.62 KB | 0644 |
|
Menu.php | File | 21.14 KB | 0644 |
|
Message.php | File | 18.67 KB | 0644 |
|
OutputBuffering.php | File | 3.59 KB | 0644 |
|
PDF.php | File | 3.94 KB | 0644 |
|
Partition.php | File | 7.26 KB | 0644 |
|
Psr4Autoloader.php | File | 4.85 KB | 0644 |
|
RecentFavoriteTable.php | File | 11.78 KB | 0644 |
|
Response.php | File | 12.61 KB | 0644 |
|
SavedSearches.php | File | 11.67 KB | 0644 |
|
Scripts.php | File | 7.38 KB | 0644 |
|
ServerStatusData.php | File | 15.72 KB | 0644 |
|
StorageEngine.php | File | 13.61 KB | 0644 |
|
SubPartition.php | File | 3.52 KB | 0644 |
|
SysInfo.php | File | 799 B | 0644 |
|
SysInfoLinux.php | File | 1.92 KB | 0644 |
|
SysInfoSunOS.php | File | 1.86 KB | 0644 |
|
SysInfoWINNT.php | File | 3.08 KB | 0644 |
|
SystemDatabase.php | File | 3.66 KB | 0644 |
|
Table.php | File | 88.12 KB | 0644 |
|
Template.php | File | 4.45 KB | 0644 |
|
Theme.php | File | 11.34 KB | 0644 |
|
ThemeManager.php | File | 12.91 KB | 0644 |
|
Tracker.php | File | 30.35 KB | 0644 |
|
Types.php | File | 6.08 KB | 0644 |
|
TypesMySQL.php | File | 17.26 KB | 0644 |
|
Util.php | File | 172.46 KB | 0644 |
|
VersionInformation.php | File | 7.87 KB | 0644 |
|
ZipFile.php | File | 6.63 KB | 0644 |
|
advisor.lib.php | File | 1.6 KB | 0644 |
|
advisory_rules.txt | File | 25.94 KB | 0644 |
|
autoloader.php | File | 450 B | 0644 |
|
bookmark.lib.php | File | 8.5 KB | 0644 |
|
browse_foreigners.lib.php | File | 9.83 KB | 0644 |
|
central_columns.lib.php | File | 49.38 KB | 0644 |
|
charset_conversion.lib.php | File | 3.54 KB | 0644 |
|
check_user_privileges.lib.php | File | 10.65 KB | 0644 |
|
cleanup.lib.php | File | 1.29 KB | 0644 |
|
common.inc.php | File | 34.38 KB | 0644 |
|
config.default.php | File | 66.5 KB | 0644 |
|
config.values.php | File | 10.17 KB | 0644 |
|
core.lib.php | File | 29.94 KB | 0644 |
|
create_addfield.lib.php | File | 15.68 KB | 0644 |
|
database_interface.inc.php | File | 2.63 KB | 0644 |
|
db_common.inc.php | File | 3.12 KB | 0644 |
|
db_designer.lib.php | File | 10.4 KB | 0644 |
|
db_table_exists.lib.php | File | 3.21 KB | 0644 |
|
display_change_password.lib.php | File | 5.45 KB | 0644 |
|
display_create_table.lib.php | File | 1.53 KB | 0644 |
|
display_export.lib.php | File | 38.11 KB | 0644 |
|
display_git_revision.lib.php | File | 3.04 KB | 0644 |
|
display_import.lib.php | File | 24.34 KB | 0644 |
|
display_import_ajax.lib.php | File | 3.13 KB | 0644 |
|
display_select_lang.lib.php | File | 2.36 KB | 0644 |
|
error.inc.php | File | 1.21 KB | 0644 |
|
error_report.lib.php | File | 10.25 KB | 0644 |
|
export.lib.php | File | 35.16 KB | 0644 |
|
file_listing.lib.php | File | 2.37 KB | 0644 |
|
iconv_wrapper.lib.php | File | 3.88 KB | 0644 |
|
import.lib.php | File | 50.64 KB | 0644 |
|
index.lib.php | File | 1.37 KB | 0644 |
|
information_schema_relations.lib.php | File | 10.95 KB | 0644 |
|
insert_edit.lib.php | File | 112.79 KB | 0644 |
|
ip_allow_deny.lib.php | File | 9.35 KB | 0644 |
|
js_escape.lib.php | File | 4.43 KB | 0644 |
|
kanji-encoding.lib.php | File | 4.46 KB | 0644 |
|
language_stats.inc.php | File | 1.45 KB | 0644 |
|
logging.lib.php | File | 521 B | 0644 |
|
mime.lib.php | File | 704 B | 0644 |
|
mult_submits.inc.php | File | 10.64 KB | 0644 |
|
mult_submits.lib.php | File | 20.44 KB | 0644 |
|
mysql_charsets.inc.php | File | 4.09 KB | 0644 |
|
mysql_charsets.lib.php | File | 10.47 KB | 0644 |
|
mysql_relations.lib.php | File | 5.12 KB | 0644 |
|
normalization.lib.php | File | 33.98 KB | 0644 |
|
opendocument.lib.php | File | 7.94 KB | 0644 |
|
operations.lib.php | File | 73.64 KB | 0644 |
|
parse_analyze.lib.php | File | 2.12 KB | 0644 |
|
plugin_interface.lib.php | File | 19.69 KB | 0644 |
|
plugin_interface.lib.php.bak | File | 19.69 KB | 0644 |
|
pmd_common.php | File | 24.2 KB | 0644 |
|
relation.lib.php | File | 68.41 KB | 0644 |
|
relation_cleanup.lib.php | File | 13.84 KB | 0644 |
|
replication.inc.php | File | 8.82 KB | 0644 |
|
replication_gui.lib.php | File | 37.45 KB | 0644 |
|
sanitizing.lib.php | File | 6.3 KB | 0644 |
|
select_server.lib.php | File | 3.4 KB | 0644 |
|
server_common.inc.php | File | 1.22 KB | 0644 |
|
server_common.lib.php | File | 1.92 KB | 0644 |
|
server_privileges.lib.php | File | 179.22 KB | 0644 |
|
server_status.lib.php | File | 9.92 KB | 0644 |
|
server_status_advisor.lib.php | File | 1.89 KB | 0644 |
|
server_status_monitor.lib.php | File | 26.22 KB | 0644 |
|
server_status_processes.lib.php | File | 9.57 KB | 0644 |
|
server_status_queries.lib.php | File | 4.86 KB | 0644 |
|
server_status_variables.lib.php | File | 28.95 KB | 0644 |
|
server_user_groups.lib.php | File | 12.8 KB | 0644 |
|
server_users.lib.php | File | 1.35 KB | 0644 |
|
session.inc.php | File | 5.22 KB | 0644 |
|
session.lib.php | File | 735 B | 0644 |
|
special_schema_links.lib.php | File | 17.51 KB | 0644 |
|
sql.lib.php | File | 77.51 KB | 0644 |
|
sql.lib.php.bak | File | 77.51 KB | 0644 |
|
sql_query_form.lib.php | File | 15.71 KB | 0644 |
|
string.lib.php | File | 800 B | 0644 |
|
stringMb.lib.php | File | 1.86 KB | 0644 |
|
stringNative.lib.php | File | 6.82 KB | 0644 |
|
sysinfo.lib.php | File | 1.34 KB | 0644 |
|
tbl_columns_definition_form.inc.php | File | 13.55 KB | 0644 |
|
tbl_common.inc.php | File | 1.3 KB | 0644 |
|
tbl_info.inc.php | File | 3.54 KB | 0644 |
|
tbl_partition_definition.inc.php | File | 5.55 KB | 0644 |
|
tracking.lib.php | File | 54.93 KB | 0644 |
|
transformations.lib.php | File | 14.63 KB | 0644 |
|
url_generating.lib.php | File | 6.77 KB | 0644 |
|
user_preferences.inc.php | File | 2.38 KB | 0644 |
|
user_preferences.lib.php | File | 8.17 KB | 0644 |
|
util.lib.php | File | 749 B | 0644 |
|
vendor_config.php | File | 2.49 KB | 0644 |
|
zip_extension.lib.php | File | 5.38 KB | 0644 |
|