Health audit
We measure current performance and review the configuration, backups, logs and access. We list what poses a risk and what can be improved quickly.
The database is where your accounting, orders and customers live. We maintain it remotely as your database administrator: monitoring, performance, backups, clusters and updates for Microsoft SQL, MySQL, MariaDB and PostgreSQL.
Built for ISO 27001NIS2 DORA
When an ERP, an accounting system or an online store starts to lag, the server or the application gets the blame. In our experience the cause is usually the database: a transaction log that has grown out of control, indexes that have not been rebuilt for years, queries that were fast at ten thousand records and take minutes at a million, or a backup that is made but has never been restored.
Database maintenance means a remote administrator who measures and manages all of this continuously: monitoring performance and query metrics, optimising indexes and queries, managing transaction logs, making and testing backups, installing updates and, where needed, designing clusters (active-active, active-passive) so the system keeps running when one server fails. We work with both open source and licensed databases: Microsoft SQL, MySQL, MariaDB, PostgreSQL.
| Unmaintained | With MDP CLOUD | |
|---|---|---|
Who notices a slowdown | users, after complaints | monitoring, before complaints |
Transaction log | grows until it fills the disk | managed, backed up, truncated |
Indexes and statistics | as they were at installation | reviewed and rebuilt to match the workload |
Backups | made, but not tested | made and restored on a schedule, with a report |
Updates | when someone remembers | in agreed windows, with a backup before installing |
When a server fails | downtime until it is restored | failover to the second node or recovery within the agreed RTO |
From audit to ongoing maintenance in 1 to 2 weeks.
We measure current performance and review the configuration, backups, logs and access. We list what poses a risk and what can be improved quickly.
We set up the backup schedule to match the agreed RPO, run the first recovery test and connect the database to monitoring.
We tune indexes, logs and configuration, and review the slowest queries with your developers or system vendor. We show the results in numbers.
From then on we monitor, install updates, test backups and send a monthly report with metrics and recommendations.
Yes. Many ERP and accounting systems run on Microsoft SQL Server, which is one of the databases we maintain most often. In our ERP hosting service, database maintenance is already included.
Database administrator access and a monitoring agent are enough. Access is logged, used over a VPN with two-factor authentication, and every action is recorded in an audit log.
According to the agreed RPO: from daily full backups to transaction log backups every few minutes where even an hour of data loss is unacceptable. Backups are kept in separate storage.
Yes, and that is the usual setup: the vendor is responsible for the application, we are responsible for the database and the server. We review slow queries together and propose specific fixes.
Network, servers, databases, devices and web projects, managed as one system rather than separate services.
We take over workstation management, security and employee support.
Microsoft 365 is the work environment of most companies: email, Teams, files, access.
This service is delivered by specialists with valid international certifications. Their expertise is confirmed by independent organisations, not by us.
The service is delivered in line with the requirements of an ISO/IEC 27001 management system.
Personal data is handled according to privacy by design and GDPR requirements.
Cloud security is managed following ISO/IEC 27017 and 27018 practices.
We reply within 1 business day