Welcome to Drizzle’s documentation!¶
Drizzle is a transactional, relational, community-driven open-source database that is forked from the popular MySQL database.
The Drizzle team has removed non-essential code, has re-factored the remaining code, and has converted the code to modern C++ and modern libraries.
- Charter
A database optimized for Cloud infrastructure and Web applications
Design for massive concurrency on modern multi-CPU architectures
Optimize memory use for increased performance and parallelism
Open source, open community, open design
- Scope
Re-designed modular architecture providing plugins with defined APIs
Simple design for ease of use and administration
Reliable, ACID transactional
Note
Drizzle is now in git, on OpenDev and delivered via containers. The docs are still undergoing surgery to get them up to date.
Introduction¶
Specifications¶
Installing¶
Configuration¶
Administration¶
Replication¶
SQL Language¶
- Executing Queries
- SQL Functions
- Data Types
- Data Definition Language
- Data Manipulation Language
- Built in Column Types
- User Defined Variables
- User Defined Locks
- User Defined Barriers
- Dynamic SQL
- Obtaining Information on the Database Contents
- Using transactions
- Administrative Commands
- General SQL Resources
Clients¶
Plugins¶
- Plugin Documentation
- ASCII Function
- Allow All Authentication
- File-based Authentication
- HTTP Authentication
- LDAP Authentication
- PAM Authenication
- Schema Authentication
- BENCHMARK Function
- Catalog System
- CHAR_LENGTH Function
- COERCIBILITY Function
- Character and Collation Dictionary
- Compression Functions
- CONNECTION_ID Function
- Console Plugin
- CRC32 Function
- Debugging Functions
- Default Replicator
- Drizzle Protocol
- Error Messages to STDERR
- Error Dictionary
- Filtered Replicator
- Function Dictionary
- Function Engine
- Hex Functions
- HTTP Functions
- Information Schema Dictionary
- InnoDB Storage Engine
- JS
- JSON Server
- Length Functions
- Gearman Logging
- Query Logging
- User Statistics
- Math Functions
- MD5 Function
- Memcached Functions
- Memcached Statistics
- Memory Storage Engine
- Multi-Thread Scheduler
- MyISAM Storage Engine
- MySQL Protocol
- MySQL Unix Socket Protocol
- Performance Dictionary
- Protocol Dictionary
- Query Log
- RabbitMQ Integration
- RAND Function
- Regex-based Authorization
- Registry Dictionary
- REVERSE Function
- Schema Dictionary
- Schema Engine
- Session Dictionary
- SHOW Commands
- SHOW_SCHEMA_PROTO Function
- SHUTDOWN Function
- Signal Handler
- User-based Authorization
- Replication Slave
- SLEEP Function
- Status Dictionary
- String Functions
- Substring Functions
- Syslog
- Table Cache Dictionary
- Trigger Dictionary
- User Locks
- Utility Dictionary
- Utility Functions
- UUID Function
- VERSION Function
- WiredTiger Storage Engine
- ZeroMQ
Release Notes¶
libdrizzle¶
Testing¶
- test-run - Drizzle testing tool
- kewpie
- randgen (random query generator)
- sql-bench
- sysbench
- Writing native/unittest test cases
- dbqp
- Drizzletest Commands
- List of commands
- append_file
- cat_file
- change_user
- character_set
- chmod
- connect
- connection
- copy_file
- dec
- delimiter
- die
- diff_files
- dirty_close
- disable/enable_abort_on_error
- disable/enable_connect_log
- disable/enable_info
- disable/enable_metadata
- disable/enable_parsing
- disable/enable_ps_protocol
- disable/enable_query_log
- disable/enable_reconnect
- disable/enable_result_log
- disable/enable_rpl_parse
- disable/enable_warnings
- disconnect
- echo
- end
- end_timer
- error
- eval
- exec
- exit
- file_exists
- horizontal_results
- if
- inc
- let
- mkdir
- list_files
- list_files_append_file
- list_files_write_file
- lowercase_result
- move_file
- perl
- ping
- query
- query_get_value
- query_horizontal
- query_vertical
- real_sleep
- reap
- remove_file
- remove_files_wildcard
- replace_column
- replace_regex
- replace_result
- require
- result
- rmdir
- save_master_pos
- send
- send_eval
- send_quit
- shutdown_server
- skip
- sleep
- sorted_result
- source
- start_timer
- sync_slave_with_master
- sync_with_master
- system
- vertical_results
- wait_for_slave_to_stop
- while
- write_file
C++ API Reference¶
The Drizzle server’s C++ internals are documented separately, generated from the source by Doxygen and published alongside these docs:
