计算机应用与软件
計算機應用與軟件
계산궤응용여연건
COMPUTER APPLICATIONS AND SOFTWARE
2013年
12期
229-231,251
,共4页
刘钢%陈荣华%潘高峰%卢盛祺
劉鋼%陳榮華%潘高峰%盧盛祺
류강%진영화%반고봉%로성기
流复制%电子商务%数据库%扩展性
流複製%電子商務%數據庫%擴展性
류복제%전자상무%수거고%확전성
Streams replication%E-commerce%Database%Scalability
随着B4 C电子商务的高速发展,数据库渐渐成为瓶颈,很多B4 C电子商务系统都需要将现有数据库根据业务进行拆分,因此要考虑数据复制的问题。现有的系统一般采用读写分离来进行数据复制,数据复制粒度相对较粗,写操作容易成为瓶颈。使用流复制可以很方便地按照表或者表空间进行复制,并且支持双向复制,可以很容易地把现有系统扩展到多个数据库,从而提升系统的性能和扩展性。
隨著B4 C電子商務的高速髮展,數據庫漸漸成為瓶頸,很多B4 C電子商務繫統都需要將現有數據庫根據業務進行拆分,因此要攷慮數據複製的問題。現有的繫統一般採用讀寫分離來進行數據複製,數據複製粒度相對較粗,寫操作容易成為瓶頸。使用流複製可以很方便地按照錶或者錶空間進行複製,併且支持雙嚮複製,可以很容易地把現有繫統擴展到多箇數據庫,從而提升繫統的性能和擴展性。
수착B4 C전자상무적고속발전,수거고점점성위병경,흔다B4 C전자상무계통도수요장현유수거고근거업무진행탁분,인차요고필수거복제적문제。현유적계통일반채용독사분리래진행수거복제,수거복제립도상대교조,사조작용역성위병경。사용류복제가이흔방편지안조표혹자표공간진행복제,병차지지쌍향복제,가이흔용역지파현유계통확전도다개수거고,종이제승계통적성능화확전성。
With the fast development of B4C e-commerce, the database has gradually become a bottleneck of the businesses that use single database.Many B4C business systems need to split their databases based on business logic so data replication must be taken into consideration .Reading and writing are generally separated in data replication for current systems , the granularity of data replication is relatively coarse, and the writing operation tends to be a bottleneck .Streams replication makes it convenient to replicate data according to tables or tablespace , it also supports bi-directional replication , so that the current systems can be easily extended to multiple databases .These result in enhanced scalability and performance of the system .