loadBalacing Database with Asp.Net

Question

0.00/5 (No votes)

See more:

I have One Web Server and Two Database Server (Oracle DataBase).
When One Database Server is down Client Data should be routed to second Database Server.

Is this possible.

Please help me.

Thanks in Advance.

Posted 8-Jun-11 23:06pm

kanchan dhage

Updated 8-Jun-11 23:13pm

Ramalinga Koushik

v2

Add a Solution

Comments

Sandeep Mewara 9-Jun-11 5:20am

Ping the database and check for connections... if not available then route to another one. What is the issue?

AswinKrishnan 13-Jun-11 15:55pm

Oracle's High Availability Architecture may help you in this.

Data guard only
The productive site runs on the primary database. One or more secondary sites have a logical or a a physical standby database.
When there is a failure at the productive site, the DBA can use Data Guard to fail over to a secondary site. However, this failover must be triggered manually.
disaster recovery

Maximum Availability Architecture (MAA)
The primary site has a RAC environment. The secondary site(s) have clusters with both physical and logical standby databases.
This is the most secure architecture against inavailability.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prerak Patel · Answer 1 · 2011-06-08T23:19:00

Solution 1

This article might be useful to you.
Database Load Balancing Service for ASP.NET[^]

Posted 8-Jun-11 23:19pm

Prerak Patel

Comments

kanchan dhage 9-Jun-11 6:09am

I have gone through this article.But In this i am not able to call windows service from my web application