Create your first Database

Once the Control Plane is deployed, projects and databases can be created.

Check out

For more information on the available services, see REST API reference.

Create Project

Create a new project messaging in organization acme:

nuodb-cp project create acme/messaging \
  --sla "dev" \
  --tier n0.small
curl -X PUT -H 'Content-Type: application/json' \
    $NUODB_CP_URL_BASE/projects/acme/messaging \
    -d '{"sla": "dev", "tier": "n0.small"}'
resource "nuodbaas_project" "proj" {
  organization = "acme"
  name         = "messaging"
  sla          = "dev"
  tier         = "n0.small"
}

Note

Creating project and database with n0.small service tier requires 3 vCPUs and 5Gi of RAM. If your environment is resource constrained, consider using the n0.nano service tier.

Create database

Create a new database demo in the messaging project.

nuodb-cp database create acme/messaging/demo \
  --dba-password changeIt
curl -X PUT -H 'Content-Type: application/json' \
    $NUODB_CP_URL_BASE/databases/acme/messaging/demo \
    -d '{"dbaPassword": "changeIt"}'
resource "nuodbaas_database" "db" {
  organization = nuodbaas_project.proj.organization
  project      = nuodbaas_project.proj.name
  name         = "demo"
  dba_password = "changeIt"
}

Wait for the database to become available.

while [ "$(nuodb-cp database get acme/messaging/demo | jq -r '.status.ready')" != "true" ]; do
  echo "Waiting ..."
  sleep 5
done
echo "Database is available"
while [ "$(curl $NUODB_CP_URL_BASE/databases/acme/messaging/demo | jq '.status.ready')" != "true" ]; do
  echo "Waiting ..."
  sleep 5
done
echo "Database is available"
Terraform waits until all resources are available before reporting a success.
Prev
Connect to NuoDB Control Plane
Next
Connect to the Database