Skip to main content

Managed Databases

Lineserve's Managed Database service provides fully managed MySQL, PostgreSQL, and Redis instances with automated backups, monitoring, and high availability.

Overview​

Our managed database service takes the complexity out of database administration. We handle maintenance, backups, security updates, and monitoring, so you can focus on building your applications. All databases run on high-performance SSD storage with automatic failover and point-in-time recovery.

Supported Database Engines​

MySQL​

  • Versions: 5.7, 8.0
  • Use Cases: Web applications, e-commerce, content management
  • Features: InnoDB storage, full-text search, JSON support

PostgreSQL​

  • Versions: 12, 13, 14, 15
  • Use Cases: Analytics, geospatial applications, complex queries
  • Features: Advanced indexing, JSON/JSONB, full-text search

Redis​

  • Versions: 6.2, 7.0
  • Use Cases: Caching, session storage, real-time analytics
  • Features: In-memory storage, pub/sub, data structures

Key Features​

  • Automated Backups: Daily backups with 30-day retention
  • Point-in-time Recovery: Restore to any point within backup retention
  • High Availability: Multi-zone deployment with automatic failover
  • Monitoring & Alerts: Real-time performance monitoring
  • Security: Encrypted connections, VPC isolation, firewall rules
  • Scaling: Vertical and horizontal scaling options
  • Maintenance Windows: Automated updates during scheduled windows
  • Connection Pooling: Built-in connection pooling for better performance

Database Plans​

Starter Database​

  • CPU: 1 vCPU
  • RAM: 1GB
  • Storage: 20GB SSD
  • Connections: 100
  • Price: Starting at $15/month

Professional Database​

  • CPU: 2 vCPU
  • RAM: 4GB
  • Storage: 100GB SSD
  • Connections: 500
  • Price: Starting at $50/month

Business Database​

  • CPU: 4 vCPU
  • RAM: 8GB
  • Storage: 250GB SSD
  • Connections: 1000
  • Price: Starting at $120/month

Enterprise Database​

  • CPU: 8 vCPU
  • RAM: 16GB
  • Storage: 500GB SSD
  • Connections: 2000
  • Price: Starting at $250/month

Getting Started​

  1. Choose Database Engine: Select MySQL, PostgreSQL, or Redis
  2. Select Plan: Choose the configuration that fits your needs
  3. Configure Settings: Set database name, username, and password
  4. Deploy Database: Your database will be ready in 2-3 minutes
  5. Connect: Use the provided connection string to connect your application

Connection Examples​

MySQL Connection​

const mysql = require('mysql2');

const connection = mysql.createConnection({
  host: 'mysql-cluster-id.lineserve.com',
  port: 3306,
  user: 'your_username',
  password: 'your_password',
  database: 'your_database',
  ssl: { rejectUnauthorized: false }
});

PostgreSQL Connection​

const { Client } = require('pg');

const client = new Client({
  host: 'postgres-cluster-id.lineserve.com',
  port: 5432,
  user: 'your_username',
  password: 'your_password',
  database: 'your_database',
  ssl: { rejectUnauthorized: false }
});

Redis Connection​

const redis = require('redis');

const client = redis.createClient({
  host: 'redis-cluster-id.lineserve.com',
  port: 6379,
  password: 'your_password'
});

Management Features​

  • Database Dashboard: Monitor performance and resource usage
  • Query Analytics: Identify slow queries and optimization opportunities
  • User Management: Create and manage database users and permissions
  • Backup Management: Schedule backups and manage retention policies
  • Scaling Options: Upgrade resources or add read replicas
  • Maintenance Scheduling: Control when updates are applied

Security Features​

  • VPC Isolation: Deploy databases in private networks
  • SSL/TLS Encryption: Encrypted connections by default
  • Firewall Rules: Control access with IP whitelisting
  • User Authentication: Strong password policies and user management
  • Audit Logging: Track database access and changes
  • Compliance: SOC 2, GDPR, and HIPAA compliance options

Next Steps​