際際滷

際際滷Share a Scribd company logo

xDB 5.0シングルマスタ`C嬬h苧 シングルマスタ`

?
?
Yuji Fujita
Yuji Fujita

Mewtec 室g云何L　互Q掎諒呂砲茲襦XDB 5.0のシングルマスタ`C嬬のB初

1 of 7
Download to read offline
xDB Replication Server 5.0 ! ? 2012 EnterpriseDB. All rights reserved. 1
PPAS xDB 5.0 / Features PostgreSQL u?? PPAS/ PostgreSQL褒圭で旋喘辛嬬 u?? PPAS / Solution Packに揖y ?? EnterpriseDBでサポ`ト u?? 和撹における、燕レベルでのレプリケ`ションC嬬をg廾 ?? シングル?マスタ`?レプリケ`ション [SMR] ! (マスタ`?スレ`ブ?レプリケ`ション)! ! ?? マルチ?マスタ`?レプリケ`ション [MMR]! New ? 2012 EnterpriseDB. All rights reserved. 2
xDB 5.0 / SMR C嬬 u?? Replication ServerによるPublication/Subscriptionア`キテクチャ(匯圭 ) u?? スナップショット?モ`ドと揖豚モ`ド(餓蛍厚仟) u?? 仇尖議にxれたマスタgのデ`タ揖豚が辛嬬な仝掲揖豚々参シ淑 u?? 匯つ參貧のテ`ブルをレプリケ`ション辛嬬 u?? 佩フィルタ`の協xとm喘 u?? 悲なスケジュ`ル u?? カスケ`ド?レプリケ`ション u?? レプリケ`ション堕sの歌孚 u?? GUIコンソ`ルとCLI u?? 互辛喘來I囃への旋喘 u?? OLTPI尖とレポ`ティングI尖の蛍け ? 2012 EnterpriseDB. All rights reserved. 3
xDB 5.0 / SMR Offloading Reporting Oracle ?Server ? Improved ? Inexpensive ? OLTP ? Query ?/ ? Procs ? Performance ? Repor9ng ? ? ? ? Objects ? ? ? ? Transac3on ? ? Reports ? Replica3on ? Queries ? ? Postgres ?Plus ? ? Table ? Table ? Standard ?Server ? ?A ? ?C ? Con9nuous ? or ?Scheduled ? Table ? Table ? -?\-?\-?\-?\-?\-?\-?\-?\-?\-?\-?\-?\-?\-?\-?\-?\ ? Table ? Table ? ?B ? ?D ? Filtered ? ?C ? ?D ? or ?All ?Rows ? ? ? 2012 EnterpriseDB. All rights reserved. 4
xDB 5.0 / SMR デ`タベ`ス サポ`ト マトリックス Advanced Advanced Source/Target Oracle MS SQL Server PostgreSQL Server Server 2005/2008 (Oracle mode) (PostgreSQL mode) Oracle ＄ ＄ ＄ MS SQL Server 2005/2008 ＄ ＄ ＄ PostgreSQL ＄ ＄ ＄ ＄ Advanced Server (Oracle mode) ＄ ＄ ＄ Advanced Server (PostgreSQL ＄ ＄ ＄ ＄ mode) ? 2012 EnterpriseDB. All rights reserved. 5
xDB 5.0 / SMR vs PostgreSQL Replication PostgreSQL Slony EnterpriseDB Streaming Replication xDB Replication Feature Replication Server Configuration Simple Complex Complex Flexibility 1:1 or 1:n 1:1 or 1:n or 1:n:n´ 1:1 or 1:n or 1:n:n´ Primary Use High Availability Offload Reporting Offload Reporting Offload Boost Performance Boost Performance Reporting* Type Single Master Single Master Single or Multi-Master Granularity Database Cluster Table Table with Row Filters Technology Log based Trigger based (C) Trigger based (PL/ pgSQL) GUI Tools none Minimal in pgAdmin Robust GUI and CLI Oracle / MS SQL No No Yes Server Support Cost $0 Free 3rd Party OSS Included in Subscription * Requires setting up Hot Standby mode. ? 2012 EnterpriseDB. All rights reserved. 6
Thank You! ? 2012 EnterpriseDB. All rights reserved. 7

More Related Content

xDB 5.0シングルマスタ`C嬬h苧 シングルマスタ`

  • 1. xDB Replication Server 5.0 ! ? 2012 EnterpriseDB. All rights reserved. 1
  • 2. PPAS xDB 5.0 / Features PostgreSQL u?? PPAS/ PostgreSQL褒圭で旋喘辛嬬 u?? PPAS / Solution Packに揖y ?? EnterpriseDBでサポ`ト u?? 和撹における、燕レベルでのレプリケ`ションC嬬をg廾 ?? シングル?マスタ`?レプリケ`ション [SMR] ! (マスタ`?スレ`ブ?レプリケ`ション)! ! ?? マルチ?マスタ`?レプリケ`ション [MMR]! New ? 2012 EnterpriseDB. All rights reserved. 2
  • 3. xDB 5.0 / SMR C嬬 u?? Replication ServerによるPublication/Subscriptionア`キテクチャ(匯圭 ) u?? スナップショット?モ`ドと揖豚モ`ド(餓蛍厚仟) u?? 仇尖議にxれたマスタgのデ`タ揖豚が辛嬬な仝掲揖豚々参シ淑 u?? 匯つ參貧のテ`ブルをレプリケ`ション辛嬬 u?? 佩フィルタ`の協xとm喘 u?? 悲なスケジュ`ル u?? カスケ`ド?レプリケ`ション u?? レプリケ`ション堕sの歌孚 u?? GUIコンソ`ルとCLI u?? 互辛喘來I囃への旋喘 u?? OLTPI尖とレポ`ティングI尖の蛍け ? 2012 EnterpriseDB. All rights reserved. 3
  • 4. xDB 5.0 / SMR Offloading Reporting Oracle ?Server ? Improved ? Inexpensive ? OLTP ? Query ?/ ? Procs ? Performance ? Repor9ng ? ? ? ? Objects ? ? ? ? Transac3on ? ? Reports ? Replica3on ? Queries ? ? Postgres ?Plus ? ? Table ? Table ? Standard ?Server ? ?A ? ?C ? Con9nuous ? or ?Scheduled ? Table ? Table ? -?\-?\-?\-?\-?\-?\-?\-?\-?\-?\-?\-?\-?\-?\-?\-?\ ? Table ? Table ? ?B ? ?D ? Filtered ? ?C ? ?D ? or ?All ?Rows ? ? ? 2012 EnterpriseDB. All rights reserved. 4
  • 5. xDB 5.0 / SMR デ`タベ`ス サポ`ト マトリックス Advanced Advanced Source/Target Oracle MS SQL Server PostgreSQL Server Server 2005/2008 (Oracle mode) (PostgreSQL mode) Oracle ＄ ＄ ＄ MS SQL Server 2005/2008 ＄ ＄ ＄ PostgreSQL ＄ ＄ ＄ ＄ Advanced Server (Oracle mode) ＄ ＄ ＄ Advanced Server (PostgreSQL ＄ ＄ ＄ ＄ mode) ? 2012 EnterpriseDB. All rights reserved. 5
  • 6. xDB 5.0 / SMR vs PostgreSQL Replication PostgreSQL Slony EnterpriseDB Streaming Replication xDB Replication Feature Replication Server Configuration Simple Complex Complex Flexibility 1:1 or 1:n 1:1 or 1:n or 1:n:n´ 1:1 or 1:n or 1:n:n´ Primary Use High Availability Offload Reporting Offload Reporting Offload Boost Performance Boost Performance Reporting* Type Single Master Single Master Single or Multi-Master Granularity Database Cluster Table Table with Row Filters Technology Log based Trigger based (C) Trigger based (PL/ pgSQL) GUI Tools none Minimal in pgAdmin Robust GUI and CLI Oracle / MS SQL No No Yes Server Support Cost $0 Free 3rd Party OSS Included in Subscription * Requires setting up Hot Standby mode. ? 2012 EnterpriseDB. All rights reserved. 6
  • 7. Thank You! ? 2012 EnterpriseDB. All rights reserved. 7