<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 20/02/18 07:16, James Purl wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAJ=aDds+vmb6oqiAQ6p9i1J+9x0pLa5SRgG4icToocX0bKWTaQ@mail.gmail.com">
<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"
moz-do-not-send="true">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"
moz-do-not-send="true">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>
</blockquote>
I am not a dev and my crystal ball is in for it's 100 year service.
:-)<br>
<br>
Basically the `Does anyone know if these modifications might break
future schema upgrades?` question can't be answered.<br>
Depends on what the dev do. As you said, we can't predict the
future. Also adding what is a new index may slow queries down. (or
make it better <shrug>)<br>
<br>
Any reason for using group replication instead of just replication?
(oh, cluster).<br>
One thing I have seen is that devs have thought about not using
mysql in the future, or an embedded version (or something), I hope
they don't as my mysql DB is on another host anyway.<br>
<br>
<pre class="moz-signature" cols="72">--
'ooroo
Stinga...(:)-)
---------------------------------------------------
Email: <a class="moz-txt-link-abbreviated" href="mailto:stinga+mythtv@wolf-rock.com">stinga+mythtv@wolf-rock.com</a> o
You need only two tools. o /////
A hammer and duct tape. If it /@ `\ /) ~
doesn't move and it should use > (O) X< ~ Fish!!
the hammer. If it moves and `\___/' \) ~
shouldn't, use the tape. \\\
---------------------------------------------------</pre>
</body>
</html>