How to remove Routers/Interfaces without losing the history from the MySQL DB?
Netflow Flow Analysis
Example for Router IP Address: 100.200.300.400
1 - Stop all NFA services on Harvester and NFA Console machines:
2 - Queries to Delete on Harvester machine:
mysql
use harvester
select * from routers where inet6_ntoa(router)='100.200.300.400'; (Note the routerID)
select * from interfaces where inet6_ntoa(router)='100.200.300.400';
delete from routers where inet6_ntoa(router)='100.200.300.400';
delete from interfaces where inet6_ntoa(router)='100.200.300.400';
select * from persistent_map where routerid='x'; (Inform the routerID from first select)
delete from persistent_map where routerid='x';
NFA Console machine:
use reporter
select ID from routers where deviceName = '100.200.300.400'; (Note the routerID)
select * from interfaces where routerId = 'nnnnnnn'; (Inform the routerID from select above)
delete from routers where deviceName = '100.200.300.400';
delete from interfaces where routerId = 'nnnnnnn'; (Inform the routerID from select above)
3 - Start all NFA services on Harvester and NFA Console machines
4 - Make sure that the desired interfaces show back up and are enabled
5 - Wait 15 minutes to Validate