--------------ms020109020808090902020201
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Hi Ethan,
hi list,
Ethan Galstad schrieb:
> OpenDBX (http://www.linuxnetworks.de/doc/index.php/OpenDBX) looks like
> it might be a good abstraction layer. Not sure how DB-specific table
> maintenance tasks would be handled (e.g. vacuuming Postgres tables after
> a large # of deletes).
>
> I also wonder about performance hits. The decision between using MyISAM
> or InnoDB tables might be more of a non-issue if an abstraction layer is
> used.
>
> Comments/ideas?
>
Only my simple opinion:
DB Abstraction is a fine thing - for the developer. He doesn't have to
think about the specials behind but the abstraction layer has to know
the driver specific stuff.
IMHO each single layer between might be a bottleneck for the performance
cause different libraries are calling different libraries.
You are just moving the responsibility who takes care about the
necessary driver - I guessed that this moving goes to the account of
performance, but OpenDBX is showing some performance tests and the
results looks not so bad:
MySQL native: 227 seconds
OpenDBX mysql: 230 seconds
LibDBI mysql: 251 seconds
All results for the same test queries containing 1.000.000 basic queries.
So I would say: What are 3 seconds on 1 Million transactions on a near 4
minutes runtime?
I was realy amazed about my faulty thinking.
Another point may be the responsibility.
If you say: "Install OpenDBX before you try to install NDO" you drop
some new users into a carrousel of recursiv compiling each tool with
different dependencies.
This might lead into a big red 'STOP' sign for the beginners und I think
the NDOUtils are getting more and more to a big bucket of nagios related
informations.
With NDO in the background you are able to get information out of nagios
without a direct access to your nagios host, faster access, availibility
reports within seconds instead of waiting minutes to parse the logfiles.
NDO might be the favorite addon for a many users, users with small
installations and even users with huge installations.
You need s.th. easy to install for the small users and good performance
for the huge ones.
Hard to say what might be the best way.
Just my twenty cents.
Hendrik
--------------ms020109020808090902020201
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature
MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIFuDCC
AtgwggJBoAMCAQICCQCm2uXMgNJKLDANBgkqhkiG9w0BAQUFADBPMQswCQYDVQQGEwJERTEM
MAoGA1UECBMDTlJXMRwwGgYDVQQKExNCYWVja2VyIElUIFNlcnZpY2VzMRQwEgYDVQQDEwtp
bnRlcm5hbCBDQTAeFw0wNzA4MDgxMzExMThaFw0wODA4MDcxMzExMThaMHsxCzAJBgNVBAYT
AkRFMQwwCgYDVQQIEwNOUlcxHDAaBgNVBAoTE0JhZWNrZXIgSVQgU2VydmljZXMxGDAWBgNV
BAMTD0hlbmRyaWsgQmFlY2tlcjEmMCQGCSqGSIb3DQEJARYXYW5kdXJpbkBwcm9jZXNzLXpl
cm8uZGUwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAJ9MdGOUbOUVjqr6sVAmSmwM4pl4
RCpOhRkLcZsxqS01xSdtsk60O9zKTNIM23A05WTECJwQL9jtdf2yjEpRrdBlwXGnU+muYZX7
L64RrdjqCRRdNqUlaM1YBRFTGKLSEjBfiF3B5SI6U19Gs4JdVH/Tnq9F/VmL7wPTBPT6HQfH
AgMBAAGjgY8wgYwwCQYDVR0TBAIwADARBglghkgBhvhCAQEEBAMCBaAwLAYJYIZIAYb4QgEN
BB8WHU9wZW5TU0wgR2VuZXJhdGVkIENlcnRpZmljYXRlMB0GA1UdDgQWBBQeM6m5375Z0mi+
4fR2vjs/33lYVzAfBgNVHSMEGDAWgBS3rNDUwCvH3HcY6lNfn7uOxsWp4DANBgkqhkiG9w0B
AQUFAAOBgQC/NdkSRFIVzD21pqbGnX3NpG0l77QI5/GUraeWTiAUI1MCb+coUg7ySWqRwYl3
lVyrRY8vpf45xNib8LncgzoP4M6/T/YUWeYv+YIzrePEJS0oEUIwJcKTsdflVzoeiUipa64r
G2xpp/pln+zcRK75elz0ELKlp5YMc0IJpwXAMDCCAtgwggJBoAMCAQICCQCm2uXMgNJKLDAN
BgkqhkiG9w0BAQUFADBPMQswCQYDVQQGEwJERTEMMAoGA1UECBMDTlJXMRwwGgYDVQQKExNC
YWVja2VyIElUIFNlcnZpY2VzMRQwEgYDVQQDEwtpbnRlcm5hbCBDQTAeFw0wNzA4MDgxMzEx
MThaFw0wODA4MDcxMzExMThaMHsxCzAJBgNVBAYTAkRFMQwwCgYDVQQIEwNOUlcxHDAaBgNV
BAoTE0JhZWNrZXIgSVQgU2VydmljZXMxGDAWBgNVBAMTD0hlbmRyaWsgQmFlY2tlcjEmMCQG
CSqGSIb3DQEJARYXYW5kdXJpbkBwcm9jZXNzLXplcm8uZGUwgZ8wDQYJKoZIhvcNAQEBBQAD
gY0AMIGJAoGBAJ9MdGOUbOUVj
...[email truncated]...
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]