Documentation

Databases Overview

DanubeData provides fully managed database instances with MySQL, PostgreSQL, and MariaDB support.

What are Database Instances?

Database instances are managed database servers that provide:

  • Automated Setup: Deploy in minutes
  • Automated Backups: Daily backups with 7-day retention
  • High Availability: Read replicas and automatic failover
  • Monitoring: Real-time performance metrics
  • Security: Firewall integration and encryption

Supported Database Engines

MySQL

  • Versions: 8.0, 8.4
  • Use cases: Web applications, e-commerce, CMS
  • Features: InnoDB storage, full-text search, JSON support

PostgreSQL

  • Versions: 14, 15, 16, 17
  • Use cases: Analytics, complex queries, GIS applications
  • Features: JSONB, full-text search, PostGIS support

MariaDB

  • Versions: 10.6, 10.11, 11.0
  • Use cases: Drop-in MySQL replacement
  • Features: Improved performance, better replication

Key Features

📊 Performance Monitoring

  • Real-time CPU, memory, and disk metrics
  • Query performance tracking
  • Connection monitoring
  • Slow query logs

🔒 Security

  • Firewall protection
  • Private networking
  • Encrypted connections (TLS/SSL)
  • Encrypted backups

💾 Automated Backups

  • Daily automated backups
  • 7-day retention period
  • Point-in-time recovery
  • Manual snapshots

📈 Scalability

  • Read replicas for scaling reads
  • Vertical scaling (resize instances)
  • Connection pooling

⚙️ Customization

  • Custom parameter groups
  • Version selection
  • Storage configuration

Getting Started

Create a Database

  1. Navigate to Databases in the main menu
  2. Click Create Database Instance
  3. Select your database engine (MySQL, PostgreSQL, or MariaDB)
  4. Choose a version
  5. Select a resource profile
  6. Configure networking and security
  7. Click Create Database

Your database will be ready in 2-3 minutes!

Connect to Your Database

Once your database is running, you'll receive:

  • Hostname: The connection endpoint
  • Port: Database port (3306 for MySQL/MariaDB, 5432 for PostgreSQL)
  • Username: Database username
  • Password: Secure password (shown once)

Example Connection String:

mysql -h your-db-hostname -P 3306 -u admin -p

Resource Profiles

Profile vCPU RAM Storage Price/hour
Micro 1 1 GB 10 GB $0.010
Small 2 2 GB 25 GB $0.020
Medium 4 4 GB 50 GB $0.040
Large 8 8 GB 100 GB $0.080
XL 16 16 GB 200 GB $0.160

Read Replicas

Scale read operations by creating replicas:

  1. Go to your database instance page
  2. Click Replicas tab
  3. Click Add Replica
  4. Select a node and resource profile
  5. Click Create Replica

Benefits

  • Offload read queries from primary
  • Geographic distribution
  • Automatic synchronization
  • Promote to primary if needed

Backups & Recovery

Automated Backups

  • Performed daily automatically
  • 7-day retention
  • No performance impact
  • Stored securely

Manual Snapshots

  1. Go to your database page
  2. Click Snapshots tab
  3. Click Create Snapshot
  4. Enter a name
  5. Click Create

Restore from Backup

  1. Navigate to Snapshots
  2. Click Restore on a snapshot
  3. Choose to restore to existing or new instance

Parameter Groups

Customize database configuration:

  1. Navigate to Parameter Groups
  2. Click Create Parameter Group
  3. Select database engine and version
  4. Configure parameters
  5. Attach to your database instance

Monitoring

Track database performance:

Key Metrics

  • CPU Usage: Monitor compute resources
  • Memory Usage: Track RAM and buffer pool
  • Connections: Active and max connections
  • Queries per Second: Throughput
  • Disk I/O: Read/write operations
  • Replication Lag: For replicas

Alerts (Coming Soon)

Set up alerts for:

  • High CPU usage
  • Memory exhaustion
  • Connection limits
  • Replication lag

Best Practices

Performance

  1. Use appropriate indexes
  2. Optimize queries
  3. Configure buffer pool size
  4. Use connection pooling
  5. Monitor slow queries

Security

  1. Use strong passwords
  2. Enable firewalls
  3. Use private networks
  4. Restrict access by IP
  5. Enable SSL/TLS

Reliability

  1. Enable automated backups
  2. Take manual snapshots before major changes
  3. Test restore procedures
  4. Monitor replication lag
  5. Set up read replicas

Cost Optimization

  1. Right-size your instance
  2. Clean up old data
  3. Archive historical data
  4. Delete unused snapshots

Troubleshooting

High CPU Usage

  1. Identify slow queries
  2. Add missing indexes
  3. Optimize queries
  4. Consider upgrading instance

Connection Errors

  1. Check firewall rules
  2. Verify connection details
  3. Check max connections setting
  4. Review connection pool settings

Replication Lag

  1. Check network connectivity
  2. Review primary load
  3. Increase replica resources
  4. Optimize queries on primary

Next Steps

Need help? Contact our support team through the dashboard.