Databases — Docs

PostgreSQL Connection Pooling with PgBouncer
A comprehensive guide to postgresql covering installation, configuration, and optimization for Linux VPS environments. 10 views
Setting Up TimescaleDB for Time-Series Data
Step-by-step tutorial for timescaledb on Ubuntu/Debian servers, with practical code examples and troubleshooting tips. 8 views
DuckDB for Serverless Analytics on VPS
Guide to using DuckDB for serverless analytics on VPS, including installation, direct file querying, and Python integration. 8 views
MySQL Slow Query Log Analysis
Step-by-step tutorial for mysql on Ubuntu/Debian servers, with practical code examples and troubleshooting tips. 7 views
MySQL 8 Performance Schema Monitoring
Everything you need to know about mysql for your VPS, from initial setup to production-ready configuration with performance-schema. 6 views
MySQL Backup and Recovery Strategies
| Method | Speed | Size | Point-in-Time | Lock? | 138 views
MongoDB Replica Set on Multiple VPS Instances
A comprehensive guide to mongodb covering installation, configuration, and optimization for Linux VPS environments. 7 views
MySQL Event Scheduler for Automated Tasks
Guide to MySQL Event Scheduler for automating database maintenance, data aggregation, partition management, and cleanup tasks with practical examples. 315 views
Setting Up Citus for Distributed PostgreSQL
Guide to setting up Citus for distributed PostgreSQL, covering multi-tenant sharding, reference tables, columnar storage, rebalancing, and production deployment. 396 views
Database Migrations with Flyway and Liquibase
Comparison guide to Flyway and Liquibase for database schema migration management, covering setup, changelog formats, CI/CD integration, and migration best practices. 306 views
Setting Up Percona Monitoring and Management
Guide to deploying Percona Monitoring and Management (PMM) for MySQL, PostgreSQL, and MongoDB with query analytics, dashboards, and alerting. 296 views
Optimizing MongoDB Indexes for Performance
Complete guide to MongoDB index optimization covering index types, the ESR rule for compound indexes, query analysis with explain(), and removing unused indexes. 715 views
MySQL Shell Administration Guide
Guide to MySQL Shell (mysqlsh) for database administration, covering SQL/JS/Python modes, parallel data import/export, InnoDB Cluster management, and diagnostics. 458 views
S3-Compatible Database Backups with WAL-G
Guide to using WAL-G for PostgreSQL and MySQL backups to S3-compatible storage, with delta backups, point-in-time recovery, encryption, and automated retention. 351 views
Migrating from MongoDB to PostgreSQL
Step-by-step guide to migrating from MongoDB to PostgreSQL, covering schema design, data transformation, query migration, JSONB usage, and validation procedures. 510 views
Setting Up Database Read Replicas for Scaling
Guide to setting up MySQL and PostgreSQL read replicas for horizontal read scaling, with application-level routing patterns and replication lag monitoring. 532 views
DBeaver for Multi-Database Management
Complete guide to DBeaver for managing MySQL, PostgreSQL, MongoDB, and other databases from a single interface, covering connections, SQL editing, data transfer, and ER diagrams. 540 views
Back Up and Restore MongoDB with mongodump and mongorestore
Complete guide to MongoDB backup and restore using mongodump and mongorestore, with automation scripts, compression, S3 upload, and replica set backup strategies. 430 views
Scaling MySQL with Vitess: A Practical Guide
Practical guide to horizontal MySQL scaling with Vitess, covering deployment, sharding with VSchema, resharding, online DDL, and production monitoring. 338 views
Managing PostgreSQL with pgAdmin: Complete Guide
Comprehensive guide to using pgAdmin for PostgreSQL administration, covering installation, query analysis, server monitoring, backup/restore, and security configuration. 457 views
Tuning PostgreSQL for Maximum Write Performance
Guide to tuning PostgreSQL for maximum write throughput, covering WAL configuration, checkpoint optimization, bulk loading, partitioning, and benchmarking techniques. 542 views
Deploying a CockroachDB Multi-Node Cluster
Step-by-step guide to deploying a CockroachDB multi-node cluster with TLS certificates, multi-region support, automatic failover, and production monitoring. 443 views
Using Redis Streams for Event-Driven Architectures
Guide to building event-driven architectures with Redis Streams, covering consumer groups, message acknowledgment, dead-letter handling, and production monitoring. 285 views
Building a Redis Job Queue with BullMQ
Complete guide to building production job queues with BullMQ and Redis, covering delayed jobs, priorities, cron scheduling, job flows, dashboards, and retry strategies. 672 views
Setting Up MongoDB Sharding for Horizontal Scaling
Guide to deploying MongoDB sharding for horizontal scaling, covering shard key selection, cluster deployment, chunk management, and production operations. 353 views
Implementing PostgreSQL Full-Text Search
Comprehensive guide to implementing full-text search in PostgreSQL with tsvector, GIN indexes, ranking, highlighting, phrase search, and performance tuning. 489 views
Setting Up MariaDB MaxScale for Load Balancing and Failover
Guide to deploying MariaDB MaxScale for transparent read-write splitting, automatic failover, and database load balancing with production configuration. 269 views
How to Set Up MySQL InnoDB Cluster for High Availability
Complete guide to setting up MySQL InnoDB Cluster with Group Replication, MySQL Router, and MySQL Shell for automatic failover and high availability. 335 views
Using pg_stat_statements to Find and Fix Slow Queries
Learn how to use PostgreSQL pg_stat_statements extension to identify slow queries, analyze performance bottlenecks, and optimize database workloads with practical examples. 463 views
Setting Up PostgreSQL Logical Replication
Step-by-step guide to setting up PostgreSQL logical replication for selective table replication, cross-version support, and zero-downtime database upgrades. 227 views
How to Migrate from MySQL to PostgreSQL
Comprehensive guide to migrating from MySQL to PostgreSQL, covering schema conversion, data type mapping, pgloader usage, SQL syntax differences, and post-migration validation. 645 views
Setting Up a MongoDB Replica Set for High Availability
Complete guide to deploying a MongoDB replica set with authentication, automatic failover, read scaling, monitoring, and production best practices. 512 views
Redis Cluster Setup for High Availability
Learn how to set up and configure redis on your VPS with step-by-step instructions, including cluster and best practices for production environments. 5 views
PostgreSQL Logical Replication Setup
Learn how to set up and configure postgresql on your VPS with step-by-step instructions, including logical-replication and best practices for production environments. 4 views
MySQL InnoDB Buffer Pool Tuning
A comprehensive guide to mysql covering installation, configuration, and optimization for Linux VPS environments. 5 views
PostgreSQL Vacuum and Autovacuum Tuning
A comprehensive guide to postgresql covering installation, configuration, and optimization for Linux VPS environments. 5 views
How to Set Up MySQL Group Replication
How to Set Up MySQL Group Replication MySQL Group Replication provides a fault-tolerant, highly available database layer by replicating data across multiple ... 33 views
How to Install and Configure CockroachDB
How to Install and Configure CockroachDB CockroachDB is a distributed SQL database that provides horizontal scalability, strong consistency, and survivabilit... 28 views
How to Set Up TimescaleDB for Time-Series Data
How to Set Up TimescaleDB for Time-Series Data TimescaleDB is a PostgreSQL extension purpose-built for time-series data. It provides automatic partitioning, ... 30 views
How to Configure PostgreSQL Connection Pooling with PgBouncer
How to Configure PostgreSQL Connection Pooling with PgBouncer PgBouncer is a lightweight connection pooler for PostgreSQL that sits between your application ... 27 views
How to Set Up MariaDB Galera Cluster
How to Set Up MariaDB Galera Cluster MariaDB Galera Cluster provides synchronous multi-master replication, meaning every node can accept both reads and write... 31 views
How to Optimize MySQL Slow Queries
How to Optimize MySQL Slow Queries Slow queries are one of the most common performance bottlenecks for applications running on Breeze instances. Identifying ... 28 views
How to Set Up Database Monitoring with PMM
How to Set Up Database Monitoring with PMM Percona Monitoring and Management (PMM) is a free, open-source platform for monitoring MySQL, PostgreSQL, MariaDB,... 30 views
How to Configure PostgreSQL Streaming Replication
How to Configure PostgreSQL Streaming Replication PostgreSQL streaming replication continuously ships write-ahead log (WAL) records from a primary server to ... 30 views
How to Use pg_dump and pg_restore for Backups
How to Use pg_dump and pg_restore for Backups Regular database backups are essential for any application running on a Breeze instance. PostgreSQL provides pg... 26 views
How to Set Up SQLite for Lightweight Applications
How to Set Up SQLite for Lightweight Applications SQLite is a self-contained, serverless, zero-configuration SQL database engine. It stores the entire databa... 34 views
How to Install and Configure Cassandra
How to Install and Configure Cassandra Apache Cassandra is a distributed NoSQL database designed for handling massive amounts of data across many Breeze inst... 31 views
How to Set Up Elasticsearch for Full-Text Search
How to Set Up Elasticsearch for Full-Text Search Elasticsearch is a distributed search and analytics engine built on Apache Lucene. It provides powerful full... 28 views
How to Configure MySQL Binary Logging
How to Configure MySQL Binary Logging MySQL binary logging records all data-modifying statements and events in a binary format. Binary logs are essential for... 28 views
How to Set Up Database Connection Pooling with ProxySQL
How to Set Up Database Connection Pooling with ProxySQL ProxySQL is a high-performance MySQL protocol-aware proxy that provides connection pooling, query rou... 29 views
How to Set Up MariaDB Galera Cluster for High Availability
How to Set Up MariaDB Galera Cluster for High Availability Galera Cluster provides synchronous multi-master replication for MariaDB. Set up a cluster across ... 30 views
How to Install and Use ClickHouse for Analytics
How to Install and Use ClickHouse for Analytics ClickHouse is a column-oriented database optimized for real-time analytical queries. Install it on your Breez... 28 views
Database Index Optimization Strategies for MySQL and PostgreSQL
Database Index Optimization Strategies for MySQL and PostgreSQL Proper indexing is one of the most impactful optimizations for database performance on your B... 26 views
How to Set Up Percona XtraBackup for MySQL Hot Backups
How to Set Up Percona XtraBackup for MySQL Hot Backups Percona XtraBackup performs non-blocking backups of MySQL and MariaDB databases. Unlike mysqldump, it ... 29 views
How to Install and Use CockroachDB on a VPS
How to Install and Use CockroachDB on a VPS CockroachDB is a distributed SQL database designed for cloud-native resilience. You can run a single-node instanc... 26 views
How to Install and Use TimescaleDB for Time-Series Data
How to Install and Use TimescaleDB for Time-Series Data TimescaleDB is a PostgreSQL extension optimized for time-series workloads such as metrics, IoT data, ... 28 views
How to Set Up InfluxDB for Metrics and Monitoring
How to Set Up InfluxDB for Metrics and Monitoring InfluxDB is a purpose-built time-series database ideal for storing metrics, monitoring data, and real-time ... 26 views
How to Install Elasticsearch on a VPS
How to Install Elasticsearch on a VPS Elasticsearch is a distributed search and analytics engine that enables fast full-text search and log analysis on your ... 29 views
How to Set Up the ELK Stack on Linux
How to Set Up the ELK Stack on Linux The ELK Stack (Elasticsearch, Logstash, Kibana) provides centralized log management and visualization for your Breeze in... 27 views
How to Set Up Redis Sentinel for High Availability
How to Set Up Redis Sentinel for High Availability Redis Sentinel provides automatic failover and monitoring so your Breeze applications maintain Redis avail... 29 views
How to Set Up Redis Cluster Mode
How to Set Up Redis Cluster Mode Redis Cluster distributes data across multiple nodes using hash slots, providing horizontal scalability and fault tolerance ... 29 views
How to Use pgBouncer for PostgreSQL Connection Pooling
How to Use pgBouncer for PostgreSQL Connection Pooling pgBouncer is a lightweight connection pooler for PostgreSQL that reduces connection overhead and impro... 27 views
Setting Up KeyDB as a Redis Alternative
A comprehensive guide to keydb covering installation, configuration, and optimization for Linux VPS environments. 7 views
SQLite: When and How to Use It on a VPS 50 views
How to Migrate from MySQL to MariaDB 114 views
MongoDB Basics: Installation and CRUD Operations 97 views
How to Use mysqldump for Selective Database Backups 97 views
How to Set Up MySQL Replication (Primary-Replica) 185 views
PostgreSQL Backup and Restore with pg_dump 71 views
MariaDB Performance Tuning for VPS Servers 140 views
SQLite for Lightweight Applications 31 views
Database Connection Pooling Explained 32 views
Database Replication with MySQL and MariaDB 30 views
Query Optimization Techniques for MySQL 34 views
MongoDB Basics for Developers 31 views
PostgreSQL Installation and Basic Administration 34 views
Redis Caching Fundamentals 26 views
How to Enable Remote MySQL Access
By default, MySQL only accepts connections from localhost. Here's how to enable remote access securely.1. Configure MySQLEdit /etc/mysql/mysql.conf.d/mysqld.cnf... 338 views
How to Set Up MySQL Replication
MySQL replication creates a copy of your database on another server for redundancy.On the Primary ServerEdit /etc/mysql/mysql.conf.d/mysqld.cnf:server-id = 1\nl... 376 views
How to Install MySQL on Ubuntu
MySQL is the world's most popular open-source relational database.Installapt update apt install mysql-server -ySecure Installationmysql_secure_installationFollo... 237 views
How to Install MariaDB on Ubuntu
MariaDB is a community-developed fork of MySQL with enhanced features and performance.Installapt update apt install mariadb-server -ySecure Installationmariadb-... 236 views
How to Install PostgreSQL on Ubuntu
PostgreSQL is a powerful, enterprise-grade relational database with advanced features.Installapt update apt install postgresql postgresql-contrib -yAccess Postg... 146 views
How to Install MongoDB on Ubuntu
MongoDB is a NoSQL document database for flexible, JSON-like data storage.Install# Import MongoDB GPG key curl -fsSL https://www.mongodb.org/static/pgp/server-7... 494 views
How to Install Redis on Ubuntu
Redis is an in-memory data store used for caching, sessions, and message queues.Installapt update apt install redis-server -yConfigureEdit /etc/redis/redis.conf... 194 views
How to Back Up a MySQL Database
Regular database backups protect against data loss.Backup a Single Databasemysqldump -u root -p myapp > myapp_backup.sqlBackup All Databasesmysqldump -u root -p... 83 views
How to Back Up a PostgreSQL Database
PostgreSQL provides powerful backup tools for data protection.Backup with pg_dumpsudo -u postgres pg_dump myapp > myapp_backup.sqlCompressed Backupsudo -u postg... 360 views
How to Optimize MySQL Performance
Tuning MySQL configuration can dramatically improve database performance.Key SettingsEdit /etc/mysql/mysql.conf.d/mysqld.cnf:[mysqld] # InnoDB buffer pool (set ... 152 views
PostgreSQL Performance Tuning Guide
```bash 352 views
MySQL Query Optimization with EXPLAIN
Step-by-step tutorial for mysql on Ubuntu/Debian servers, with practical code examples and troubleshooting tips. 5 views
Database Migration with Flyway
Step-by-step tutorial for flyway on Ubuntu/Debian servers, with practical code examples and troubleshooting tips. 5 views
SQLite Performance Optimization for Web Apps
Learn how to set up and configure sqlite on your VPS with step-by-step instructions, including performance and best practices for production environments. 6 views
CockroachDB Single-Node Development Setup
Learn how to set up and configure cockroachdb on your VPS with step-by-step instructions, including single-node and best practices for production environments. 5 views
Redis Sentinel for Automatic Failover
Practical guide to redis featuring real-world examples, performance tuning tips, and security best practices. 5 views
MariaDB Galera Cluster Configuration
A comprehensive guide to mariadb covering installation, configuration, and optimization for Linux VPS environments. 5 views
MariaDB Replication Setup Guide
- **Read scaling** — distribute SELECT queries across replicas 86 views
ClickHouse for Analytics Workloads
Step-by-step tutorial for clickhouse on Ubuntu/Debian servers, with practical code examples and troubleshooting tips. 5 views
Percona XtraBackup for Hot MySQL Backups
Learn how to set up and configure percona on your VPS with step-by-step instructions, including xtrabackup and best practices for production environments. 6 views