[mythtv-users] Okay adding primary key to mythconverg tables that don't have them?

[James Purl]

Folks,

I was considering moving my mythconverg DB into a MySQL cluster using the group
replication plugin
<https://dev.mysql.com/doc/refman/5.7/en/group-replication.html>, but some
of the tables don't have primary keys--among the requirements
<https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html>
for
group replication. I was considering altering those tables to just add an
auto_increment primary key. Does anyone know if these modifications might
break future schema upgrades? Not asking to predict the future, but if
anyone knows if the typical changes done to the DB schema would conflict. I
also understand I'd be on my own if this causes me a mess.

I have an old database that has been through several versions of updates
and so I'm finding it has some cruft, like bad timestamps, that also
require fixing.

In any case, I'll be testing in a dev system long before poking my
production database!

Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180220/f63c40f3/attachment.html>