Find guides, tutorials, and documentation to help you get the most out of CubePath services.
Showing 14 of 14 guides
Automate nightly MySQL and PostgreSQL backups on Ubuntu 24.04 with one script, a systemd timer, retention rules, off-site copies with rsync and restore tests.
Configure MySQL 8.0 source-replica (master-slave) replication with GTIDs on Ubuntu 24.04, seed the replica from a consistent dump, then verify and monitor it.
Configure PostgreSQL 16 streaming replication on Ubuntu 24.04 with a replication slot, a read-only hot standby, lag monitoring and a tested manual failover.
Create MySQL and MariaDB users on Ubuntu 24.04, grant least-privilege access per database, restrict hosts, use roles and password policies, and audit accounts.
Create PostgreSQL roles, grant least-privilege access to databases, schemas and tables, set default privileges and row-level security on Ubuntu 24.04.
Enable the MySQL slow query log, rank queries with pt-query-digest, read EXPLAIN plans and fix them with indexes and rewrites, plus the PostgreSQL equivalents.
Install MySQL 8.0 or MariaDB on Ubuntu 24.04, secure it, create a database and user, tune InnoDB, allow remote access safely and schedule daily backups.
Install PostgreSQL 16 on Ubuntu 24.04, create a database and user, allow secure remote connections, tune memory settings and schedule daily backups.
Install MongoDB 8.0 Community on Ubuntu 24.04 from the official repository, enable authentication, restrict remote access and automate mongodump backups.
Install Redis on Ubuntu 24.04, protect it with ACL users and passwords, set a memory limit and eviction policy, configure persistence and back up the dataset.
Harden MySQL 8.0 or MariaDB on Ubuntu 24.04: run the security script, create least-privilege users, restrict network access, require TLS and lock brute force.
Tune MySQL 8.0 and MariaDB on Ubuntu 24.04 through my.cnf: size the InnoDB buffer pool and redo log, set connection limits, log slow queries and measure gains.
Tune PostgreSQL 16 on Ubuntu 24.04 by sizing memory, WAL, planner and autovacuum settings in postgresql.conf, then measure the results with pg_stat_statements.
Create consistent logical backups of MySQL, MariaDB and PostgreSQL with mysqldump and pg_dump on Ubuntu 24.04, then restore them and check every dump is usable.
