4 Replies Latest reply on Mar 27, 2002 4:29 PM by bacchu_anjan

    Does Minerva support JDBC Multipools

    kubokushi

      Can someone please confirm if Minerva support JDBC multipools for performance ?
      A multipool is a pool of pool which is great for load balancing and availability.It has backup pools.
      Backup Pools, in which the connection pools are set up as an ordered list and used sequentially.
      Load Balancing, in which all listed pools are accessed using a round-robin scheme.

      Please advise

      KK

        • 1. Re: Does Minerva support JDBC Multipools
          davidjencks

          Not that I know of. Could you explain or provide a reference to an explanation of how this is an improvement over plain ordinary pooling where all items in the pool are equal?

          • 2. Re: Does Minerva support JDBC Multipools
            bacchu_anjan

            Hi,

            Weblogic 6.x has this feature.

            Say, you setup Oracle so that there is a primary database and a replicating database. A multi-pool is set up such that by default, the primary database is hit. But if the primary database goes down, the secondary(replicating) database starts getting hit from the connection pool. Does that make sense ?

            Best Regards,
            ANJAN. B

            • 3. Re: Does Minerva support JDBC Multipools
              oravecz

              I'm surprised that the vendor's JDBC driver doesn't transparently failover in these situations.

              How does the app server know that the "primary" pool should not be used because the database is down, and not just some other SQL Exception (like a dead connection because the db was recycled)?

              • 4. Re: Does Minerva support JDBC Multipools
                bacchu_anjan

                Hi,

                The driver needs to be configured to do the fail-over.

                There are a few semantics which can be used by the pool driver to implement the fail-over. One possibility is to ping the Database Driver to see if it's alive(what "alive" means can be debated).

                None of these implementations are standard across App Servers. So far, they have not made their way into most other connection pools.

                Best Regards,
                ANJAN. B