Setting up mysql server on a seperate host

Hi All,

I am setting up a MRTG server which polls close to 100 nodes. A lot of perl scripts process the
data collected by this server. This processing is heavy and involves database (mysql) and flat mrtg
log files. There are other perl scripts which are used as part of a mailing engine (uses sendmail).
MRTG is called by cron every 5 minutes and the 100 nodes are divided such that there are 4 simple
shell scripts which contain the MRTG execution lines. These 4 scripts are called in cron every 5
minutes. There are other scheduled jobs which run only few (1-4) times a day.

Few days back, when I increased my nodes polled by 20 (from 80 to 100) and introduced a perl
script, I could see a lot of processing happening on the box. 'top' showed that most of it was
being crunched up my mysql (20-40%), mrtg, snmpwalks.

Now, I want to shift my entire mysql database and processing to another server (in the LAN) without
affecting much the scripts which will be accessing them. So, my scripts will be on one server and
database on other. The question is:
How do I do it?
Cheers,

Amol Sapkal
--------------------------
"Logic is a systematic method of coming to the wrong conclusion with confidence"

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org