purging database tables
by John Holland
We are going to be doing some testing of time sensitive data using RHQ.
We want to run successive tests with a internal NTP server
making the servers think they are always in the same time period. That
is, we will reset the NTP clock back before each test. This is because
the data being
tested has business logic that relates to the current time.
We want to purge the RHQ server of data from each previous test so the
identically-timestamped data don't collide. Is this viable? Would it be
a matter
of truncating certain tables? Or would it be better to snapshot the
whole machine?
Thanks,
John
13 years
RHQ on EC2
by John Holland
we are doing some use of RHQ on EC2 - the question came up, when the EC2
instances change IP address (but not FQDN - we are using Elastic IPs)
is there any chance of RHQ losing the connection to the server? In other
words does RHQ store the IP for a server with an agent anywhere,
or does it just use the FQDN- or does it get it from the agent?
Thanks,
John
13 years
postgres WAL files question
by Bala Nair
We have enabled WAL archiving to back up the RHQ postgres server on a
periodic basis. I'm using the default archiving settings with an
archive timeout of 12 hours - so archive the latest WAL file every 12
hours even if it isn't complete. This installation is our scaling test
system, with a pair of rhq servers running in HA and ~80 agents running
standard services. I expect there will be a lot of traffic on this
system, but I'm seeing a lot more than I expected and it's very bursty.
Here is the pg_xlog listing from postgres:
-rw------- 1 postgres postgres 16777216 May 3 09:21
0000000100000012000000E6
drwx------ 2 postgres postgres 16384 May 3 09:17 archive_status
-rw------- 1 postgres postgres 16777216 May 3 09:07
0000000100000012000000FB
-rw------- 1 postgres postgres 16777216 May 3 09:00
0000000100000012000000F5
-rw------- 1 postgres postgres 16777216 May 3 09:00
0000000100000012000000F6
-rw------- 1 postgres postgres 16777216 May 3 09:00
0000000100000012000000F8
-rw------- 1 postgres postgres 16777216 May 3 09:00
0000000100000012000000F7
-rw------- 1 postgres postgres 16777216 May 3 09:00
0000000100000012000000F9
-rw------- 1 postgres postgres 16777216 May 3 09:00
0000000100000012000000FA
-rw------- 1 postgres postgres 16777216 May 3 08:46
0000000100000012000000F4
-rw------- 1 postgres postgres 16777216 May 3 08:25
0000000100000012000000F3
-rw------- 1 postgres postgres 16777216 May 3 08:01
0000000100000012000000F2
-rw------- 1 postgres postgres 16777216 May 3 08:00
0000000100000012000000ED
-rw------- 1 postgres postgres 16777216 May 3 08:00
0000000100000012000000EE
-rw------- 1 postgres postgres 16777216 May 3 08:00
0000000100000012000000EF
-rw------- 1 postgres postgres 16777216 May 3 08:00
0000000100000012000000F0
-rw------- 1 postgres postgres 16777216 May 3 08:00
0000000100000012000000F1
-rw------- 1 postgres postgres 16777216 May 3 07:56
0000000100000012000000EC
-rw------- 1 postgres postgres 16777216 May 3 07:51
0000000100000012000000EB
-rw------- 1 postgres postgres 16777216 May 3 07:46
0000000100000012000000EA
-rw------- 1 postgres postgres 16777216 May 3 07:41
0000000100000012000000E9
-rw------- 1 postgres postgres 16777216 May 3 07:37
0000000100000012000000E7
-rw------- 1 postgres postgres 16777216 May 3 07:35
0000000100000012000000E8
-rw------- 1 postgres postgres 265 Apr 29 13:42
000000010000000D000000BA.00000068.backup
What I notice here is that between 7:30 and 8 this morning there's a lot
of database activity, then the system gets quiet for about 1/2 hour,
then busy again. I understand there are probably jobs running
periodically, but I didn't expect it to be this bursty or have quite
this much traffic. Is this unusual?
Bala Nair
SeaChange International
13 years
RHQ 4.0.0 has been released
by Heiko W.Rupp
Hello,
it is my pleasure to announce the release of RHQ 4.0.0
Then months of hard work have passed since RHQ 3.0.0 ...
... and they have brought
• new SmartGWT-based GUI
• support for Postgres 9.0
• support for deleting Agent plugins
• support for executing an RHQ CLI script when an alert fires (for more info, see this blog)
• improved authorization for content repositories - public/private repos, repo owners, and MANAGE_REPOSITORIES priv
• Much improved MySQL agent-plugin (by Steve Milidge)
• New logfile alert-sender (by Steve Milidge)
and much more.
Check out the release notes at http://rhq-project.org/display/RHQ/Release+Notes+4.0.0
and the binary from http://sourceforge.net/projects/rhq/files/rhq/rhq-4.0.0/
Thanks to everyone who has contributed to this effort; be it via code contributions, bug reports or cookies :)
Heiko (on behalf of the RHQ team)
--
Reg. Adresse: Red Hat GmbH, Technopark II, Haus C,
Werner-von-Siemens-Ring 14, D-85630 Grasbrunn
Handelsregister: Amtsgericht München HRB 153243
Geschaeftsführer: Brendan Lane, Charlie Peters, Michael Cunningham, Charles Cachera
13 years