* haproxy to balance the ro-queries over the 2 servers
In our new setup we will have also new hardware:
cpu: 2x Intel(R) Xeon(R) CPU E5-2643 v3 6C @ 3.4GHz 20MB Cache 2133MHz 135W
ram: 128GB ram (8x 16GB TruDDR4 Memory (2Rx4, 1.2V) PC4-17000 CL15 2133MHz LP RDIMM)
disks: 11x 1.2TB 10K disks + 1x 400GB cache (is a raid controller feature)
raid controller: ServeRAID M5100 Series with 1GB flash cache; ssd caching enabler
network: 10GBs
Since we have a high buffer hit ratio we didn't add extra ram. But the rest of the setup is build for better performance. Due to the price difference between 10K disks and professional SSD disks we chose not to install SSD disks, except one for caching.
But we are still not sure on how to install those servers; except that we will run PostgreSQL 9.4.
Extra features we want to have is 'online upgrades'. Which is possible with the logicial replication feature.
But we are not sure the that logical replication is the best way to do replication for us, since we have commits of data of sometimes more than 1GB. My understanding of the various replication options in PGSQL is that streaming replication will be more performant for those cases?
Since are running multiple 'ETL's' at the same time; we were thinking about installing 2 PGSQL instances on the 2 servers, and run one instance as master, and one as slave on the both servers. But I'm not sure if that is a super idea, because the 2 instances might want to fight for the available memory?
Anyone who can shed a light on this?
This is the architecture we would like to keep for the next 5 years.
wkr,
Bert
--
Bert Desmet
0477/305361