K/V存储方案-Sophia
2024-10-18 16:28:15 
阿炯
Sophia是支持高级事务性MVCC键值/行存储库。采用C语言编写开发并在BSD协议下授权使用。
与其他存储有什么不同？
Sophia是RAM与Disk混合存储。旨在提供最佳的磁盘上性能，而不会及时降低性能。它保证读、写和范围扫描操作的最坏情况复杂度为0(1)。
使用场景
对于服务器环境，它需要最低的读写延迟，可预测的行为，优化的存储模式和事务保证。它可以有效地处理大量有序数据，如时间序列、分析、事件、日志、计数器、指标、全文搜索、通用键值等。
特性
Full ACID compliancy
MVCC engine
Optimistic, non-blocking concurrency with N-writers and M-readers
Pure Append-Only
Unique data storage architecture
Fast: O(1) worst for read, write and range scan operations
Multi-threaded compaction
Multi-databases support (sharing a single write-ahead log)
Multi-Statement and Single-Statement Transactions (cross-database)
Serialized Snapshot Isolation (SSI)
Optimized storage schema (numeric types has zero-cost storage)
Can be used to build Secondary Indexes
Upsert (fast write-only 'update or insert' operation)
Consistent Cursors
Prefix search
Automatic garbage-collection
Automatic key-expire
Hot Backup
Compression (no fixed-size blocks, no-holes, supported: lz4, zstd)
Direct IO support
Use mmap or pread access methods
Simple and easy to use (minimalistic API, FFI-friendly, amalgamated)
Implemented as small C-written library with zero dependencies
Carefully tested
Open Source Software, BSD
最新版本：2.2
官方主页：
http://sophia.systems/
https://github.com/pmwkaa/sophia
与其他存储有什么不同？
Sophia是RAM与Disk混合存储。旨在提供最佳的磁盘上性能，而不会及时降低性能。它保证读、写和范围扫描操作的最坏情况复杂度为0(1)。
使用场景
对于服务器环境，它需要最低的读写延迟，可预测的行为，优化的存储模式和事务保证。它可以有效地处理大量有序数据，如时间序列、分析、事件、日志、计数器、指标、全文搜索、通用键值等。
特性
Full ACID compliancy
MVCC engine
Optimistic, non-blocking concurrency with N-writers and M-readers
Pure Append-Only
Unique data storage architecture
Fast: O(1) worst for read, write and range scan operations
Multi-threaded compaction
Multi-databases support (sharing a single write-ahead log)
Multi-Statement and Single-Statement Transactions (cross-database)
Serialized Snapshot Isolation (SSI)
Optimized storage schema (numeric types has zero-cost storage)
Can be used to build Secondary Indexes
Upsert (fast write-only 'update or insert' operation)
Consistent Cursors
Prefix search
Automatic garbage-collection
Automatic key-expire
Hot Backup
Compression (no fixed-size blocks, no-holes, supported: lz4, zstd)
Direct IO support
Use mmap or pread access methods
Simple and easy to use (minimalistic API, FFI-friendly, amalgamated)
Implemented as small C-written library with zero dependencies
Carefully tested
Open Source Software, BSD
最新版本：2.2
官方主页：
http://sophia.systems/
https://github.com/pmwkaa/sophia