MySQL Best Practices for DBAs and Developers

This is one of the MySQL presentations I’m doing on the OTN LAD Tour in South America, starting today in Lima, Peru.

MySQL Best Practices for DBAs and Developers

Learn the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Understand what subtle differences between MySQL and other RDBMS products are essential to understand in order to maximize the benefits and strengths of MySQL. We will be covering areas including the minimum MySQL configuration, ideal SQL, MySQL security and schema optimizations.

  • MySQL Configuration default settings including SQL_MODE
    • Documenting, formatting and future proofing your SQL
      • Developing and reviewing all SQL paths
        • MySQL physical and user security
          • The best schema optimizations
            • Essential Monitoring and Instrumentation
Tagged with: Databases MySQL Oracle Oracle/MySQL Conferences South America OTN LAD Tour 2010

Related Posts

Databases MySQL MySQL Events MySQL Sunday at OOW 2010 Oracle/MySQL Conferences

OTN Interview about MySQL

I was interviewed by Justin Kestelyn the OTN Senior Director about MySQL at Oracle Open World this week. Some highlights of the questions asked: 0:55 Since the close of acquisition has there been any change in direction?

Read more
Databases MySQL Uncategorized

Successful MySQL Scalability Presentation

Last night I was the invited guest at the SF MySQL Meetup . In my presentation “Successful MySQL Scalability” I talked about a set of principles to ensure appropriate system architecture, data availability and best practices to build an ideal solution for your business.

Read more
Databases Kaleidoscope 2010 MySQL Oracle/MySQL Conferences

Improving MySQL Productivity – From Design to Implementation

My closing presentation at the dedicated MySQL track at ODTUG Kaleidoscope 2010 discussed various techniques and best practices for improving the ROI of developer resources using MySQL. Included in the sections on Design, Security, Development, Testing, Implementation, Instrumentation and Support were also a number of horror stories of not what to do, combined with practical examples of improving productivity.

Read more