MySQL
Some 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 moreUsing Flipper to manage MySQL Pairs
As discussed previously in Options using MySQL pairs I have started evaluating the strengths and weaknesses of various open source options. This is an evaluation of Flipper , a product from Proven Scaling a MySQL consulting organization.
Read moreMost valuable MySQL slides
My presentation from the 2008 MySQL Conference on Top 20 Design Tips for Data Architects has been receiving a lot of traffic lately. Most recently this presentation was featured on the front page of Slideshare , as well as last month I made the top 10 of Hacker News .
Read moreSome MySQL pairs terminology
In response to a number of comments, I thought I would clarify the scope of my discussion regarding Options using MySQL pairs before I begin. As mentioned their is no one way or type of configuration for MySQL in a HA solution, however the simplest progression from a single Master/Slave environment is the concept of a pair of servers, configured to support a fail over and fail back via MySQL Replication.
Read moreOptions using MySQL Pairs
Configuring a production environment using a pair of MySQL servers in a Master/Fail Over Master situation is a common process to provide many benefits including supporting failover, backup/recovery, higher availability for software & database upgrades.
Read moreWhere is the innovation?
The 2009 MySQL Conference has closed it’s submissions for papers. This year the motto is “Innovation Everywhere”. Last weekend’s Open SQL Camp in Charlottesville, Virginia, we had the chance to talk about the movements in the MySQL ecosystem.
Read moreWhen mysqldump –no-set-names matters
I had this perplexing problem yesterday where a mysql dump and restore was producing different results when using MaatKit mk-table-checksum. mk-table-checksum --algorithm=BIT_XOR h=192.168.X.XX,u=user,p=password --databases=db1 --tables=c DATABASE TABLE CHUNK HOST ENGINE COUNT CHECKSUM TIME WAIT STAT LAG db1 c 0 192.
Read more