# Database design: MySQL, MS-SQL, MongoDB

> Schema design, migration, performance tuning and tested backups for MySQL/MariaDB, MS-SQL Server and MongoDB. For businesses in Berlin and Brandenburg.

Source: https://1x1it.de/en/datenbankdesign/

Web application, ERP system or IoT platform: the database decides speed, stability and how easy the system is to maintain. We design, optimise and look after it.

[Discuss a database project](https://1x1it.de/en/kontakt/#anfrage)
Compare technologies

Database design Service

- **Relational:** MySQL, MariaDB, MS-SQL Server
- **Documents:** MongoDB
- **Services:** Schema, tuning, migration, replication
- **Backup:** Restore tested, retention under GoBD (German rules for digital bookkeeping)
- **Use:** Web, ERP, IoT, reporting

## Three database worlds, each with its own strengths

Which one fits depends on your data, not on our preference. We work with all three in practice.

| Technology | Strength | Typical use | What we do |
| MySQL / MariaDB | Open source, fast, proven replication | Web applications and CMS | Optimisation, replication, administration |
| MS-SQL Server | Microsoft environments for business-critical applications | Business intelligence and reporting | Design and maintenance, including complex environments |
| MongoDB | Flexible documents instead of fixed tables | Unstructured data, agile projects, IoT data streams | Design of scalable document databases |

## What we do for your database

Including live systems whose schema has grown over the years and no longer holds up.

[Performance tuning Find slow queries, optimise indexes, rework the schema. While the system keeps running. Details](https://1x1it.de/en/datenbankdesign/performance-tuning/)
[Migration & replication Switching between database systems, version upgrades and replication. Planned, tested, with a fallback option and without data loss. Details](https://1x1it.de/en/datenbankdesign/migration-replikation/)
[Backup strategy A daily backup is one thing. We regularly check that restoring actually works, and we set retention in line with GoBD. Details](https://1x1it.de/en/datenbankdesign/backup-strategie/)

## How we work

Analysis first, then a proposal. We only implement what really makes a difference.

- Analyse the current state: We look at the schema, queries, load and backups of your existing database.
- Name the levers: You get a proposal showing which measures will have the biggest effect.
- Implement and check: Changes are tested before they go live, with a fallback option in case something goes wrong.

## Looking for a faster database?

We analyse your current state and suggest what will really make a difference.

[0173 644 22 17](tel:+491736442217)

[Discuss a database project](https://1x1it.de/en/kontakt/#anfrage)