sql - LAMP 与 Hudson : How to run SQL Statement every hour

Question

我正在使用 CentOS 5.5、Apache、MySQL 和 PHP。我还安装了 Hudson。现在我想每小时运行一个 SQL 语句。最简单的方法是什么？我应该使用 Cron 还是 Hudson？

Answer 1

cron 是可插拔的，只要你的盒子启用了 crond，
与基于 java 的 hudson 不同，使用更少的资源，

As a Java-based web application, Hudson is heavyweight. A low-memory or embedded system is better-off with cron. Even Hudson’s remote job invocation installs and starts a Java-based runtime. You can, however, use the SSH plugin if even one box can run the main Hudson instance.

Cron’s scheduling is more precise if things have to happen exactly at certain time intervals. Hudson’s assumption is that your periodic builds aren’t dependent on when they start within a minute or two.