Running PostgreSQL in a Xen DomU?
От | Thomas Harold |
---|---|
Тема | Running PostgreSQL in a Xen DomU? |
Дата | |
Msg-id | 45094556.7020603@tgharold.com обсуждение исходный текст |
Ответы |
Re: Running PostgreSQL in a Xen DomU?
Re: Running PostgreSQL in a Xen DomU? |
Список | pgsql-general |
We're slowly trying to move away from hardware dependence for our servers and it looks like Xen is the path. Our primary goal is that if a particular server fails, we can simply migrate the guest OSs to another Xen node and the users will not experience any downtime. Plus it should allow us to consolidate a few servers. Our database needs aren't that great at the moment, less then 50 concurrent users even at the worst of times. But we might have multi-gigabyte databases that will be queried in bursts and then left alone for a few days. A single CPU is generally fast enough for us. So our current thinking is: - Place PG in a DomU that can be moved from host-to-host as needed - Backend storage would be over a SAN (iSCSI, 9k jumbo frames, dedicated NIC or bonded NICs for the SAN, dedicated switch or VLAN for the SAN) - SAN unit itself would be DRBD'd to a 2nd SAN storage unit. That's down the road a bit once we build out the first few Xen nodes. What I'm not sure of: - Maybe it's better to run PGSQL in Dom0, on 2 different Xen units that are beefed up, with a few lighter DomU guest OSs running in the background. Some sort of heartbeat software that allows the 2 Xen units to grab the PGSQL's IP address as needed. - Performance of PGSQL in a DomU. What are the gotchas? Do we need to export PCI NICs to the PGSQL DomU? (I have a lot of freedom to experiment. As long as services are up and running and things are stable... We're going from individual machine with DAS to a more clustered/virtual environment with SAN.)
В списке pgsql-general по дате отправления: