350 likes | 377 Views
Drizzle 5.0 focuses on enhancing ease of use, adopting open-source methodology, and preparing for tomorrow's 64-bit world with SSD becoming common. It eliminates challenges, embraces modern applications, and emphasizes C++/STL/Boost technologies. The system is UTF-8 compatible, transparent, and organically open source, with pluggable interfaces for various functions. The upgrade path includes improved replication, storage engines, logging, authentication, authorization, table functions, and more. Drizzle aims to be cloud-ready, with strong developer-community support and a commitment to further advancements like improved user tracking and resource handling.
E N D
Drizzle MicroKernel
Leap Forward • Further Ease of Use • Focus on the Web • Use Open Source Methodology
Focus On Tomorrow • World is 64bit • SSD will be the common in Two Years • No New Locks, More Cores will be Common • Modern Applications • C++/STL/Boost
Интернет является UTF-8. は、 Web UTF - 8です。 The Web is UTF-8.
No Gotchas • No bad record inserts. • No hidden truncations. • No “is my filesystem case sensitive” issues • No Modes
Organic Open Source • Everything is public, complete transparency. • Release Early, Release Often. • Launchpad and Hudson • There is no Drizzle INC.
Query 101101 Query 101101 Query Memcached Cache Parser Parser Optimizer Optimizer Client Client Client Routing Proxies Storage Routing SQL & REST
Query 101101 Query 101101 Query Memcached Cache Parser Parser Optimizer Optimizer Client Client Client Routing Proxies Storage Routing SQL & REST
Today’s Pluggable Interfaces • Replication • Storage Engine • Logging • Authentication • Authorization • Table Functions • Functions • Protocol • Query Rewrite • XA
Replication • Google Protocol Buffer Based • Replicates row transformations. • Integrates today with RabbitMQ, Casandra. Memcached, Gearman
libdrizzle • Supports Drizzle (and MySQL, and SQLite) • Asynchronous • BSD
Authentication/Authorization • No Cost Authentication • PAM, LDAP, HTTP
Table Functions • TABLE_CACHE • TABLE_DEFINITION_CACHE • SHOW TEMPORARY TABLES • All new SQL compliant information_schema
Storage Engines • For nearly two years we have been a transactional database by default. • No more table level locking engines. • Federated Data Dictionary.
Akiban.com • Shared Nothing • Join Cost Elimination • Cloud Ready
109,00 Lines of Code in Kernel • (209,000)
~440 goto’s • (compared to +2000)
Default Engine has been transactional for over a year, and passes all test cases. • Upgrades still require reload. • Replication is still under testing.
Rackspace • Coming Beta with Cloud Sites web platform. • “Committed to Drizzle for it to succeed not only for our needs, but for the community needs.”
Better user usage tracking/resource handling. • More Authentication Handlers • Hardened Replication • Shared Nothing Storage Nodes • Server Side Scripting • <YOUR WORK>
Drizzle Developer Day! This Friday, room 209/210 http://drizzle.org http://planetdrizzle.org Freenode #drizzle