Update of /cvsroot/nagios-db/nagios-db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31587
Modified Files:
README
Log Message:
Notes about mysql
Index: README
===================================================================
RCS file: /cvsroot/nagios-db/nagios-db/README,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** README 23 Dec 2004 00:09:24 -0000 1.1.1.1
--- README 1 Feb 2005 06:18:39 -0000 1.2
***************
*** 49,54 ****
! DATABASE DETAILS
! ================
I wrote this to utilize postgres for my database. I needed the features
--- 49,54 ----
! POSTGRES DATABASE DETAILS
! =========================
I wrote this to utilize postgres for my database. I needed the features
***************
*** 106,107 ****
--- 106,132 ----
takes a long time to bring it together, you can always make the UI read
from the non-materialized version of the view.
+
+ MYSQL DATABASE DETAILS
+ ======================
+
+ A MySQL 4.1 module has been added and will be supported by Matthew
+ Kent. Although it implements the same schema as the postgres module
+ there are many differences in how it's written. Most of the differences
+ are not improvements but making up for some features which MySQL lacks
+ (like stored procedures) that make writting C for it more difficult.
+
+ The module also includes some simple caching to take advantage of bulk
+ inserts and updates. Queries are collected in memory and fed to the
+ database after an adjustable interval.
+
+ The schema, like the postgres module, is simple but requires InnoDB
+ support.
+
+ The gui itself now supports both databases, so it's just a matter
+ of picking the right one in the configuration file. They *should*
+ function identically but differences may show up as more of the
+ interface is built out.
+
+ See database/mysql/README
+ neb/mysql/inserter.c
+ ui/config.php
|
