Subversion Repositories ALCASAR

Rev

Rev 3308 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 3308 Rev 3309
Line 22... Line 22...
22 
readonly DB_ROOT_PWD
 22 
readonly DB_ROOT_PWD
23 
REPL_PWD="$(tr -dc "a-zA-Z0-9" < /dev/random | head -c "$REPL_PWD_LENGTH")"
 23 
REPL_PWD="$(tr -dc "a-zA-Z0-9" < /dev/random | head -c "$REPL_PWD_LENGTH")"
24 
readonly REPL_PWD
 24 
readonly REPL_PWD
25 
REPL_DB_PWD="$(tr -dc "a-zA-Z0-9" < /dev/random | head -c "$REPL_DB_PWD_LENGTH")"
 25 
REPL_DB_PWD="$(tr -dc "a-zA-Z0-9" < /dev/random | head -c "$REPL_DB_PWD_LENGTH")"
26 
readonly REPL_DB_PWD
 26 
readonly REPL_DB_PWD
27 
# SRV_ID must be < 2^32, see server_id variable of MariaDB
 - 
 
28 
SRV_ID="$(cat /dev/urandom | tr -dc "0-9" | head -c 9)"
 - 
 
29 
readonly SRV_ID
 - 
 
30 
 
 - 
 
31 
 
 27 
 
32 
# Execute SQL queries on local server
 28 
# Execute SQL queries on local server
33 
exec_query() {
 29 
exec_query() {
34 
	if [ $# -ne 1 ]
 30 
	if [ $# -ne 1 ]
35 
	then
 31 
	then
Line 88... Line 84...
88 
 
 84 
 
89 
# Listen on localhost
 85 
# Listen on localhost
90 
sed -i "s?^.*skip-networking.*?#skip-networking?" "$DB_CONF"
 86 
sed -i "s?^.*skip-networking.*?#skip-networking?" "$DB_CONF"
91 
sed -i "s?^#bind-address.*?bind-address=127.0.0.1?" "$DB_CONF"
 87 
sed -i "s?^#bind-address.*?bind-address=127.0.0.1?" "$DB_CONF"
92 
 
 88 
 
93 
# Be sure to not have same server_id on members of replication architecture
 - 
 
94 
sed -i "s?^server_id.*?server_id=$SVR_ID?g" "$DB_CONF"
 - 
 
95 
 
 - 
 
96 
# Apply binary logging
 89 
# Apply binary logging
97 
echo "Restarting MariaDB..."
 90 
echo "Restarting MariaDB..."
98 
/usr/bin/systemctl restart mariadb.service
 91 
/usr/bin/systemctl restart mariadb.service
- 
 
 92 
echo "initializing binary logging"
- 
 
 93 
exec_query "RESET MASTER" || exit
99 
 
 94 
 
100 
# User for SSH tunneling
 95 
# User for SSH tunneling
101 
echo "Creating replication user..."
 96 
echo "Creating replication user..."
102 
/usr/sbin/useradd -s /bin/sh -m "$REPL_USER"
 97 
/usr/sbin/useradd -s /bin/sh -m "$REPL_USER"
103 
echo -e "$REPL_PWD\n$REPL_PWD" | passwd "$REPL_USER"
 98 
echo -e "$REPL_PWD\n$REPL_PWD" | passwd "$REPL_USER"