Using Superset to Obtain Data from MySQL Databases for Analysis

Application Scenario

Superset is an open-source data exploration and visualization platform. This tool provides a quick way to intuitively visualize datasets by allowing you to create and share interactive dashboards. Supported By FlexusL, the Superset application image uses Ubuntu 22.04 and is deployed using Docker. The Nginx, Redis, pgAdmin, and Docker have been preconfigured in the image. This section describes how to use Superset to obtain data from MySQL databases for analysis.

Resource Planning and Costs

This practice uses the following resource planning as an example. You can adjust it as required.

Procedure

Step 1: Purchase a FlexusL Instance

1. Log in to the FlexusLconsole and click Buy FlexusL.
2. Specify required parameters for the FlexusL instance.
   

   Parameter	Example	Description
   Region	CN-Hong Kong	For low network latency and quick resource access, select the region nearest to your target users. After a FlexusL instance is created, the region cannot be changed. Exercise caution when selecting a region.
   Application Images	Superset	Select the Superset application image.
   Instance Specifications	2 vCPUs | 8 GiB memory	Select instance specifications as needed.
   Instance Name	Superset-Example	Customize an instance name that is easy to identify, for example, Superset-Example.
   (Optional) Associated Services	Data disk: 10 GiB Host security Cloud backup vault: 170 GiB	You can bundle any of the services to your FlexusL instances as needed: EVS, HSS (basic edition), and CBR and set specifications as needed.
   Required Duration	1 month	The minimum duration of a purchase is one month and the maximum duration is three years. Auto-renew is enabled by default, which means the purchased FlexusL instances will be automatically renewed before they expire. If you do not enable auto-renew during the purchase process, you can still enable it later after the instances are created. For more information about auto-renewal rules, see Auto-Renewal Rules.
   Quantity	1	Set the number of FlexusL instances to be purchased.

3. Click Buy Now and complete the payment as prompted.
4. Go back to the FlexusL console and view the purchased FlexusL instance.
   

   After a FlexusL instance is created using an application image, wait until the image with the pre-installed application is up and running. Then, you can perform operations such as restarting or stopping the instance, or resetting the password. Otherwise, the installation may fail and you cannot log in to the image application dashboard.

Step 2: Configure Security Groups

Add inbound security group rules to ensure that the application preinstalled in the image can be accessed.

1. Log in to the FlexusL console and click a resource card to go to the instance details page.
2. In the navigation pane on the left, choose Cloud Servers. Locate the server and click its name.

   

3. On the Security Groups tab, click Add Rule. In the displayed dialog box, add rules displayed in the following figure and click OK.

   The following figure only displays common rules. You can add more rules as needed.

   Table 1 Security group rules

   Priority	Action	Type	Protocol & Port	Source	Description
   1	Allow	IPv4	TCP: 80	0.0.0.0/0	Specifies the internal forwarding port of application images
   1	Allow	IPv4	TCP: 3306	0.0.0.0/0	Allows access to MySQL databases.
   1	Allow	IPv4	TCP: 9000	0.0.0.0/0	Allows external access to the application O&M dashboard.
   1	Allow	IPv4	TCP: 9001	0.0.0.0/0	Allows external access to the application dashboard.

Step 3: Initialize Superset

The image application dashboard needs to be initialized only when you log in for the first time.

1. Obtain the administrator username and password for logging in to GitLab.
   1. In the address bar of a local browser, enter http://EIP:9000 to log in to the application O&M dashboard.

      The username and password for logging in to the dashboard are the root user and password of the FlexusL instance. A FlexusL instance does not have an initial password. Reset the password and use it to log in to the dashboard.

   2. Choose My Apps and click the App icon.
   3. Choose Access and click Initial Account to view the username and password of the administrator.

      

2. On the Overview page, click Access in the Dashboard field in the Image area.

   

   

   If the dashboard of WordPress cannot be accessed, it may be because the port for accessing the dashboard is not allowed or the application has not been up and running. To solve this problem, see Why Can't I Open the Dashboard of the Application Pre-installed in the Application Image?

3. Enter the username and password obtained in step 1 to access the management page.

   You can set the language on the login page or on the management page.

   

   

   If a message is displayed indicating that the username or password you entered is invalid when you attempt to log in to the application dashboard, refer to Why Can't I Access the Dashboard of the Application Pre-installed in the Application Image After Entering the Initial Username and Password?

4. In the upper right corner of the page, choose Settings > User > Info and click RESET MY PASSWORD.

   Preset passwords are usually difficult to remember, so you are advised to set a password that is easy to remember, and please keep it safe.

   

Then, you have obtained a Superset hosting server. You can start using Superset or follow the steps in Step 4: Obtain Data from MySQL Databases for Analysis to connect to a database, add datasets, and create charts.

Step 4: Obtain Data from MySQL Databases for Analysis

This section describes some basic operations of Superset. For more information, see Superset Documentation.