MySQL as a Redash backend!


#1

Hi All,

I wanted to check can I use a MySQL database as a Redash backend?
I update .env file with the following database details -

export REDASH_DATABASE_URL=“mysql://user:pass@external-hive-metastore-dev.rds.amazonaws.com:3306/redash”

but my create_table command fails with the below error:

conn = _connect(dsn, connection_factory=connection_factory, async=async)
peewee.OperationalError: server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
could not send startup packet: Broken pipe

I am able to connect to same mysql using python command line:

ubuntu@ip-redash-server:~$ python
Python 2.7.6 (default, Jun 22 2015, 17:58:13) 
[GCC 4.8.2] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> from peewee import *
>>> from playhouse.db_url import connect
>>> db = connect('mysql://user:pass@external-hive-metastore-dev.rds.amazonaws.com:3306/redash')
>>> db
<peewee.MySQLDatabase object at 0x7fdc976b0350>
>>> db.get_conn()
<_mysql.connection open to 'dl-external-hive-metastore-dev.cenxa8za5mfg.us-east-1.rds.amazonaws.com' at 292a290>
>>> db.get_cursor()
<MySQLdb.cursors.Cursor object at 0x7fdc9769f6d0>
>>> 

Thanks,
Hussain Bohra


#2

Redash supports only PosgreSQL as a backend for its metadata (you can still use Redash to query MySQL and many other databases).


#3

Thank You Arik. Appreciate your quick reply.

Thanks,
Hussain Bohra