This discussion is archived
2 Replies Latest reply: Oct 24, 2012 9:21 AM by 615173 RSS

Are there any manual scale-out options?

615173 Newbie
Currently Being Moderated
In other words, can we sign up to multiple 'instances' and set them up as RAC nodes for the same database?

Our application load will be very variable–we might suddenly get 60000 new users all logging on in a short period after signing up a new customer–how do we know if the database will handle the load?
  • 1. Re: Are there any manual scale-out options?
    RickG Explorer
    Currently Being Moderated
    Hello -

    I think there is some confusion over the composition of a Database Cloud Service. This Service is not an instance - it's a slice of an instance, implemented with schema isolation. So just as you could not create a RAC node from a schema, you cannot create one from a Database Cloud Service. In addition, configuration options like RAC are not exposed in the Database Cloud - it's essentially Platform-as-a-Service, not Database- or Infrastructure-as-a-Service.

    As far as performance goes, you should refer to the white paper on performance, available here - http://www.oracle.com/technetwork/database/database-cloud/public/performance-wp-1844129.pdf - to help you better understand how performance is managed for the Database Cloud. There is no limit on the number of users you could have for a service, but please keep in mind that it will take some amount of time to add that many users to whatever authentication method you choose, so a "short period" is relative here.

    Of course, the good news about all general performance questions is that they all have the same answer - "It depends". An Oracle Database 11g R2 instance running on Exadata could definitely handle that many users, but the performance delivered depends on what they are doing and what everyone else in the shared resource environment of the Database Cloud is doing. The white paper should help you to address your particular situation better.

    Hope this helps, and thanks for your interest.

    - Rick Greenwald
  • 2. Re: Are there any manual scale-out options?
    615173 Newbie
    Currently Being Moderated
    Many thanks, that is what I needed to understand.

    Kind regards
    Jack

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points