| Server IP : 185.86.78.101 / Your IP : 216.73.216.213 Web Server : Apache System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,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_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /www/server/mysql/mysql-test/include/ |
Upload File : |
# ==== Purpose ====
#
# Create the default connections to the cluster nodes server1,
# server2, server3...
# If you need more than 2 servers, please add them to cnf file.
# Example:
##!include ../my.cnf
##
##[mysqld.3]
##
##[mysqld.4]
##
##[ENV]
##SERVER_MYPORT_3= @mysqld.3.port
##SERVER_MYSOCK_3= @mysqld.3.socket
##
##SERVER_MYPORT_4= @mysqld.4.port
##SERVER_MYSOCK_4= @mysqld.4.socket
#
# If master.opt file exists, it will be applied to servers 3 and
# greater.
#
# ==== Usage ====
#
# [--let $rpl_group_replication_reconnect= 1]
# --source include/rpl_group_replication_default_connections.inc
#
# Parameters:
# $rpl_group_replication_reconnect
# If this parameter is set then disconnect current connection.
# This is to be used when connection is open and we want to
# reconnect so session variable can be reinitialized with
# its corresponding global value.
--let $include_filename= rpl_group_replication_default_connections.inc
--source include/begin_include_file.inc
# To distinguish between rpl and group_replication suite, we are
# setting $using_rpl_group_replication_default_connections.
# As only group_replication suite includes it, so this variable
# will be true only for group_replication suite.
--let $using_rpl_group_replication_default_connections= 1
--let $_rpl_server_max= 10
--let $_rpl_server_number= 1
while ($_rpl_server_number <= $_rpl_server_max)
{
--let $_rpl_server_port= \$SERVER_MYPORT_$_rpl_server_number
if (!$_rpl_server_port)
{
# We exceeded the number of servers specified on cnf file.
--let $_rpl_server_number= $_rpl_server_max
}
if ($_rpl_server_port)
{
--let $rpl_connection_name= server$_rpl_server_number
--let $rpl_server_number= $_rpl_server_number
# reconnection
if ($rpl_group_replication_reconnect)
{
--disconnect $rpl_connection_name
}
--source include/rpl_connect.inc
}
--inc $_rpl_server_number
}
# unset the value so next call doesn't reconnect without
# explicitly setting $rpl_group_replication_reconnect
--let $rpl_group_replication_reconnect= 0
--let $include_filename= rpl_group_replication_default_connections.inc
--source include/end_include_file.inc