Getting started with DBaaS from the Web interface
Pukki DBaaS is in closed beta. This means that the service is probably not suitable for most users and there might be breaking changes. If you are still interested in using the service you can contact us to see if the service would be suitable for you.
You can log into DBaaS by going to pukki.dbaas.csc.fi.
Creating a new database instance
In the column on the left hand side you can go to
Instances and then press on the
Launch Instance that can be found on your right hand side.
Now you can define what settings you want for your database:
Instance name- What ever you want to name the instance.
Volume size- How much disk space you will need for your database. If you just want to test the DBaaS then 1 GiB is probably enough. To increase the disk size later, downtime is required for the database. If you already know how much data you will use then it is easy to estimate how large volume you need.
Volume type- This can be left empty.
Datastore- What type of database you want. It is recommend to use the latest version of your preferred database, if you don't have a specific reason for using an older version. PostgreSQL is the only available database at the moment.
Flavor- How large database instances you want. For small use cases the
standard.smallis probably enough. If you later find out that it is not large enough you can always change it later. Changing flavor will require downtime.
Locality- Is not needed. In the future DBaaS will support clustered databases and at that point anti-affinity should be the preferred option in most cases.
On the next page
Allowed CIDRs- Here you want to add your allowed IP-addresses in the format
$IP/32if you want to allow multiple IP-addresses. You need to separate them by a comma
,. By default the database are created without any
Allowed CIDRswhich means that you won't be able to connect to your database.
On the third page `Intialize Databases:
- In the
Initial Databasesfield you can write what databases should be initialized. You can add additional database after the instance have started.
Initial Admin Useradding first user that you want to use to connect to the database. You can add more user accounts after the database instance have started.
Passwordfor the you first user. Please make sure that this password is not used anywhere else.
Allowed Host (optional), this feature is not supported at the moment but in the future it will possible to limit users access based on IP.
On the fourth page
- You don't need to do anything but it is possible to launch a new database from a backup. If you choose to launch a database from a backup you don't need to specify
Initial Admin User,
- Now you can press
- Once the database instance has launched, you can click the name of the database instance and manage additional items, such as users, backups etc. But it might take a couple minutes before the instance is up and running.
Now you can go to the database specific documentation to find out further instructions on how to use the database:
Modify user accounts in the database instance
You can add, remove and modify users from the users tab of the database instances view. You need to make sure that you use strong passwords for each and every user.
Add and remove databases
You can add and remove databases from the
Database tab of the database instances.