CAcert Code Development list.

[gstark <gstark AT cacert.org>]

Henrik,
The point of my inquirers and effort is to determine and fix the poor
performance of the MySQL database. Then talk to this group here about
scaling, testing, secure replication and switchover.  Solomon has
experience in high demand enterprise scale MySQL installations and is
willing to help. 

What access is available to the test machine?

Greg

On Wed, 01 Jul 2009 20:22:05 +0200, Henrik Heigl 
<cacert AT gmx.net>
 wrote:
> Hy there,
> 
> as I can read here my services for monitoring the CAcert
> Servers/services from outside including ping, Service supervising (e.g.
> Apache, mySQL, wiki, blog, diskspace, etc.) Services, etc. over a
> Whatsup Gold instance from outside (and so independant System) are no
> longer needed.
> As of this day I will delete all the monitors and let this job (also the
> Mail Alarm, etc.) up to you guys.
> 
> Greg Stark schrieb:
>> -----Original Message-----
>> From: Solomon K. Chang 
>> [mailto:skevin521 AT yahoo.com]
>>  
>> Sent: Tuesday, June 30, 2009 5:45 PM
>> To: Greg Stark
>> Cc: 'Wytze van der Raay'
>> Subject: Re: CAcert - Monitoring
>>
>> For monitoring, I definitely recommend Zabbix.  It's easy to set up, and
>> if
>> you have an SMTP server on the same network, you can have it email you
>> alerts if anything exceeds a certain threshold.  Everything is also
>> stored
>> as historical data, so if you want want to watch things like CPU and
>> memory
>> usage over the course of the day/week (usually to see when your peak
>> hours
>> are), you can do so easily.  Almost anything that you can capture a
>> number
>> for, you can render as a graph.
>>
>> As for schema, well, it doesn't look like you're too buried in data yet.
>> Yeah, "locations" is big, so for starters, if this table requires
>> concurrent
>> access, change the storage engine to InnoDB.  You might want to consider
>> it for your users table too.
>>
>> "notary" has redundant indexes, "from_2" and "to_2".
>>
>> Do you have your Slow Log set?  I like to keep mine at 1 second. 
>> Especially
>> for a user heavy database.  Any query that takes up more than a single
>> second to run is way too much, unless you're doing BI, which should only
>> take place on a slave that has nothing to do with production.
>>
>> If either of you have a specific question, please, ask away.
>>
>> Solomon Chang
>>
>> --- On Thu, 6/25/09, Greg Stark 
>> <gstark AT cacert.org>
>>  wrote:
>>> From: Greg Stark 
>>> <gstark AT cacert.org>
>>> Subject: CAcert - Monitoring
>>> To: "'Solomon K. Chang'" 
>>> <skevin521 AT yahoo.com>
>>> Cc: "'Wytze van der Raay'" 
>>> <wytze AT cacert.org>
>>> Date: Thursday, June 25, 2009, 9:11 PM
>>> Solomon,
>>> I don't think we have a MySQL DBA. Hence my contacting you.
>>> In your response, you mention:
>>>
>>>> Get a good monitoring package, but every sysadmin
>>>> already knows that.
>>>     
>>>> You'll want to set alerts on CPU usage of the mysql process, number of
>>>> tables open, number of current deadlocked queries, etc.
>>>
>>> What would you recommend for a monitoring tool(s)?
>>>
>>> You may find quicker answers to questions if I step out of the middle
and
>>> talk directly to Wytze van der 
>>> Raay<wytze AT cacert.org>.
>>>  There are some
>>> questions I think you have great expertise, about live updating of two
or
>>> more MySQL DBs switching between the them, and backups.  Send him your
>>> presentation handouts you had at CalTech - SGVLUG would be
>>> helpful.  Scaling needs?  Wytze may be able to tell you more.
>>>
>>> The web server runs mysql-server-5.0 (version 5.0.32-7etch).
>>> The current table layout of the database can be obtained
>>> through
>>> the regular web interface at http://www.cacert.org/sqldump.php
>>>
>>> Oh, there is also the https://lists.cacert.org/wws/lists and ;
>>> cacert-devel AT lists.cacert.org
>>>  
>>> CAcert Code Development list to monitor.
>>>
>>> Regards,
>>> Greg