Blog
MySQL 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 .
Determining 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.
Exciting 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.
Why is searching the manual so hard
As a consultant I often use the MySQL Reference Manual to provide additional information for clients. I am very happy to recognize the quality of the content in the MySQL documentation, but why is the searching of the manual so, so bad?
The most important MySQL Reference Manual page
In my opinion, The Server Option and Variable Reference at http://dev.mysql.com/doc/refman/5.5/en/mysqld-option-tables.html rates as my most important page. This is a consolidated index that enables a drill down to the Server Command Options, System Variables, Startup and replication specifics, as well as important information on default values and differences between versions including point releases.
Binary Log Replayer
When using the replication slave stream, or mysql command line client and mysqlbinlog output from a binary/relay log, all statements are executed in a single thread as quickly as possible.
Speaking in Denver
Following a heavy schedule in the last month speaking in Tokyo , Beijing, Manila and Auckland it is nice to be on home soil for upcoming speaking. I will be in Denver, Colorado for RMOUG 2012 from February 14-16, 2012 where I will be speaking about the essentials of MySQL security.
Do you have a MySQL horror story to share?
I am looking for a few more unique examples to add to the final chapter of my upcoming book on MySQL Backup & Recovery . If you would like to share your fun experience, receive a mention and a free copy please let me know via comment.
NoSQL from a RDBMS company
Oracle has announced an open source product for the NoSQL space, the Oracle NoSQL Database . Unlike other popular products including Redis, MongoDB, Cassandra, Voldermort and many others, Oracle has set a benchmark on the features that are truly necessary for highly available data systems.
Oracle Open World Presentations
<p> At <a href="http://orancle.com/openworld">Oracle Open World 2011</a> there has been a large number of MySQL presentations. You can download the slides of my two presentations at <a href="http://effectivemysql.com/downloads/ExplainingTheMySQLEXPLAIN-OOW-2011.pdf">Explaining the MySQL Explain</a> and <a href="http://effectivemysql.
The Effective MySQL Book Series
Announced on Sunday at Oracle Open World 2011 is the release of the Effective MySQL book series starting with the “Optimizing SQL Statements” title. The goal of the Effective MySQL series is a highly practical, concise and topic specific reference providing applicable knowledge to use on each page.
Visualizing reqstat
The reqstat tool was written to provide a vmstat like output of total web requests happening in real time. This really lightweight monitoring leverages memcached and has a trivial impact for immediate benefit.
Visualizing crowd sourcing data
At the closing keynote of the recent Strata Summit in New York, O’Reilly Media founder Tim O’Reilly showed a representation of crowd sourced data on Wikipedia of the 2011 Tōhoku earthquake and tsunami , showing a before and after picture of the page.
Speaking at Insight Out in Tokyo
I will be joining a stellar class of speakers at the Insight Out DB Showcase in Tokyo from Oct 19-21, 2011. This event covers several RDBMS technologies including MySQL. My topics are: