ObjectRocket CockroachDB on AWS Beta¶
We currently offer a hosted CockroachDB product, in Beta, on the new platform. The key features of the service are:
- 3 node HA clusters, single region
- Access to the CockroachDB admin UI
- IP whitelisting, user authentication, and TLS to secure the cluster
3 Node HA clusters¶
CockroachDB was created to be able to scale and provide high availability, so all instances on our service run in 3+ node clusters.
Though production workloads are in no way supported while we’re in Beta, you can still test HA on the platform. Failed/problematic nodes are automatically replaced by our Kubernetes-based platform, so we can ensure that your cluster is always up and available.
CockroachDB Admin UI¶
Baked into CockroachDB is an Admin UI that provides visibility into key metrics and the status of your CockroachDB cluster. We provide access to this UI for all CockroachDB users.
All external access to the cluster is blocked by default. To connect you must specify IPs and IP ranges that you will allow access to the cluster. This is accomplished during instance creation, or via the ACLs API endpoints
When you create a new cluster on our service, you’ll also need to create a user that can be used to connect to the database.
This user will have an admin-like role that can perform all of the functions of CockroachDB, except create databases. Creating and managing databases is performed via our API.
How to connect to my CockroachDB instance?¶
In order to connect to your PostgreSQL instance, there are a few steps:
- First you’ll create an instance either via our API or Mission control
- When the instance is ready, you’ll add ACLs for wherever you’re connecting from. This is your external IP address as viewed from our service.
- Create a CockroachDB admin user via our API or UI.
- Create a CockroachDB database via our API (UI support coming soon)
- On the instance details screens (or in the instance list API response), you should see a connection endpoint that looks something like
postgresql://<username>:<password>@ingress.w98sujpz.launchpad.objectrocket.cloud:<port>/. You’ll use that connection string in your client of choice while filling in the username and password you just created.
What is CockroachDB?¶
In the words of the developers, CockroachDB is a “cloud-native SQL database for building global, scalable cloud services that survive disasters.”
What this means to you is that you get a relational, ACID compliant datastore with a comfortable SQL interface and PostgreSQL wire compatibility, but with automatic HA, easy scalability, and geographic scaling.
While we’re in beta, we only support clusters in the same datacenter, but our roadmap includes all of the key features that CockroachDB has to offer.