On Fri, 3 Apr 2015, C.L. Martinez wrote:
On 04/01/2015 12:51 PM, C.L. Martinez wrote:
Hi all,
In the following weeks, I need to install a syslog collector server
using mysql as a backend to store all logs (and I would like to use
OpenBSD 5.7 to accomplish that).
I expect +/- 5k-6k EPS from our servers (unix, linux, windows). As a
syslog process I will use syslog-ng or rsyslog. But my question is about
using mysql under OpenBSD.
Due to the log volume, I will need to do, probably, some type of
tuning in mysql side.
Somebody uses mysql in production environments with a respectable
amount of inserts under OpenBSD? Tips tricks about what options to use
under fstab where mysql stores all data, memory limits, etc?
Thanks.
Please, any inputs?
I don't see why running MySQL on OpenBSD would be much different than on
any other OS?
Set your settings in the MySQL config like you would on any other OS.
Then look at the mount man page and see if there is anything there that
you might want to change (my guess would be no...).
I do have the following in my /etc/login.conf:
mysqld:\
:openfiles-cur=1024:\
:openfiles-max=2048:\
:tc=daemon:
which I got from the mysql-* file in /usr/local/share/doc/pkg-readmes
It's possible there might be more interesting things to mess with in
login.conf for MySQL but I'm guessing probably not more than those two
openfiles settings.
It sounds like this is a new project that you haven't done before? If you
have done this with this amount of load before then you should have some
guess as to how it will work. If not I would say start with the
my-huge.cnf MySQL config and go from there. Try to do some testing,
particularly try to simulate the load before you go to production. I'm
thinking fast CPUs and fast disks will be your best friends on this
project.
--
John Merriam