' . "\n" . PMA_getIcon('s_replication.png') . __('Replication') . "\n" . '' . "\n"; PMA_Message::error(__('No Privileges'))->display(); include 'libraries/footer.inc.php'; } /** * Sets globals from $_REQUEST */ $request_params = array( 'hostname', 'mr_adduser', 'mr_configure', 'pma_pw', 'port', 'repl_clear_scr', 'repl_data', 'sl_configure', 'sl_sync', 'slave_changemaster', 'sr_skip_errors_count', 'sr_slave_action', 'sr_slave_control_parm', 'sr_slave_server_control', 'sr_slave_skip_error', 'sr_take_action', 'url_params', 'username' ); foreach ($request_params as $one_request_param) { if (isset($_REQUEST[$one_request_param])) { $GLOBALS[$one_request_param] = $_REQUEST[$one_request_param]; } } /** * Handling control requests */ if (isset($GLOBALS['sr_take_action'])) { $refresh = false; if (isset($GLOBALS['slave_changemaster'])) { $_SESSION['replication']['m_username'] = $sr['username'] = PMA_sqlAddSlashes($GLOBALS['username']); $_SESSION['replication']['m_password'] = $sr['pma_pw'] = PMA_sqlAddSlashes($GLOBALS['pma_pw']); $_SESSION['replication']['m_hostname'] = $sr['hostname'] = PMA_sqlAddSlashes($GLOBALS['hostname']); $_SESSION['replication']['m_port'] = $sr['port'] = PMA_sqlAddSlashes($GLOBALS['port']); $_SESSION['replication']['m_correct'] = ''; $_SESSION['replication']['sr_action_status'] = 'error'; $_SESSION['replication']['sr_action_info'] = __('Unknown error'); // Attempt to connect to the new master server $link_to_master = PMA_replication_connect_to_master($sr['username'], $sr['pma_pw'], $sr['hostname'], $sr['port']); if (! $link_to_master) { $_SESSION['replication']['sr_action_status'] = 'error'; $_SESSION['replication']['sr_action_info'] = sprintf(__('Unable to connect to master %s.'), htmlspecialchars($sr['hostname'])); } else { // Read the current master position $position = PMA_replication_slave_bin_log_master($link_to_master); if (empty($position)) { $_SESSION['replication']['sr_action_status'] = 'error'; $_SESSION['replication']['sr_action_info'] = __('Unable to read master log position. Possible privilege problem on master.'); } else { $_SESSION['replication']['m_correct'] = true; if (! PMA_replication_slave_change_master($sr['username'], $sr['pma_pw'], $sr['hostname'], $sr['port'], $position, true, false)) { $_SESSION['replication']['sr_action_status'] = 'error'; $_SESSION['replication']['sr_action_info'] = __('Unable to change master'); } else { $_SESSION['replication']['sr_action_status'] = 'success'; $_SESSION['replication']['sr_action_info'] = sprintf(__('Master server changed successfully to %s'), htmlspecialchars($sr['hostname'])); } } } } elseif (isset($GLOBALS['sr_slave_server_control'])) { if ($GLOBALS['sr_slave_action'] == 'reset') { PMA_replication_slave_control("STOP"); PMA_DBI_try_query("RESET SLAVE;"); PMA_replication_slave_control("START"); } else { PMA_replication_slave_control($GLOBALS['sr_slave_action'], $GLOBALS['sr_slave_control_parm']); } $refresh = true; } elseif (isset($GLOBALS['sr_slave_skip_error'])) { $count = 1; if (isset($GLOBALS['sr_skip_errors_count'])) { $count = $GLOBALS['sr_skip_errors_count'] * 1; } PMA_replication_slave_control("STOP"); PMA_DBI_try_query("SET GLOBAL SQL_SLAVE_SKIP_COUNTER = ".$count.";"); PMA_replication_slave_control("START"); } elseif (isset($GLOBALS['sl_sync'])) { // TODO username, host and port could be read from 'show slave status', // when asked for a password this might work in more situations then just after changing master (where the master password is stored in session) $src_link = PMA_replication_connect_to_master($_SESSION['replication']['m_username'], $_SESSION['replication']['m_password'], $_SESSION['replication']['m_hostname'], $_SESSION['replication']['m_port']); $trg_link = null; // using null to indicate the current PMA server $data = PMA_DBI_fetch_result('SHOW MASTER STATUS', null, null, $src_link); // let's find out, which databases are replicated $do_db = array(); $ignore_db = array(); $dblist = array(); if (! empty($data[0]['Binlog_Do_DB'])) { $do_db = explode(',', $data[0]['Binlog_Do_DB']); } if (! empty($data[0]['Binlog_Ignore_DB'])) { $ignore_db = explode(',', $data[0]['Binlog_Ignore_DB']); } $tmp_alldbs = PMA_DBI_query('SHOW DATABASES;', $src_link); while ($tmp_row = PMA_DBI_fetch_row($tmp_alldbs)) { if (PMA_is_system_schema($tmp_row[0])) { continue; } if (count($do_db) == 0) { if (array_search($tmp_row[0], $ignore_db) !== false) { continue; } $dblist[] = $tmp_row[0]; PMA_DBI_query('CREATE DATABASE IF NOT EXISTS '.PMA_backquote($tmp_row[0]), $trg_link); } else { if (array_search($tmp_row[0], $do_db) !== false) { $dblist[] = $tmp_row[0]; PMA_DBI_query('CREATE DATABASE IF NOT EXISTS '.PMA_backquote($tmp_row[0]), $trg_link); } } } // end while unset($do_db, $ignore_db, $data); if (isset($GLOBALS['repl_data'])) { $include_data = true; } else { $include_data = false; } foreach ($dblist as $db) { PMA_replication_synchronize_db($db, $src_link, $trg_link, $include_data); } // TODO some form of user feedback error/success would be nice // What happens if $dblist is empty? // or sync failed? } if ($refresh) { Header("Location: ". PMA_generate_common_url($GLOBALS['url_params'])); } unset($refresh); } echo '
'; echo '

'; echo ' ' . PMA_getImage('s_replication.png'); echo __('Replication'); echo '

'; // Display error messages if (isset($_SESSION['replication']['sr_action_status']) && isset($_SESSION['replication']['sr_action_info'])) { if ($_SESSION['replication']['sr_action_status'] == 'error') { PMA_Message::error($_SESSION['replication']['sr_action_info'])->display(); $_SESSION['replication']['sr_action_status'] = 'unknown'; } elseif ($_SESSION['replication']['sr_action_status'] == 'success') { PMA_Message::success($_SESSION['replication']['sr_action_info'])->display(); $_SESSION['replication']['sr_action_status'] = 'unknown'; } } if ($server_master_status) { if (! isset($GLOBALS['repl_clear_scr'])) { echo '
'; echo '' . __('Master replication') . ''; echo __('This server is configured as master in a replication process.'); echo '"; echo "
"; } } elseif (! isset($GLOBALS['mr_configure']) && ! isset($GLOBALS['repl_clear_scr'])) { $_url_params = $GLOBALS['url_params']; $_url_params['mr_configure'] = true; echo '
'; echo '' . __('Master replication') . ''; echo sprintf(__('This server is not configured as master in a replication process. Would you like to configure it?'), PMA_generate_common_url($_url_params)); echo '
'; } if (isset($GLOBALS['mr_configure'])) { // Render the 'Master configuration' section echo '
'; echo '' . __('Master configuration') . ''; echo __('This server is not configured as master server in a replication process. You can choose from either replicating all databases and ignoring certain (useful if you want to replicate majority of databases) or you can choose to ignore all databases by default and allow only certain databases to be replicated. Please select the mode:') . '

'; echo ''; echo '

'; echo __('Please select databases:') . '
'; echo PMA_replication_db_multibox(); echo '

'; echo __('Now, add the following lines at the end of [mysqld] section in your my.cnf and please restart the MySQL server afterwards.') . '
'; echo '
';
    echo __('Once you restarted MySQL server, please click on Go button. Afterwards, you should see a message informing you, that this server is configured as master');
    echo '
';
    echo '
';
    echo ' 
';
    echo PMA_generate_common_hidden_inputs('', '');
    echo '  ';
    echo ' 
';
    echo '
';

    include 'libraries/footer.inc.php';
    exit;
}

echo '
';

if (! isset($GLOBALS['repl_clear_scr'])) {
    // Render the 'Slave configuration' section
    echo '
';
    echo '' . __('Slave replication') . '';
    if ($server_slave_status) {
        echo '
';

        $_url_params = $GLOBALS['url_params'];
        $_url_params['sr_take_action'] = true;
        $_url_params['sr_slave_server_control'] = true;

        if ($server_slave_replication[0]['Slave_IO_Running'] == 'No') {
            $_url_params['sr_slave_action'] = 'start';
        } else {
            $_url_params['sr_slave_action'] = 'stop';
        }

        $_url_params['sr_slave_control_parm'] = 'IO_THREAD';
        $slave_control_io_link = PMA_generate_common_url($_url_params);

        if ($server_slave_replication[0]['Slave_SQL_Running'] == 'No') {
            $_url_params['sr_slave_action'] = 'start';
        } else {
            $_url_params['sr_slave_action'] = 'stop';
        }

        $_url_params['sr_slave_control_parm'] = 'SQL_THREAD';
        $slave_control_sql_link = PMA_generate_common_url($_url_params);

        if ($server_slave_replication[0]['Slave_IO_Running'] == 'No'
            || $server_slave_replication[0]['Slave_SQL_Running'] == 'No'
        ) {
            $_url_params['sr_slave_action'] = 'start';
        } else {
            $_url_params['sr_slave_action'] = 'stop';
        }

        $_url_params['sr_slave_control_parm'] = null;
        $slave_control_full_link = PMA_generate_common_url($_url_params);

        $_url_params['sr_slave_action'] = 'reset';
        $slave_control_reset_link = PMA_generate_common_url($_url_params);

        $_url_params = $GLOBALS['url_params'];
        $_url_params['sr_slave_skip_error'] = true;
        $slave_skip_error_link = PMA_generate_common_url($_url_params);

        if ($server_slave_replication[0]['Slave_SQL_Running'] == 'No') {
            PMA_Message::error(__('Slave SQL Thread not running!'))->display();
        }
        if ($server_slave_replication[0]['Slave_IO_Running'] == 'No') {
            PMA_Message::error(__('Slave IO Thread not running!'))->display();
        }

        $_url_params = $GLOBALS['url_params'];
        $_url_params['sl_configure'] = true;
        $_url_params['repl_clear_scr'] = true;

        $reconfiguremaster_link = PMA_generate_common_url($_url_params);

        echo __('Server is configured as slave in a replication process. Would you like to:');
        echo '
';
        echo '';
        echo '
';

    } elseif (! isset($GLOBALS['sl_configure'])) {
        $_url_params = $GLOBALS['url_params'];
        $_url_params['sl_configure'] = true;
        $_url_params['repl_clear_scr'] = true;

        echo sprintf(__('This server is not configured as slave in a replication process. Would you like to configure it?'), PMA_generate_common_url($_url_params));
    }
    echo '
';
}
if (isset($GLOBALS['sl_configure'])) {
    PMA_replication_gui_changemaster("slave_changemaster");
}
require 'libraries/footer.inc.php';
?>