We are playing with Capistrano to poll our cluster of servers. We have
it up and running, and are able to send commands to all of our servers
like:
$cap shell
cap> uptime
[establishing connection(s) to web1.XXXXXX.com, db1.XXXXXX.com,
web1.XXXXXX.com, web2.XXXXXX.com, db1.XXXXXX.com, web1.XXXXXX.com,
db1.XXXXXX.com, web1.XXXXXX.com, db1.XXXXXX.com]
** [out :: web1.XXXXXX.com] 23:11:24 up 23:18, 0 users, load
average: 0.00, 0.00, 0.00
** [out :: web2.XXXXXX.com] 23:11:24 up 22:28, 0 users, load
average: 0.00, 0.00, 0.00
** [out :: db1.XXXXXX.com] 23:11:25 up 23:22, 0 users, load
average: 0.00, 0.00, 0.00
** [out :: db1.XXXXXX.com] 01:11:31 up 5 days, 2:51, 0 users, load
average: 0.00, 0.00, 0.00
** [out :: web1.XXXXXX.com] 23:11:36 up 4 days, 6:06, 0 users,
load average: 0.00, 0.00, 0.00
** [out :: web1.XXXXXX.com] 01:11:33 up 5 days, 2:33, 0 users,
load average: 0.00, 0.00, 0.00
** [out :: db1.XXXXXXX.com] 23:11:40 up 6 days, 3:38, 0 users,
load average: 0.00, 0.00, 0.00
** [out :: web1.XXXXXX.com] 23:11:33 up 3 days, 20:23, 0 users,
load average: 0.00, 0.00, 0.00
** [out :: db1.XXXXXX.com] 23:11:39 up 7 days, 21:41, 0 users, load
average: 0.00, 0.00, 0.00
What is the best way to process this information though. We wish to
store the results into a MySQL database. So like:
INSERT INTO load_averages (server, minute, five_minute,
fifteen_minute) VALUES ('web1.XXXXXX.com', 0.00, 0.00, 0.00);
Thanks.
--
* You received this message because you are subscribed to the Google Groups
"Capistrano" group.
* To post to this group, send email to [email protected]
* To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/capistrano?hl=en
