5 ms·
I wonder if it would be possible to put InnoDB to a kernel mode filesystem driver to create a new database filesystem. (BeFS/WinFS-style)
by frik 9y ago
I wonder if it would be possible to put InnoDB to a kernel mode filesystem driver to create a new database filesystem. (BeFS/WinFS-style)
- TickleSteve 9y agoShould be relatively easy to try it out as a fuse filesystem.
- DigitalJack 9y agoGreat, I'll expect a progress report from you in the morning.
- justinjlynn 9y agoRelatively easy does not mean little work.
- hodgesrm 9y agoAmazon Aurora does something similar in the sense that it decouples InnoDB functions including buffer cache and storage access from the overlying MySQL engine. The decoupled InnoDB lives on separate VM(s) and includes optimized data replication to support DBMS high availability. For example, with Aurora you can failover a large DBMS in seconds to a new site and have it come up with a heated buffer cache since that replicates too. This approach makes sense for Aurora because it leverages cloud storage to provide data high availability across availability zones. Just putting InnoDB in a file system seems less interesting unless you add features that are strikingly different from what it does now. See http://www.allthingsdistributed.com/files/p1041-verbitski.pdf http://www.allthingsdistributed.com/files/p1041-verbitski.pd... for a full description.
- late2part 9y agoSounds overly complicated and obscure.
- openasocket 9y agoThe results are a massive gain in performance, availability, and durability, that seems worth added complexity.
- hodgesrm 9y agoIt's worth reading the paper. The Aurora team claims 10x plus boosts in transaction throughput and extremely fast recovery times. These are important benefits.