Database Engineering

High-Availability Database Clusters

We design and manage self-healing MySQL (Galera, Percona, MariaDB), PostgreSQL, MongoDB, MSSQL, Oracle, and DB2 architectures. Keep your data consistent, secure, and highly available, even during high traffic spikes.
Expert services available in Munich (Bayern) and remotely.

Database Tuning Zero-Downtime Migration Disaster Recovery Scaling
MySQL
PostgreSQL
MongoDB
Redis
MSSQL
Oracle
DB2
Primary ● Active
Replica 1
Replica 2
Sync_Latency: 0.4ms

Abstract Data Tools

Processing Engine

Apache Spark

Unified engine for large-scale in-memory data processing (analytics, ML, graphs).

Support Tools

Apache Kafka

Streaming platform for real-time data transmission.

NoSQL Databases

Apache Cassandra

Highly scalable database for huge volumes of data with no downtime.

Apache CouchDB

Document JSON database, ideal for web and synchronization.

Apache HBase

Distributed database for random access to Big Data (runs on Hadoop).

Apache Accumulo

Secure, sorted, distributed key-value store.

SQL & Relational Databases

Apache Derby

Lightweight relational database entirely in Java.

Open Source Power

Enterprise Grade Solutions

AI-Powered Solutions for Business Challenges

Sortia Labs builds custom software, integrates artificial intelligence (AI) into business processes and runs cloud and database infrastructure for companies in Munich and across Germany.

Data Input (Trigger)
Data Validation (Quality Check)
AI Processing (Sortia Core)
Results Output (Actionable Results)
Learn More

Software Development, Cloud Engineering, AI Consulting and Database Consulting

Sortia Labs is a software studio in Munich, Germany. We build custom software, integrate artificial intelligence (AI) and language models into existing processes, run cloud infrastructure and look after databases. For companies in Munich and across Germany, on site and remote.

AI consulting and AI integration

Artificial intelligence where it saves time: LLM integration (OpenAI, Anthropic, open source), document analysis, speech transcription and AI agents with human approval. Built with GDPR in mind, hosting in the EU.

Learn more

Software development

Custom software for companies: web applications, Android apps (Kotlin), integrations, legacy modernisation and automation with Python. Cleanly documented, fixed price after the prototype.

Learn more

Cloud engineering and DevOps

AWS, Azure, Kubernetes, Docker and self-hosting: zero downtime migration, CI/CD, monitoring and cost control. Operations as a fixed monthly price.

Learn more

Database consulting

MySQL, PostgreSQL, MongoDB, Oracle, MSSQL and DB2: performance tuning, high availability, disaster recovery and zero downtime migrations, with experience from banking IT.

Learn more

Sortia Labs stands for software, cloud and AI from one team: IT consulting, software development, cloud engineering, AI solutions and database operations for mid-sized companies in Munich, Bavaria and all of Germany.

Adaptable Workflow Development

Combining visual development speed with the precision of code, a platform leveraging powerful workflow engines like n8n offers a unique approach. Start with intuitive drag-and-drop tools for rapid prototyping and standard tasks. When complexity increases, seamlessly switch to code for fine-grained control and custom logic integration.

Connect directly with external APIs using standard cURL commands within your workflows.
Extend capabilities further by incorporating libraries from npm or Python's package index.
Leverage JavaScript or Python for sophisticated custom functions and precise data handling.
Finally, manage intricate processes effectively with advanced flow controls like branch merging.

White-Label Automation Solutions

Supported by a robust integration engine, powerful, custom-branded automation features can be embedded directly into products to empower end customers.

Workflow diagram showing problem, processing, and solution steps AI Robot Head

Action, AI, Insights, Solution

Action

Taking decisive steps based on intelligent analysis.

AI

Leveraging cutting-edge artificial intelligence.

Insights

Uncovering valuable patterns and predictions.

Solution

Delivering effective and scalable results.

IT Consulting

Inefficient Data Processing

Implement AI models to automate and accelerate data extraction.

Manual Workflow Bottlenecks

Deploy AI-driven automation to streamline operations.

Lack of Predictive Insights

Utilize machine learning for accurate forecasting and decision-making.

Data Scalability Challenges

Architect and optimize AI solutions for large-scale data environments.

DevOps & Technologies

Cloud Platforms

  • AWS: Comprehensive cloud services suite.
  • Azure: Microsoft's cloud computing platform.
  • GCP: Google's cloud infrastructure services.
  • EC2: Scalable virtual servers on AWS.
  • S3: Scalable object storage on AWS.
  • Lambda: Serverless compute service on AWS.
  • CloudFormation: Infrastructure as Code on AWS.
  • Azure VMs: Virtual machines on Azure.
  • Azure Blob Storage: Object storage on Azure.

Containerization

  • Docker: OS-level virtualization platform.
  • Kubernetes (K8s): Container orchestration system.
  • Helm: Package manager for Kubernetes.
  • EKS: Managed Kubernetes on AWS.
  • AKS: Managed Kubernetes on Azure.
  • GKE: Managed Kubernetes on GCP.
  • OpenShift: Red Hat's Kubernetes platform.
  • Istio: Service mesh for microservices.

Databases

  • MySQL: Popular open-source RDBMS.
  • PostgreSQL: Advanced open-source RDBMS.
  • MongoDB: NoSQL document database.
  • Redis: In-memory data structure store.
  • Cassandra: Distributed NoSQL database.
  • Elasticsearch: Search and analytics engine.
  • DynamoDB: Managed NoSQL database on AWS.
  • RDS: Managed relational databases on AWS.
  • SQL Server: Microsoft's RDBMS.
  • Oracle DB: Enterprise RDBMS.

OS & Infrastructure

  • Linux (Ubuntu, CentOS): Widely used open-source OS.
  • Unix: Foundational multi-user OS family.
  • Bash/Shell Scripting: Command-line automation.
  • Networking (TCP/IP, DNS): Core internet protocols.
  • Load Balancers (Nginx, HAProxy): Traffic distribution.
  • Terraform: Multi-cloud Infrastructure as Code.
  • Ansible: Configuration management & automation.

Automation & Workflow

  • n8n: Extendable workflow automation tool.
  • Jenkins: CI/CD automation server.
  • GitLab CI/CD: Integrated CI/CD pipelines.
  • GitHub Actions: Workflow automation in GitHub.
  • Zapier: Web application integration platform.
  • Make (Integromat): Visual workflow automation.

Programming

  • Python: Versatile high-level language.
  • JavaScript: Core web scripting language.
  • Node.js: Server-side JavaScript runtime.
  • React: JavaScript library for UI building.
  • Java: Widely used object-oriented language.
  • Go: Efficient language by Google.
  • PHP: Server-side scripting language.
  • REST APIs: Standard for web service communication.
  • GraphQL: Query language for APIs.

Detailed Database Solutions

MySQL & MariaDB Clustering

Specialized in designing high-availability architectures. From synchronous Galera Cluster and Percona XtraDB to high-performance asynchronous replication setups.

  • Galera / Percona Cluster: Multi-master synchronous replication: committed transactions are on every node, for high availability.
  • ProxySQL & Load Balancing: Intelligent query routing, caching, and connection multiplexing for massive scale.
  • Replication Topologies: Master-Slave, Master-Master, and delayed replicas for disaster recovery scenarios.
cluster_status.sh

root@db-node-01:~# mysql -e "SHOW STATUS LIKE 'wsrep%'"

+---------------------------+------------+
| Variable_name             | Value      |
+---------------------------+------------+
| wsrep_local_state_comment | Synced     |
| wsrep_cluster_size        | 3          |
| wsrep_cluster_status      | Primary    |
| wsrep_ready               | ON         |
+---------------------------+------------+

# Cluster is healthy and replicating...

PostgreSQL Enterprise Edition

PostgreSQL Enterprise

Robust architecture for mission-critical data. Leveraging PostgreSQL's advanced features for reliability, performance, and geospatial data.

  • High Availability (Patroni): Automated failover using Etcd/Consul to minimize downtime.
  • Performance Tuning: Advanced vacuum tuning, index optimization, and slow query analysis.
  • PgBouncer: Efficient connection pooling for high-throughput environments.

Comprehensive Database Services

Disaster Recovery

Emergency data rescue, Point-in-Time Recovery (PITR), and handling corruption or accidental 'DROP TABLE' scenarios.

Upgrades & Migrations

Zero-downtime migrations to Cloud (AWS RDS, GCP) and major version upgrades (e.g., MySQL 5.7 to 8.0).

Fixes & Troubleshooting

Resolving deadlocks, slow queries, replication lags, foreign key issues, and server stability problems.

Certifications

ITIL 4 Foundation

Best practices for the creation, delivery, and continual improvement of technology-enabled products and services embracing the new service management culture.

Infrastructure & Platform Engineering

Enterprise-grade platforms for container orchestration, virtualization, GitOps automation, and full-stack observability.

Kubernetes & OpenShift

Production-grade container orchestration on Red Hat OpenShift and OKD. Namespace-scoped operator deployments, RBAC management, OLM configuration, and multi-cluster context management across production and test environments.

OpenShift / OKD Operator Lifecycle Helm / Kustomize RBAC & SCC

Virtualization & Proxmox

Enterprise virtualization with Proxmox VE: from high-availability clusters to desktop VM provisioning. NVMe-backed storage, VFIO GPU passthrough, automated backup policies, and comprehensive infrastructure monitoring.

Proxmox VE VM Provisioning PBS Backup Storage / ZFS

GitOps & CI/CD Automation

End-to-end automation pipelines: NetBox webhooks to AWX job templates to Ansible playbooks to GitLab push to ArgoCD sync to OpenShift deployment. Self-service provisioning with automated sync, self-heal, and pruning policies.

ArgoCD GitLab CI/CD Ansible / AWX NetBox CMDB

Monitoring & Observability

Full-stack monitoring pipeline: exporters to ServiceMonitor to VictoriaMetrics to Grafana dashboards. Cross-namespace monitoring architecture, PromQL/MetricsQL query development, and custom dashboards for database replication, connection pools, and query performance.

Grafana VictoriaMetrics Prometheus ServiceMonitor

Database Operators on Kubernetes

Automated database lifecycle on Kubernetes: Percona XtraDB Cluster with HAProxy, Crunchy PGO with PgBouncer and pgBackRest, MariaDB Enterprise Operator. T-shirt sizing, automated failover, backup CronJobs, and disaster recovery procedures.

Percona PXC Crunchy PGO MariaDB Op. HA / Failover

Network & Firewall

Enterprise network management with OPNsense firewalls, DNS architecture, VLAN segmentation, and SSL automation using Lets Encrypt wildcards. Traefik reverse proxy with automatic certificate management.

OPNsense Traefik Lets Encrypt DNS / VLAN

Our Products

Mobile, web and desktop products built by Sortia Labs: fitness tracking, AI voice transcription, meditation, end-to-end encrypted file transfer, and a hardware-accelerated Windows screen recorder.

Tractor
Weight & Activity Tracking
Interactive weight charts, BMI tracking, 60+ sports & activities, daily diary with mood, custom reminders. Available in many languages.
Android Web Many Languages 60+ Activities
GET IT ONGoogle Play
Loma
Voice Transcription & Translation
AI-powered voice transcription with translation in the same step. Many languages, currently with models from OpenAI and Google Gemini, web, Android and Chrome, audio export.
Android Web Many Languages GPT-4o
GET IT ONGoogle Play
Balsam
Meditation, Breathing & Sounds
100+ ambient soundscapes in the Android app, breathing exercises and a meditation timer. Currently free; sounds you have played stay available offline on your phone.
Android Web 100+ Sounds Currently free
GET IT ONGoogle Play
Encrypted Clipboard & File Transfer
End-to-end encrypted file and clipboard sharing. AES-GCM 256 via the Web Crypto API: content is encrypted on your device before upload. Brute-force protection.
Android Web AES-GCM 256 End-to-end
GET IT ONGoogle Play
SCREEN
Hardware-Accelerated Screen Recorder
Windows screen recorder with NVENC and Intel Quick Sync hardware encoding. FFmpeg under the hood, system-wide hotkeys, distraction-free mode. Recordings are saved locally; optional AI features are off by default.
Windows Desktop NVENC / QSV Hotkeys
Day organizer
Your day in focus: a Google-style calendar, dictate events by voice, realtime sync between phone and desktop, Gmail attachments right on the event.
Android Web / PWA Realtime Sync Voice AI
GET IT ONGoogle Play
FIBU
Local accounting with AI
Receipts, bank and VAT in one self-hosted app: database and archive are stored on your own machine. AI reads documents, payments are the truth, every receipt tracked by its sha256 checksum. Currently an internal tool, not publicly available.
Desktop Self-hosted AI receipts VAT
OMNIA
The local document archive
Contracts, letters, scans and everything without a payment attached. AI names and sorts, removed files go to the trash first, one folder is the whole backup.
Desktop Self-hosted AI archive Recycle bin

All products are designed, built and shipped by Sortia Labs: from concept to Google Play and Windows distribution. Native Android in Kotlin + Jetpack Compose, web apps as installable PWAs, Windows apps in Python with PyInstaller and Inno Setup. Modern cloud back-ends, real-time performance.

Android

Kotlin Jetpack Compose Material 3 Coroutines StateFlow Gradle KTS OkHttp

AI & Backend

OpenAI API GPT-4o Whisper Supabase PostgreSQL Row Level Security Google OAuth

Web & Infra

PWA WebAudio API Service Workers Nginx Contabo VPS GitHub Firebase Crashlytics Google Play Store

Clients & Project Partners

Ready to Transform Your Business?

Let's discuss how Sortia AI solutions can help you achieve your goals.

Headquarters in Munich (München), Bavaria