drizzle keynote from o'reilly's mysql's conference
DESCRIPTION
TRANSCRIPT
In the beginning...
•2005 MySQL 5.0 released with little love from Web Developers
•2008 Sun buys MySQL
•2008 MySQL 6.0 becomes Drizzle
•2009 Oracle buys Sun
•2010 Drizzle Developers split from Oracle
•2011 First GA Release, Drizzle7
Drizzle7(Quick Update)
HTTP Blob Streaming
ClientReplication
Client
Listener
Parser
Optimizer
Storage System
Logging
Error Reporting
HTTPClient
MySQL
Memcached
Gearman
Executioner
SQL
Drizzle
MicroKernel
Cloud Service
No Gotchas
•No NULL when you don’t want NULL
•No fake’it ALTER TABLE
•Real datetime (64bit), with microseconds
•IPV6
•No updates that “half complete”
Интернет является UTF-8.
は、 Web UTF - 8 です。
The Web is UTF-8.
Replication
•Google Protocol Buffer Based
•Replicates row transformations.
•Integrates today with RabbitMQ, Casandra. Memcached, Gearman
INSERTINSERT
INSERTINSERT
UPDATEUPDATE
INSERTINSERT
StoredTransactiona
llyby
Delta
TransactTransactionionLogLog
BinlogBinlog
Group Commit :(
DatabasDatabasee
KernelKernel
TransactTransactionionLogLog
No Group Commit Required
DatabasDatabasee
KernelKernel
•Single sync
•Entirely transactional / safety in storage
•Scatter / gather
•No need to be concerned about determinism.
•You get to sleep at night!
libDrizzle
•Supports Drizzle (and MySQL, and SQLite)
•Asynchronous
•BSD
•Lawyer free
Client
Instance
Amazon S3
Storage
NoSQL Stream Access
Is there more?
•No cost Auth (pam, ldap, http,..)
•Table Functions (new Data dictionary,…)
•UUID, BOOL, all known types
•(except for SET, its broke by design)
•…
Drizzle 7+
Replication?
MastMasterer
SlaveSlave
SlaveSlave
SlaveSlave
MastMasterer
SlaveSlave
SlaveSlave
SlaveSlave
MastMasterer
MastMasterer
MastMasterer
MastMasterer
UsersUsers
InstanceInstance
SchemaSchema
TableTable
TableTable
TableTable
SchemaSchema
TableTable
TableTable
TableTable
SchemaSchema
TableTable
TableTable
TableTable
SchemaSchema
TableTable
TableTable
TableTable
UsersUsers
InstanceInstance
SchemaSchema
TableTable
TableTable
TableTable
UsersUsers
SchemaSchema
TableTable
TableTable
TableTable
•Cuts the 30/40% hit from virtualizing
•Single instance maintenance
•Still allows for IO spread on San/NAS
•Supports Partial Backup
•No locking
•Single solution, point-in-time recovery in a single solution.
•Comes with the database.
Percona’s Hot Backup
Was it worth it?Could you have...
•Could we have built it from PostgreSQL?
•What is a rat hole?
•Are there bugs in Drizzle?
•Should we have rewritten it in Erlang?
•What does cloud mean?
What was the big win?
120+ Developers Since Day One
26/36 on average each month
Drizzle Developer Day
This Friday!
http://drizzle.orgFreenode #drizzle
Me?blog: http://blog.krow.nettwitter: brianaker