Thanks for the caveat. I should be clear that I am adding a new INT auto_increment column to be the primary key only for the dozen or so tables I found without either a unique key or primary key, but I'll be on the lookout for anomalies once I migrate. <br><br><div class="gmail_quote"><div dir="ltr">On Tue, Feb 20, 2018, 12:43 Peter Bennett <<a href="mailto:pb.mythtv@gmail.com">pb.mythtv@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<br>
<div class="m_-7758199959862641313moz-cite-prefix">On 02/20/2018 02:16 AM, James Purl
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>Folks, </div>
<div><br>
</div>
<div>I was considering moving my mythconverg DB into a MySQL
cluster using the <a href="https://dev.mysql.com/doc/refman/5.7/en/group-replication.html" target="_blank">group replication plugin</a>, but
some of the tables don't have primary keys--among the <a href="https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html" target="_blank">requirements</a> 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.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>In any case, I'll be testing in a dev system long before
poking my production database!</div>
<div><br>
</div>
<div>Thanks!</div>
</div>
<br>
<fieldset class="m_-7758199959862641313mimeAttachmentHeader"></fieldset>
<br>
</blockquote></div><div text="#000000" bgcolor="#FFFFFF">
I am not sure about adding the extra keys. I would think it would
not be a problem. However, be aware of a problem that was previously
reported. Another user had tried this and he has set it up with auto
increment key 2 each time instead of by 1. This caused a problem
because there are some hard coded values in the code for recording
group sequence numbers and different numbers had been allocated in
the database in his setup. This is really a bug that should be fixed
in the code.<br>
<br>
Peter<br>
</div>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote></div>