Databases
Encrypting your MySQL backups and more
Assuming you have a backup and recovery strategy in place, how secure is your data? Does a hacker need to obtain access to your production system bypassing all the appropriate security protection you have in place, or just the unencrypted data on the backup server?
Read moreWhat compression do you use?
The following is an evaluation of various compression utilities that I tested when reviewing the various options for MySQL backup strategies. The overall winner in performance was pigz, a parallel implementation of gzip.
Read moreRecent Presentations Buenos Aires MySQL/NoSQL/Cloud Conference
The first annual Latin America MySQL/NoSQL/Cloud Conference was held in Buenos Aires Argentina from June 26-28. Kudos to Santiago Lertora from Binlogic who had the vision for the conference in his country and made it happen.
Read moreUpcoming MySQL Connect Presentations
The MySQL Connect 2012 conference event being held in San Francisco on Sep 29-30 has a long list of quality MySQL speakers including myself. I will be giving 2 presentations on:
Read moreRecent Presentations at Charlotte South East LinuxFest
At the recent South East LinuxFest in June 2012 I gave two MySQL presentations. The first was on Explaining the MySQL Explain . This presentation details the MySQL Query Execution Plan (QEP) of an SQL statement and how to understand and interpret the information from the EXPLAIN command.
Read moreREPOST: A Tragically Comedic Security Flaw in MySQL
“In short, if you try to authenticate to a MySQL server affected by this flaw, there is a chance it will accept your password even if the wrong one was supplied.
Read moreThe black vodka MySQL tradition
Many do not need any further introduction to this Monty tradition at MySQL events. For the New York Effective MySQL Meetup group this was a new experience for many that I had the opportunity to share at our recent meeting.
Read moreSouth America Speaking Events
Following my 2 presentations at SouthEast LinuxFest on Friday and Open DB Camp on Sunday in Charlotte, NC, I will then be speaking at the first Latin America MySQL event in Buenos Aires, Argentina later this month.
Read moreUTF-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 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 more