> Hi, > I am developing a web application that accesses MaxDB. > > The application has several instances, every instance should be limited to > a > number of concurrent sessions to one big MaxDB database instance. So, for > example: > > - Web application Instance "A" should have max. 5 concurrent sessions > - Web application Instance "B" should have max. 3 concurrent sessions. > > How would I do this? I am thinking about giving every web application > instance > a seperate username for MaxDB (Security is done in the web application). > But > is there a way to limit the number of concurrent sessions per user?
I'd do it with connection pools. If you're in Java I think you can even configure he pool in server.xml or in some other XML file. I'd guess you can then limit the pool size as well as the number of concurrent connections. It's also not very difficult to roll your owl pool impl that deals with these contraints but this problem is so general that I am nearly sure you'll find something out there (or even already built into tomcat). Kind regards robert > > Another way would be to create multiple MaxDB instances for each > application > instance and start an according number of user processes. Maybe this would > work but I don't like this solution as this produces a lot of overhead > (creation, backup, seperate data spaces etc.) which is for my application > not > useful. > > Another issue is that if 6 people query Instance "A", 5 should be > processed > and the 6th should not be rejected but instead queried and processed when > one > of those 5 is done. (e.g. like a FIFO). Moreover there should be some > timeout > so that if the database is blocked, the user can be informed about this. > Is > there some solution to this? > > Best Regards, > Hermann > > -- > [EMAIL PROTECTED] > GPG key ID: 299893C7 (on keyservers) > FP: 0124 2584 8809 EF2A DBF9 4902 64B4 D16B 2998 93C7 > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- +++ GMX DSL Premiumtarife 3 Monate gratis* + WLAN-Router 0,- EUR* +++ Clevere DSL-Nutzer wechseln jetzt zu GMX: http://www.gmx.net/de/go/dsl -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
