|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
#!/bin/bash
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
#
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
# This is an entrypoint that runs the MySQL server in the 'slave' mode.
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
#
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
export_vars=$(cgroup-limits); export $export_vars
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
source ${CONTAINER_SCRIPTS_PATH}/common.sh
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
set -eu
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
# Just run normal server if the data directory is already initialized
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
if [ -d "${MYSQL_DATADIR}/mysql" ]; then
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
exec /usr/bin/run-mysqld "$@"
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
fi
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
export MYSQL_RUNNING_AS_SLAVE=1
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
[ -f ${CONTAINER_SCRIPTS_PATH}/validate_replication_variables.sh ] && source ${CONTAINER_SCRIPTS_PATH}/validate_replication_variables.sh
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
# Generate the unique 'server-id' for this master
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
export MYSQL_SERVER_ID=$(server_id)
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
log_info "The 'slave' server-id is ${MYSQL_SERVER_ID}"
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
# Process the MySQL configuration files
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
envsubst < ${CONTAINER_SCRIPTS_PATH}/my-base.cnf.template > /etc/my.cnf.d/base.cnf
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
envsubst < ${CONTAINER_SCRIPTS_PATH}/my-paas.cnf.template > /etc/my.cnf.d/paas.cnf
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
envsubst < ${CONTAINER_SCRIPTS_PATH}/my-slave.cnf.template > /etc/my.cnf.d/slave.cnf
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
envsubst < ${CONTAINER_SCRIPTS_PATH}/my-repl-gtid.cnf.template > /etc/my.cnf.d/repl-gtid.cnf
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
envsubst < ${CONTAINER_SCRIPTS_PATH}/my-tuning.cnf.template > /etc/my.cnf.d/tuning.cnf
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
# Initialize MySQL database and wait for the MySQL master to accept
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
# connections.
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
initialize_database "$@"
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
wait_for_mysql_master
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
# Get binlog file and position from master
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
STATUS_INFO=$(mysql --host "$MYSQL_MASTER_SERVICE_NAME" "-u${MYSQL_MASTER_USER}" "-p${MYSQL_MASTER_PASSWORD}" replication -e 'SELECT gtid from replication limit 1\G')
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
GTID_VALUE=$(echo "$STATUS_INFO" | grep 'gtid:' | head -n 1 | sed -e 's/^\s*gtid: //')
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
# checking STATUS_INFO here because empty GTID_VALUE is valid value
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
if [ -z "${STATUS_INFO}" ] ; then
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
echo "Could not read GTID value from master"
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
exit 1
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
fi
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
mysql $mysql_flags <
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
STOP SLAVE;
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
SET GLOBAL gtid_slave_pos = "${GTID_VALUE}";
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
CHANGE MASTER TO MASTER_HOST='${MYSQL_MASTER_SERVICE_NAME}',MASTER_USER='${MYSQL_MASTER_USER}', MASTER_PASSWORD='${MYSQL_MASTER_PASSWORD}', MASTER_USE_GTID=slave_pos;
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
START SLAVE;
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
EOSQL
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
log_info 'Sourcing post-init.sh ...'
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
[ -f ${CONTAINER_SCRIPTS_PATH}/post-init.sh ] && source ${CONTAINER_SCRIPTS_PATH}/post-init.sh
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
# Restart the MySQL server with public IP bindings
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
shutdown_local_mysql
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
unset_env_vars
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
log_volume_info $MYSQL_DATADIR
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
log_info 'Running final exec -- Only MySQL server logs after this point'
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
exec ${MYSQL_PREFIX}/libexec/mysqld --defaults-file=$MYSQL_DEFAULTS_FILE \
|
|
![](https://seccdn.libravatar.org/avatar/3d0a4f295af5f9857ef04c3d8f6e89d5b4154c2463647b61e8e48ed700d065c7?s=16&d=retro) |
d27be39 |
--report-host=$(hostname -i) "$@" 2>&1
|