Planing for below environment on Proxmox in prod system. Please advise!!

B

blason16

Member
Jan 16, 2012
59
0
6
Hi Folks,

I am planning to deploy Oracle Database and Application server on Proxmox server. Please advise what precaution I need to take care before I move forward.
Has anyone already deployed it? Or does any one have any use case? I really would appreciate if someone can provide me help here

my proxmox Host configuration would be

[FONT=arial, sans-serif]Proxmox Node = BL 460 blade 2.53 GHz x 2 CPU(dual CPU) 8 cores each CPU, 24 GB RAM[/FONT]

[FONT=arial, sans-serif]And on that Virtual machines would be [/FONT]

[FONT=arial, sans-serif]A.] Oracle Database Server On windows 2008 Server= 4GB RAM [/FONT]
[FONT=arial, sans-serif]B.] Oracle Application Server on Windows 2008 Server = 4GB RAM[/FONT]
[FONT=arial, sans-serif]C.] Native Application, Windows 2008 Server = 4GB RAM[/FONT]


[FONT=arial, sans-serif]Now can someone please let me know [/FONT]
[FONT=arial, sans-serif]1. If 4GB RAM would be sufficient if anyone had already tried deploying Oracle on Windows on Proxmox?[/FONT]
[FONT=arial, sans-serif]2. Can we take a hot backup of VMs if the machine is Windows [ I played lot with Linux, but haven't had a chance to install Windows]
[/FONT]3. Or Do I need to suspend the machine and then back it up?
4. Can I use resource pool here to have optimized performance?

Please advise
 
First: Never, ever run an Oracle database on Windows, performance sucks! Windows is a second class citizen in the Oracle domain.
Second: If you require decent write performance the underlying storage must provide high IOPS. So using anything else than SAS RAID 10/50/60 or SSD for the storage is a no-go. If you a going for HA then forget about DRBD, you must use a SAN or a high performance NAS. The application server will live happily in a virtual machine except if the application server is having 100000 of hits every day and the application server hosts the OID locally.
 
Thaks for your reply. So which OS would you suggest for Database RHEL or Unbreakable Linux? And definitely we are gonna use SAN or NAS for storage or if not then local SAS disks for storage. But one point I would like to specify here is; this is an Test environment "UAT" environment where development will be tested before deploying into production and I guess hardly there would any load on systems. That is the reason I allocated 4GB RAM for Db as well as application server.

How about configuring High Performance iSCSI as a storage option? Would that degrade the performance? OR I need to go for FC/SAN
 
OS: Oracle 10g: RHEL 5 or Solaris 10 11g: RHEL 6 or Solaris 11
Storage: iSCSI is fine as long as the connection is at least 1 GB and the storage is partitioned on SAS RAID 10/50/60 or RAID 1 on top of two Intel 520 SSD. Alternatively replace RAID with a stripe mirrored ZFS pool (I have recently tested FreeNAS and NAS4Free which both provide excellent performance. If you want to squeeze the last drop of stability and performance out of the ZFS pool a Solaris should give you bang for the buck. If was suggested OpenIndiana+nappit (http://www.napp-it.org/index_en.html) it did perform well but for my low power consuming setup OpenIndiana/Solaris seemed a bit to heavy. It is also my impression that OpenIndiana/Solaris + nappit requires some more knowledge to operated when compared to FreeNas/NAS4Free. In the end I have choosen NAS4Free since it fitted more close with my hardware.
 
Perhaps obvious: re UAT:
1. of course also depends on whether the specs require realistic (comparable to the prodution environment) load/stress testing.
2. will the UAT environment perhaps also be usable as a disaster recovery solution (e.g. in another location to the production environment)?
These points reinforce the importance of keeping UAT and production hardware/configuration as similar as possible... but looking at your question I'm thinking you'll be going from designing the UAT environment, (load/stress/acceptance etc) testing it to going through a beefed-up version for production so that may be less relevant.
 
blason16 said:
Hi Folks,

A.] Oracle Database Server On windows 2008 Server= 4GB RAM
Click to expand...

Not related to kvm, but in general for database, try to have enough memory to handle your database in buffer, so disk access will be reduce. (don't try a 100GB database on a 4GB ram server ;)
 
Well not exactly. This wont be used for DR purpose. This is purely gonna be UAT environment; Even I am seriously considering RHEL rather than Windows but since I already have lics available for 2k8 R2 Enterprise, I at this moment might not wanna spend on RHEL. Or even I thought of CentOS but not sure if Oracle support contract would void.

So, folks if I decide to go for RHEL what would you recommend on Proxmox front a Container or VM machine? Which would give me better performance and of course backup is the most critical thing. This needs to be backed up every night. Hence considering all the factors.

Even if I choose to go with Windows will it be backed up like Linux flavors? [I really never tried installing Windows on PMX; I am big time windows hater ;-D ]
 
We just use oracle databease in our network. And now did plan to virtualize W2008 R2 with orcale database. As for windows our softwarehouse did tell us this won' t work. And we could only us the virtualization tools from oracle.
 
You mean to say Oracle wouldnt work with Windows on Proxmox :( . That's really sad. Are there any other alternatives available

And what exactly you mean by Virtualization Tools from Oracle. You mean virtualbox
 
No, Oracle do support running it virtualized but if problems occurs which cannot be solved using the known fixes then Oracle will require you to replicated the error on a physical server. For windows Oracle generally just performs bad.
 
OK - Now I am completely confused here!!

1. First Can we run oracle on Proxmox using Linux? If yes What configuration would you recommend then?
OR
2. You wouldnt recommend virtualizing Oracle at all on Proxmox no matter if it Linux or windows

Just to elaborate more there would be hardly 5 users will be working on Oracle DB and it is completely an UAT environment.
 
For your requirements providing sufficient storage it would be perfectly ok to virtualize oracle in a RHEL VM on Proxmox. If you are only ever going to be more than 5 users then Oracle 11g XE would be more than enough.
"Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 11GB of user data, use up to 1GB of memory, and use one CPU on the host machine."
 
So my take away is; Oracle can be virtualized if the guest OS is RHEL and big no no no if it is Windows.
 
Yes and no. Yes Oracle can be virtualized and No to that Oracle cannot be virtualized on Windows - Oracle just performs bad on Windows. This has nothing to do with running virtualized or not but simply because the Windows port of oracle is performing badly. If you insist on using Windows then my advice would be to choose MSSQL as database. MSSQL performs well on Windows, also running virtualized.
 
You must log in or register to reply here.
Top Bottom