Hi Jordan,
Yes, that is a valid scenario. To minimize effects locking (which impact is only increased memory footprint due to the writers sitting there waiting for the lock), you could play with sql_startup_delay so that the two daemons fire up writers with some time offset; but, if the two daemons touch distinct set of tuples and you successfully enforce an INSERT-only kind of behaviour, then you may give a try to disable locking, ie. 'sql_locking_style: none'. Paolo On Wed, Jan 22, 2020 at 11:39:19AM +0200, Jordan Grigorov (Neterra NMT) wrote: > Hello, > > We're using a mixed network environment with equipment that supports either > sflow or netflow. > > Currently we're using sfacctd only and mysql plugin which stores data into > MariaDB CS database. > > Is there any option to use both sfacctd and nfacctd that are using the same > DB and tables? > > > Thank you in advance. > > Kind Regards, > > > -- > --- > > > Jordan Grigorov > > > Network Engineer IP Services > > > > _______________________________________________ > pmacct-discussion mailing list > http://www.pmacct.net/#mailinglists _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
