nycpug_comparin g_postgresql_an d_mysql.pdf - Meetup

frightenedfroggeryData Management

Dec 16, 2012 (4 years and 10 months ago)

110 views



NYCPUG
PostgreSQL
&
MySQL


PostgreSQL Strengths


Strong Advanced Features
GeoSpatial Queries
Full Text Search
Stored Procedure Languages
Point In Time Recovery
Advanced Data Types
Many More...


Strong Security
Object Level Privileges assigned to “Roles &
User”
Kerberos + SSL communication
Data Level Encryption (AES, 3DES, etc)
Ability to utilize 3rd party Key Stores in a full PKI
infrastructure


Data Integrity
Multi Version Concurrency Control
Write Ahead Logging
Online Backup
Foreign Keys
Constraints


Flexible License
Similar to BSD and MIT licenses
Corporate IT developers can modify
open source code under the
PostgreSQL License without having to
contribute back enhancements
Independent Software Vendors are free
to redistribute without the fear of being
“infected” by an open source license


Community
Independent Development Community
~20 committers and ~200 reviewers
1,500 contributors and 15,000+
members

6,000,000+ downloads / year
20+ years of development


MySQL Strengths


Performance
Low overhead MyISAM storage engine
for read mostly applications
Memory storage engine for frequently
accessed tables
Query Cache for frequently used
statements


Pluggable Storage Engines
Native Storage Engines
MyISAM
Memory
InnoDB
Federated

Merge
Partner Developed Storage Engines
SolidDB
Infobright


High Availability
Master-Slave Replication
Very easy to set up for scale-Out Implementations
Offload Reporting
Geographic Data Distribution
Statement and row-based option
MySQL Cluster
99.999% availability


Corporate Backing


Popularity
Independent Software Vendor Support
Availability of experienced resources
Easily accessible information from
various sources such as whitepapers,
blogs, and books


Storage Comparison


PostgreSQL Storage


PostgreSQL Page


MySQL Storage


InnoDB Storage


InnoDB Page