I don't think there's a reason to share the MySQL database among the Rivendell workstations - only the database server needs direct access to it. The Rivendell workstations will use an IP connection to the server for their database accesses..
Although NFS can provide file locks, a database server needs much finer serialization controls. That's one reason why I/O accesses are done in the server. And then there's that whole accidental deletion or mangling possibility, which I suspect is what's making Fred twitch. <smile> On Mon, Jan 27, 2020 at 5:38 PM Rich Stivers <r...@stivers-bros.com> wrote: > On 1/27/2020 8:09 AM, Fred Gleason wrote: > > On Jan 26, 2020, at 08:14, Cowboy <c...@cwf1.com> wrote: > > As near as I can tell, this is a RedHat/centos/systemd bug. > > > Yup. Known problem. > > The solution is to configure an auto mounter rule for ‘/var/snd’ (which is > exactly how the Rivendell v3.x installer does it). This not only fixes the > ’network not ready’ problem, but a whole raft of other potential gotchas > (like recovering from a site-wide power failure and having the workstations > finish booting before the server). > > I'm not familiar with an auto mounter rule. What is that exactly? > > > > On Jan 26, 2020, at 04:37, Rich Stivers <r...@stivers-bros.com> wrote: > > I'm running Centos 7 with Rivendell v2.19.3. I've run into what seems like > a timing issue for the NFS mount of /var/snd and > /var/lib/mysql during Centos boot. > > > Whoa! Why are we exporting ‘/var/lib/mysql’? That is asking for a whole > world of trouble. Those files should be private to the local mysqld(8) > instance. The way to share the DB is via MySQL’s native sharing protocols. > > Up until now I thought the person who configured the RAID server for us > had set up the MySQL database properly. I'll reread all the Rivendell > documentation on nfs and client/server communication. Are you saying the > /var/lib/mysql files should be on a Rivendell host instead of the > RAID server? > > Rich Stivers > KKUP-FM > > > > Cheers! > > > |---------------------------------------------------------------------| > | Frederick F. Gleason, Jr. | Chief Developer | > | | Paravel Systems | > |---------------------------------------------------------------------| > | A room without books is like a body without a soul. | > | | > | -- Cicero | > |---------------------------------------------------------------------| > > _______________________________________________ > Rivendell-dev mailing > listRivendell-dev@lists.rivendellaudio.orghttp://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > > _______________________________________________ > Rivendell-dev mailing list > Rivendell-dev@lists.rivendellaudio.org > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >
_______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
