The MySQL* channel allows the logging server to log events to a MySQL database. The logging server can use the MySQL channel to create the central data store or a filtered database.
The space you need for your database depends on a number of factors. These include, but are not limited to, how many events per second you are storing and how long you want to keep the data. The MySQL install, itself, is about 20 MB. (Keep in mind that the MySQL database does not need to be on the same volume as the MySQL binaries.) For the data store, a system that generates around 80 events per second with an average event size of 80 bytes consumes approximately 500 MB of disk space for the database table and 150 MB for the index in a 24-hour period.
NOTE: To enable the MySQL channel, the MySQL client library, libmysql, is installed with the Secure Logging Server.
For further information, see "Using MySQL with Novell Audit" in the Novell® Audit Administration Guide.
When the MySQL Channel object configuration is loaded in the logging server's memory, the MySQL channel driver, lgdmsql, automatically creates the following table structure for the MySQL data store:
NOTE: The table name is defined in the MySQL Channel object configuration page. The default table name is NAUDITLOG.
The default number of rows depends on the operating system. The default maximum size for a MySQL table is 4 GB (or 2 GB if your operating system only supports 2 GB tables). This default size limitation keeps pointer sizes down, making the index smaller and faster.
NOTE: If you need larger tables, use the max_rows and avg_row_length commands in the MySQL Channel object's Create Table Options property.
A trademark symbol (®, , etc.) denotes a Novell trademark. An asterisk (*) denotes a third-party trademark. For information on trademarks, see Legal Notices.