小敏的博客


  • 首页

  • 分类

  • 标签

  • 归档

  • 关于

运维-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

1
2
3
4
5
6
7
8
# 修改以下几处:
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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
# 添加一下配置
[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:

1
2
3
4
// 查看已安装的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版本都有)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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

// 安裝 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

// 安裝 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

// 安裝 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

// 安裝 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

3-1.卸载PHP版本

1
2
3
4
5
6
7
8
9
10
// 卸载安装包
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

// 查看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/

  1. 启动服务
    安裝好之後爲了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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42

// 編輯配置文件修改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

// 修改相关文件的所属

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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

// 启动服务

1
2
3
4
5
6
7
8
9
10
11
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版本

1
2
3
4
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

Hecker-OBS多端推流

发表于 2023-03-20 | 分类于 IT , Hecker | | 阅读次数:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
## 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 安装

1
2
3
4
5
6
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 安装

1
2
3
4
5
6
7
8
9
10
11
12
13
### 直接安装
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. 查看容器的挂载目录

    1
    docker inspect 6a11b0b8291a | grep Mounts -A 20
  2. 阿里云 docker 镜像加速器

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    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
  3. 启动/关闭容器

    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”
}
]

快捷键

1
2
3
4
5
6
7
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 | | 阅读次数:

安装 elasticsearch

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
rpm --import https://artifacts.elastic.co/GPG-KEY-elasticsearch

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

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"]
###

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

sysctl -p

systemctl start elasticsearch
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":"世界如此之大"}'

ik插件

1
2
3
4
5
6
7
8
9
10
11
12
13
14
/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

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

# 分词
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:会做最粗粒度的拆分;已被分出的词语将不会再次被其它词语占有


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

命令

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

相关链接

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
# IK分词
https://github.com/medcl/elasticsearch-analysis-ik

# laravel-scout-elasticsearch 扩展
https://github.com/matchish/laravel-scout-elasticsearch

# IK分词配置和使用
https://blog.csdn.net/jam00/article/details/52983056


https://www.ar414.com/tags/Elasticsearch

# ElasticSearch实战系列
https://www.cnblogs.com/xuwujing/p/11385255.html
https://www.cnblogs.com/xuwujing/p/11567053.html
https://www.cnblogs.com/xuwujing/p/11645630.html

运维-mysql创建数据库

发表于 2022-02-07 | | 阅读次数:
12…9
小敏-mingo

小敏-mingo

86 日志
14 分类
132 标签
GitHub E-Mail
友情链接
  • Google
  • Twitter
  • FB Page
  • VK Group
  • StackOverflow
  • YouTube
  • Instagram
© 2018 — 2023 小敏-mingo
由 Hexo 强力驱动
|
主题 — NexT.Gemini v5.1.4
本站总访问量次 本站访客数次