Comments on: Some observations on MySQL to sqlite migration & compatibility https://shlomi-noach.github.io/blog/mysql/some-observations-on-mysql-to-sqlite-migration-compatibility Blog by Shlomi Noach Wed, 01 Feb 2017 09:12:00 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Shlomi Noach https://shlomi-noach.github.io/blog/mysql/some-observations-on-mysql-to-sqlite-migration-compatibility/comment-page-1#comment-382870 Wed, 01 Feb 2017 09:12:00 +0000 https://shlomi-noach.github.io/blog/?p=7663#comment-382870 I’ll be looking forward to read your blog post, Simon!
These are early stages, and I’m still looking into the diffs between mysql/sqlite, and clearly expect to be looking more into the app behavioral changes.

While I’m looking at this for an actual use case, I should note that orchestrator will continue to support mysql as backend (and I/we will continue to use it like that…).

You’re right about the architectural changes that would be required of orchestrator. We discussed some of those in the past: sharing work between orchestrator nodes; taking leadership; getting quorum agreement for failover; operation locks.

I do believe with proper layering most of these changes would not have to complicate existing code, which would mostly be ignorant of the change. But — ongoing effort, so we’ll see.

]]>
By: Simon Mudd https://shlomi-noach.github.io/blog/mysql/some-observations-on-mysql-to-sqlite-migration-compatibility/comment-page-1#comment-382829 Tue, 31 Jan 2017 19:43:00 +0000 https://shlomi-noach.github.io/blog/?p=7663#comment-382829 Not heavyweight depends. For people in small environments then having a single app+db is great. There’s no disagreement there, but if you want orchestrator to be HA because you don’t want to have your db servers going down then that’s not so good. So perhaps it’s misleading to lead people to a “this app fixes your problem mentality” as they may think: just install orchestrator and my MySQL failover problems are solved. I don’t think it’s quite as simple as that. I am pending writing a blog on setting up orchestrator in a HA environment and obviously that’s a lot more complex and maybe only makes sense if orchestrator is monitoring a number of servers.

If I were to do what you want I guess I would keep state in memory with a very basic setup on disk of the boxes to monitor (not their state) and if I needed HA I would exchange “config” and/or state with neighbours etc. Basically like networking daemons exchange routing information. The idea sounds simple, but having seen and knowing the current code that’s a major change in the way things work and quite a risky undertaking though maybe it would allow “instant” recognition of failure scenarios and therefore be “better” than now. Most people don’t really appreciate the complexity of what orchestrator does, the situations it handles and in practice a new in-memory based orchestrator server would also be pretty complex. It might be an interesting path to take but few people probably have time for such an adventure.

]]>
By: Shlomi Noach https://shlomi-noach.github.io/blog/mysql/some-observations-on-mysql-to-sqlite-migration-compatibility/comment-page-1#comment-382720 Mon, 30 Jan 2017 15:54:00 +0000 https://shlomi-noach.github.io/blog/?p=7663#comment-382720 Yes, definitely, my use case will not be heavyweight and will not expect high performance. If it grows such that sqlite can’t hold, that is perfect justification to switch back to MySQL.

]]>
By: Jouni Järvinen https://shlomi-noach.github.io/blog/mysql/some-observations-on-mysql-to-sqlite-migration-compatibility/comment-page-1#comment-382714 Mon, 30 Jan 2017 15:02:00 +0000 https://shlomi-noach.github.io/blog/?p=7663#comment-382714 SQLite is a pretty good option to be compatible in the direction of MySQL, but if the SQLite db is heavily used the performance just won’t cut it. Firefox with tons of data in its DBs is a good example on slow db. LibreOffice changes to Firebird 3.0.0.

]]>