New in 5.6: –innodb_read_only, running MySQL from DVD

存储架构 Mablomy (源链)

I recently met two distinct customers who want to use MySQL as a read-only database, stored on a read-only medium like a DVD. With MyISAM this was easily possible. Starting with MySQL 5.6 it is also possible to run this setup with InnoDB based databases. There is a new option:

–innodb_read_only

See details in the reference manual
. This options opens all tablespaces and InnoDB log files as read-only. A small test showed that you need to set some more options in the my.cnf to avoid any write access to @@datadir:

innodb-read-only

log-error=/tmp/mysql-ro.err

pid-file=/tmp/mysql-ro.pid

event-scheduler=disabled

I was a bit surprised why I had to disable the event scheduler. But on the other hand, what use has a regularly running statement that cannot store any data? After all your database is read only ;-)

And together with the new fulltext indexes in InnoDB and maybe compressed table spaces you can now deploy catalogue applications or reference manuals on DVD.

您可能感兴趣的

MySQL Innodb 如何找出阻塞事务源头 SQL 在MySQL数据库中出现了阻塞问题,如何快速查找定位问题根源?在实验开始前,我们先梳理一下有什么工具或命令查看MySQL的阻塞,另外,我们也要一一对比其优劣,因为有些命令可能在实际环境下可能并不适用。 show engine innodb status Innotop工具 ...
Geographic Indexes in InnoDB One of the big features of MySQL 8.0 is geography support. MySQL now has a catalog of spatial reference systems (SRSs) , of which almost 500 ...
MySQL InnoDB Cluster in Oracle Public Cloud: A Tut... In the first part of this series you learned how to setup an InnoDB cluster using Oracle Cloud . In this second part, you are going to learn how and ...
MySQL 8.0: MVCC of Large Objects in InnoDB In this article, I’ll explain about the multi version concurrency control (MVCC) of large objects (LOBs) design in the MySQL InnoDB storage engine...
InnoDB—深入理解事务提交–02 三 为什么说 InnoDB 不符合 WAL 预写日志机制? 在标题二中我们提出这样的一个调用栈:innobase_commit_low(t...
责编内容来自:Mablomy (源链) | 更多关于

阅读提示:酷辣虫无法对本内容的真实性提供任何保证,请自行验证并承担相关的风险与后果!
本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » New in 5.6: –innodb_read_only, running MySQL from DVD



专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录