From 040eee1aa49b49df4698d83a05af57c220127fd1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 13:36:04 +0200 Subject: Adding upstream version 2.2.0. Signed-off-by: Daniel Baumann --- src/lib/database/database.dox | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 src/lib/database/database.dox (limited to 'src/lib/database/database.dox') diff --git a/src/lib/database/database.dox b/src/lib/database/database.dox new file mode 100644 index 0000000..6612d6d --- /dev/null +++ b/src/lib/database/database.dox @@ -0,0 +1,24 @@ +// Copyright (C) 2020-2022 Internet Systems Consortium, Inc. ("ISC") +// +// This Source Code Form is subject to the terms of the Mozilla Public +// License, v. 2.0. If a copy of the MPL was not distributed with this +// file, You can obtain one at http://mozilla.org/MPL/2.0/. + +/** + @page libdatabase libkea-database - Kea Database Library + +@section databaseMTConsiderations Multi-Threading Consideration for Database + +MySQL and PostgreSQL provide connection pools which are used to make +lease, host and legal log backends thread safe. + +MySQL and PostgreSQL are inter-process safe only when transactions are used +(including the MySQL auto-transaction mode which includes queries into +a transaction). For MySQL this means that transactions must be supported +by the database engine (the engine selection is done in the schema). + +Note the InnoDB engine used by Kea for MySQL databases cancels a transaction +when a deadlock is detected (rare but possible event) and leaves the +responsibility to retry the transaction to the caller. + +*/ -- cgit v1.2.3