Gearing up MySQL: Implementing MySQL Synchronization for Browser-based Apps Using an Embedded Database (Powered by Google Gears)

Roland Bouman (XCDSQL Solutions / Strukton Rail)
Average rating: **...
(2.40, 5 ratings)

The features offered by Google Gears (but also the upcoming HTML 5 standard, and the Webkit browser framework) allow Ajax developers to create rich, fully fledged database applications that have to ability to be partially or even completely off-line.

Access to an off-line database as provided by google gears offers great opportunities to increase the availability as well as the scalability of regular web-applications:

  1. Users can continue with data entry and retrieval even when the connection is lost or the central database server is down.
  2. Chatty conversations with the database can be taken offline, offloading the central database server by only storing the result of a transaction in the central database, shortening the number and duration of database server sessions.
  3. Complex queries can be executed offline, utilizing the clients processing power rather than the server’s

One of the recurring themes in creating Gears applications that utilize the embedded database is how to implement synchronization to a central relational database server. This talk describes in detail a number of different approaches to creating Google Gears database applications and synchronizing the local google gears database to an online MySQL database.

Rough outline:

Google Gears

  • features
  • API

Offline architectures

  • synchronization
  • conflict resolution

Practical Implementation

  • creating and using the local database
  • setting up a workerpool
  • processing local SQL requests with the workerpool
  • using the workerpool for background synchronization
  • database schema requirements for various synchronization techniques
  • security
Photo of Roland Bouman

Roland Bouman

XCDSQL Solutions / Strukton Rail

I’m a Web Application and Business Intelligence developer and I authored two books about the Pentaho Open Source Business Intelligence stack: “Pentaho Solutions” (ISBN 978-0470484326) and "Pentaho Kettle Solutions (ISBN 978-0470635179). I’m an active member of the MySQL and Pentaho communities. In the past, I worked for Inter Access, MySQL AB, Sun Microsystems. I currently work for Strukton Rail.

Comments on this page are now closed.

Comments

Picture of Peter Thung
04/28/2009 2:05pm PDT

Even though it wasn’t complete, I thought it showed pretty good promise. I quite enjoyed it. I wonder if even the incomplete slides might be made available and then updated if and when he chooses to complete it. Some questions I have are. 1. If you start out with a disconnected environment to the server, would it be possible to have a a client side view of the web interface to still show up? Would you essentially create or replicate the server generated web interfaces wthin your client side google gears environment so that if you start out disconnected, you can still operate “Disconnected”.

2.

Picture of Chuck Hagenbuch
04/22/2009 2:50pm PDT

Presentation wasn’t done, and the MySQL-relevant bit (syncing gears db with a MySQL db) was completely missing. The speaker was completely up front about this, but especially given the title, it was pretty disappointing.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.