A problem that I have faced with SQL many times is pre-ordering the
GROUP BY clause.
When you GROUP BY, MySQL will return a set of records which I call representing records. These records represent the group that is selected.
select id from test group by class will return one representing record per unique value of the
class field. The problem with this is that you have no control over which record will represent the group.
This is a quick 1 page application to monitor your replicated MySQL servers.
Use it as you will. Enjoy!
Here is what I use to make a backup library of MySQL daily that will keep backups for 30 days.
Some notes and commands I want to keep handy the next time I setup MySQL replication.