Failed to add mysql db as pool

[Feilong Wang]

When adding pool with mysql database, user will run into 400 error, and below error message. Though the connection uri is correct.

{
"title":"Invalid request body",
"description":"cannot connect to mysql://root:passw8rd@localhost"
}

[peng fei wang (wpf)]

if mysql = xxx mapping in setup.cfg which like sqlite is not the best way, then we need to map sqlite & mysql to sqlalchemy in code level

[Kurt Griffiths (kgriffs)]

We need to decide if fixing this is worth the effort right now. I'd like to propose the following:

1. Decouple pool management from data storage (two separate drivers)
2. Keep pool management driver for sqla, but drop the sqla data storage driver.

[Feilong Wang (flwang)]

I'm setting this as 'Won't Fix', since the sql driver for pool node will be disabled. see https://blueprints.launchpad.net/marconi/+spec/disable-sqlalchemy-as-pool