Spaceack的专栏

实现起来就是 消息 带 状态 和 版本号 字段。更新时用 版本号 做乐观锁。操作逻辑就是个状态机。UPDATE mq SET mq.status=new_status mq.version = mq.version + 1 WHERE mq.version = old_version实现mysql mq 表结构设计CREATE TABLE `mq` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `msg` varchar(102.

MariaDB双活热备1. 环境准备创建目录 mkdir conf conf2 data data2 log log2创建 MariaDB 配置文件 touch conf/my.cnf conf2/my.cnfconf/my.cnf文件# The MariaDB configuration file## The MariaDB/MySQL tools read configuration files in the following order:# 0. "/etc/mysql/my.cnf

step1: 创建目录mkdir -p /server/mariadb/{config,data,log}chmod -R 777 /server/mariadbstep2: 编写docker-compose.ymlversion: '3.1'services: mariadb: image: mariadb:10.5.5 container_name: "mariadb1" restart: always environment: MYS..

测试命令mysqlslap -a -c 100 -i 10 -uroot -ppassword报错：mysqlslap: unknown variable 'default-character-set=utf8mb4'加入 --no-defaults 参数即可