> tar -xzvf libdrizzle-0.3.tar.gz
> cd libdrizzle-0.3
> ./configure
> make
> make install
> tar -xzvf drizzle-2009.06.1063.tar.gz
> cd drizzle-2009.06.1063
> ./configure --with-libprotobuf-prefix=/usr/local
> make
> make install
shell> groupadd drizzle
shell> useradd -g drizzle drizzle
> mkdir /usr/local/drizzle
> mkdir /usr/local/drizzle/data
> cd /usr/local/drizzle
> chown -R drizzle .
> chgrp -R drizzle .
> /usr/local/sbin/drizzled --user=drizzle --basedir=/usr/local/drizzle/ --datadir=/usr/local/drizzle/data/ &
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
090630 10:29:42 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090630 10:29:42 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090630 10:29:42 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090630 10:29:43 InnoDB Plugin 1.0.3 started; log sequence number 0
/usr/local/sbin/drizzled: ready for connections.
Version: '2009.06.1063' socket: '' port: 4427 Source distribution
> /usr/local/bin/drizzle
Welcome to the Drizzle client.. Commands end with ; or \g.
Your Drizzle connection id is 24
Server version: 2009.06.1063 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
drizzle>
drizzle> SELECT VERSION (); + -------------- + | VERSION () | + -------------- + | 2009.06.1063 | + -------------- + 1 row in set (0 sec)
drizzle> CREATE DATABASE test;
Query OK, 1 row affected (0 sec)
drizzle> USE test;
Database changed
drizzle> CREATE TABLE items (
-> ItemID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> ItemDesc VARCHAR(255) NOT NULL,
-> ItemQty INT NOT NULL
-> );
Query OK, 0 rows affected (0.01 sec)
drizzle> INSERT INTO items (ItemDesc, ItemQty) VALUES ('Bacon', 4);
Query OK, 1 row affected (0 sec)
drizzle> INSERT INTO items (ItemDesc, ItemQty) VALUES ('Eggs', 3);
Query OK, 1 row affected (0 sec)
drizzle> INSERT INTO items (ItemDesc, ItemQty) VALUES ('Milk', 1);
Query OK, 1 row affected (0 sec)
drizzle> INSERT INTO items (ItemDesc, ItemQty) VALUES ('Apples', 6);
Query OK, 1 row affected (0.01 sec)
drizzle> SELECT * FROM items; + -------- + ---------- + --------- + | ItemID | ItemDesc | ItemQty | + -------- + ---------- + --------- + | 1 | Bacon | 4 | | 2 | Eggs | 3 | | 3 | Milk | 1 | | 4 | Apples | 6 | + -------- + ---------- + --------- + 4 rows in set (0 sec)
shell> pecl install drizzle-beta
shell> tar -xzvf drizzle-0.4.0.tar.gz shell> cd drizzle-0.4.0 shell> phpize shell> ./configure shell> make shell> make install
Source: https://habr.com/ru/post/64050/