Feb-28-2017, 11:47 PM
First post to the forum! Looking forward to hearing your guys input.
I have a script I'm writing at work that will help us audit our cisco ASA firewall rules. It parses the acl output into objects and then inserts/updates the information in a MySQL database. The whole process takes longer then I think it should, and I need some help with a few things. Using multithreading I am getting the firewall acl output eight firewalls at a time. This has reduced the time for getting the acl out from over an hour down to around 15 minutes (this is an enterprise level organization, and this is being done with 52 firewall contexts). However, inserting/updating the rule information for all firewalls into/on the database still takes over an hour. I would really like to cut that time down as I did with getting the acl output. I'm just not sure what the best approach to take. Would it be best to use multithreading, multiprocessing, or mysql connection pooling? Or a combination of any of the three? Thanks in advance to anyone who can help!
I have a script I'm writing at work that will help us audit our cisco ASA firewall rules. It parses the acl output into objects and then inserts/updates the information in a MySQL database. The whole process takes longer then I think it should, and I need some help with a few things. Using multithreading I am getting the firewall acl output eight firewalls at a time. This has reduced the time for getting the acl out from over an hour down to around 15 minutes (this is an enterprise level organization, and this is being done with 52 firewall contexts). However, inserting/updating the rule information for all firewalls into/on the database still takes over an hour. I would really like to cut that time down as I did with getting the acl output. I'm just not sure what the best approach to take. Would it be best to use multithreading, multiprocessing, or mysql connection pooling? Or a combination of any of the three? Thanks in advance to anyone who can help!