Relational DB Logo

While leveraging a cloud service provider (CSP) to run a dev/test environment is nothing new, it’s probably easier now than ever before to make it happen. Lots of companies (large, medium, or small) leverage the flexibility and scalability of the cloud to run these environments. From a development perspective, the advantages of cloud dev/test make the proposition an attractive one to consider:

  • spin-up environments quickly
  • access on demand
  • take a snapshot
  • re-create a bug
  • implement changes
  • test run the entire stack
  • compare the outcome against the original snapshot
  • increased control over projects
  • ease of collaboration

In short, an agile development environment in the cloud allows developers to scale lab infrastructure rapidly. Cloud testing provides a safe and simple way to help transition a database through the application development process while shifting all of the costs from CapEx to OpEx.

Relational DB

CenturyLink’s Relational DB is a MySQL-compatible Database-as-a-Service product that can be leveraged in test and dev environments to help with speed and agility. Part of the value of Relational DB is that the developer can quickly spin up a database instance to support their application development needs without having to worry about the compute layer or database configuration details. Once a developer has their application running as they like in their dev environment, they can easily move their database into production with additional resource and availability configurations simply by leveraging the service's backup and restore capabilities. Once an application is in production, users can similarly pull back production data into a test database quickly and easily to support regular testing needs.

High Availability Larger application development environments may require more high availability. Relational DB offers in-data center replication with auto-failover. When purchased, a secondary instance is provisioned on a different host in the same data center. Data is replicated from the primary instance to the secondary instance in real-time and the service monitors the health of the primary database instance. If the primary instance is unavailable, we will fail over to the secondary instance.

This tutorial walks you through how to provision a MySQL-compatible database instance on CenturyLink Cloud and then move that data to a new production database instance using backup and restore functionality.

Tools Used

CenturyLink Cloud Relational Database supporting rapid software delivery needs by providing instant access to a high performance, enterprise-hardened MySQL-compatible Relational DB Service instance built on our Hyperscale platform with 100% flash storage.

Control Portal is our intuitive management interface that reduces the time required to administer cloud environments. Self-service functionality enables you to set up environments, add, modify, or remove capacity at will. Note: You can also use API calls to manage your dev/test environments.

Before We Start

If you don’t have a CenturyLink Cloud account yet, head over to our website and sign up for a free trial. You’ll need it to access our Relational Database service. In addition, you can get a free 30-day trial of Relational Database specifically that gives you 1vCPU, 1 GB RAM, and 1 GB Storage.

Deploy Your Dev Database Using CenturyLink’s Relational DB

  1. Log-in to the Control Portal.
  2. From the Navigation Menu, click Services > Relational DB. Navigation menu
  3. On the Database Instances page, click database.
  4. Select a Location from the drop-down menu. Enter an Name for the database, a Username, and a Password.
  5. Identify the CPU, Memory, and Storage resources. Resources
  6. Enable the Options you want for your MySQL Database.
    • Notifications (email alerts for CPU and Storage percentage limits reached)
    • Replication (for high availability)
    • Customizable Backup Schedule
    • Backup Retention Length Options
  7. Click Create Database.
  8. The database information is returned containing your connection string, which you need to administer your MySQL instance using the CLI or from your favorite MySQL client. You can also download your certificate. Relational DB Information
  9. You are now ready to upload your data and begin using your environment.

Move Your Development Database to Production

  1. Log-in to the Control Portal as above.
  2. From the Navigation Menu, click Services > Relational DB.
  3. Follow the steps in the section above to create your new Production Database with the resources and availability required.
  4. Navigate back to the list of databases. Identify your Dev Database instance and select it.
  5. From the details page, create a new backup by clicking backup.
  6. Navigate to your new Production Database instance and select it.
  7. From the details page, click restore.
  8. In the Restore From drop-down, find your Dev Database instance and select it.
  9. In the Backup drop-down, find the backup you just made and select it.
  10. Click restore.
  11. It's that easy! You now have a production database instance that is an exact replica of your development environment.

Next Steps

We provide all the tools and functionality developers love, from a robust open Platform-as-a-Service (PaaS) to dev/test environments that spin up and tear down quickly. Check out our products and services. We’ve designed them to abstract the complexity of enterprise development away, so it’s easier for you to accelerate innovation for your apps.

Sign-up for our Developer-focused newsletter CODE. Designed hands-on by developers, for developers. Keep up-to-date on topics of interest: tutorials, tips and tricks, and community building events.