Hi Tom,
On 12/14/20 8:41 AM, you wrote:
>
> Hi all,
>
> Just wondering what the state of play is for InnoDB?
>
> In the changelog, I see: "2.15.0 (2016-07-29) Bug fix: complete support
> for the MySQL/MariaDB InnoDB database engine" - however after looking at
> the engine in use on my Rivendell 3.5.0 test box all tables are still
> MyISAM.
>
> Is this just a case of changing the running engine myself, or are there
> plans for Paravel to push out some changes to move to InnoDB? And if I
> do change to InnoDB will any future schema changes break because of
> this?
>
> The reason I ask is that I'm looking to try running the database on
> MariaDB with Galera Cluster as a potential option for cross-WAN database
> access.
>
> Many thanks,
> Tom
>
Disclaimer: I am not a database expert or an educated DBA.
I can't say what the formal plans are regarding switching the database
engine, but I *can* tell you that I have successfully converted a few
Rivendell databases to InnoDB (on MariaDB server). I have also
implemented a multi-node WAN cluster using Galera. It's a lot more work
(initial setup and on-going maintenance) than I had expected, but it has
been worth the effort for this specific use case.
I have not figured out a way to consistently maintain a (Galera) quorum
when one site loses Internet connectivity for an extended period.
Usually things work and the cluster recovers from the outage, but there
are still times when the cluster goes "split brain" and I have to
initialize it from scratch.
Would love to continue this conversation off list (or on list) if you're
interested.
~David Klann
Broadcast Tool & Die
broadcasttool.com / btd.support
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
