Why move from Oracle® MySQL to EDB Postgres Advanced Server

There are many benefits that come from making the move from MySQL to EDB Postgres Advanced Server. Some of the top reasons to make the switch include the following:

  • No-Compromise Feature Set - The lack of enterprise features in MySQL causes developers to code many workaround's that take a lot of time. Such is not the case with Postgres, which is the world's most advanced open source database. Postgres Plus is a robust database that includes many key features that MySQL does not or exceeds what MySQL does offer. Features like the best geo-spatial support found in any open source database, advanced SQL analytic functions, full database link/federation capabilities, table inheritance, and Oracle comparable features are all in EDB Postgres Advanced Server, but are either missing completely or not fully developed in MySQL.
  • Better Security Model - Postgres offers the best security model of any open source database and contains features that rival the best proprietary databases in the market. Security features that EDB Postgres Advanced Server has over MySQL include comprehensive support for external authentication (e.g. PAM, LDAP, SSL, more), security groups/roles, built-in SQL injection attack defenses, stored procedure obfuscation, and detailed security auditing.
  • Great High Availability Options - EDB Postgres Advanced Server contains high availability features that go beyond what is found in the standard MySQL database. In addition to standard replication support (both built-in and provided via third-parties), EDB Postgres Advanced Server also offers hot standby database management (like Oracle Dataguard) and a programmable middleware layer that allows easy load balancing and failover between multiple Postgres nodes.
  • 우수한 개발자 지원 - Postgres는 현재 MySQL에서 볼 수 있는 것보다 우수한 개발 환경을 제공합니다. 개발자들은 Oracle의 PL/SQL, Java, Ruby, Python, Perl, C/C++, Postgres의 프로시저 언어 등을 이용해 저장 프로시저와 함수 등을 작성할 수 있습니다. 뿐만 아니라, Postgres Plus 솔루션은 코드 디버거, 프로그래밍이 가능한 통합 커넥션 풀링, 사용자 정의 오브젝트 유형 지원, 기타 등등도 포함하고 있습니다.
  • 기본적인 데이터베이스 호환성 - 많은 IT 기업들이 Oracle과 MySQL을 동시에 사용하고 있습니다. MySQL과는 달리, Oracle 데이터베이스 담당자의 기술력이 곧장 Postgres로 전해져 기본적으로 데이터베이스 호환성 계층을 이룹니다. DBA와 개발자들은 모든 데이터베이스 코드를 Oracle PL/SQL로 작성해 Postgres Plus에서 실행할 수 있습니다. 더 나아가서, Postgres Plus에는 기타 다양한 Oracle 기능(예: 고속 SQL*Loader 유틸리티)이 있어서 Oracle 전문가 입장에서 볼 때 Postgres로 이전하는 것이 가장 투명합니다.
  • Easier Database Management - EDB Postgres Advanced Server actually exceeds MySQL where management ease of use is concerned. EDB Postgres Advanced Server solutions come with one-click installers, bundled job schedulers, automatic software update notifications, automated software patch management, enterprise graphical monitoring capabilities, GUI administration and SQL querying tools, advanced performance diagnostics (including an Oracle-style wait statistics interface), and other development / administration aids.
  • Advanced Data Warehouse Capabilities - MySQL is known for not being able to scale where large data volumes are concerned, and therefore must rely on third-party software providers (that charge extra licensing fees) for help in supporting "big data" deployments. The EDB Postgres Advanced Server reputation and capabilities are different in that there are many terabyte-sized Postgres data warehouses that are supported in an out-of-the-box fashion.
  • Bundled Heterogeneous Data Management - Many organizations offload data from proprietary RDBMS's like Oracle to open source databases to create reporting solutions or other departmental applications. While there is no easy way to do this with MySQL, EDB Postgres Advanced Server solutions contain replication software to continuously replicate data from other databases like Oracle directly into Postgres. A GUI management console makes the configuration and management of such operations simple and straightforward.
  • 오픈 소스의 독립성 - MySQL과는 달리, Postgres는 독립형 오픈 소스 데이터베이스로서 대규모 전담 커뮤니티가 운영하면서 매년 새로운 또는 보완한 데이터베이스 버전을 지속적으로 개발하고 있습니다. 또, MySQL과는 달리, Postgres에는 사용할 fork를 결정하는 데 혼동이 없습니다.
  • Full Enterprise Support - With EDB, full 24x7x365 support is available for all Postgres editions. Various subscription plans are available so an organization can choose the exact set of options that are right for them. In addition, professional training classes are available as are various consulting packages that help ensure customers are successful with their Postgres implementations.
  • Better Total Cost of Ownership - With EDB Postgres Advanced Server, you get a better database than MySQL at a cost that is actually less than what MySQL costs today. Discover the cost savings yourself - contact an EDB Account Manager now who will help you spend less and get more with EDB Postgres Advanced Server and the EDB Postgres Enterprise software/support subscription.

Start enjoying the benefits that come from making the move from MySQL to Postgres. For more information on getting started with EDB Postgres solutions, please see the following resources: