Project

Profile

Help

Send by e-mail

Task #4270

Add support for MariaDB and MySQL

Added by bmbouter over 1 year ago. Updated 5 months ago.

Status:
CLOSED - CURRENTRELEASE
Priority:
Normal
Assignee:
daviddavis
Category:
-
Sprint/Milestone:
3.0.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") CLOSED - CURRENTRELEASE 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 CLOSED - CURRENTRELEASE Actions

Associated revisions

Revision 55b43da4 View on GitHub
Added by dalley about 1 year 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 about 1 year ago

Adding support for mariadb/mysql

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

Revision 39c8147d View on GitHub
Added by David Davis about 1 year ago

Install pulpcore with extra postgres packages

ref #4270

Revision 225e1c41 View on GitHub
Added by David Davis about 1 year ago

Install pulpcore with postgres extra packages

ref #4270

Revision 5ea25c9d View on GitHub
Added by David Davis about 1 year ago

Install postgres extra packages

ref #4270

Revision 62a2628f View on GitHub
Added by David Davis about 1 year ago

Update instructions to install db extras

ref #4270

Revision 246abd41 View on GitHub
Added by daviddavis about 1 year ago

Install the postgresql extra packages in Travis

ref #4270

Revision 85a6f969 View on GitHub
Added by daviddavis about 1 year ago

Install the psycopg package if using postgres

ref #4270

Revision 85a6f969 View on GitHub
Added by daviddavis about 1 year ago

Install the psycopg package if using postgres

ref #4270

Revision 1a7a1e5a View on GitHub
Added by David Davis about 1 year ago

Install pulpcore with postgresql extra packages

ref #4270

Revision d32db5b4 View on GitHub
Added by David Davis about 1 year 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 about 1 year ago

Install pulpcore with postgresql extra packages

ref #4270

Revision d32db5b4 View on GitHub
Added by David Davis about 1 year 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 about 1 year ago

Install pulpcore with postgresql extra packages

ref #4270

Revision d32db5b4 View on GitHub
Added by David Davis about 1 year 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 about 1 year ago

Install pulpcore with postgresql extra packages

ref #4270

Revision d32db5b4 View on GitHub
Added by David Davis about 1 year 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 about 1 year ago

Install the postgresql extra packages in Travis

ref #4270

Revision e6832c74 View on GitHub
Added by daviddavis about 1 year ago

Removing file publisher stuff

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

History

#1 Updated by bmbouter over 1 year 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 over 1 year 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 over 1 year ago

MariaDB sounds fine to me.

#4 Updated by bmbouter over 1 year 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 over 1 year 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 over 1 year ago

  • Status changed from NEW to POST

#7 Updated by bmbouter over 1 year ago

  • Sprint set to Sprint 47

#8 Updated by rchan over 1 year ago

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

#9 Updated by rchan over 1 year ago

  • Sprint changed from Sprint 47 to Sprint 48

#10 Updated by ipanova@redhat.com over 1 year ago

  • Assignee set to daviddavis

#11 Updated by rchan over 1 year ago

  • Sprint changed from Sprint 48 to Sprint 49

#12 Updated by daviddavis over 1 year 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 over 1 year ago

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

#14 Updated by daviddavis about 1 year ago

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

#15 Updated by daviddavis about 1 year ago

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

#16 Updated by daviddavis about 1 year ago

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

#17 Updated by daviddavis about 1 year 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 about 1 year ago

  • Sprint changed from Sprint 49 to Sprint 50

#19 Updated by daviddavis about 1 year ago

  • Status changed from POST to MODIFIED

#20 Updated by daviddavis about 1 year ago

  • Sprint/Milestone set to 3.0.0

#21 Updated by bmbouter about 1 year ago

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

#22 Updated by bmbouter 5 months ago

  • Status changed from MODIFIED to CLOSED - CURRENTRELEASE

Please register to edit this issue

Send by e-mail

Also available in: Atom PDF