Crown的博客

按照这个重新下载安装 新的版本](https://macwk.com/soft/navicat-premium)

后台日志报错如下### SQL: UPDATE t_shop_mp_liveroom SET liveStatus = ? , coverImg = ?,shareImg = ? where shopId =? and appId = ? and roomId =?### Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock found when trying to get lock

1.准备两台linux服务器安装好Mysql的环境，我这里Mysql的服务器的ip分别为#matser 节点192.168.88.201 #slave 节点192.168.88.2022 配置主的mysql第一步vim /etc/my.cnf第二步 添加binlog 跟server_id[mysqld]# 添加如下的配置#开启binloglog_bin ...