Yesterday I ran into an old collegue that now runs quite a
successful computer store chain and highly successful web store
here in Australia. Long story short he was having some MySQL
problems, so I offered to pass my eye over it. Now, given that
they had some data corruption in stock levels not being correct
(e.g. getting to an inventory count of -1), my first split second
thought was inappropiate transaction management.
In thinking last night, what would I do as part of auditing an
existing MySQL Installation and application quickly for reference
and also to highlight issues etc, assuming I would have no access
to any administrators or developers.
So what would you do? I made some preliminary notes, here’s the
full account of what I did do.
Audit Steps
OS Specifics
$ mkdir /tmp/arabx
$ cd /tmp/arabx
# keep a quick copy of stuff
$ script
# Linux generals
$ hostname
$ uname -a
$ uptime
$ …
[Read more]