1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
==========
Glossary
==========
.. glossary::
ACID
Set of properties that guarantee database transactions are
processed reliably. Stands for :term:`Atomicity`,
:term:`Consistency`, :term:`Isolation`, :term:`Durability`.
Atomicity
Atomicity means that database operations are applied following a
"all or nothing" rule. A transaction is either fully applied or not
at all.
Consistency
Consistency means that each transaction that modifies the database
takes it from one consistent state to another.
Drizzle
Drizzle: a database for the cloud.
`Drizzle <http://www.drizzle.org/>`_ is a community-driven open source project that is forked
from the popular MySQL database. The Drizzle team has removed
non-essential code, re-factored the remaining code into a
plugin-based architecture and modernized the code base moving to
C++.
Drizzle Charter
* A database optimized for Cloud infrastructure and Web applications.
* Design for massive concurrency on modern multi-cpu architecture
* Optimize memory 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
Durability
Once a transaction is committed, it will remain so.
Foreign Key
A referential constraint between two tables. Example: A purchase
order in the purchase_orders table must have been made by a customer
that exists in the customers table.
Isolation
The Isolation requirement means that no transaction can interfere
with another.
InnoDB
A :term:`Storage Engine` for MySQL and derivatives (:term:`Percona
Server`, :term:`MariaDB`, :term:`Drizzle`) originally written by
Innobase Oy, since acquired by Oracle. It provides :term:`ACID`
compliant storage engine with :term:`foreign key` support. As of
:term:`MySQL` version 5.5, InnoDB became the default storage engine
on all platforms.
Jenkins
`Jenkins <http://www.jenkins-ci.org>`_ is a continuous integration
system that we use to help ensure the continued quality of the
software we produce. It helps us achieve the aims of:
* no failed tests in trunk on any platform,
* aid developers in ensuring merge requests build and test on all platforms,
* no known performance regressions (without a damn good explanation).
LSN
Log Serial Number. A term used in relation to the :term:`InnoDB` or
:term:`XtraDB` storage engines.
MariaDB
A fork of :term:`MySQL` that is maintained primarily by Monty
Program AB. It aims to add features, fix bugs while maintaining 100%
backwards compatibility with MySQL.
my.cnf
The file name of the default MySQL configuration file.
MyISAM
A :term:`MySQL` :term:`Storage Engine` that was the default until
MySQL 5.5.
MySQL
An open source database that has spawned several distributions and
forks. MySQL AB was the primary maintainer and distributor until
bought by Sun Microsystems, which was then acquired by Oracle. As
Oracle owns the MySQL trademark, the term MySQL is often used for
the Oracle distribution of MySQL as distinct from the drop-in
replacements such as :term:`MariaDB` and :term:`Percona Server`.
Percona Server
Percona's branch of :term:`MySQL` with performance and management improvements.
Storage Engine
A :term:`Storage Engine` is a piece of software that implements the
details of data storage and retrieval for a database system. This
term is primarily used within the :term:`MySQL` ecosystem due to it
being the first widely used relational database to have an
abstraction layer around storage. It is analogous to a Virtual File
System layer in an Operating System. A VFS layer allows an operating
system to read and write multiple file systems (e.g. FAT, NTFS, XFS,
ext3) and a Storage Engine layer allows a database server to access
tables stored in different engines (e.g. :term:`MyISAM`, InnoDB).
XtraDB
Percona's improved version of :term:`InnoDB` providing performance,
features and reliability above what is shipped by Oracle in InnoDB.
|