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:


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:





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

使用声明 | 英豪名录