Easy Access to WSO2's Online Resources During COVID-19 Lockdown.   Read More

WSO2 unveils its Relational Storage Solutions via WSO2 StratosLive

Archived Content
This article is provided for historical perspective only, and may not reflect current conditions. Please refer to relevant product page for more up-to-date product information and resources.
  • By Prabath Abeysekara
  • 20 Sep, 2011


Businesses around the globe increasingly adapt the cloud as it offers highly-scalable, agile, flexible service offerings at low capital, operational and maintenance costs. Customer attraction towards cloud services is one of the key driving forces for vendors who provide Cloud-based services. Among such vendors, WSO2 is a strong competitor in the cloud space, recently introducing WSO2 StratosLive, the most complete and innovative open PaaS (Platform as a Service). WSO2 StratosLive comes as various services and represents its own unique products stack comprising ESB-as-a-Service, Data-as-a-Service, etc, which are completely built upon WSO2 Carbon, the comprehensive enterprise middleware platform introduced by WSO2.

Applies To

StratosLive 1.5.1 

WSO2 Relational Storage Service

Almost all applications, irrespective of whether they are run on the cloud or as a piece of standalone application, have got the requirement of storing and manipulating data associated with their numerous operations. That triggers the need to have a proper storage solution, which caters for all such data-related requirements of applications. Although there is a diverse set of options available for standalone applications to be used locally to store data, not many options provide such storage capabilities and easy access to stored data in the cloud space. WSO2 Relational Storage Service (RSS) which comes as part of StratosLive, is capable of fulfilling all such data-related requirements of applications running on the cloud. 
Let’s take a detailed look at WSO2 RSS and its offerings.
Delving into the storage solutions offered by WSO2 RSS gives you full control over your data storage space absolutely free of charge, by allowing you to create and manage your data storage space via an easy-to-use user interface. The users are given the capability to make their choice from the two options mentioned below.
1. Create and manage their data storage space within WSO2 RSS.
2. Add user-defined RDS instances and manage them using WSO2 Data-as-a-Service user interface.
WSO2 RSS is implemented based on Amazon Relational Data Storage (RDS) System. Therefore, it inherits all the benefits offered by the Amazon RDS, which is an added advantage.

Creating and managing your databases within WSO2 RSS

Now, let's look at how we can create a database and perform related tasks such as creating database users and assigning them to databases, creating carbon datasources and dataservices using those databases, etc. 

Step 1: Creating your database within the WSO2 RSS. 

The first step in the process of consuming WSO2 Relational Storage Service is to create a database for your application in the WSO2 RSS storage space. As the figure below depicts, the WSO2_RSS option together with the set of your own RDS instances that are configured to be used to manipulate your application data, will be listed out in the select box which carries the label "Database Server Instance Name". There you can either use WSO2 Relational Storage Service or your own RDS instances to create and consume your database. Once you select your preferred storage solution, you can then proceed with the creation of your database. The user is given the ability to specify a preferred name for the database under "Database Name". Once you click on the create button after fulfilling the aforementioned requirements, you will be able to create the database of your own choice to store the application data manipulated within your own domain.

Figure 1.a

Once you're done with creating the database, it will be listed out in the page titled "Databases" as shown in the figure below. One important thing to note here is that, you will be given a jdbc url upon the successful creation of the database to be used in any data manipulative tasks which are carried out under your domain such as creating datasources, creating dataservices, composing webapps to manipulate data, etc. In addition to that, the users are given the ability to obtain total control over the created database so that they are able to add database users or drop their databases once their tasks are over. Those administrative actions that are allowed to perform upon a particular database are listed under the section named "Actions".

Figure 1.b 

Having created a database, let's delve into how you can create database users and assign them to the database created in the firstmost step of the process. 

Before we create such database users upon a particular database, we introduce the concept of database privilege groups which allow you to create a group of database privileges that are intended to grant a particular database user and then reuse that group of privileges to create users which would considerably reduce the time associated with that task. It is interesting to explore how we can create such privilege groups before we move towards our main task of creating database users.

Step 2: Creating permission templates to be assigned to database users.

In this step, the users are given contorol over coming up with their own permission schemes that will be granted to their database users later. As the figure below shows, it's simply a matter of selecting the permission just by clicking on the check boxes associated with a particular database permission which helps you avoid tedious tasks such as writing lengthy SQL queries and executing them to grant database privileges for a particular database user.

Figure 2.a 

Once you are done creating a privilege group, it will be listed out in the page titled "Database user privilege groups" as shown in figure below.

Figure 2.b

After creating privilege groups, then use them in creating database users. This is discussed in step 3.

Step 3: Creating database users and attaching them to the created database.

The "Add new user" user interface allows you to specify a name and a password of your choice for a particular user. It also lists down the prvilege groups that you created under step 1 so that you can select the appropriate permission scheme which is intended to grant the database user. Once you successfully fulfill the above requirements and click the save button which can be located at the bottom of the image, a database user will be created to be used in the data manipulative tasks carried out in your tenant domain.

Figure 3.a

At the successful completion of the aforementioned task, you will be able to observe the database user that you've just created in the "Database Users" page as depicted in the figure below. Now you can use this user to carryout various database related tasks such as exploring the databases and configuring it with using your own schemas, creating carbon datasources to be used in the process of creating dataservices, etc.

Figure 3.b

Step 4: Configuring your database with your own schemas and more.

Having successfully created a database and attached a database user, you now need to configure your database so that it suits your own requirements. This task is also made quite simple with the database explorer that we've integrated into the database management user interface by which you can execute your desired SQL schemas to configure the database the way you prefer. To get you redirected to the database explorer, click on the "Explore Database" option listed under the "Actions" category in the "Database Users" page.

Figure 4.a

Next, you can execute your SQL scrips in the console given to you by the database explorer page and configure your database as discribed earlier.

Figure 4.b

Although we're almost done with our task, let us now discuss a couple of other enticing functionalities offered to you via the management console of the WSO2 Relational Storage Service.

Step 5: Creating carbon datasources pointing your databases. 

Carbon Datasources play a vital role in carbon as it provides means to reuse relational database connections in various data manipulative tasks carried out across the platform. Thus, the create datasource option offered as an administrative action can be a handy feature whenever a user wishes to create such a carbon datasource out of the database which we've created in the earlier steps. Just clicking on the "Create Datasource" will get this task done for you in a matter of seconds.

Figure 5.a

Now, you can observe the entry corresponding to the carbon datasource created in the previous step if you browse the Data Sources option which comes under the Configure menu of the management user interface as shown below.

Figure 5.b

The "Generate" data service option that comes as a part of WSO2 Data Services Server can now be used to create a dataservice upon the datasource created in the previous step and deploy in absolutely no time. As it is shown in figure below, you can select the desired datasource out of the listed data sources, the appropriate database name that is given to you at the completion of creating a database and proceed with creating a dataservice and eventually deploy it.

Step 6: Creating data services using those created carbon datasources.

Figure 6.a


Adding user-defined RDS instances and managing them using WSO2 Data Services Server user interface

WSO2 Relational Storage Service not only gives you the ability to use the storage space offered to you by the service itself, but also offers you the ability to use your own RDS instances to be used in your data manipulative activities. Let's investigate how to achieve that functionality via the user interface of the WSO2 Data Services Server.

Step 1: Add your own RDS instances.

In order to add your own RDS instances to the system, you can simply use the "Database Server Instance" option which can be loacated under the "Configure" menu of the management console. You can fill up the fields depenending on your preference and add your RDS instance to the system to be used as a data store for the applications running under your tenant domain.

 Figure 1

Step 2: Create your database within the user-defined RDS instance instead of using WSO2 RSS.

Once you're done adding your own RDS instance to the system, the rest of the process of creating databases and managing them is as same as described in step 1 of the previous category.

Figure 2

This way you can select your preferred data storage solution and continue experiencing the awesome set of functionalities provided by StratosLive, the most complete PaaS offered by WSO2. Try WSO2 StratosLive NOW!



Prabath Abeysekara, Software Engineer, WSO2 Inc.



About Author

  • Prabath Abeysekara
  • Technical Lead
  • WSO2