Network
Join Attendee Network
 

Mixed MySQL/PostgreSQL Environments

Jeff Davis (Aster Data)
11:55am Wednesday, 04/13/2011
Architecture and Technology, PostgreSQL
 Location: Ballroom D
Tags: mysql, postgresql

MySQL dominates many OLTP environments due to application support, high transaction rates, and low connection overhead. PostgreSQL has a powerful extension mechanism that offers great flexibility, a powerful query language, a robust type system, and a cost-based optimizer that can efficiently execute sophisticated queries.

It’s possible to take advantage of both systems by using MySQL to record transactions, then consolidating data from multiple MySQL-based applications into PostgreSQL while checking for inconsistencies. Then, you can run cross-application analytics efficiently and have confidence in the result.

Jeff Davis

Aster Data

Jeff Davis has been a member of the PostgreSQL community for more than 10 years. He’s contributed two major features – Synchronized Scans and Exclusion Constraints – and participated in patch review, conferences, and user groups.

Jeff works on DBMS internals for Aster Data, a data warehouse software company focused on analytics.

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

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

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts