This is a small example on Migrating from MySQL DB to MongoDB.

DB name : blog

The above diagram shows the relationships among  tables on the database called blog. Now the task is to migrate MySQL to mongoDB . 

The above image is the structure of the blog database which is structured using mongoDB.

The custom userstore database's relationships among tables shown above.

Simple and in-complex Coustom userstore with the support of mongoDB will be delivered on or before April 30th.     

Learn more »

WSO2 identity servers are compatible with MySQL database. Today we are looking quick start guide for MySQL and how to use a MySQL database to run WSO2 identity servers.

step 1 : MySQL and PHPMyadmin installation

Step 2 : go to localhost/phpmyadmin

step 3 : create a database userstore

step 4 : Download WSO2 Identity Servers and Extract

step 5 : Download MySQL jdbc connector and Extract  after that
             mysql-connector-java-5.1.38-bin.jar move to wso2is-5.1.0/repository/components/lib

step 6 : wso2is database configuration edit wso2is-5.1.0/repository/conf/datasources/master-
             datasources.xml  (add this configuration)
         
        <datasource>
           <name>WSO2_CARBON_DB</name>
           <description>The datasource used for registry and user manager</description>
           <jndiConfig>
               <name>jdbc/WSO2CarbonDB</name>
           </jndiConfig>
           <definition type="RDBMS">
               <configuration>
                   <url>jdbc:mysql://localhost:3306/userstore</url>
                   <username>root</username>
                   <password>root</password>
                   <driverClassName>com.mysql.jdbc.Driver</driverClassName>
                   <maxActive>80</maxActive>
                   <maxWait>60000</maxWait>
                   <minIdle>5</minIdle>
                   <testOnBorrow>true</testOnBorrow>
                   <validationQuery>SELECT 1</validationQuery>
                   <validationInterval>30000</validationInterval>
               </configuration>
           </definition>
       </datasource>

step 7 : open your terminal and run wso2 IS
            cd wso2is-5.1.0/
            sh bin/wso2server.sh -Dsetup

step 8 : now check you MySQL DB

so finally your are configured.

Learn more »

Install apache, open terminal and type in these commands:
sudo apt-get update
sudo apt-get install apache2

Install MySQL, open terminal and type in these commands:
sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql

Install PHP, open terminal and type in this command.
sudo apt-get install php5 libapache2-mod-php5 php5-mcrypt

Install phpMyAdmin

sudo apt-get install phpmyadmin apache2-utils

After the installation has completed, add phpmyadmin to the apache configuration.

sudo nano /etc/apache2/apache2.conf

Add the phpmyadmin config to the file.

Include /etc/phpmyadmin/apache.conf

Restart apache:

sudo service apache2 restart

Set Up the .htaccess File
sudo nano /etc/phpmyadmin/apache.conf

<Directory /usr/share/phpmyadmin>
       Options FollowSymLinks
       DirectoryIndex index.php
          AllowOverride All
         [...]

Installation finished. go to your web browser
localhost              

 













localhost/phpmyadmin

successfully installed .

Learn more »

Description

WSO2 Identity Server out of the box supports LDAP, Microsoft Active Directory and Relational Databases as User Stores. With the fast growth of enterprise level NoSQL databases, it is important to support NoSQL user stores to improve the value that WSO2 Identity Server can deliver to enterprises in terms of user data management.

In order to support NoSQL, It is expected to customize or write a new User Store Manager that supports storing/retrieving data from NoSQL databases.

The database architecture has to be completely redesigned for optimizing the performance of operations. Initially, new document collections can be created for each database table referring the current relational database schema. Some of the document collections can be combined together as embedded documents or new data models should be created for performance improvement considering the following facts.  

- Document size considerations

- Complexity of data structures

- Data Consistency

The performance has to be further improved by creating appropriate indexes. 

Initially the project should be done on MongoDB 3.2  which is a Document based NoSQL database that is widely used . Test automation should be done appropriately as Unit Tests or Integration Tests for all the operations in the userstore manager. 

Based on completion, other Document based databases such as CouchDB, RavenDB can be considered for implementation.

Deliverables

• Database Architecture Diagrams
• Custom Userstore Manager
• Automated Tests
• Developer documentation
• Articles/blog posts on using the custom userstore manager

Skills Needed

• Java
• Database knowledge and SQL
• Understanding of NoSQL
• MongoDB 3.2
• Using MongoDB with Java 
• Test Automation (Junit, Selenium)

Reference : WSO2 GSoC Project Proposals

Learn more »