› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
这是一个创建于 618 天前的主题，其中的信息可能已经有所发展或是发生改变。
试了这个set global read_only = 1; 是把实例下所有的库都给锁了
也试个锁定库下的所有表 ,这个貌似是会话级的，对其他已连接的用户不起作用
lock table T1 read;
lock table T2 read;
lock table T3 read;
..............
 |
1
GTim 2023-03-01 10:30:16 +08:00
要 global
|
 |
2
wps353 2023-03-01 10:42:50 +08:00
MySQL 8.0.22 以上的版本可以设置库级别的 read only.
"The READ ONLY option, introduced in MySQL 8.0.22, controls whether to permit modification of the database and objects within it. The permitted values are DEFAULT or 0 (not read only) and 1 (read only). This option is useful for database migration because a database for which READ ONLY is enabled can be migrated to another MySQL instance without concern that the database might be changed during the operation." |
Select Language