Snort Forums Archive

Archive Home » Linux » Separate MySQL and Base on CentOS 4.4?

Please note that the categories listed below represent an archived version of our forums pages. To view the current version and be able to post and reply to threads, please register and login here to go to the full forums pages.

[ Notice: Full Version of This Topic ]

Separate MySQL and Base on CentOS 4.4?

Posted by tensors on October 09, 2006 13:07:49

Here is a simple but potentially complex question:

For performance, should I run MySQL and BASE on separate servers? Would the overhead introduced by having BASE access SQL data over a 100 mbps Ethernet connection outweigh the benefits of having two processors in two separate machines handling SQL and PHP/web operations separately.

Here's what I have:

(4) Dell 240 1.6 ghz workstations with dual NICs: one in stealth node monitoring their respective segments and one on a private network used to feed alerts to a central database

(1) Dell 240 1.6 ghz 512 MB workstation running the latest version of both MySQL and BASE. We're in the tuning phase with literally hundreds of thousands of alerts a day.

Needless to say, BASE and SQL operations run at a crawl.

Posted by scratchandsnort on July 11, 2007 07:44:42

Yes. I've noticed. The SQL queries need tuning, and/or the the ACID/BASE schema needs changing. Most who post here have claimed that it's the size of the database that is the problem, but I've used databases in the Terabytes that have had much better performance.