FugokuFugoku Docs
Mask

Managed Databases

Fully managed PostgreSQL, MySQL, and Redis with automated backups, PITR, and read replicas

Managed Databases

Fugoku Managed Databases provide fully managed PostgreSQL, MySQL, and Redis with automated backups, point-in-time recovery, read replicas, and zero egress fees.

Access database management at: console.fugoku.com/databases

Supported Engines

EngineVersionsKey FeaturesIdeal For
PostgreSQL14, 15, 16PostGIS, pgvector, logical replication, partitioningOLTP, analytics, geospatial, AI
MySQL8.0InnoDB, GTID replication, JSON, invisible indexesWeb apps, e-commerce, CMS
Redis7.2Cluster mode, persistence (RDB/AOF), ACLs, Lua scriptingCaching, sessions, queues, pub/sub

All engines run on dedicated resources — no shared tenancy, consistent performance.

Creating a Database

Console

  1. Navigate to Databases
  2. Click Create Database
  3. Select Engine: PostgreSQL, MySQL, or Redis
  4. Select Version: Choose supported version
  5. Configure Instance:
    • Name: prod-postgres-main
    • Region: ashburn-1 (must match your VPC)
    • Plan: Choose CPU/RAM/storage (see plans below)
    • High Availability: Enable for automatic failover (PostgreSQL/MySQL)
    • Private Network: Attach to your VPC (required)
    • Backup Window: Daily backup time (UTC)
    • Retention: 7-35 days (PITR)
  6. Click Create Database — Ready in 2-5 minutes

CLI

# PostgreSQL
fugoku databases create \
  --name prod-pg \
  --engine postgresql \
  --version 16 \
  --plan db-standard-4 \
  --region ashburn-1 \
  --network backend-net \
  --enable-ha \
  --backup-window "03:00" \
  --retention 14

# MySQL
fugoku databases create \
  --name prod-mysql \
  --engine mysql \
  --version 8.0 \
  --plan db-standard-4 \
  --region ashburn-1 \
  --network backend-net \
  --enable-replicas 2

# Redis
fugoku databases create \
  --name session-cache \
  --engine redis \
  --version 7.2 \
  --plan db-redis-standard \
  --region ashburn-1 \
  --network backend-net \
  --cluster-mode enabled

API

curl -X POST https://api.fugoku.com/v1/databases \
  -H "Authorization: Bearer $FUGOKU_API_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "data": {
      "type": "databases",
      "attributes": {
        "name": "prod-pg",
        "engine": "postgresql",
        "version": "16",
        "plan": "db-standard-4",
        "site": "ashburn-1",
        "network_id": "net-abc123",
        "high_availability": true,
        "backup_window": "03:00",
        "retention_days": 14
      }
    }
  }'

Plans & Pricing

PostgreSQL / MySQL Plans

PlanvCPURAMStorageMax ConnectionsHAHourlyMonthly
db-standard-112 GB20 GB100Optional$0.025$18
db-standard-224 GB50 GB200Optional$0.050$36
db-standard-448 GB100 GB400Included$0.100$72
db-standard-8816 GB200 GB800Included$0.200$144
db-standard-161632 GB400 GB1600Included$0.400$288
db-memory-4432 GB200 GB400Included$0.180$130
db-memory-8864 GB400 GB800Included$0.360$260
db-storage-4416 GB1 TB400Included$0.150$108

Redis Plans

PlanvCPURAMStorageClusterHourlyMonthly
db-redis-standard24 GB20 GBOptional$0.040$29
db-redis-standard-848 GB50 GBOptional$0.080$58
db-redis-cluster-4416 GB100 GBIncluded$0.180$130
db-redis-cluster-8832 GB200 GBIncluded$0.360$260

All plans include:

  • Automated daily backups + PITR (7-35 days)
  • Encryption at rest (AES-256) + TLS in transit
  • Zero egress fees
  • Automated patching (configurable window)

High Availability (PostgreSQL/MySQL)

Enable HA for automatic failover:

Architecture:

  • Primary — Accepts reads/writes
  • Standby — Synchronous replication, same region
  • Witness — Quorum for split-brain prevention

Failover:

  • Automatic on primary failure (< 30s)
  • DNS flip via internal load balancer
  • No application changes needed

CLI:

# Enable HA on existing database
fugoku databases enable-ha prod-pg

# Promote standby (manual failover)
fugoku databases promote-standby prod-pg

Read Replicas (PostgreSQL/MySQL)

Scale reads with async replicas:

# Create read replica
fugoku databases create-replica prod-pg \
  --name prod-pg-replica-1 \
  --region ashburn-1 \
  --plan db-standard-4

# Promote replica to primary
fugoku databases promote-replica prod-pg-replica-1

Features:

  • Async replication (sub-second lag typical)
  • Up to 5 replicas per primary
  • Cross-region replicas for DR
  • Promote to primary in < 60s

Redis Cluster Mode

Enable horizontal scaling:

fugoku databases create \
  --name redis-cluster \
  --engine redis \
  --version 7.2 \
  --plan db-redis-cluster-8 \
  --region ashburn-1 \
  --network backend-net \
  --cluster-mode enabled \
  --shards 3 \
  --replicas-per-shard 1

Features:

  • Automatic sharding across shards
  • Multi-AZ replica placement
  • Automatic failover with Redis Sentinel
  • Lua scripting, Pub/Sub, Streams supported

Backups & Point-in-Time Recovery (PITR)

Automated Backups

  • Daily full backup — Configurable window (default 03:00 UTC)
  • Continuous WAL archiving — PostgreSQL/MySQL
  • RDB snapshots — Redis (configurable frequency)

Point-in-Time Recovery (PITR)

Restore to any second within retention window:

# Restore to specific timestamp
fugoku databases restore prod-pg \
  --pitr "2024-01-15T14:30:00Z" \
  --name prod-pg-restored

# Restore to latest
fugoku databases restore prod-pg --latest --name prod-pg-restored

Retention: 7-35 days (configurable per database)

Manual Snapshots

# Create manual snapshot
fugoku databases snapshot prod-pg --name before-migration

# List snapshots
fugoku databases snapshots prod-pg

# Restore from snapshot
fugoku databases restore prod-pg --snapshot snap-abc123 --name prod-pg-restored

Connection & Security

Connection Details

# Get connection info
fugoku databases get prod-pg

# Output:
# Host: prod-pg.ashburn-1.fugoku.cloud
# Port: 5432
# Database: fugoku
# User: fugoku
# Password: (shown once, or reset)
# TLS: Required (cert provided)

SSL/TLS

  • TLS 1.2+ required for all connections
  • Server certificate provided for verification
  • Client certificates optional (mutual TLS)

Access Control

  • Private network only — Databases only accessible from attached VPC
  • Security groups — Firewall rules per database
  • IAM authentication — Optional, integrate with your IdP
  • Database users — Create via console/CLI/API
# Create database user
fugoku databases user create prod-pg \
  --username app_user \
  --password auto-generate \
  --permissions read_write

Encryption

  • At rest: AES-256 (default), customer-managed keys (CMK) available
  • In transit: TLS 1.2+ (enforced)
  • Backup encryption: Separate keys, same standards

Monitoring & Metrics

Key Metrics

MetricPostgreSQLMySQLRedis
CPU utilization✓✓✓
Memory usage✓✓✓
Disk usage✓✓✓
Connections✓✓✓
Query latency (p50/p95/p99)✓✓✓
Cache hit ratio✓✓✓
Replication lag✓✓✓
Cache evictions——✓

View Metrics

Console: Database detail → Metrics tab

CLI:

fugoku databases metrics prod-pg --period 1h

Set Up Alerts

fugoku alerts create \
  --database prod-pg \
  --metric cpu \
  --threshold 80 \
  --duration 5m \
  --notify email:ops@yourcompany.com

fugoku alerts create \
  --database prod-pg \
  --metric connections \
  --threshold 80 \
  --duration 5m \
  --notify email:ops@yourcompany.com

Maintenance & Patching

Automated Patching

  • Minor versions — Auto-applied in maintenance window
  • Major versions — Opt-in, scheduled
  • Maintenance window — Configurable (default: Sun 03:00-05:00 UTC)
  • Notifications — 7 days advance notice for major upgrades

Manual Maintenance

# Trigger minor upgrade
fugoku databases upgrade prod-pg --version 16.2

# Schedule maintenance window
fugoku databases schedule-maintenance prod-pg \
  --day sunday \
  --time 04:00 \
  --duration 2h

Import / Export

Import Data

# From SQL dump
fugoku databases import prod-pg --file dump.sql

# From another Fugoku database
fugoku databases clone prod-pg --name prod-pg-clone

Export Data

# To SQL dump
fugoku databases export prod-pg --format sql --output dump.sql

# To CSV (specific table)
fugoku databases export prod-pg --table users --format csv --output users.csv

Compliance & Security

StandardPostgreSQLMySQLRedis
SOC 2 Type II✓✓✓
HIPAA✓ (BAA)✓ (BAA)✓ (BAA)
GDPR✓✓✓
PCI DSS✓✓✓
Encryption at restAES-256AES-256AES-256
TLS in transit1.2+1.2+1.2+
Customer-managed keys✓✓✓

Audit Logging

All administrative actions logged:

  • Database create/delete/modify
  • User create/delete/permission changes
  • Backup/restore operations
  • Configuration changes
  • Access via console: Audit Logs page

Migration

From Self-Hosted

# 1. Create target database on Fugoku
fugoku databases create --name prod-pg --engine postgresql --version 16 ...

# 2. Dump source
pg_dump -h source-host -U postgres -d mydb > dump.sql

# 3. Import to Fugoku
fugoku databases import prod-pg --file dump.sql

# 4. Update DNS / connection strings

From Other Cloud

  • AWS RDS → Use pg_dump/mysqldump + import
  • Google Cloud SQL → Use Cloud SQL export + import
  • Azure Database → Use Azure export + import

Troubleshooting

IssueResolution
High CPUCheck slow queries, add indexes, consider read replica
High memoryCheck work_mem, shared_buffers, connection count
Slow queriesEnable pg_stat_statements, analyze with EXPLAIN ANALYZE
Replication lagCheck network, reduce write load, check standby resources
Connection refusedCheck VPC attachment, security groups, DNS
Backup failedCheck disk space, WAL archiving, retention settings

CLI Reference

# Create
fugoku databases create --name &lt;name&gt; --engine &lt;pg|mysql|redis&gt; --version &lt;v&gt; --plan &lt;plan&gt; --region &lt;region&gt; --network &lt;network&gt;

# List
fugoku databases list

# Get
fugoku databases get &lt;name&gt;

# Update
fugoku databases update &lt;name&gt; --plan &lt;new-plan&gt;

# Delete
fugoku databases delete &lt;name&gt; --confirm

# HA
fugoku databases enable-ha &lt;name&gt;
fugoku databases disable-ha &lt;name&gt;

# Replicas
fugoku databases create-replica &lt;name&gt; --name &lt;replica-name&gt; --plan &lt;plan&gt;
fugoku databases promote-replica &lt;replica-name&gt;

# Backups
fugoku databases snapshot &lt;name&gt; --name <snapshot-name>
fugoku databases restore &lt;name&gt; --pitr <timestamp> --name <new-name>
fugoku databases enable-backups &lt;name&gt; --schedule daily --retention 14

# Users
fugoku databases user create <db-name> --username <user> --password auto
fugoku databases user delete <db-name> <username>

# Metrics
fugoku databases metrics &lt;name&gt; --period 1h

# Import/Export
fugoku databases import &lt;name&gt; --file dump.sql
fugoku databases export &lt;name&gt; --format sql --output dump.sql

Getting Help

Next Steps:

On this page

Managed DatabasesSupported EnginesCreating a DatabaseConsoleCLIAPIPlans & PricingPostgreSQL / MySQL PlansRedis PlansHigh Availability (PostgreSQL/MySQL)Read Replicas (PostgreSQL/MySQL)Redis Cluster ModeBackups & Point-in-Time Recovery (PITR)Automated BackupsPoint-in-Time Recovery (PITR)Manual SnapshotsConnection & SecurityConnection DetailsSSL/TLSAccess ControlEncryptionMonitoring & MetricsKey MetricsView MetricsSet Up AlertsMaintenance & PatchingAutomated PatchingManual MaintenanceImport / ExportImport DataExport DataCompliance & SecurityAudit LoggingMigrationFrom Self-HostedFrom Other CloudTroubleshootingCLI ReferenceGetting Help