Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Deprecate MySQL support #191

Closed
dennissiemensma opened this issue Dec 25, 2016 · 4 comments
Closed

Deprecate MySQL support #191

dennissiemensma opened this issue Dec 25, 2016 · 4 comments
Milestone

Comments

@dennissiemensma
Copy link
Member

It seems that MySQL has too many issues with DST. Also, the new DB-features of Django in #72 lack decent support.

I think I'll have to deprecate it, and support an management command as well to easily migrate all data to PostgreSQL.

@dennissiemensma dennissiemensma added this to the 1.6 milestone Dec 25, 2016
@dennissiemensma
Copy link
Member Author

I'm not sure about this yet, but it will make support a lot easier as well. TODO for later.

@dennissiemensma
Copy link
Member Author

Now I'm pretty sure.

It's causing too many issues and I can't guarantee decent timezone support. Also, adding a field to a table rebuilds the entire table, which PostgreSQL does not require (when default value of new field is NULL).

Upgrading a 1-year instance of dsmrreader from v1.4 to v1.5 took 20+ minutes. And because MySQL does not support schema migrations in transactions, the migration will break as well when anything happens.

@dennissiemensma
Copy link
Member Author

Well, I rewrote quite some docs and placed warnings regarding MySQL.

I also completed a migration script to copy data to PostgreSQL using Django. It's quite slow, but I do not see another reliable way of migrating data without users having to debug stuff themselves.

I'll also insert a notification for any MySQL users pointing at the migration docs.

dennissiemensma added a commit that referenced this issue Jan 7, 2017
@dennissiemensma dennissiemensma modified the milestones: 1.6, 1.5.2 Jan 8, 2017
dennissiemensma added a commit that referenced this issue Jan 21, 2017
@dennissiemensma
Copy link
Member Author

Merged doc changes back to 1.6 branch. Migration script should be part of #223.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant