Database

Database Management

This section of our documentation explains database management or our DBaaS (Database as a Service) offering, and has details on creation, configuration, and maintenance of databases. Our service focuses on providing scalable, secure, and efficient database infrastructure, tailored to be highly performant.

You'll learn how to manage databases on the MyAccount portal or E2E Cloud. We provide fully-managed database services such as MySQL, PostgreSQL, Kafka, Valkey, MariaDB, and Cassandra, helping you set up, maintain, manage, and administer your databases seamlessly.

E2E DBaaS Features

Feature	MySQL	MariaDB	PostgreSQL	Cassandra	Valkey	Kafka
Fully Managed DBaaS	✓	✓	✓	✓	✓	✓
Relational Database	✓	✓	✓	✗	✗	✗
NoSQL Database	✗	✗	✗	✓	✓	✗
Event Streaming	✗	✗	✗	✗	✗	✓
High Scalability	✓	✓	✓	✓	✓	✓
Automatic Failover	✓	✓	✓	✓	✓	✓
Replication Support	✓	✓	✓	✓	✓	✓
In-Memory Storage	✗	✗	✗	✗	✓	✗
Supports Complex Queries	✓	✓	✓	✗	✗	✗
Data Partitioning	✗	✗	✗	✓	✗	✓
Multi-Datacenter Support	✗	✗	✗	✓	✗	✓
Read Replica Support	✓	✓	✓	✗	✗	✗
Snapshot & Backup Support	✓	✓	✓	✓	✗	✗

Key Benefits of using E2E DBaaS

MySQL
- Fully managed database service, eliminating the need for manual installation and maintenance.
- Supports high performance and scalability, making it ideal for web applications.
- Secure with firewall restrictions, ensuring that only authorized hosts can connect.
- Easy administration through the MyAccount portal with quick provisioning.
MariaDB
- Provides a seamless, fully managed experience with automated maintenance and backups.
- Offers high performance and scalability, making it suitable for WordPress and other CMS applications.
- Cost-efficient and easy to upgrade based on usage requirements.
- Reliable with automated failover and replication support.
PostgreSQL
- Highly extensible and supports complex SQL queries for advanced data management.
- Ensures data integrity and fault tolerance, making it reliable for enterprise applications.
- Can handle large and small datasets efficiently with built-in scalability.
- Fully managed DBaaS automates provisioning, patching, and maintenance tasks.
Cassandra
- Designed for high availability with no single point of failure, ensuring reliability.
- Scales horizontally without downtime, making it ideal for big data and global applications.
- Supports multi-datacenter replication for disaster recovery and high availability.
- Optimized for high write and read throughput, handling large volumes of data efficiently.
Valkey
- High-speed in-memory data storage ensures ultra-fast data access.
- Supports caching, message queues, and real-time analytics for performance optimization.
- Offers clustering and high availability for scalable applications.
- Supports various data structures, enhancing flexibility for different use cases.
Kafka
- Enables real-time data streaming and event-driven architectures.
- Highly scalable with partitioned logs for parallel processing.
- Fault-tolerant and durable, ensuring reliable data storage and delivery.
- Supports low-latency, high-throughput messaging, making it ideal for big data applications.