运维-redis多实例 mysql多实例

发表于 2023-07-13 | | 阅读次数:

redis 多实例

// 复制默认的配置文件以创建新的配置
cp /etc/redis.conf /etc/redis_6380.conf
cp /etc/redis.conf /etc/redis_6381.conf
cp /etc/redis.conf /etc/redis_6382.conf

// 打开新的配置文件进行编辑（对应修改）
vim /etc/redis_6380.conf

# 修改以下几处：
port 6380
pidfile /var/run/redis_6380.pid
daemonize yes
logfile /var/log/redis/redis_6380.log
dbfilename dump_6380.rdb
dir /var/lib/redis
requirepass "xxxxxx"

// 启动 redis 实例
/usr/bin/redis-server /etc/redis_6380.conf –supervised systemd
/usr/bin/redis-server /etc/redis_6381.conf –supervised systemd
/usr/bin/redis-server /etc/redis_6382.conf –supervised systemd

// 关闭 redis 实例
/usr/bin/redis-cli -p 6380 -a gp123456 shutdown
/usr/bin/redis-cli -p 6381 -a gp123456 shutdown
/usr/bin/redis-cli -p 6382 -a gp123456 shutdown

mysql 多实例

// 创建每个实例对应的目录
mkdir -p /data/mysql/3307
mkdir -p /data/mysql/3308
mkdir -p /data/mysql/3309

// 目录所属修改到 MariaDB 用户与用户组
chown -R mysql:mysql /data/mysql/3307
chown -R mysql:mysql /data/mysql/3308
chown -R mysql:mysql /data/mysql/3309

// 初始化数据目录
mysql_install_db –datadir=/data/mysql/3307/data –basedir=/usr –user=mysql
mysql_install_db –datadir=/data/mysql/3308/data –basedir=/usr –user=mysql
mysql_install_db –datadir=/data/mysql/3309/data –basedir=/usr –user=mysql

// MariaDB 配置文件
vim /etc/my.cnf

# 添加一下配置
[mysqld_multi]
mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user       = root
pass       = password

[mysqld3307]
socket     = /data/mysql/3307/mariadb.sock
port       = 3307
pid-file   = /data/mysql/3307/mariadb.pid
datadir    = /data/mysql/3307/data
user       = mysql

[mysqld3308]
socket     = /data/mysql/3308/mariadb.sock
port       = 3308
pid-file   = /data/mysql/3308/mariadb.pid
datadir    = /data/mysql/3308/data
user       = mysql

[mysqld3309]
socket     = /data/mysql/3309/mariadb.sock
port       = 3309
pid-file   = /data/mysql/3309/mariadb.pid
datadir    = /data/mysql/3309/data
user       = mysql

// 启动
mysqld_multi start 3307-3309

// 初始化配置密码设置成 password
mysql_secure_installation -S /data/mysql/3307/mariadb.sock
mysql_secure_installation -S /data/mysql/3308/mariadb.sock
mysql_secure_installation -S /data/mysql/3309/mariadb.sock

// 停止
mysqld_multi stop 3307-3309

运维-yum安裝php56, php73, php74, php80多版本共存

发表于 2023-07-08 | | 阅读次数:

yum安裝php56, php73, php74, php80多版本共存

1.安装epel：

// 查看已安装的PHP，查到后rpm -e 卸载
yum list installed | grep php
yum repolist all | grep php 
yum install epel-release -y

2.安装REMI源：

1	rpm -ivh https://mirrors.tuna.tsinghua.edu.cn/remi/enterprise/remi-release-7.rpm

3.查看可以安装的PHP版本：(54-80版本都有)

yum repolist all | grep php

// 安裝 php56 版本
yum install php56 php56-php-fpm php56-php-cli php56-php-bcmath php56-php-gd php56-php-json php56-php-mbstring php56-php-mcrypt php56-php-mysqlnd php56-php-opcache php56-php-pdo php56-php-pecl-crypto php56-php-pecl-mcrypt php56-php-soap php56-php-pecl-zip php56-php-process php56-php-pecl-yaf php56-php-xml php56-php-pecl-swoole4 php56-php-ldap php56-php-pear php56-php-xml php56-php-pecl-imagick php56-php-pecl-wddx php56-php-intl php56-php-sodium

// 安裝 php73 版本
yum install php73 php73-php-fpm php73-php-cli php73-php-bcmath php73-php-gd php73-php-json php73-php-mbstring php73-php-mcrypt php73-php-mysqlnd php73-php-opcache php73-php-pdo php73-php-pecl-crypto php73-php-pecl-mcrypt php73-php-soap php73-php-pecl-zip php73-php-process php73-php-pecl-yaf php73-php-xml php73-php-pecl-swoole4 php73-php-ldap php73-php-pear php73-php-xml php73-php-pecl-imagick php73-php-pecl-wddx php73-php-intl php73-php-sodium

// 安裝 php74 版本
yum install php74 php74-php-fpm php74-php-cli php74-php-bcmath php74-php-gd php74-php-json php74-php-mbstring php74-php-mcrypt php74-php-mysqlnd php74-php-opcache php74-php-pdo php74-php-pecl-crypto php74-php-pecl-mcrypt php74-php-soap php74-php-pecl-zip php74-php-process php74-php-pecl-yaf php74-php-xml php74-php-pecl-swoole4 php74-php-ldap php74-php-pear php74-php-xml php74-php-pecl-imagick php74-php-pecl-wddx php74-php-intl php74-php-sodium

// 安裝 php80 版本
yum install php80 php80-php-fpm php80-php-cli php80-php-bcmath php80-php-gd php80-php-json php80-php-mbstring php80-php-mcrypt php80-php-mysqlnd php80-php-opcache php80-php-pdo php80-php-pecl-crypto php80-php-pecl-mcrypt php80-php-soap php80-php-pecl-zip php80-php-process php80-php-pecl-yaf php80-php-xml php80-php-pecl-swoole4 php80-php-ldap php80-php-pear php80-php-xml php80-php-pecl-imagick php80-php-pecl-wddx php80-php-intl php80-php-sodium

// 安裝 php81 版本
yum install php81 php81-php-fpm php81-php-cli php81-php-bcmath php81-php-gd php81-php-json php81-php-mbstring php81-php-mcrypt php81-php-mysqlnd php81-php-opcache php81-php-pdo php81-php-pecl-crypto php81-php-pecl-mcrypt php81-php-soap php81-php-pecl-zip php81-php-process php81-php-pecl-yaf php81-php-xml php81-php-pecl-swoole4 php81-php-ldap php81-php-pear php81-php-xml php81-php-pecl-imagick php81-php-pecl-wddx php81-php-intl php81-php-sodium

3-1.卸载PHP版本

// 卸载安装包5.6
yum remove php56 php56-php-fpm php56-php-cli php56-php-bcmath php56-php-gd php56-php-json php56-php-mbstring php56-php-mcrypt php56-php-mysqlnd php56-php-opcache php56-php-pdo php56-php-pecl-crypto php56-php-pecl-mcrypt php56-php-soap php56-php-pecl-zip php56-php-process php56-php-pecl-yaf php56-php-xml php56-php-pecl-swoole4 php56-php-ldap php56-php-pear php56-php-xml php56-php-pecl-imagick php56-php-pecl-wddx php56-php-intl php56-php-sodium

// 查看rpm包
rpm -qa|grep php56
// 删除rpm包
rpm -e php56-runtime-5.6-1.el7.remi.x86_64

ls -al /opt/remi/
ls -al /etc/opt/remi/

启动服务
安裝好之後爲了PHP版本能夠共存還需要更改不同的php版本端口

// 在路徑下能夠找到相應的版本

1	ls /etc/opt/remi/

// 修改 php.ini 配置
vim /etc/opt/remi/php73/php.ini
# 开启整站 zlib 压缩输出
zlib.output_compression = Off
# 修改 zlib 压缩比
zlib.output_compression_level = 5
# 关闭 PATH_INFO
cgi.fix_pathinfo = 0
# 设置时区
date.timezone = Asia/Shanghai

vim /etc/opt/remi/php74/php.ini
# 开启整站 zlib 压缩输出
zlib.output_compression = Off
# 修改 zlib 压缩比
zlib.output_compression_level = 5
# 关闭 PATH_INFO
cgi.fix_pathinfo = 0
# 设置时区
date.timezone = Asia/Shanghai

vim /etc/opt/remi/php80/php.ini
# 开启整站 zlib 压缩输出
zlib.output_compression = Off
# 修改 zlib 压缩比
zlib.output_compression_level = 5
# 关闭 PATH_INFO
cgi.fix_pathinfo = 0
# 设置时区
date.timezone = Asia/Shanghai

vim /etc/opt/remi/php81/php.ini
# 开启整站 zlib 压缩输出
zlib.output_compression = Off
# 修改 zlib 压缩比
zlib.output_compression_level = 5
# 关闭 PATH_INFO
cgi.fix_pathinfo = 0
# 设置时区
date.timezone = Asia/Shanghai


// 編輯配置文件修改listen端口（端口可自定义）
vim /etc/opt/remi/php73/php-fpm.d/www.conf
    # 监听
    listen = 127.0.0.1:9073
    # 设置进程所属用户及用户组
    user = themismin
    group = nginx
    # 设置 unix socket 权限
    listen.owner = themismin
    listen.group = nginx
    listen.mode = 0660
vim /etc/opt/remi/php74/php-fpm.d/www.conf
    # 监听
    listen = 127.0.0.1:9074
    # 设置进程所属用户及用户组
    user = themismin
    group = nginx
    # 设置 unix socket 权限
    listen.owner = themismin
    listen.group = nginx
    listen.mode = 0660
vim /etc/opt/remi/php80/php-fpm.d/www.conf
    # 监听
    listen = 127.0.0.1:9080
    # 设置进程所属用户及用户组
    user = themismin
    group = nginx
    # 设置 unix socket 权限
    listen.owner = themismin
    listen.group = nginx
    listen.mode = 0660
vim /etc/opt/remi/php81/php-fpm.d/www.conf
    # 监听
    listen = 127.0.0.1:9081
    # 设置进程所属用户及用户组
    user = themismin
    group = nginx
    # 设置 unix socket 权限
    listen.owner = themismin
    listen.group = nginx
    listen.mode = 0660

// 修改相关文件的所属

chown themismin:nginx /var/opt/remi/php73/lib/php/opcache
chown themismin:nginx /var/opt/remi/php73/lib/php/session
chown themismin:nginx /var/opt/remi/php73/lib/php/wsdlcache
chown themismin:nginx /var/opt/remi/php73/log/php-fpm

chown themismin:nginx /var/opt/remi/php74/lib/php/opcache
chown themismin:nginx /var/opt/remi/php74/lib/php/session
chown themismin:nginx /var/opt/remi/php74/lib/php/wsdlcache
chown themismin:nginx /var/opt/remi/php74/log/php-fpm

chown themismin:nginx /var/opt/remi/php80/lib/php/opcache
chown themismin:nginx /var/opt/remi/php80/lib/php/session
chown themismin:nginx /var/opt/remi/php80/lib/php/wsdlcache
chown themismin:nginx /var/opt/remi/php80/log/php-fpm

chown themismin:nginx /var/opt/remi/php81/lib/php/opcache
chown themismin:nginx /var/opt/remi/php81/lib/php/session
chown themismin:nginx /var/opt/remi/php81/lib/php/wsdlcache
chown themismin:nginx /var/opt/remi/php81/log/php-fpm

// 启动服务

systemctl restart php73-php-fpm
systemctl enable php73-php-fpm

systemctl restart php74-php-fpm
systemctl enable php74-php-fpm

systemctl restart php80-php-fpm
systemctl enable php80-php-fpm

systemctl restart php81-php-fpm
systemctl enable php81-php-fpm

升级php版本

yum-config-manager --disable 'remi-php*'
yum-config-manager --enable   remi-php80
yum clean all
yum install php php-fpm php-cli php-bcmath php-gd php-json php-mbstring php-mcrypt php-mysqlnd php-opcache php-pdo php-pecl-crypto php-pecl-mcrypt php-soap php-pecl-zip php-process php-pecl-yaf php-xml php-pecl-swoole4 php-ldap php-pear php-xml php-pecl-imagick php-pecl-wddx php-php-intl php-php-sodium

Hecker-OBS多端推流

发表于 2023-03-20 | 分类于 IT ， Hecker | | 阅读次数:

## OBS下载地址
https://obsproject.com/

## 多端推流下载地址
https://github.com/sorayuki/obs-multi-rtmp

## 手机作为 Droidcam OBS 的网络摄像头
https://www.dev47apps.com/obs/
https://play.google.com/store/apps/details?id=com.dev47apps.obsdroidcam&hl=en&gl=US

## 手机作为带迷彩的网络摄像头
https://reincubate.com/camo/
https://play.google.com/store/apps/details?id=com.reincubate.camo


## 其他站点内容
https://apkpure.com/

centos7-Docker安装

发表于 2022-11-17 | 分类于 IT ，运维 | | 阅读次数:

docker 安装

yum remove docker docker-client docker-client-latest docker-common docker-latest docker-latest-logrotate docker-logrotate docker-engine
yum install -y yum-utils
yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo
yum install docker-ce docker-ce-cli containerd.io
systemctl start docker
systemctl enable docker

docker-compose 安装

### 直接安装
curl -L https://github.com/docker/compose/releases/download/v2/docker-compose-`uname -s`-`uname -m` -o /usr/local/bin/docker-compose

### 间接安装（网络问题，无法直接安装）
echo "https://github.com/docker/compose/releases/download/v2.12.0/docker-compose-$(uname -s)-$(uname -m)"

### 本地下载好，再上传
rz

### 安装
mv docker-compose-linux-x86_64 /usr/local/bin/docker-compose
chmod +x /usr/local/bin/docker-compose
docker-compose -v

其他

1	docker inspect 6a11b0b8291a \| grep Mounts -A 20

阿里云 docker 镜像加速器

https://cr.console.aliyun.com/cn-hangzhou/instances/mirrors


# 配置
mkdir -p /etc/docker
tee /etc/docker/daemon.json <<-'EOF'
{
  "registry-mirrors": ["https://am3rvw31.mirror.aliyuncs.com"]
}
EOF
systemctl daemon-reload
systemctl restart docker

启动/关闭容器

1
2
3

docker-composer up -d

docker-composer down

centos7-使用nvm切换node版本

发表于 2022-07-04 | | 阅读次数:

VSCode-IDE配置

发表于 2022-06-23 | 分类于 IT ， VSCode | | 阅读次数:

插件

Chinese (Simplified) (简体中文) Language Pack for Visual Studio Code

此中文（简体）语言包为 VS Code 提供本地化界面。

Sublime Text Keymap and Settings Importer

导入Sublime Text设置和按键绑定到VS Code中。

PHP Intelephense#

PHP 的代码提示、补全、跳转定义、格式化插件，功能强大，无需配置

PHP DocBlocker

注释自动生成器

PHP Snippets from PHPStorm

快捷代码片段

Better Align

对齐代码
Code > 首选项 > 键盘快捷方式 > 打开键盘快捷方式(JSON)
// 将键绑定放在此文件中以覆盖默认值
[
{
“key” : “shift+alt+d”,
“command”: “wwm.aligncode”,
“when” : “editorTextFocus && !editorReadonly”
}
]

快捷键

shift+alt+d: 光标移动到等号行，等号对齐
shift+alt+f: 代码格式化

cmd+d     : 同时选中下一个同样单词
ctrl+cmd+g: 选中与当前选中字符相同的所有字符

ctrl+空格: 代码提示

php-记一次服务器部署问题

发表于 2022-06-11 | 分类于 IT ，运维 | | 阅读次数:

opencache 影响在线部署调试问题
mysql.default_socket 导致数据库无法连接问题
short_open_tag 导致php对短标签无法解析问题
nginx try_files 单入口文件设置问题

php-Laravel elasticsearch DSL 教程

发表于 2022-03-24 | | 阅读次数:

Elasticsearch DSL

如何使用 Elasticsearch DSL 的方式执行搜索

php-Laravel elasticsearch教程

发表于 2022-02-08 | 分类于 IT ， PHP | | 阅读次数:

centos 安装 elasticsearch

rpm --import https://artifacts.elastic.co/GPG-KEY-elasticsearch

sudo vim /etc/yum.repos.d/elasticsearch-7.x.repo
###
[elasticsearch-7.x]
name=Elasticsearch repository for  7.x packages
baseurl=https://artifacts.elastic.co/packages/7.x/yum
gpgcheck=1
gpgkey=https://artifacts.elastic.co/GPG-KEY-elasticsearch
enabled=1
autorefresh=1
type=rpm-md
###

yum install -y elasticsearch

sudo systemctl restart elasticsearch
sudo systemctl enable elasticsearch

ubuntu 安装

0. 查看版本
sudo apt-cache madison elasticsearch
0. 显示包的版本
sudo dpkg -s elasticsearch

1. 卸载旧软件
sudo apt-get purge elasticsearch
sudo apt-get autoremove elasticsearch
sudo rm -rf /var/lib/elasticsearch/
sudo rm -rf /etc/elasticsearch/

#2. 安装 7.17.*
#sudo apt-get install elasticsearch

2. 安装指定版本 7.17.18
sudo apt install elasticsearch=7.17.18

3. 加载，开启启动，启动
sudo systemctl daemon-reload
sudo systemctl enable elasticsearch.service
sudo systemctl start elasticsearch.service

ik插件

1. 对应置顶版本插件
sudo /usr/share/elasticsearch/bin/elasticsearch-plugin install https://github.com/medcl/elasticsearch-analysis-ik/releases/download/v7.17.0/elasticsearch-analysis-ik-7.17.0.zip

sudo /usr/share/elasticsearch/bin/elasticsearch-plugin install https://github.com/infinilabs/analysis-ik/releases/download/v7.17.18/elasticsearch-analysis-ik-7.17.18.zip

sudo /usr/share/elasticsearch/bin/elasticsearch-plugin list

sudo systemctl restart elasticsearch

# 分词
curl http://127.0.0.1:9200/_analyze --header 'Content-Type: application/json' --data '{"analyzer":"ik_max_word","text":"世界如此之大"}'

ik 带有两个分词器
ik_max_word ：会将文本做最细粒度的拆分；尽可能多的拆分出词语
ik_smart：会做最粗粒度的拆分；已被分出的词语将不会再次被其它词语占有


# 热词更新配置
sudo vim /etc/elasticsearch/analysis-ik/IKAnalyzer.cfg.xml

配置

sudo vim /etc/elasticsearch/elasticsearch.yml
###
...
bootstrap.memory_lock: false
bootstrap.system_call_filter: false
...
network.host: 0.0.0.0
...
cluster.initial_master_nodes: ["node-1"]
###

sudo vim /etc/sysctl.conf
###
...
vm.max_map_count=655360
###

sysctl -p

sudo vim /etc/security/limits.conf
###
...
* soft nofile 65535
* hard nofile 65535
###
# 重启服务器


sudo systemctl restart elasticsearch
sudo systemctl enable elasticsearch

# 服务是否启动
curl http://127.0.0.1:9200?pretty

# 分词
curl http://127.0.0.1:9200/_analyze --header 'Content-Type: application/json' --data '{"text":"世界如此之大"}'

命令

# 查看所有列表
curl -X GET 'http://localhost:9200/_cat/indices?v'

运维-mysql创建数据库

发表于 2022-02-07 | | 阅读次数:

运维-redis多实例 mysql多实例

redis 多实例

mysql 多实例

运维-yum安裝php56, php73, php74, php80多版本共存

yum安裝php56, php73, php74, php80多版本共存

升级php版本

推荐文章

Hecker-OBS多端推流

centos7-Docker安装

docker 安装

docker-compose 安装

其他

推荐文章

centos7-使用nvm切换node版本

VSCode-IDE配置

插件

Chinese (Simplified) (简体中文) Language Pack for Visual Studio Code

Sublime Text Keymap and Settings Importer

PHP Intelephense#

PHP DocBlocker

PHP Snippets from PHPStorm

Better Align

快捷键

推荐文章

php-记一次服务器部署问题

推荐文章

php-Laravel elasticsearch DSL 教程

Elasticsearch DSL

php-Laravel elasticsearch教程

centos 安装 elasticsearch

ubuntu 安装

ik插件

配置

命令

相关链接

推荐文章

运维-mysql创建数据库