Database management systems
100 articles
ClickHouse: Real-Time Analytics and OLAP with Columnar Storage
Complete ClickHouse guide: columnar storage, MergeTree engines, replication, materialized views, data ingestion, and a practical log analytics example.
ClickHouse: Echtzeit-Analytik und OLAP mit Spaltenorientiertem Speicher
ClickHouse-Leitfaden für Echtzeit-Analytik: Spaltenspeicher, MergeTree-Engines, Replikation, materialisierte Views, Dateningestion und Log-Analytics-Beispiel.
ClickHouse: Analítica en Tiempo Real y OLAP con Almacenamiento Columnar
Guía completa de ClickHouse para analítica en tiempo real: almacenamiento columnar, motores MergeTree, replicación, vistas materializadas e ingesta de datos.
ClickHouse: Analytique en Temps Réel et OLAP avec Stockage Colonnaire
Guide complet ClickHouse: stockage colonnaire, moteurs MergeTree, réplication, vues matérialisées, ingestion de données et exemple de log analytics.
ClickHouse: Análise em Tempo Real e OLAP com Armazenamento Colunar
Guia completo do ClickHouse: armazenamento colunar, motores MergeTree, replicação, views materializadas, ingestão de dados e exemplo de log analytics.
MySQL Replication: Master-Slave Setup for High Availability
MySQL master-slave replication for high availability: binary logs, slave config, lag monitoring, failover, and read/write splitting with ProxySQL.
MySQL-Replikation: Master-Slave-Einrichtung fuer Hochverfuegbarkeit
Vollstaendige Anleitung zur MySQL-Master-Slave-Replikation fuer Hochverfuegbarkeit: Binary Logs, Slave-Konfiguration, Lag-Monitoring, Failover und ProxySQL.
Replicacion MySQL: Configuracion Master-Slave para Alta Disponibilidad
Guia completa de replicacion MySQL master-slave para alta disponibilidad: binary logs, configuracion de slaves, monitoreo de lag, failover y ProxySQL.
Replication MySQL : Configuration Master-Slave pour la Haute Disponibilite
Guide complet de replication MySQL master-slave pour la haute disponibilite : binary logs, configuration des slaves, surveillance du lag, failover et ProxySQL.
Replicacao MySQL: Configuracao Master-Slave para Alta Disponibilidade
Guia completo de replicacao MySQL master-slave para alta disponibilidade: binary logs, configuracao de slaves, monitoramento de lag, failover e ProxySQL.
PostgreSQL VACUUM and Autovacuum Tuning Guide
Master PostgreSQL VACUUM and autovacuum tuning to eliminate table bloat, prevent transaction ID wraparound, and maximize database performance.
PostgreSQL VACUUM und Autovacuum Tuning Leitfaden
PostgreSQL VACUUM und Autovacuum richtig tunen: Table Bloat beseitigen, XID-Wraparound verhindern und die Datenbankperformance in der Produktion maximieren.
Guía de ajuste de VACUUM y autovacuum en PostgreSQL
Domina el ajuste de VACUUM y autovacuum en PostgreSQL para eliminar el bloat, prevenir el desbordamiento de XID y maximizar el rendimiento de tu base de datos.
Guide d'optimisation VACUUM et autovacuum PostgreSQL
Maîtrisez VACUUM et autovacuum PostgreSQL pour éliminer le bloat, prévenir le wraparound XID et maximiser les performances de votre base de données.
Guia de ajuste de VACUUM e autovacuum no PostgreSQL
Domine o ajuste de VACUUM e autovacuum no PostgreSQL para eliminar bloat, prevenir o wraparound de XID e maximizar o desempenho do seu banco de dados.
Redis Sentinel Guide: High Availability and Automatic Failover
Deploy Redis Sentinel for automatic failover and high availability. Configure quorum, master-replica topology, Sentinel-aware clients, and production security.
Redis Sentinel Guide: Hochverfügbarkeit und automatisches Failover
Redis Sentinel für automatisches Failover und Hochverfügbarkeit einrichten. Quorum, Master-Replikat-Topologie, Sentinel-Clients und Sicherheit konfigurieren.
Guía de Redis Sentinel: Alta Disponibilidad y Failover Automático
Despliega Redis Sentinel para failover automático y alta disponibilidad. Configura quórum, topología master-réplica, clientes y seguridad en producción.
Guide Redis Sentinel : Haute Disponibilité et Basculement Automatique
Déployez Redis Sentinel pour le basculement automatique et la haute disponibilité. Configurez le quorum, la topologie master-réplique et la sécurité.
Guia do Redis Sentinel: Alta Disponibilidade e Failover Automático
Implante o Redis Sentinel para failover automático e alta disponibilidade. Configure quorum, topologia master-réplica, clientes e segurança em produção.
SQLite in Production: When and How to Use It
SQLite as a production database is increasingly viable for web applications. Learn when to use SQLite in production, performance tuning, and backup strategies.
SQLite in Produktion: Wann und Wie Man Es Einsetzt
SQLite als Produktionsdatenbank wird für Webanwendungen zunehmend praktikabler. Lernen Sie wann SQLite geeignet ist und Backup-Strategien mit Litestream.
SQLite en Producción: Cuándo y Cómo Usarlo
SQLite como base de datos en producción es cada vez más viable para aplicaciones web. Aprende cuándo usarlo, optimización de rendimiento y respaldos.
SQLite en Production : Quand et Comment l'Utiliser
SQLite comme base de données en production est de plus en plus viable pour les applications web. Apprenez quand utiliser SQLite et les stratégies de backup.
SQLite em Produção: Quando e Como Usar
SQLite como banco de dados em produção é cada vez mais viável para aplicações web. Aprenda quando usar SQLite em produção, otimização e backup estratégias.
Valkey: The Open-Source Redis Fork Migration Guide
Valkey is the Linux Foundation's open-source Redis fork. Install it, migrate from Redis with zero data loss, and configure clusters and Sentinel HA.
Valkey: Vollständiger Leitfaden zum Open-Source-Redis-Fork
Valkey ist der Open-Source-Redis-Fork der Linux Foundation. Installieren, ohne Datenverlust von Redis migrieren und Cluster sowie Sentinel konfigurieren.
Valkey: Guía Completa del Fork Open Source de Redis
Valkey es el fork open source de Redis bajo la Linux Foundation. Instálalo, migra sin perder datos y configura clústeres y Sentinel con esta guía.
Valkey : Guide Complet du Fork Open Source de Redis
Valkey est le fork open source de Redis par la Linux Foundation. Installez-le, migrez depuis Redis sans perte de données et configurez clusters et Sentinel.
Valkey: Guia Completo do Fork Open Source do Redis
Valkey é o fork open source do Redis pela Linux Foundation. Instale, migre do Redis sem perda de dados e configure clusters e Sentinel com este guia completo.
PostgreSQL Backup and Restore Strategies for Production Databases
PostgreSQL backup and restore strategies: pg_dump, pg_dumpall, pg_basebackup, WAL archiving, PITR, and automated scripts with rotation and S3 upload.
PostgreSQL Backup- und Wiederherstellungsstrategien für Produktion
PostgreSQL-Backups in der Produktion: pg_dump, pg_dumpall, pg_basebackup, WAL-Archivierung, PITR und automatisierte Skripte mit Rotation und S3-Upload.
Estrategias de Backup y Restauración en PostgreSQL para Producción
Estrategias de backup en PostgreSQL: pg_dump, pg_dumpall, pg_basebackup, archivado WAL, PITR y scripts automatizados con rotación y subida a S3.
Stratégies de Sauvegarde et Restauration PostgreSQL en Production
Sauvegardes PostgreSQL en production : pg_dump, pg_dumpall, pg_basebackup, archivage WAL, PITR et scripts automatisés avec rotation et envoi vers S3.
Estratégias de Backup e Restauração no PostgreSQL para Produção
Estratégias de backup no PostgreSQL: pg_dump, pg_dumpall, pg_basebackup, WAL archiving, PITR e scripts automatizados com rotação e upload para S3.
pgBackRest: PostgreSQL Backup, PITR Recovery, and Troubleshooting
Configure pgBackRest for reliable PostgreSQL backups with incremental, differential, and full strategies. Set up PITR recovery and fix common archive errors.
pgBackRest: PostgreSQL-Backup, PITR-Wiederherstellung und Fehlerbehebung
Konfigurieren Sie pgBackRest für zuverlässige PostgreSQL-Backups mit inkrementellen, differenziellen und vollständigen Strategien. PITR und häufige Fehler.
pgBackRest: Respaldo de PostgreSQL, Recuperación PITR y Solución de Problemas
Configure pgBackRest para respaldos confiables de PostgreSQL con estrategias incremental, diferencial y completo. Recuperación PITR y errores comunes.
pgBackRest : Sauvegarde PostgreSQL, Récupération PITR et Dépannage
Configurez pgBackRest pour des sauvegardes PostgreSQL fiables avec stratégies incrémentale, différentielle et complète. Récupération PITR et erreurs courantes.
pgBackRest: Backup do PostgreSQL, Recuperação PITR e Solução de Problemas
Configure o pgBackRest para backups confiáveis do PostgreSQL com estratégias incremental, diferencial e completo. Recuperação PITR e erros comuns.
PostgreSQL Streaming Replication Setup Guide
PostgreSQL streaming replication setup guide covering primary-standby configuration, WAL archiving, replication lag monitoring, and failover strategies.
PostgreSQL Streaming-Replikation einrichten
Anleitung zur Einrichtung von PostgreSQL Streaming-Replikation mit Primaer-Standby-Konfiguration, WAL-Archivierung, Lag-Ueberwachung und Failover.
Configuración de Replicación Streaming en PostgreSQL
Guía para configurar replicación streaming en PostgreSQL con configuración primario-standby, archivado WAL, monitoreo de lag y estrategias de failover.
Configuration de la Replication Streaming PostgreSQL
Guide de configuration de la replication streaming PostgreSQL avec serveur primaire-standby, archivage WAL, surveillance du lag et failover.
Configuração de Replicação Streaming no PostgreSQL
Guia para configurar replicação streaming no PostgreSQL com configuração primário-standby, arquivamento WAL, monitoramento de lag e failover.
MySQL Slow Query Log Analysis and Optimization
MySQL slow query log enables you to find and fix database performance bottlenecks by analyzing queries with mysqldumpslow and pt-query-digest
MySQL Slow Query Log Analyse und Optimierung
MySQL Slow Query Log ermöglicht die Identifizierung und Behebung von Datenbank-Leistungsengpässen mit mysqldumpslow und pt-query-digest Tools
Análisis y Optimización del Slow Query Log de MySQL
MySQL slow query log permite identificar y corregir cuellos de botella de rendimiento usando herramientas como mysqldumpslow y pt-query-digest
Analyse et Optimisation du Slow Query Log MySQL
MySQL slow query log vous permet d'identifier et corriger les goulots d'étranglement de performances en utilisant mysqldumpslow et pt-query-digest
Análise e Otimização do Slow Query Log do MySQL
MySQL slow query log permite identificar e corrigir gargalos de desempenho usando ferramentas de análise como mysqldumpslow e pt-query-digest
PostgreSQL on Ubuntu: Installation, Configuration, and Performance Tuning
Install and configure PostgreSQL on Ubuntu Server. Covers authentication, remote access, pg_dump backups, performance tuning, and essential psql commands.
PostgreSQL auf Ubuntu: Installation, Konfiguration und Leistungsoptimierung
PostgreSQL auf Ubuntu Server installieren und konfigurieren. Authentifizierung, Fernzugriff, pg_dump-Backups, Leistungsoptimierung und psql-Befehle.
PostgreSQL en Ubuntu: Instalación, Configuración y Optimización del Rendimiento
Instala y configura PostgreSQL en Ubuntu Server. Cubre autenticación, acceso remoto, backups con pg_dump, optimización del rendimiento y comandos psql.
PostgreSQL sur Ubuntu : Installation, Configuration et Optimisation des Performances
Installez et configurez PostgreSQL sur Ubuntu Server. Authentification, accès distant, sauvegardes pg_dump, optimisation des performances et commandes psql.
PostgreSQL no Ubuntu: Instalação, Configuração e Otimização de Desempenho
Instale e configure o PostgreSQL no Ubuntu Server. Abrange autenticação, acesso remoto, backups com pg_dump, otimização de desempenho e comandos psql.
Redis Caching: Install, Configure, and Optimize for Production
Deploy Redis as a caching layer on Ubuntu. Covers installation, production config, RDB vs AOF persistence, memory management, security hardening, and redis-cli.
Redis-Caching: Installation, Konfiguration und Optimierung fuer die Produktion
Redis als Caching-Schicht auf Ubuntu einrichten. Deckt Installation, Produktionskonfiguration, RDB/AOF-Persistenz, Speicher, Sicherheit und redis-cli ab.
Redis Caching: Instalar, Configurar y Optimizar para Produccion
Despliega Redis como caché en Ubuntu. Instalación, configuración para producción, persistencia RDB/AOF, gestión de memoria, seguridad y monitoreo con redis-cli.
Redis Caching : Installer, Configurer et Optimiser pour la Production
Déployez Redis comme cache sur Ubuntu. Installation, configuration production, persistance RDB/AOF, gestion mémoire, sécurité et surveillance avec redis-cli.
Redis Caching: Instalar, Configurar e Otimizar para Producao
Implante o Redis como cache no Ubuntu. Cobre instalação, configuração para produção, persistência RDB/AOF, gerenciamento de memória, segurança e redis-cli.
MySQL Performance Tuning: Optimization Guide for Production Servers
MySQL performance tuning for production: InnoDB buffer pool, slow query optimization, indexing strategies, connection pooling, and monitoring best practices.
MySQL Performance-Tuning: Optimierungsleitfaden fuer Produktionsserver
MySQL-Performance-Tuning für Produktionsserver: InnoDB Buffer Pool, langsame Abfragen, Indexierung, Connection Pooling und Monitoring-Best-Practices.
Optimización de Rendimiento de MySQL: Guía para Servidores de Producción
Optimización de MySQL para producción: buffer pool InnoDB, consultas lentas, indexación, connection pooling y mejores prácticas de monitoreo para servidores.
Optimisation des Performances MySQL : Guide pour Serveurs de Production
Optimisation MySQL pour la production : buffer pool InnoDB, requêtes lentes, indexation, connection pooling et meilleures pratiques de surveillance serveur.
Otimização de Desempenho do MySQL: Guia para Servidores de Produção
Otimização do MySQL para produção: buffer pool InnoDB, consultas lentas, indexação, connection pooling e melhores práticas de monitoramento em servidores.
PostgreSQL Backup and Restore with pg_dump
PostgreSQL backup and restore with pg_dump covers logical dumps, automated scheduling, point-in-time recovery, and tested restore procedures for production.
PostgreSQL Backup und Wiederherstellung mit pg_dump
PostgreSQL-Backup und Wiederherstellung mit pg_dump: logische Dumps, automatisierte Zeitplanung, Point-in-Time-Recovery und getestete Wiederherstellungsverfahren.
Backup y Restauración en PostgreSQL con pg_dump
Backup y restauración en PostgreSQL con pg_dump: volcados lógicos, programación automatizada, recuperación puntual y procedimientos de restauración verificados para producción.
Sauvegarde et restauration PostgreSQL avec pg_dump
Sauvegarde et restauration PostgreSQL avec pg_dump : dumps logiques, planification automatisée, récupération ponctuelle et procédures de restauration testées en production.
Backup e Restauração no PostgreSQL com pg_dump
Backup e restauração no PostgreSQL com pg_dump abrange dumps lógicos, agendamento automatizado, recuperação point-in-time e procedimentos de restauração validados para produção.
MongoDB: Getting Started with NoSQL Databases
MongoDB NoSQL database stores flexible JSON documents without rigid schemas. Install MongoDB, perform CRUD operations, create indexes, and set up replication.
MongoDB: Einstieg in NoSQL-Datenbanken
MongoDB speichert flexible JSON-Dokumente ohne starres Schema. Installation, CRUD-Operationen, Indizes erstellen und Replikation für Produktivumgebungen einrichten.
MongoDB: Primeros Pasos con Bases de Datos NoSQL
MongoDB NoSQL almacena documentos JSON flexibles sin esquemas rígidos. Instala MongoDB, realiza operaciones CRUD, crea índices y configura replicación.
MongoDB : Débuter avec les bases de données NoSQL
MongoDB stocke des documents JSON flexibles sans schéma rigide. Installez MongoDB, effectuez des opérations CRUD, créez des index et configurez la réplication.
MongoDB: Primeiros Passos com Bancos de Dados NoSQL
MongoDB armazena documentos JSON flexíveis sem esquemas rígidos. Instale, execute operações CRUD, crie índices e configure replicação para produção.
etcd: Distributed Key-Value Store Guide
etcd is the distributed key-value store powering Kubernetes. Learn to deploy a cluster, secure it with TLS, take snapshots, and restore from backup.
etcd: Leitfaden zum verteilten Key-Value-Store
etcd ist der verteilte Key-Value-Store, der Kubernetes antreibt. Cluster einrichten, TLS absichern, Snapshots erstellen und aus Backups wiederherstellen.
etcd: Guía del Almacén Distribuido de Clave-Valor
etcd es el almacén distribuido de clave-valor que impulsa Kubernetes. Aprende a desplegar un clúster, protegerlo con TLS, crear instantáneas y restaurar backups.
etcd : Guide du Magasin de Clés-Valeurs Distribué
etcd est le magasin clés-valeurs distribué qui alimente Kubernetes. Déployez un cluster, sécurisez-le avec TLS, créez des snapshots et restaurez depuis une sauvegarde.
etcd: Guia do Armazenamento Distribuído de Chave-Valor
etcd é o armazenamento distribuído de chave-valor que alimenta o Kubernetes. Aprenda a implantar um cluster, protegê-lo com TLS, tirar snapshots e restaurar backups.
How to: Install Aspel SAE using a MS SQL database instead of the default Paradox
Obtained entirely from: https://aspelsae.blogspot.com/2007/04/como-configurar-aspel-sae-40-en-sql.html Por Jorge Macias Esta guia contempla el uso del...
Anleitung: Install Aspel SAE using a MS SQL database instead of the default Paradox
Obtained entirely from: https://aspelsae.blogspot.com/2007/04/como-configurar-aspel-sae-40-en-sql.html Por Jorge Macias Esta guia contempla el uso del...
Cómo: Install Aspel SAE using a MS SQL database instead of the default Paradox
Obtained entirely from: https://aspelsae.blogspot.com/2007/04/como-configurar-aspel-sae-40-en-sql.html Por Jorge Macias Esta guia contempla el uso del...
Comment : Install Aspel SAE using a MS SQL database instead of the default Paradox
Obtained entirely from: https://aspelsae.blogspot.com/2007/04/como-configurar-aspel-sae-40-en-sql.html Por Jorge Macias Esta guia contempla el uso del...
Como: Install Aspel SAE using a MS SQL database instead of the default Paradox
Obtained entirely from: https://aspelsae.blogspot.com/2007/04/como-configurar-aspel-sae-40-en-sql.html Por Jorge Macias Esta guia contempla el uso del...
SQL Server Firewall Ports: Complete List of Ports to Open
Complete reference of TCP and UDP ports required by SQL Server for remote connections, including default instances, named instances, and ancillary services.
SQL Server Firewall Ports: Complete List of Ports to Open
Complete reference of TCP and UDP ports required by SQL Server for remote connections, including default instances, named instances, and ancillary services.
SQL Server Firewall Ports: Complete List of Ports to Open
Complete reference of TCP and UDP ports required by SQL Server for remote connections, including default instances, named instances, and ancillary services.
SQL Server Firewall Ports: Complete List of Ports to Open
Complete reference of TCP and UDP ports required by SQL Server for remote connections, including default instances, named instances, and ancillary services.
SQL Server Firewall Ports: Complete List of Ports to Open
Complete reference of TCP and UDP ports required by SQL Server for remote connections, including default instances, named instances, and ancillary services.
Why when trying to mount a SQL database you get the following error: 948
Fix SQL Server error 948 when trying to mount or attach a database created in a newer version of SQL Server to an older instance.
Warum when trying to mount a SQL database you get the following error: 948
Fix SQL Server error 948 when trying to mount or attach a database created in a newer version of SQL Server to an older instance.
Por qué when trying to mount a SQL database you get the following error: 948
Fix SQL Server error 948 when trying to mount or attach a database created in a newer version of SQL Server to an older instance.
Pourquoi when trying to mount a SQL database you get the following error: 948
Fix SQL Server error 948 when trying to mount or attach a database created in a newer version of SQL Server to an older instance.
Por que when trying to mount a SQL database you get the following error: 948
Fix SQL Server error 948 when trying to mount or attach a database created in a newer version of SQL Server to an older instance.
Error 28805 Setup cannot finish the request to the SQL Server 2005 Reporting Service report server. Verify that the report server is installed and running, and that you have sufficient privledges to access it.
Fix: Error 28805 Setup cannot finish the request to the SQL Server 2005 Reporting Service report server. Verify that the report server is installed and runni...
Error 28805 Setup cannot finish the request to the SQL Server 2005 Reporting Service report server. Verify that the report server is installed and running, and that you have sufficient privledges to access it.
Lösung für: Error 28805 Setup cannot finish the request to the SQL Server 2005 Reporting Service report server. Verify that the report server is installed an...
Error 28805 Setup cannot finish the request to the SQL Server 2005 Reporting Service report server. Verify that the report server is installed and running, and that you have sufficient privledges to access it.
Solución para: Error 28805 Setup cannot finish the request to the SQL Server 2005 Reporting Service report server. Verify that the report server is installed...
Error 28805 Setup cannot finish the request to the SQL Server 2005 Reporting Service report server. Verify that the report server is installed and running, and that you have sufficient privledges to access it.
Solution pour : Error 28805 Setup cannot finish the request to the SQL Server 2005 Reporting Service report server. Verify that the report server is installe...
Error 28805 Setup cannot finish the request to the SQL Server 2005 Reporting Service report server. Verify that the report server is installed and running, and that you have sufficient privledges to access it.
Solução para: Error 28805 Setup cannot finish the request to the SQL Server 2005 Reporting Service report server. Verify that the report server is installed ...