ubuntu_20安装单例_redis_mysql_nginx

安装redis单例

• 推荐官网下载-根据自己的系统和cpu类型选择下载

https://redis.io/download/#redis-downloads

tar -zxvf redis.7.0.5.tar.gz
mv redis-7.0.5 /usr/local/redis
sudo apt install gcc pkg-config make libc6-dev avr-libc

cd /usr/local/redis
sudo make MALLOC=libc

• 常见编译报错

/usr/bin/ld: 找不到 ../deps/linenoise/linenoise.o: 没有那个文件或目录
类似这样的报错直接进入到.o文件的目录,单个编译就行,比如:
cd ./deps/linenoise/linenoise.o
sudo make linenoise.o

sudo make install

sudo cp src/redis-server /usr/local/bin/
sudo cp src/redis-cli /usr/local/bin/
sudo cp redis.conf /etc/redis/6379.conf
sudo cp utils/systemd-redis_server.service /etc/systemd/system/redis.service

systemctl daemon-reload
#systemctl enable redis
systemctl start redis 

安装mysql单例

• 推荐官网下载-根据自己的系统和cpu类型选择下载

https://dev.mysql.com/downloads/mysql/
https://downloads.mysql.com/archives/community/

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.38-linux-glibc2.17-x86_64.tar.xz

• 先解压资源包

解压.tar.gz 用 tar -zxvf
解压.tar 用 tar -xvf
解压.xz 用 xz -d

xz -d mysql-8.0.38-linux-glibc2.17-x86_64.tar.xz
tar -xvf mysql-8.0.38-linux-glibc2.17-x86_64.tar
mv mysql-8.0.38-linux-glibc2.17-x86_64 /usr/local/mysql

• 创建安装过程会依赖的文件

sudo apt update
sudo apt --fix-broken install
sudo apt-get install libaio1 libaio-dev libc6-dev libc6-dev-armel-cross libc6-dev-armhf-cross net-tools
sudo apt-get -f install
sudo apt autoremove
sudo apt upgrade
sudo apt clean

安装初始化mysql脚本

#!/bin/bash
NOW_HOME="$( cd $(dirname $0) && pwd )"
cd ${NOW_HOME}
sudo groupadd mysql
sudo useradd -g mysql mysql

find /usr/bin/ -type l -name 'mysql*' -exec /bin/rm {} \;

sudo mkdir -p /usr/local/mysql/data
sudo mkdir -p /usr/local/mysql/bin
sudo mkdir -p /var/run/mysqld
sudo mkdir -p /var/lib/mysql
sudo touch /var/log/mysqld.log
sudo ln -sf /usr/local/mysql/bin/* /usr/bin/
sudo ln -sf /usr/local/mysql/bin/mysqld /usr/sbin/mysqld

sudo chown -R mysql:mysql /usr/local/mysql
sudo chown -R mysql:mysql /var/run/mysqld
sudo chown -R mysql:mysql /var/lib/mysql
sudo chown mysql.mysql /var/log/mysqld.log
sudo chmod 755 /usr/local/mysql/bin/*


sudo rm -rf /usr/local/mysql/data/*
sudo rm -rf /etc/my.cnf
sudo mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --socket=/usr/local/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --lower_case_table_names=1

INIT_PWD=$(cat /var/log/mysqld.log | sed -n "s/.*A temporary password is generated for root@localhost\: \(.*\)$/\1/p" | tail -n 1)
echo "initialize password: ${INIT_PWD}"
if [[ "${INIT_PWD}" == '' ]];then
    echo "initialize mysql error"
    cat /var/log/mysqld.log | grep '[ERROR]' | tail -n 10
    exit 1
fi

sudo touch /etc/my.cnf /usr/bin/mysqld_pre_systemd
sudo chown mysql:mysql /etc/my.cnf /usr/bin/mysqld_pre_systemd
sudo chmod 644 /etc/my.cnf
sudo chmod 755 /usr/bin/mysqld_pre_systemd

cat <<'EOT' > /etc/my.cnf
[client]
port=13306
socket=/var/lib/mysql/mysql.sock

[mysql]
port=13306
socket=/var/lib/mysql/mysql.sock

[mysqld_safe]
port=13306
socket=/var/lib/mysql/mysql.sock

[mysqld]
port=13306
socket=/var/lib/mysql/mysql.sock
character_set_server=utf8mb4
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
lower_case_table_names=1
datadir=/usr/local/mysql/data
lc-messages-dir=/usr/local/mysql/share/english
plugin_dir=/usr/lib64/mysql/plugin
symbolic-links=0
max_connections=600
innodb_file_per_table=1
default-time_zone='+08:00'
default-storage-engine=INNODB
sql_mode='STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION'
#每个节点设置不同的唯一ID
server_id=1
gtid_mode=ON
#默认目录为datadir设置的目录,可指定绝对路径
log_bin=mysql-bin
#从节点回放日志存放路径,主库也需要设置,方便后期主从切换
relay_log=relay-log
enforce-gtid-consistency=true
log-slave-updates=1
relay-log-info-repository=TABLE
relay_log_recovery=1
master-info-repository=TABLE
#full; minimal; noblob
binlog_row_image=minimal
#STATEMENT; ROW; MIXED
binlog_format=ROW
#binlog-do-db=bs_account,bs_account_flowable,bs_saas,dep,exchangis,express_gateway,information_schema,lapp_act,lapp_flowable_ng,lapp_ng,lapp_uom,mysql,nacos,performance_schema,plat_apigw,plat_corp,plat_dp,plat_dr,powerjob-product,sftpgo,sys,work
#binlog-ignore-db=mysql
#binlog-ignore-db=information_schema
#binlog-ignore-db=performance_schema
#binlog-ignore-db=sys
EOT

cat <<'EOT' > /usr/bin/mysqld_pre_systemd
#!/bin/bash

get_option () {
    local section=$1
    local option=$2
    local default=$3
    local instance=$4
    ret=$(/usr/bin/my_print_defaults  ${instance:+--defaults-group-suffix=@$instance} $section | \
	      grep '^--'${option}'=' | cut -d= -f2- | tail -n 1)
    [ -z "$ret" ] && ret=$default
    echo $ret
}

install_validate_password_sql_file () {
    local initfile
    initfile="$(mktemp /var/lib/mysql-files/install-validate-password-plugin.XXXXXX.sql)"
    chmod a+r "$initfile"
    echo "SET @@SESSION.SQL_LOG_BIN=0;" > "$initfile"
    echo "INSERT INTO mysql.component (component_id, component_group_id, component_urn) VALUES (1, 1, 'file://component_validate_password');" >> $initfile
    echo $initfile
}

fix_mysql_upgrade_info () {
    datadir=$(get_option mysqld datadir "/var/lib/mysql${instance:+-$instance}" $instance)
    if [ -d  "$datadir" ]  && [ -O "$datadir/mysql_upgrade_info" ]; then
	chown --reference="$datadir" "$datadir/mysql_upgrade_info"
	if [ -x /usr/bin/chcon ]; then
            /usr/bin/chcon --reference="$datadir" "$datadir/mysql_upgrade_info" > /dev/null 2>&1
	fi
    fi
}

install_db () {
    # Note: something different than datadir=/var/lib/mysql requires SELinux policy changes (in enforcing mode)

    # mysql_upgrade_info file should be owned by mysql user since MySQL 8.0.16
    fix_mysql_upgrade_info

    # No automatic init wanted
    [ -e /etc/sysconfig/mysql ] && . /etc/sysconfig/mysql
    [ -n "$NO_INIT" ] && exit 0

    local instance=$1
    datadir=$(get_option mysqld datadir "/var/lib/mysql${instance:+-$instance}" $instance)
    log=$(get_option mysqld 'log[_-]error' "/var/log/mysql${instance:+-$instance}.log" $instance)

    # Restore log, dir, perms and SELinux contexts

    if [ ! -d "$datadir" -a ! -h "$datadir" -a "x$(dirname "$datadir")" = "x/var/lib" ]; then
	install -d -m 0751 -omysql -gmysql "$datadir" || exit 1
    fi

    if [ ! -e "$log" -a ! -h "$log" -a x$(dirname "$log") = "x/var/log" ]; then
	case $(basename "$log") in
	    mysql*.log) install /dev/null -m0640 -omysql -gmysql "$log" ;;
	    *) ;;
	esac
    fi

    if [ -x /usr/sbin/restorecon ]; then
        /usr/sbin/restorecon "$datadir"
        [ -e "$log" ] && /usr/sbin/restorecon "$log"
	for dir in /var/lib/mysql-files /var/lib/mysql-keyring ; do
            if [ -x /usr/sbin/semanage -a -d /var/lib/mysql -a -d $dir ] ; then
                /usr/sbin/semanage fcontext -a -e /var/lib/mysql $dir >/dev/null 2>&1
                /sbin/restorecon -r $dir
            fi
	done
    fi

    # If special mysql dir is in place, skip db install
    [ -d "$datadir/mysql" ] && exit 0

    # Create initial db and install validate_password plugin
    initfile="$(install_validate_password_sql_file)"
    /usr/sbin/mysqld ${instance:+--defaults-group-suffix=@$instance} --initialize \
		     --datadir="$datadir" --user=mysql --init-file="$initfile"
    rm -f "$initfile"

    # Generate certs if needed
    if [ -x /usr/bin/mysql_ssl_rsa_setup -a ! -e "${datadir}/server-key.pem" ] ; then
        /usr/bin/mysql_ssl_rsa_setup --datadir="$datadir" --uid=mysql >/dev/null 2>&1
    fi
    exit 0
}

install_db $1

exit 0

EOT


cat <<'EOT' > /usr/lib/systemd/system/mysqld.service

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network-online.target
Wants=network-online.target
After=syslog.target

[Install]
WantedBy=multi-user.target

[Service]
User=mysql
Group=mysql

Type=notify

# Disable service start and stop timeout logic of systemd for mysqld service.
TimeoutSec=0

# Execute pre and post scripts as root
PermissionsStartOnly=true

# Needed to create system tables
ExecStartPre=/usr/bin/mysqld_pre_systemd

# Start main service
ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS

# Use this to switch malloc implementation
EnvironmentFile=-/etc/sysconfig/mysql

# Sets open_files_limit
LimitNOFILE = 10000

Restart=on-failure

RestartPreventExitStatus=1

# Set enviroment variable MYSQLD_PARENT_PID. This is required for restart.
Environment=MYSQLD_PARENT_PID=1

PrivateTmp=false
EOT

sudo systemctl daemon-reload
sudo systemctl restart mysqld
sudo systemctl enable mysqld
sudo systemctl list-unit-files --type=service | grep mysqld

DEFAULT_ROOT_PWD='P@ssW0rd'
DEFAULT_REPL_PWD='P@ssW0rd'
RUN_SQL=$(echo "
ALTER USER 'root'@'localhost' IDENTIFIED BY '${DEFAULT_ROOT_PWD}';
FLUSH PRIVILEGES;
USE mysql;
UPDATE mysql.user SET user.Host='%' WHERE USER.User='root';
FLUSH PRIVILEGES;
CREATE USER 'repl'@'%' IDENTIFIED by '${DEFAULT_ROOT_PWD}';
FLUSH PRIVILEGES;
EXIT;
")

echo "mysql -P 13306 -uroot --connect-expired-password  -p'${INIT_PWD}' -se ${RUN_SQL}"
mysql -P 13306 -uroot --connect-expired-password  -p"${INIT_PWD}" -se "${RUN_SQL}"
echo "${RUN_SQL}"
echo "mysql -h 127.0.0.1 -P 13306 -uroot -p'${DEFAULT_ROOT_PWD}'"
mysql -h 127.0.0.1 -P 13306 -uroot --connect-expired-password  -p"${DEFAULT_ROOT_PWD}"

nginx安装

• 官网下载地址

http://nginx.org/en/download.html

sudo apt install libpcre3 libpcre3-dev openssl zlib1g zlib1g-dev

wget http://nginx.org/download/nginx-1.23.3.tar.gz

tar -zxvf nginx-1.23.3.tar.gz
cd nginx-1.23.3
useradd -M -s /sbin/nologin nginx

sudo ./configure --prefix=/usr/local/nginx --user=nginx --group=nginx --with-http_stub_status_module
sudo make
sudo make install

nginx -c conf/nginx.conf