Drizzle - A Microkernel DBMS for High Performance Scale-Out Applications
Blog | Bugs | Build Farm | Events | Feature Requests | IRC | LCOV | Mailing List | Planet Drizzle | Source Code | Source Docs | Wiki

Drizzle User Guide

Last Edited by: --Msacks 09:07, 23 December 2008 (UTC)

Contents 1 About Drizzle 1.1 Intended Readers 1.2 What does this document assume about the reader? 1.3 What you’ll be able to do after reading this document 2 Drizzle Overview 2.1 Drizzle History 2.2 What can Drizzle do? 2.3 Differences in use with MySQL 2.4 Drizzle compared with SQLite 2.5 Is Drizzle right for me? 3 Getting Started with Drizzle 3.1 Using Launchpad.net 3.2 Getting started with Bazaar 3.3 Installing Drizzle 3.3.1 Choosing a Drizzle Version 3.3.2 Downloading Source Code and Compiling Drizzle 3.3.3 Drizzle Binaries Layout 3.3.4 Installation Troubleshooting 3.4 Starting_drizzled Starting the Drizzle Database 3.4.1 Starting Drizzle Troubleshooting 3.5 Drizzle Configuration 3.5.1 Command line options 3.6 Accessing Drizzle 3.6.1 Command Line Drizzle Access 3.6.1.1 Tab completion 3.6.2 Programatically Accessing Drizzle 3.6.2.1 DBD::Drizzle 3.6.2.2 Other Drizzle Connectors 3.6.3 GUI Drizzle Access 3.7 Upgrading Drizzle 3.8 Connecting to Drizzle 3.9 Authentication 4 Drizzle's SQL 4.1 Language Structure 4.1.1 Comments 4.1.2 Case-sensitivity 4.1.3 Escape characters 4.1.4 Reserved words 4.1.5 Quoting 4.1.6 Character sets and collations 4.1.7 "SQL mode" 4.2 Data Types 4.2.1 Character Strings 4.2.2 BLOB Strings 4.2.3 Numbers 4.2.4 Boolean 4.2.5 Datetime 4.2.5.1 Microseconds 4.2.5.2 Conversions 4.2.5.3 Time Zones 4.2.6 Intervals 4.2.7 Spatial/GIS data 4.2.8 Other data types 4.2.9 Using NULL 4.3 Index Types 4.3.1 Key constraints 4.3.2 Indexes for faster lookups 4.3.3 FULLTEXT 4.3.4 SPATIAL 4.4 SQL Syntax Reference 4.4.1 CREATE 4.4.1.1 IF NOT EXISTS 4.4.1.2 Check constraints 4.4.1.3 Foreign Keys 4.4.1.4 Views 4.4.2 DROP 4.4.2.1 IF EXISTS 4.4.3 DELETE 4.4.4 INSERT 4.4.5 REPLACE 4.4.6 SELECT 4.4.6.1 GROUP BY 4.4.6.2 ORDER BY 4.4.6.3 FOR UPDATE 4.4.6.4 INTO OUTFILE 4.4.6.5 LIMIT 4.4.6.6 UNION 4.4.7 SET 4.4.8 SHOW 4.4.9 UPDATE 4.4.10 Table maintenance 4.5 Functions 4.5.1 SQL standard functions 4.5.2 Drizzle extensions 5 Drizzle Administration 5.1 Storage Engines 5.2 Plugins 5.2.1 Finding a Plugin 5.2.2 Installing plugins 5.3 Locking 5.4 Transactions 5.5 memcached 5.6 Backups and Recovery 5.7 Logging 5.8 Replication 5.9 Measuring Performance 5.10 Security 5.11 INFORMATION_SCHEMA 5.12 Drizzle Architectures 6 Getting Started in Developing for Drizzle 6.1 You have the source, now what? 6.2 Setting up Your IDE 7 Further Reading 7.1 Launchpad site for Drizzle 8 FAQs for Review 9 12. Getting Help

About Drizzle

About Drizzle

The purpose of this document is to give a complete reference manual for getting started with using Drizzle and developing and contributing to the Drizzle.org Project.

Intended Readers

The primary intended readers of this document are application developers and general users and administrators who are interested in using the Drizzle, highly concurrent platform.

What does this document assume about the reader?

This document assumes that the reader understands the basic functionality of a DBMS system and SQL syntax. Those familiar with MySQL will find Drizzle to be somewhat similar in functionality and use.

What you’ll be able to do after reading this document

The user should be able to get Drizzle running and set up their development environment for contributing to the Drizzle project.

Drizzle Overview

Drizzle History

What can Drizzle do?

Differences in use with MySQL

For DDL, OPTIMIZE, REPAIR, and RENAME are no longer supported.

REPAIR: All engines will "repair" themselves without operator intervention.

OPTIMIZE: Can be done via a ALTER TABLE ENGINE=<SAME ENGINE>. RENAME: Just use ALTER TABLE.

Drizzle compared with SQLite

Is Drizzle right for me?

Getting Started with Drizzle

Using Launchpad.net

Getting started with Bazaar

Installing Drizzle

Choosing a Drizzle Version

Downloading Source Code and Compiling Drizzle

Drizzle Binaries Layout

Installation Troubleshooting

Starting_drizzled Starting the Drizzle Database

Starting Drizzle Troubleshooting

Drizzle Configuration

Command line options

Accessing Drizzle

Command Line Drizzle Access

Tab completion

Programatically Accessing Drizzle

DBD::Drizzle

Other Drizzle Connectors

GUI Drizzle Access

Upgrading Drizzle

Connecting to Drizzle

Authentication

Authentication is done via the authentication plugin. Without the plugin, anyone can connect and do anything in Drizzle if they can connect to the port that Drizzle listens on.

Drizzle's SQL

Language Structure

Comments

Case-sensitivity

Escape characters

Reserved words

Quoting

Character sets and collations

"SQL mode"

Data Types

Character Strings

BLOB Strings

Numbers

Boolean

Datetime

Microseconds

Conversions

Time Zones

Intervals

Spatial/GIS data

Other data types

ENUM, SET

Using NULL

Index Types

Key constraints

Indexes for faster lookups

FULLTEXT

SPATIAL

SQL Syntax Reference

CREATE

IF NOT EXISTS

Check constraints

Foreign Keys

Views

DROP

IF EXISTS

DELETE

INSERT

REPLACE

SELECT

GROUP BY

ORDER BY

FOR UPDATE

INTO OUTFILE

LIMIT

UNION

SET

SHOW

UPDATE

Table maintenance

ie ANALYZE, CHECK, OPTIMIZE, REPAIR

Functions

SQL standard functions

Drizzle extensions

Drizzle Administration

Storage Engines

Plugins

Finding a Plugin

Installing plugins

Locking

Transactions

memcached

Backups and Recovery

Logging

Replication

Measuring Performance

Security

INFORMATION_SCHEMA

Drizzle Architectures

Getting Started in Developing for Drizzle

You have the source, now what?

Setting up Your IDE

Further Reading

Launchpad site for Drizzle

FAQs for Review

Q: Why are there only certain sections of the documentation filled out?
A: The Drizzle documentation is currently under construction. Drizzle users are encouraged to contribute to the documentation.

12. Getting Help

• Chat room: irc.freenode.net #drizzle
• Mailing List (on launchpad)

= Drizzle Contributors =