General
Testing your system
I have raised this specific topic 3 times this week alone, twice in a MySQL setting. The fundamental philosophy of testing is NOT to verify features of your product that work, it is to BREAK your system.
Read moreConfiguration management concepts for database objects
Correctly managing your MySQL database objects such as schemas, tables, indexes, base data etc, is critical to the success of a 24×7 online website. I rarely encounter a robust working solution as part of my consulting so I would like to share my experience in identifying the best practices you should be adopting whether your an existing organization or just an individual with a simple website.
Read morePlanet MySQL at a new URL
Did anybody notice that http://planetmysql.org now redirects to http://planet.mysql.com ? Curious to know the reason why, perhaps an official MySQL person can give us some details. Also it’s a 302 redirect, not a 301 redirect, interesting?
Read moreEliminating unnecessary internal temporary tables
I can’t stress enough that people look at SQL statements that are being executed against your production MySQL database, and you optimize queries when you can. Often it’s the improvement to the large number of similar queries executed that can optimize resources.
Read moreAnnouncing “MySQL Essentials” Training
Are you having problems getting up to speed on MySQL? Are you asking yourself “Is there a hands-on training course we can send a developer/system admin to learn MySQL?”. In response, at 42SQL we have put together two new training courses, MySQL Essentials and MySQL Operations.
Read moreThe art of looking at the actual SQL statements
It’s a shame that MySQL does not provide better granularity when you want to look at all SQL statements being executed in a MySQL server. I canvas that you can with the general log, but the inherit starting/stopping problems in 5.
Read moreWatching a slave catchup
This neat one line command can be of interest when you are rebuilding a MySQL slave and replication is currently catching up. $ watch --interval=1 --differences 'mysql -uuser -ppassword -e "
Read moreSome Drupal observations
I had the opportunity to review a client’s production Drupal installation recently. This is a new site and traffic is just starting to pick up. Drupal is a popular LAMP stack open source CMS system using the MySQL Database.
Read moreBest Practices in Migrating to MySQL
This week I was the invited speaker to give a 4 hr presentation to the Federal Government Sector in Washington DC on “Best Practices in Migrating to MySQL“. This was a followup to my day long “MySQL for the Oracle DBA Bootcamp” which I presented in Washington DC last year.
Read moreStrict mode can still throw warnings
MySQL by default is vary lax with data validation. Silent conversions is a concept that is not a common practice in other databases. In MySQL, instead of throwing an error, a warning was thrown and many applications simply did not handle warnings.
Read moreJavascript Helpers
Combined with my old favorites of Dynamic Drive , DHTML Goodies and Brain Jar , I’ve added the following to my list of Javascript sources. Mochikit JQuery
Read moreTechnology changes, humans don’t. – Web 2.0 NY Second keynote
I needed a rest from my opening keynote review NY Tech 1995-2008. Opening Web 2.0 Expo NY Keynote but a few siginificant points from The Death of the Grand Gesture by Deb Schultz.
Read more