Hello,
The Linux Foundation KernelCI project is looking for PostgreSQL DBA contract
proposals to help improve the aggregated report database for the various Linux
Kernel CI systems - "KCIDB".
The contracted company/individual needs to be regularly available for
cooperation in the EU time zones (specifically around UTC+3). The generally
part-time work is expected to take 2-4 months, projected between 1 May 2025
and 31 Aug 2025, but may shift and/or stretch to six months.
The deadline to respond to this request for proposals is 26 Mar 2025, followed
by a board vote picking the contractor on 2 Apr 2025. Exact dates might be
subject to change in case of a major practical issue or unavailability of
voting members.
KCIDB Challenges
----------------
At the moment, KCIDB receives up to half a million of test and related data
rows per day (330K average). We keep six months worth of data in PostgreSQL
(117GB in tables and 16GB in indexes) for displaying on dashboards, analyzing,
and generating notifications. The complete archive is stored in BigQuery.
While our dashboards and notifications generally function, their performance
has been degrading recently, due to increasing ingestion, no longer leaving us
space and time to experiment and develop new and exciting features.
Additionally we would like to keep more historical data in the operational
PostgreSQL database, so we can make queries over a larger time-span.
Deliverables
------------
* A design of a scalable database architecture, and an assessment of capacity
required to hold 10x the current load/scale.
* Documented production deployment code integrated with KCIDB CI (existing or
modified), deploying the following:
* A PostgreSQL server tuned for serving the main KCIDB database.
* An empty KCIDB database tuned and ready for accepting data.
* Automated server/schema upgrades NOT included in the automatic
deployment, but available separately.
* Google Cloud and/or Docker/Podman containers as supported deployment
targets.
* All code licensed under GPLv2 or LGPL-2.1
The deliverable process needs to be iterative, gathering extensive feedback
multiple times from the Sysadmin working group and the community at large.
About KernelCI
--------------
KernelCI was created several years ago by Linux kernel maintainers in order to
provide an automated test system for the upstream kernel. It then became a
Linux Foundation project in 2019 and the founding members are still part of
the project. An annual budget is collected from the members’ contributions
which makes it possible to fund work packages, this being one of them.
Links
-----
Primary KCIDB dashboard
https://kcidb.kernelci.org/
A custom dashboard feeding its database off KCIDB
https://dashboard.kernelci.org
KCIDB source code
https://github.com/kernelci/kcidb/
https://github.com/kernelci/kcidb-io/
KernelCI project
https://kernelci.org/
Attached is also the official RFP document.Attachment:
RFP KCIDB DBA.pdf
Description: Adobe PDF document
