The JusDB Database Engineering Blog

Aurora and RDS share the MySQL engine but diverge at the storage layer in ways that produce very different cost and performance profiles — the right choice depends entirely on your I/O pattern.

Implement MySQL audit logging for SOC2, PCI-DSS, and HIPAA compliance. Covers MariaDB Audit Plugin, general query log, trigger-based auditing, and SIEM integration.

A detailed comparison of ClickHouse and BigQuery for analytical workloads — MergeTree engine vs Capacitor storage, self-hosted vs serverless cost models, query latency, real-time ingestion, and when to choose each.

Configure PostgreSQL TLS with self-signed or CA-signed certificates. Force TLS via pg_hba.conf, set minimum TLS version, and verify server certs from clients.

Authenticate to RDS and Aurora using IAM credentials instead of passwords. Eliminates long-lived passwords with 15-minute token-based access. Covers PostgreSQL and MySQL setup.

Implement PostgreSQL Row Level Security for multi-tenant isolation. Covers USING clauses, WITH CHECK policies, tenant context via set_config, and performance indexing.

MySQL InnoDB full-text search is underused and often misconfigured. With 8.4 LTS, new defaults and tuning opportunities can cut FTS query time by 60% or more.

Encrypt MySQL data at rest with InnoDB tablespace encryption and in transit with TLS. Covers keyring plugin, require_secure_transport, and binary log encryption.

Configure Aurora Serverless v2 for production workloads. ACU sizing, RDS Proxy integration, CloudWatch monitoring, and cost vs provisioned comparison.

A measurement-led guide to RDS and Aurora cost control: right-size safely, cover steady usage, govern storage, schedule idle systems, and verify each change.

DynamoDB and MongoDB are the two most common NoSQL choices, but cost structures, query flexibility, and operational overhead differ dramatically depending on your access patterns.

pgvector 0.8 delivers significant HNSW indexing improvements and new distance functions. Here is what changed and how to take advantage of it in production.