Project

Profile

Help

Send by e-mail

Task #4270

Add support for MariaDB and MySQL

Added by bmbouter 10 months ago. Updated 6 months ago.

Status:
MODIFIED
Priority:
Normal
Assignee:
daviddavis
Category:
-
Sprint/Milestone:
3.0
Start date:
Due date:
% Done:

100%

Platform Release:
Blocks Release:
Backwards Incompatible:
No
Groomed:
No
Sprint Candidate:
No
Tags:
QA Contact:
Complexity:
Smash Test:
Verified:
No
Verification Required:
No
Sprint:
Sprint 50

Description

Given the recent discovery that we are benefitting from PostgreSQL-only Django features, we need to test against another SQL database to ensure we are compatible.

Related issues

Related to Pulp - Story #4517: As a user, I can install pulp with mysql or mariadb NEW Actions
Blocked by Pulp - Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length") MODIFIED Actions
Blocked by Pulp - Task #4290: Investigate performance of Pulp with UUID PKs CLOSED - COMPLETE Actions
Blocks Pulp - Task #4507: Remove job_id field on Tasks MODIFIED Actions

Associated revisions

Revision 914d14f6 View on GitHub
Added by dalley 7 months ago

Make changes to support UUID Primary Keys

re: #4270
https://pulp.plan.io/issues/4270

Revision 55b43da4 View on GitHub
Added by dalley 7 months ago

Use UUID primary keys

Required PR: https://github.com/pulp/pulpcore-plugin/pull/69

re: #4270
https://pulp.plan.io/issues/4270

Revision 1be95b7d View on GitHub
Added by daviddavis 7 months ago

Adding support for mariadb/mysql

fixes #4270
https://pulp.plan.io/issues/4270

Revision 39c8147d View on GitHub
Added by David Davis 7 months ago

Install pulpcore with extra postgres packages

ref #4270

Revision 225e1c41 View on GitHub
Added by David Davis 7 months ago

Install pulpcore with postgres extra packages

ref #4270

Revision 5ea25c9d View on GitHub
Added by David Davis 7 months ago

Install postgres extra packages

ref #4270

Revision 62a2628f View on GitHub
Added by David Davis 7 months ago

Update instructions to install db extras

ref #4270

Revision cb911745 View on GitHub
Added by David Davis 7 months ago

Install pulpcore with postgres extras

ref #4270

Revision 246abd41 View on GitHub
Added by daviddavis 7 months ago

Install the postgresql extra packages in Travis

ref #4270

Revision 85a6f969 View on GitHub
Added by daviddavis 7 months ago

Install the psycopg package if using postgres

ref #4270

Revision 1a7a1e5a View on GitHub
Added by David Davis 7 months ago

Install pulpcore with postgresql extra packages

ref #4270

Revision d32db5b4 View on GitHub
Added by David Davis 7 months ago

Fixing conditions check pk for None

With UUIDs, pks are never None. Instead check _state.

refs #4270

Revision 1a7a1e5a View on GitHub
Added by David Davis 7 months ago

Install pulpcore with postgresql extra packages

ref #4270

Revision d32db5b4 View on GitHub
Added by David Davis 7 months ago

Fixing conditions check pk for None

With UUIDs, pks are never None. Instead check _state.

refs #4270

Revision c31d1db6 View on GitHub
Added by mdellweg 7 months ago

Install the postgresql extra packages in Travis

ref #4270

Revision e6832c74 View on GitHub
Added by daviddavis 5 months ago

Removing file publisher stuff

refs #4270
https://pulp.plan.io/issues/4720

History

#1 Updated by bmbouter 10 months ago

I think the best thing would be to do this with each PR's run in Travis. Another option is to do it in the nightly Travis run, but by then the PR author is long gone. Since it would run in parallel with PostgreSQL I don't think it will add significant runtime to the PR runner.

#2 Updated by daviddavis 10 months ago

I am +1 to this. This might be my personal bias against Oracle but what about using MariaDB instead of MySQL?

Also, I suggest we keep the number of jobs to < 5. Travis limits the number of concurrent builds per project to about 4-5 (depending on their overall load) and having 5+ jobs per build makes builds take a long time.

#3 Updated by bmbouter 10 months ago

MariaDB sounds fine to me.

#4 Updated by bmbouter 10 months ago

  • Subject changed from Enable MySQL testing in Travis for pulp/pulp and pulp/pulpcore-plugin to Enable MariaDB testing in Travis for pulp/pulp and pulp/pulpcore-plugin

#5 Updated by daviddavis 10 months ago

  • Blocked by Issue #4288: _mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'name' used in key specification without a key length") added

#6 Updated by daviddavis 10 months ago

  • Status changed from NEW to POST

#7 Updated by bmbouter 9 months ago

  • Sprint set to Sprint 47

#8 Updated by rchan 9 months ago

In the future, please bring up the question of adding something to the sprint if work starts on it.

#9 Updated by rchan 9 months ago

  • Sprint changed from Sprint 47 to Sprint 48

#10 Updated by ipanova@redhat.com 8 months ago

  • Assignee set to daviddavis

#11 Updated by rchan 8 months ago

  • Sprint changed from Sprint 48 to Sprint 49

#12 Updated by daviddavis 8 months ago

  • Subject changed from Enable MariaDB testing in Travis for pulp/pulp and pulp/pulpcore-plugin to Add support for MariaDB and MySQL

#13 Updated by daviddavis 8 months ago

  • Blocked by Task #4290: Investigate performance of Pulp with UUID PKs added

#14 Updated by daviddavis 7 months ago

  • Blocks Task #4507: Remove job_id field on Tasks added

#15 Updated by daviddavis 7 months ago

  • Related to Story #4517: As a user, I can install pulp with mysql or mariadb added

#16 Updated by daviddavis 7 months ago

  • Status changed from POST to MODIFIED
  • % Done changed from 0 to 100

#17 Updated by daviddavis 7 months ago

  • Status changed from MODIFIED to POST

Reopening issue. I need to update the docs and notify plugins of this change.

#18 Updated by rchan 7 months ago

  • Sprint changed from Sprint 49 to Sprint 50

#19 Updated by daviddavis 7 months ago

  • Status changed from POST to MODIFIED

#20 Updated by daviddavis 6 months ago

  • Sprint/Milestone set to 3.0

#21 Updated by bmbouter 6 months ago

  • Tags deleted (Pulp 3, Pulp 3 RC Blocker)

Please register to edit this issue

Send by e-mail

Also available in: Atom PDF