This article is intended to get your feet wet with SpinUp Databases.
This should take less than 5 minutes to complete. The end goal will be to have a database instance online and ready for you to import or create your data.
You’ll need to already have created a SpinUp account. If you haven’t created one yet, you can register for an account via our sign-up page.
Create your first database
Log in to your SpinUp account.
On the left navigation bar, click Databases.
Click + CREATE at the top of the page.
Enter the name of the database and select the appropriate region.
Select an appropriate datastore for your new database. SpinUp recommends using the newest datastore your application is compatible with.
Next, select the instance type. This determines whether you create a standalone instance, or an HA instance with built-in redundancy and automatic failover.
Select the amount of RAM and number of vCPUs your new Database will be configured with. This can be changed later, but it requires downtime for standalone instances, or a failover for HA instances.
Select the disk size your new Database will be configured with. Disk space can only increase later. Increasing your disk size does not incur downtime.
Review the information listed in the Summary panel.
After you have determined that the information is correct, click on SPINUP SINGLE INSTANCE or SPINUP HIGH AVAILABILITY GROUP as appropriate.
In the Cloud Database Details page, status will show build during the building process. Note that if you are building an HA instance, there are multiple members that have to be built, so it will take a bit longer.
After the Database has been built, the Status changes to green, and will show as active. If you built an HA instance, the individual members (source and any replicas) will be listed under INSTANCES towards the bottom of the details page.
SpinUp recommends turning on Weekly Backups, available from the DETAILS page after your instance build has completed. Once you turn on backups, enter the Name, Day of Week, Hour, and Minute you would like your Weekly Backup to begin. Full backups will run on this day, weekly, with subsequent days receiving an incremental backup.
Add databases and users
Navigate to the details page for your Database instance.
Towards the bottom of the details page, choose DATABASES.
Click ADD DATABASE.
Enter the details for your new database. Click + ADD. The database you created becomes visible in the list after a brief moment.
Click on ADD USER.
Enter the details for your new user and select which databases to grant the user access to. SpinUp recommends utilizing a password generator or manager to create sophisticated passwords that are more resistant to cracking. Click + ADD. The user you created becomes visible in the list after a brief moment.
Now that you have a database, Best Practices will help you get the knowledge you need to ensure your database is as optimized and secure as possible.
If you need to know how to perform a specific task, a list of those tasks is maintained in our How-To Articles section.
This article helped you SpinUp your database in under 5 minutes.