Infrastructure

Classic Servoy
1

I have a question about infrastructure design.

  1. Should i put the (Oracle) database server and the Servoy server on
    the same server ?
    Or is a 2-tier setup better in performance ?
    Could be 2 physical servers or 2 virtual(Esx) servers

  2. Which is the best platform for Servoy server
    Linux (Redhat) or Windows 2003 ?

I would always go for Linux for the Oracle server, but i do not
know for Servoy.

Regards,

Hans

2

Hans Nieuwenhuis:
I have a question about infrastructure design.

  1. Should i put the (Oracle) database server and the Servoy server on
    the same server ?
    Or is a 2-tier setup better in performance ?
    Could be 2 physical servers or 2 virtual(Esx) servers

  2. Which is the best platform for Servoy server
    Linux (Redhat) or Windows 2003 ?

I would always go for Linux for the Oracle server, but i do not
know for Servoy.

Regards,

Hans

  1. In general a single box will be faster as the appserver and database server communicate a lot so you’ll save a lot of network traffic. But there is no big difference so if you like to have separate boxes that will work fine as well.

  2. Best platform: there are very little differences so best is to choose for the platform you are the most comfortable with. Just like with Oracle my personal choice would be Linux but it runs perfectly fine on Windows as well.

3

Hi Hans,

Regarding point #1

Currently all servers provide 10/100/1000 Base T network interfaces …
So if you are using a Gigabit Network Setup there is almost no fear about the network traffic, especially if you are having a direct cable connection between the two servers.

In addition, you have to make sure that the hard disk drive is fast enough to process the request (10K or 15K RPM)…

My recommendation is, as if you are having two servers, try to install Oracle RAC (Real Application Cluster) 10g or 11g on both servers, in addition to install Servoy Application Server on both machines in a Clustered Environment (Check Apache Tomcat 6.0 (6.0.53) - Clustering/Session Replication HOW-TO)…

The advantage of this structure is that you are having a Fault-Tolerant (Active/Active or Active/Passive) architecture.

Regarding point #2
I fully agree with Mr. Jan Aleman

Hope this really helps you …

4

I tested performance with Windows (Xp sp2) and Linux (redhat As4 upd5).

I have a laptop, dual boot (Xp/Redhat)

I installed Oracle10gr2 and Servoy 3.5.5 on both

I run exactly the same application with exactly the same data.

To my surpise running the application under Redhat is much slower than running it under Xp. (not what i hoped for, i am a linux fan).

I only tested quickly, scrolling true the records is much slower.

Any idea how this can be ??

Regards,

Hans

5

Hi Hans,

From my experience, Oracle needs some extra tuning when installed on Linux…

However, as per oracle, the the best stack is to use Oracle Unbreakable Linux . Please refer to the following URL:

http://www.oracle.com/technologies/linux/index.html

6

I am using Oracle Unbreakable Linux
( but in fact it is Redhat with some changes/addons )

What extra Oracle tuning do you refer to ?

Regards,

Hans

7

Hi Hans,

I don’t think I can give you good answer for this as we don’t have an Oracle DBA experts.

However, I have googled and found the following website:

8

Hi Mohamad,

I will take a look.

Thanks very much.

Hans

9

Hans Nieuwenhuis:
I tested performance with Windows (Xp sp2) and Linux (redhat As4 upd5).

I have a laptop, dual boot (Xp/Redhat)

I installed Oracle10gr2 and Servoy 3.5.5 on both

I run exactly the same application with exactly the same data.

To my surpise running the application under Redhat is much slower than running it under Xp. (not what i hoped for, i am a linux fan).

I only tested quickly, scrolling true the records is much slower.

Any idea how this can be ??

Regards,

Hans

Are you running the client on the same machine? If you are its probably more a client speed test than a server speedtest.

10

Yes i was runnng the client also on the same laptop.

But i also did that for Windows XP (Database, Servoy server and client)

Both (windows and linux) on the same laptop.

Regards,

Hans

11

Hans Nieuwenhuis:
Yes i was runnng the client also on the same laptop.

But i also did that for Windows XP (Database, Servoy server and client)

Both (windows and linux) on the same laptop.

Regards,

Hans

In my experience the UI of the client is slower on Linux so I’m afraid that was influencing your results. I’d rerun the test with a Windows or Linux client on a separate box to get real comparable results.

12

Ok,

Thanks, I will do that.

Hans