Database Clusters

At the core of the CredVault Data Platform is our globally distributed, multi-model database engine allowing both Document-oriented (NoSQL) and Relational (SQL) operations on the same data.

Cluster Architecture

When you create a Database Cluster in CredVault, you instantly receive a highly available, replicated data store.

• Primary Node: Handles all write operations and guarantees strict consistency.
• Replica Nodes: Automatically scaled read-replicas that serve data globally to minimize latency.
• Automated Failover: If a primary node goes down, a replica is promoted instantly within milliseconds, ensuring zero downtime.

Data Querying (MQL & SQL)

CredVault pioneered Hybrid Querying, letting you use the right tool for the job.

Document MQL (MongoDB-Compatible)

Use flexible, JSON-like MQL for rapidly changing schemas and nested object storage.

// Example: Find active users in London
db.collection('users').find({ active: true, 'address.city': 'London' })

Advanced SQL Engine

Need to perform complex aggregations, joins across collections, or connect standard BI tools? Drop right into our powerful LakeVault SQL Engine.

-- Example: Join users and orders
SELECT users.name, SUM(orders.total) 
FROM users 
JOIN orders ON users._id = orders.user_id 
GROUP BY users.name

Indexing & Performance

CredVault automatically optimizes your queries, but provides absolute manual control when you need it:

• Compound Indexes: Speed up complex queries spanning multiple fields.
• Unique Indexes: Guarantee business logic constraints at the database level.
• Vector Indexes: Store and search High-Dimensional embeddings for AI workloads.

Backups & Point-in-Time Recovery

Every cluster includes automated, continuous backups.

• Daily Snapshots: Stored securely across regions.
• Point-in-Time Recovery (PITR): Accidentally dropped a collection? Rewind your database to the exact millisecond before the mistake occurred.