Databases
Configuration 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 moreBest practices for migrating applications to MySQL
In just over 2 weeks I’ll be the invited speaker in Washington DC to Best practices for migrating applications to MySQL . This workshop is being held in conjunction with Carahsoft and Sun/MySQL and aims to provide to the Federal sector valuable information for the continued usage and uptake of Open Source and specifically MySQL.
Read moreExtending the MySQL Data Landscape
Learn how to extend your existing MySQL based website to leverage the power of MySQL variants, AWS cloud based MySQL deployments and RDBMS alternatives. Evaluate how to integrate and use these different various technologies such as MySQL based variations KickFire, a column based optimization and InfoBright, a data warehousing solution.
Read moreDependency error installing mylvmbackup on Ubuntu 8.04
I’ve started an investigation of MySQL Backups using LVM . I’m working with Lenz’s mylvmbackup but I found it both used Perl and needed a number of dependencies installed. Installing dependencies failed on my test system, yet I found it actually worked when I went back to my dev system (but it is not configured with LVM for full testing).
Read moreThe size of memory tables
I was doing some database sizing in MySQL 5.1.30 GA for memory tables. Generally I have used INFORMATION_SCHEMA.TABLES data_length,index_length as a reasonable guide. However working with a MEMORY table, after deleting rows, the size did not decrease as expected.
Read more