Database management

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

Database management
  • 24/7 monitoring
  • Performance optimisation
  • Backups and recovery

A slow system is usually an unmaintained database

  • 4 platforms: MS SQL, MySQL, MariaDB, PostgreSQL
  • 24/7 monitoring and incident logging
  • RPO backup frequency set by how much data you can afford to lose
  • HA active-active and active-passive clusters

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.

What is included

Monitoring
24/7 monitoring
Performance, query metrics, disk space, log growth, blocking: alerts reach us before users notice a slowdown.
Performance
Performance optimisation
Slow query analysis, index rebuilds, statistics updates, configuration tuning for the workload, with measured results.
Backups
Backups and recovery
Full and partial backups on a schedule, transaction log backups for point-in-time recovery, and recovery tests with a written report.
Security
Updates and security
Version and security patches installed in agreed windows, review of access and permissions, encryption at rest and in transit.
Clusters
Clusters and replication
High-availability solutions: active-active, active-passive, replication to a second site, so the system keeps running when a server fails.
Migrations
Migrations and consulting
Moves between versions, servers or platforms without data loss, plus schema and query reviews for your developers.

Unmaintained versus MDP CLOUD

UnmaintainedWith 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

How we start

From audit to ongoing maintenance in 1 to 2 weeks.

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.

Frequently asked questions

Do you maintain ERP databases such as SAP Business One?

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.

Do we need to give you access to the whole server?

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.

How often are backups made?

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.

Can you work with our system vendor?

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.

Related services

IT infrastructure management

Network, servers, databases, devices and web projects, managed as one system rather than separate services.

More
IT helpdesk for employees

Your employees have someone to call when something stops working.

More
Managed IT for business: one price per user

We take over workstation management, security and employee support.

More
Microsoft 365

Microsoft 365 is the work environment of most companies: email, Teams, files, access.

More

Expertise confirmed by certifications

This service is delivered by specialists with valid international certifications. Their expertise is confirmed by independent organisations, not by us.

All certifications
  • ISO27001LI badge
    ISO/IEC 27001 LI PECB

    ISO/IEC 27001 Lead Implementer

    The service is delivered in line with the requirements of an ISO/IEC 27001 management system.

  • CDPSE badge
    CDPSE ISACA

    Certified Data Privacy Solutions Engineer

    Personal data is handled according to privacy by design and GDPR requirements.

  • LCSM badge
    LCSM PECB

    Lead Cloud Security Manager

    Cloud security is managed following ISO/IEC 27017 and 27018 practices.

Get a database maintenance quote

Tell us which database you have and which system uses it, and we will send a quote within 1 business day.

We reply within 1 business day

Contact us 24/7
+370 630 94 909

Fill out the form, and we will contact you within 1 business day.