Linux配置Mysql、Redis主从的流程

安装mysql：

yum install -y perl perl-devel

yum install -y libaio

更改mysql密码：

./bin/mysqladmin -u root -h localhost.localdomain password 'hOuyZJV4n8m7uIrK'

./bin/mysql -h123.60.108.208 -uroot -phOuyZJV4n8m7uIrK

jdk1.8配置环境变量：

export JAVA_HOME=/opt/jdk1.8.0_162

export PATH=$JAVA_HOME/bin:$PATH

export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar

 配置mysql环境变量：

export MYSQL_HOME=/usr/local/mysql

export PATH=$JAVA_HOME/bin:$PATH:$MYSQL_HOME/bin

 配置数据库主从：

#主数据库授予从数据库权限

grant replication slave on *.* to 'replicate'@'ip地址' identified by '数据库密码'

flush privileges

#从数据库测试

mysql -h主数据ip -ureplicate -p主数据库密码

my.conf配置：

character_set_server=utf8mb4

back_log=500

wait_timeout=600

interactive_timeout=600

symbolic-links=0

explicit_defaults_for_timestamp=true

innodb_buffer_pool_size=5G

innodb_buffer_pool_instances=2

innodb_additional_mem_pool_size=50M

innodb_log_file_size=256M

innodb_flush_method=O_DIRECT

max_connections=3000

max_connect_errors=10

join_buffer_size=1M

read_buffer_size=4194304

sort_buffer_size=4194304

innodb_lock_wait_timeout=60

thread_concurrency=64

thread_cache_size=100

配置vue项目环境：

npm install cnpm -g

npm install -g cnpm --registry=https://registry.npm.taobao.org

npm config set registry https://registry.npm.taobao.org

#引用elementui组件，element.js和css文件

配置redis主从：

#修改hostname

sudo vim /etc/hostname

sudo vim /etc/hosts

/usr/local/redis/bin/redis-server /usr/local/redis/etc/redis.conf

启动redis：

./redis-server /usr/local/redis/etc/redis.conf

设置redis自启动：

vi /etc/init.d/redis

chmod 755 redis

/etc/init.d/redis start

chkconfig redis on

redis自启动配置文件：

#!/bin/sh

# chkconfig: 2345 80 90

# Simple Redis init.d script conceived to work on Linux systems

# as it does use of the /proc filesystem.

REDISPORT=6379

REDISPATH=/usr/local/redis/bin

EXEC=${REDISPATH}/redis-server

CLIEXEC=${REDISPATH}/redis-cli

PIDFILE=/var/run/redis_${REDISPORT}.pid

CONF="/usr/local/redis/etc/redis.conf"

case "$1" in

start)

if [ -f $PIDFILE ]

then

echo "$PIDFILE exists, process is already running or crashed"

else

echo "Starting Redis server..."

$EXEC $CONF

fi

;;

stop)

if [ ! -f $PIDFILE ]

then

echo "$PIDFILE does not exist, process is not running"

else

PID=$(cat $PIDFILE)

echo "Stopping ..."

$CLIEXEC -p $REDISPORT shutdown

while [ -x /proc/${PID} ]

do

echo "Waiting for Redis to shutdown ..."

sleep 1

done

echo "Redis stopped"

fi

;;

*)

echo "Please use start or stop as first argument"

;;

esac

安装sbt：

  新建一个sbt文件

#!/bin/bash

SBT_OPTS="-Xms512M -Xmx1536M -Xss1M -XX:+CMSClassUnloadingEnabled -XX:MaxPermSize=256M"

java $SBT_OPTS -jar /usr/local/sbt/bin/sbt-launch.jar "$@" # 注意对应路径

  wq保存退出

chmod u+x ./sbt # 修改sbt脚本文件权限

sudo vim /etc/profile # 配置PATH环境变量

  在文件最后添加：

export PATH=/usr/local/sbt/:$PATH

  wq保存退出

source /etc/profile # 使配置文件立刻生效