Hi,
I've been running pmacct for a while with PostgreSQL and it works well with
lots of netflow data presumably due to inbuilt handling of CIDR.
For various reasons we're migrating to a mySQL backend to integrate with our
billing/customer portal environment better and mySQL does not appear to
In MySQL (any SQL actually), string searches are computationally very
expensive when compared with integers. If you’re dealing with a relatively
small number of rows then the difference isn’t a problem.
It’s like asking “show me all the rows where the number is between 1 and
1000” versus “show me
Hi Cameron,
Yes you can record AS details, but your Netflow exporter will need to send AS
information with the flows.
Relevant bits from my config:
sql_table_version: 6
nfacctd_as_new: false
aggregate:src_host, dst_host, src_as, dst_as
You need to read into the various SQL table versions to