Security
Because you might not want to share ExtSQL information with every user, the configuration file lets you specify the users who will have access:
extsql_users="john,domenic,phil,mary"
The root user is always allowed access.
Controlling ExtSQL
Additional commands (Table 2) allow the database administrator to temporarily suspend data collection, store data, and even change what data is being collected – without a server restart.
A configuration option called extsql_reload_file allows you to store collected data, which is automatically saved and restored during a restart.
Future Directions
Development with ExtSQL should be strong, and we plan to provide a focal point for community discussion, bug reports, fixes, and enhancements.
John Murtari has a B.S. in Astronautical Engineering from the Air Force Academy and an M.S. in Computer Science from Syracuse University. He represents Software Workshop Inc. as a member of the INCITS H2 Technical Committee for SQL standards (http://www.incits.org/). Contact John at mailto:jmurtari@softwareworkshop.com.
Comments