SCM

[#1010969] a way to increasing pgcluster speed

View Trackers | Feature Requests | Download .csv | Monitor

Date:
2010-12-29 13:50
Priority:
3
State:
Open
Submitted by:
johnson hsu (johnson0324)
Assigned to:
Atsushi Mitani (mita2)
Category:
Group:
Summary:
a way to increasing pgcluster speed

Detailed description
Hi!

I just install pgcluster in my company for weeks, It's perfect.

Because of network traffic problem, pgcluster is hard to be a big cluster system.
If there're ten cluster db in the system, when user request one time, the replicate must run nine times at lease. It will cause network jam.

I've an idea, using brocasting method. When loadbalance server received a request, It make a brocasting to all clusters DB with data in it, and every culster db use a standard TCP to tell loadbalance server it had received or not.

with this method, the best situation is just only one time data transfer, the effect of pgcluster will be the same to stand alone DB does while updating data, and it's will be suitable to be a cloud DB.



Best Regards

Johnson

Followup

No Followups Have Been Posted

Attached Files:

Changes:

Field Old Value Date By
assigned_tonone2010-12-29 13:51johnson0324
Powered By FusionForge