Question: Does Clair support Mysql database?

[coolljt0725]

In our scenario, other services use Mysql as backend database. Does
Clair support Mysql? If so, there is no need to deploy another database
for us.

[Quentin-M]

Hi,

MySQL hasn't been tested explicitly on Cayley (and thus on Clair).

The new database implementation on which I am working on uses PostgreSQL and will provide a huge performance boost and many features as well as caveats fixes compared to the current implementation.

Le 12 janv. 2016 à 06:22, Lei Jitang notifications@github.com a écrit :

In our scenario, other services use Mysql as backend database Does
Clair support Mysql? If so, there is no need to deploy another database
for us

—
Reply to this email directly or view it on GitHub.

[jzelinskie]

Rather than does clair support MySQL, allow me to answer the question will clair eventually support MySQL. There is going to be a new database implementation that uses database/sql and postgres that will be far more performant. Once that is in place, we will be open to accepting PRs that add MySQL support, but it is not a priority for us to work on. However, this will likely be nontrivial because the postgres implementation takes advantage of a couple of features that do not exist in MySQL in order to get decent performance.

[coolljt0725]

@jzelinskie

There is going to be a new database implementation that uses database/sql and postgres that will be far more performant

when does this in place? is the PR comming?

[Quentin-M]

@coolljt0725 We are really far in the development already. We are currently writing the new API and starting to run benchmarks on the official Docker images. I will push a branch to this repository as soon as the API will be mostly written. I'd say that the ETA is few weeks.

For now, it sits at https://github.com/Quentin-M/clair/tree/sql.

[coolljt0725]

@Quentin-M Thank you :)