Architecture Center
Deploy and Run Redash on Alibaba Cloud

Deploy and Run Redash on Alibaba Cloud

Overview
Redash is designed to enable anyone, regardless of the level of technical sophistication, to harness the power of data big and small. SQL users leverage Redash to explore, query, visualize, and share data from any data sources. Their work in turn enables anybody in their organization to use the data. Every day, millions of users at thousands of organizations around the world use Redash to develop insights and make data-driven decisions.
This solution deploys Redash with Docker on Ubuntu on Alibaba Cloud ECS to enhance the high availability of Alibaba Cloud database family.
Reference Architecture
Steps
Deploy Resources
Use this main.tf file in Terraform to provision ECS and other resources from this solution.
Note: This solution uses RDS PostgreSQL as example data source for Redash, so ECS and RDS PostgreSQL instances are included in the Terraform script.
Use the correct Image ID of WordPress image on the corresponding region.
Set Up Redash on ECS
1 Run the following command to log on to ECS.
ssh root@ECS_EIP
2 Run the following command to setup Redash.
mkdir /opt/redash
wget https://raw.githubusercontent.com/getredash/setup/master/setup.sh
sh setup.sh
3 After the setup is completed, visit the following URL in a web browser to initialize Redash.
http://ECS_EIP
Connect to RDS PostgreSQL
1 On the Redash main page, click "Connect a data source"" to add RDS PostgreSQL as a source database.
2 Input the RDS PostgreSQL instance connection string.
3 Create Query, Dashboard or work with other BI features on Redash.
Connect Redash to other databases on Alibaba Cloud
For ApsaraDB RDS for MySQL, refer to https://redash.io/data-sources/mysql
For ApsaraDB RDS for PostgreSQL, refer to: https://redash.io/data-sources/postgresql
For ApsaraDB RDS for SQL Server, refer to: https://redash.io/data-sources/microsoft-sql-server
For PolarDB for MySQL, refer to: https://redash.io/data-sources/mysql
For PolarDB for PostgreSQL, refer to reference: https://redash.io/data-sources/postgresql
For PolarDB for Oracle, connection URI reference: https://redash.io/data-sources/postgresql
For ApsaraDB for MongoDB, refer to: https://redash.io/data-sources/mongodb
For AnalyticDB for MySQL, refer to: https://redash.io/data-sources/mysql
For AnalyticDB PostgreSQL, refer to: https://redash.io/data-sources/greenplum
For ApsaraDB for ClickHouse, refer to: https://redash.io/data-sources/clickhouse

Reach Alibaba Cloud experts for support

Contact Us