Details
-
Improvement
-
Status: Done
-
High
-
Resolution: Done
-
None
-
10
-
Yes
-
Yes
-
No
-
-
just release notes and later mention about it in whole HA notes
Description
User story:
- As PMM developers, we want less complexity in the system with many different DB's used inside
- as PMM is used, we need the better performance of Auth system and sessions. It's a known problem with Go and SQL like about concurrency, so the SQL lite is a problem for deployments with a significant number of users and services
UI/UX:
N/A
Acceptance criteria
- PMM Grafana storage changed from internal SQL lite to PG used inside PMM for Inventory data
- All data migrated correctly and change of the component is transparent for the user and does not require additional actions from them, besides usual update
Out of scope:
- TBD
Suggested implementation:
TBD
How to test:
It's quite a big change. It contains two parts:
- Change database encoding to UTF8
- Migrate to Postgres database for Grafana.
All PMM functions can be impacted. What I think is worth paying attention to when testing:
- Upgrade process. Especially with data (Mongo, Postgress, RDS instances).
- Adding/Editing new instances.
- Grafana works as expected (Adding new users, editing/creating dashboard, datasources, and so on).
Original report:
With a lot of authentication requests, sqlite3 locks too often. We need to use PostgreSQL instead.
For PG we need to use separate DB ('grafana')
------
This will give us much better stability, especially for User Auth requests, and probably eliminate bugs with logged out users
Attachments
Issue Links
- blocks
-
PMM-8082 Ability to initialize the /srv directory when bootstrapping PMM Server
-
- Done
-
- causes
-
PMM-9727 Dashboards missing from their respective folders After upgrade to 2.27.0
-
- Done
-
-
PMM-9355 Custom dashboard is moved to another random folder after upgrade
-
- Done
-
- is blocked by
-
PMM-5197 Convert pmm-managed database to UTF8
-
- Done
-
-
PMM-4486 Provision Grafana dashboards without accessing sqlite3
-
- Done
-
-
PMM-12299 pmm-managed database has a C collation
-
- Open
-
- is duplicated by
-
PMM-8962 Migrate grafana database from SQLite to Postgres
-
- Done
-
- relates to
-
PMM-12110 Upgrades to 2.38.0 fails
-
- Done
-
-
PMM-12173 PMM gets down when adding many instances
-
- Done
-
-
PMM-10535 Failed to get annotations errors appears on all dashboard from PMM with 1000+ nodes
-
- Done
-
-
PMM-12157 Custom dashboard is not preserved as Home dashboard after upgrade
-
- Done
-
-
PMM-9811 Issue upgrading dashboards in RC when doing a container update
-
- Done
-
-
PMM-5174 Cache Grafana auth_request results
-
- Done
-
- links to
- mentioned in
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...