Forum Stats

  • 3,875,465 Users
  • 2,266,926 Discussions
  • 7,912,225 Comments

Discussions

COVID-19 OLS(Online Learning System)

Beauty_and_dBest
Beauty_and_dBest Member Posts: 8,015 Bronze Crown
edited Sep 14, 2020 9:55PM in General Database Discussions

12c

OL7

Hi ALL,

Due to COVID-19,  schools  are now closed  and  are  engaged in OLS.

Students and teachers must study/Learn at home using OLS.

We have an OLS system   and is hosted  in  Cloud.

But when 1000+  students/teachers  accessed it simultaneously, we get error > Request timeout

The OLS Homepage very slow to open or or frozen..

Our server specs is 8 CPU  and 32Gb Memory.

We checked CPU/Memory usage and it is average only

What resource do we need to address?

Anybody here has experienced on online apps which has lots of simultaneous read/write access?

Please help.....

Kind regards,

Tubby[Deleted User]Maaz Khan
«13

Answers

  • Sunny kichloo
    Sunny kichloo Member Posts: 2,460 Gold Trophy
    edited Aug 12, 2020 5:28AM

    On what logs you are getting request timeout message?What is the exact error message you are receiving

    Apart from resources was there any network issue that have encountered during this specific time

    Beauty_and_dBest
  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,946 Red Diamond
    edited Aug 12, 2020 5:49AM

    Number of concurrent connections need to support the userbase.

    E.g. if the connection or thread pool is set to 10, then for a 1000 users userbase, where a 100 (10%) users are active at the same time, 90 users are waiting for a response with 10 users being serviced.

    Depends on the architecture used, on what to configure where.

    Beauty_and_dBest
  • Beauty_and_dBest
    Beauty_and_dBest Member Posts: 8,015 Bronze Crown
    edited Aug 12, 2020 6:42AM

    Thanks Sunny and Billy,

    I am not really a network person.

    I think our bottle neck is network transfer? What resource do we need increase using "gigabit" units?

    How do we call this network resource unit, which  is in 5gigabit   that support recommended to increase to 25gigabit?

    Kind regards,

  • Beauty_and_dBest
    Beauty_and_dBest Member Posts: 8,015 Bronze Crown
    edited Aug 12, 2020 6:48AM

    Thanks Billy and ALL,

    We are using Ubunto 16.

    Is there a command to check which config has issue?

    Kind regards,

  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown
    edited Aug 12, 2020 9:21AM
    Beauty_and_dBest wrote:Thanks Billy and ALL,We are using Ubunto 16.Is there a command to check which config has issue?Kind regards,

    Using ubuntu for what, exactly?  Surely not for hosting your oracle database.  That is totally unsupported. Ubuntu is from an entirely different branch of the linux family tree than is the certified oracle/red hat linux.  Trying to run oracle on ubuntu is akin to trying to run a gasoline engine on diesel fuel.

    TubbyBeauty_and_dBest
  • [Deleted User]
    [Deleted User] Posts: 0 Silver Trophy
    edited Aug 12, 2020 9:33AM
    Beauty_and_dBest wrote:
    Is there a command to check which config has issue?

    No. Not one single command, no.

    What you have to check is the full path between client and database. Which means you need to look at what is between your database, which presumably holds the data that the students need, and the browser that the students use. Since you can't really check every student's router, wifi, internet access etc, you'll need to start at just outside your own domain. Note every step that is taken to get a response on a typical request, then figure out for every single step what the max load is at what time, and figure out if that step is needed.

    That should give you your bottleneck.

    Beauty_and_dBest
  • L. Fernigrini
    L. Fernigrini Data Engineer Sr Consultant Member Posts: 4,104 Silver Crown
    edited Aug 12, 2020 10:36PM

    First of all, this does not seem to be a question for the Oracle General Database Discussions... You never mentioned any Oracle database running the OLS.

    Most OLS include video activities, I do not know anything about  video storing and streaming, but I believe that 32Gb of RAM on a server to attend 1K concurrent requests, most of them asking for video, seem inadequate.

    You should start from the beginning, explain which particular OLS software you are using, it it runs on Oracle DB (include version) and how did you sized the server, usign what expected number of connections, and which particular documentation from the OLS provider....

    Beauty_and_dBest
  • JohnWatson2
    JohnWatson2 Member Posts: 4,516 Silver Crown
    edited Aug 13, 2020 2:54AM
    Beauty_and_dBest wrote:12cOL7Hi ALL,Due to COVID-19, schools are now closed and are engaged in OLS.Students and teachers must study/Learn at home using OLS.We have an OLS system and is hosted in Cloud.But when 1000+ students/teachers accessed it simultaneously, we get error > Request timeout The OLS Homepage very slow to open or or frozen..Our server specs is 8 CPU and 32Gb Memory.We checked CPU/Memory usage and it is average onlyWhat resource do we need to address?Anybody here has experienced on online apps which has lots of simultaneous read/write access?Please help.....Kind regards,

    What "cloud"? For example, is it an old AWS t2.2xlarge and you may be having all your CPU cycles throttled back. This wouldn't happen if you changed to a t3a unlimited.  The network performance (which you, for reasons unknown, appear to be fixated upon) is also dependent on the instance type.

    Cloud based environments can be a bit complicated and nothing like on-premises systems.

    Beauty_and_dBest
  • Beauty_and_dBest
    Beauty_and_dBest Member Posts: 8,015 Bronze Crown
    edited Aug 15, 2020 7:01AM

    Thanks ALL,

    I think the solution is to increase the shape vertically.

    Once you increase memory and CPU , the bandwidth increases also proportionally.

    After increasing the shape, our issue seem good now? or I hope so

    But it seems our OLS App is not using so much Memory/CPU

    The problem is, In Cloud you can not increase network Bandwidth separately.

    But I think ii is much more difficult if you are on-prem?

    Our apps are  hosted in both Oracle and AWS cloud.

    We are comparing which one is better in performance and cheaper in cost.

    Our app is just a simple app using apache on port 80 and 443.

    How do we protect port 80 from network flooding by hackers?

    Ho do we know if  our login page is requesting timeout due to hackers?

    Is port 80, 443 secured by default?

    Kind regards,

  • JohnWatson2
    JohnWatson2 Member Posts: 4,516 Silver Crown
    edited Aug 15, 2020 9:32AM
    Beauty_and_dBest wrote:<snip>Our app is just a simple app using apache on port 80 and 443.How do we protect port 80 from network flooding by hackers?Ho do we know if our login page is requesting timeout due to hackers?Is port 80, 443 secured by default?Kind regards,

    If you are exposing your Apache to the internet, you should have a strong word with your cloud implementation consultants. The company I work for would never implement something like that for a client. The Apache(s) should be on a VPC, with traffic routed to it by an internet facing load balancer. The load balancer (AWS or OCI, they are similar at this level) is where you deploy your certificates, and it is designed to handle all sorts of attacks. It will also be logging everything, including your putative hackers. As for the timeouts, they need to be configured on many layers

    I don't know what you mean by "Is port 80, 443 secured by default". 

    Beauty_and_dBestMaaz Khan