Managing SQL Drift: Ensuring Stability in Database Transitions
SQL drift is a significant challenge that occurs when SQL statements from an existing system produce unexpected results after migration to a new environment or system. These issues manifest in several critical ways: SQL statements may generate new execution errors, experience significant performance degradation, or yield differences in data integrity.
Read more
UTF-8 with MySQL and LAMP
A recent question on a mailing list was the best practices for UTF-8 and PHP/MySQL. The following are the configurations I used in my multi-language projects. MySQL UTF-8 Configuration # my.
Read moreAmateurs – They give us professionals a bad name
Any person with half a brain would see from the error messages below that the MySQL server is not operating optimally, or more specifically the MySQL upgrade has not completely successfully and let users can go happily use the website.
Read moreI want a mysqldump –ignore-database option
While working with RDS and Google Cloud SQL I have come to realize that excluding the mysql schema from a mysqldump is important. However with many databases, the –all-databases option enables you only to select all or none.
Read moreWhen is a database schema not a database schema?
mysql> show schemas; +--------------------+ | Database | +--------------------+ | information_schema | | innodb | | mysql | | performance_schema | +--------------------+ 4 rows in set (0.00 sec) mysql> drop schema innodb; ERROR 1010 (HY000): Error dropping database (can't rmdir '.
Read moreAn excellent conference (5 out of 5 stars)
I wanted to extend thanks as others have also about the excellent annual MySQL Conference, now a Percona Live event. This was easily the best run, attended and energetic event in at least the past 3 years.
Read moreMySQL now has two user conferences (*)
PC World has written a post with this title(*) about the upcoming MySQL Connect conference and references the Percona Live conference and an official Percona comment. As this is not syndicated in Planet MySQL I encourage you to read the full article .
Read moreTIMESTAMP data types and CURRENT_TIMESTAMP attribute
In the yet to be released MySQL 5.6.6 DMR, there has been a change to the restriction of just one TIMESTAMP column with the DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP syntax.
Read moreSQL_MODE and storage engines
I was again reminded why setting SQL_MODE is so important in any new MySQL environment. While performing benchmark tests on parallel backup features with a common InnoDB tablespace and per file tablespace, I inadvertently missed an important step in the data migration.
Read moreIOUC Leaders Summit Presentation
At the recent leaders summit of world leaders in Oracle, Java and MySQL user communities I gave a presentation on Why Upgrade to MySQL 5.5 This is a more high level overview presentation, specifically designed for Oracle resources with little to no knowledge about MySQL, however it provides a great management approach to the consideration of using the current MySQL GA version.
Read moreWhy SQL_MODE is essential even when not perfect
In a recent rant on Why I think SQL_MODE is useless… , I wanted to counteract this statement with why we MUST all use SQL_MODE, even with the inherit flaws.
Read moreColorado MySQL Users Group Presentation
In addition to speaking at RMOUG event in Denver, I also spoke today in Broomfield on “Improving MySQL Performance with Better Indexes”. This presentation included details on : Effective examples of capture SQL via application logging and TCP/IP analysis necessary for identifying the best candidates.
Read moreMySQL Security Essentials Presentation
Today at the RMOUG Training Days 2012 event I gave an introduction presentation on MySQL Security Essentials covering the following topics: MySQL Security defaults MySQL Security Improvements OS Security User Privileges Data Integrity Installation Practices Auditing Options Better Security Further References Download slides for MySQL Security Essentials .
Read moreDetermining consulting rates
It can be hard sometimes, particularly with startups to determine what to charge. I have tried various models over the years from nothing, to greatly reduced, to full-price. Nothing works well.
Read moreExciting upcoming MySQL events
At the IOUC leaders’ summit in San Francisco this week, key leaders from Oracle, Java and MySQL user groups world wide have been meeting. This has included the key Oracle MySQL resources from the community, marketing and product teams.
Read more