12 Days of #Cloud: Adding Storage to #DBaaS Node

12 Days of #Cloud: Day 7

There are three types of storage expansion possible on Oracle #DBaaS instance.

1. Increase Default File Systems

Increasing the default file systems that hold data files (/u02), FRA and backup (/u03) is easy.  These file systems can be increased by using the menu item “Scale Up / Down Service” and choosing the appropriate file system to extend. Below example shows extending the backup file system.

No other file systems can be increased easily. To increase a storage volume, you need to create a new volume, copy contents from old to new, and remove the old.

2. Creating New Storage Volume

In the above screen (Scale up / down Service), you can choose the first option of “Create New Storage Volume”. Specify a size in GB and click the confirm (Yes, Scale Up/Down Service) button.

The DBaaS Monitor Console (OS Storage) shows the storage is available on the node.

Also, view details in the Oracle Compute Cloud Services, Storage section.

#DBaaS service assigns the next available device and volume number.

File system is updated in /etc/fstab as well, so when VM is rebooted, the storage you just added is automatically mounted.

Notice that, though we added a new storage volume that has nothing to do with the running database, DBaaS service did take an outage on the environment and rebooted the node.

A note from Oracle documentation: Looks like an unnecessary limitation.

3. Attaching New Storage Volume from Compute Cloud

This is similar to #2, but more manual steps. Used Oracle documentation as a reference to do these steps.

Choose Oracle Compute Cloud Service and click on the “Create Storage Volume” button.

Pick a name and size for the storage volume, and the type of storage.

Once the storage volume is created, attach the storage to a DBaaS VM.

Choose the instance where the volume need to be attached to.

Storage is attached to the DBaaS host.

But the storage is not visible on the Linux VM as it is not mounted. Before mounting the storage, there are few steps to complete. The new storage added is /dev/xvdg.

A note from Oracle Documentation.