MySQL Users Conference 2009 Day 2

Guest Author

I presented on href="http://www.mysqlconf.com/mysql2009/public/schedule/detail/6861">Creating
Quick and Powerful Web Applications with MySQL, GlassFish, and NetBeans.
The key messages conveyed during the preso are:
  • GlassFish
    is an open source community and delivers production-quality Java EE
    compliant Application Server.
  • GlassFish v2 is the Java EE 5 Reference Implementation and
    GlassFish v3 for Java EE 6. Read complete difference href="https://glassfish.dev.java.net/public/comparing_v2_and_v3.html">here.
  • Java Persistence API makes it really easy to create
    database-backed Web applications. It even creates href="http://blogs.sun.com/arungupta/entry/totd_78_glassfish_eclipselink_and">MySQL-specific
    queries, when possible.
  • The web-based administration console and CLI are powerful
    GlassFish management tools that meets the need of any IT administrator.
  • NetBeans
    provides comprehensive and seamlessly integrated tooling for GlassFish.
    The goal is to make the href="http://blogs.sun.com/arungupta/entry/glassfish_tools_bundle_for_eclipse">Eclipse
    tooling at par with NetBeans.

The slides are available href="http://blogs.sun.com/arungupta/resource/confs/mysql-uc-2009-glassfish.pdf">here.

And then notes from some of the sessions I attended:

of the Dolphin
  • 12+ million users, 70k downloads/day, 1100 MySQL Partners
  • Multiple platforms: LAMP, Windows, Mac, OpenSolaris,
    Solaris, RedHat,
    Suse, Ubuntu
  • Multiple Languages: php, Perl, Python, Ruby, Java, C, C++,
  • MySQL 5.1: 3 million downloads in 100 days
  • href="http://dev.mysql.com/tech-resources/articles/mysql-54.html">MySQL
    announced: InnoDB Scalalbility, Sub-query optimizations, 59% faster
    than 5.1, 40% improvement in read/write test, 71% throughput increase
  • InnoDB:
    Fast index creation (add/drop indexes w/o copying the data), Data
    compression (shrink tables, to significantly reduce storage and i/o)
  • Embedded
    InnoDB (announced today): Proven high-performance and reliability and
    functionality of InnoDB, low-level but powerful non-SQL API for app
    programmers, operational characteristics needed for stand-alone apps
    where there is no DBA
  • Dr DBA was awarded "Acquirer of the Year: Oracle" :-)
  • MySQL Cluster 7.0: 99.999% availability, 4.3x higher
    throughput, 140k+
    TPM and 4x less power and consumption than 6.3
  • MySQL
    Query Analyzer: Continuous query monitoring, find and fix problem SQL
    code, historical and real-time analysis, drill down into execution

Innovative Technologies for Performance and Data Protection
  • Dr Heikki Tuuri, was professor at Helsinki, founded
    Innobase, got
    acquired by Oracle
  • Performance and Data Integrity are basic features
  • Architected and written by one person
  • Full transaction support, Unlimited row-level locking,
    read-consistency, automatic deadlock detection
  • Innovative: adaptive hash indexes, insert buffer ( href="http://mysqlha.blogspot.com/2008/12/innodb-insert-performance.html">performance
    benefits), doublewrite buffer, InnoDB plugin
  • Oracle/Innobase + Sun/MySQL

MySQL, Enter Drizzle
  • Goals
    • Pluggable/Infrastructure Aware
    • Community Developed
    • Multicore/Concurrency (load up 10,000 connections in db)
    • Focus on Web applications/enable others
    • Modernize codebase for manageability (currently C/C++,
      can we reuse STL and other libraries)
  • Philosophies
    • Have open and well-documented interfaces
    • Have transparent goals and processes, that are
      communicated publicly
    • Have fun and encourage collaboration
    • Remove barriers to contribution and participation for
    • Enable contributors to build a business around Drizzle
  • Drizzle announced at OSCON last year
    • Translated into 30+ languages since then
    • 7% of developers are from Sun
    • 100+ contributors (>500 on the mailing list), even
      Postgres and Firebird developers \\
    • href="https://launchpad.net/drizzle/+milestone/cirrus">Cirrus
      available now, href="https://launchpad.net/drizzle/+milestone/aloha">Aloha
    • href="http://drizzle.org/wiki/Drizzle_Developer_Day_2009">Drizzle
      Developer Day 2009 scheduled this Friday
    • No patches are contributed back to MySQL Enterprise
    • Will be ready for production deployment Jun 2010
  • References

Performance Rails and MySQL
  • David Berube: Apress books on "Author Practical Ruby Gems",
    "Practical Rails Plugins", "Practical Reporting with Ruby on Rails"
  • Finding performance issues in Rails
    • Rails development log
    • eabe_db_tools: Ajax popup- displays query count, query
      each time for a each query on a page. Will be available on github next
    • href="http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html">mysql_slow_log
    • Is it a database problem: Firebug, YSlow, Ping, tracert,
  • Let the database do the heavy lifting instead
    of Ruby: for example, don't sort in Ruby
  • Deep eager loading: don't load that is not required
  • Use built-int Rails grouping and aggregate functions
  • Caching: simple ootb caching, Cache Fu, MySQL triggers for
    DB function caching, Rails triggers for other caching

Did you know 1.3 billion emails were sent as part of href="http://my.obama.com">Obama's election
campaign - and all powered by MySQL ? Hear the details from href="http://www.bluestatedigital.com/">Blue State Digital
engineers who created the solution and maintained it:

value="http://www.youtube.com/v/Dg9tdW83YVo&hl=en&fs=1"> name="allowFullScreen" value="true"> name="allowscriptaccess" value="always">
type="application/x-shockwave-flash" allowscriptaccess="always"
allowfullscreen="true" height="385" width="640">

And you can always read the href="http://www.bluestatedigital.com/casestudies/client/obama_for_america_2008/">complete
case study.

Some pictures from earlier today ...

style="width: 288px; height: 216px;" alt=""
style="width: 288px; height: 216px;" alt=""
style="width: 288px; height: 216px;" alt=""
style="width: 288px; height: 216px;" alt=""
style="width: 216px; height: 288px;" alt=""
style="width: 288px; height: 216px;" alt=""

And then the evolving picture album is available at:

Come meet us at the GlassFish booth in the href="http://www.mysqlconf.com/mysql2009/public/content/exhibitors">Exhibit
Or you can stop by at room #205 for the Whisper Suite for a more
personal and 1-1 conversation.

Technorati: conf

Join the discussion

Comments ( 4 )
  • Rick Wills Wednesday, April 22, 2009

    Where is there a decent Glassfish hosting service I can try out before I buy?

  • Arun Gupta Wednesday, April 22, 2009

    Linode, Joyent, EveryCity, Contegix, Ostatic, Hyperic are some that offer hosting services for GlassFish. I don't have experience with any of them.

  • neon tabela Sunday, April 26, 2009


  • neon Sunday, April 26, 2009

    thank you

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.