vikrant disale
Member
- Messages
- 7
- Reaction score
- 0
- Points
- 1
1. Our client has 3 different types of Users using his web application,
a. Admin
b. Franchise
c. Customers
2. What i am going to do,
a. Redirect each user-type’s request to their individual database. For e.g.,
i. Franchise - If raises a stock request, views a report, etc, all requests will be redirected to DB-1 (SERVER-1) and data will be served from the same server itself. This will be applicable for all ‘Franchise’ users
ii. Customer - If places an order, views a report, etc, all requests will be redirected to DB-2 (SERVER-2) and data will be served from the same server itself. This will be applicable for all ‘Customers’ users
iii. Admin - If registers a new Franchise, views a report, etc, all requests will be redirected to DB-3 (SERVER-3) and data will be served from the same server itself. This will be applicable for all ‘Admin’ users
b. We will take care of which request to direct to which database
3. Just need suggestion is this possible below things ?,
a. Any change in database structure or any INSERT/UPDATE/DELETE statement is executed in 1 database, the same should get mirrored automatically in the other 2 databases,
i. Any change in DB-1 (SERVER-1), the same should get mirrored automatically on DB-2 (SERVER-2) & DB-3 (SERVER-3)
ii. Any change in DB-2 (SERVER-2), the same should get mirrored automatically on DB-1 (SERVER-1) & DB-3 (SERVER-3)
iii. Any change in DB-3 (SERVER-3), the same should get mirrored automatically on DB-1 (SERVER-1) & DB-2 (SERVER-2)
4. We would like to know,
a. Whether our requirement is possible or not?
b. How many more databases and database servers can be added into that cluster?
c. What will be the disaster recover strategy for the database cluster ?
a. Admin
b. Franchise
c. Customers
2. What i am going to do,
a. Redirect each user-type’s request to their individual database. For e.g.,
i. Franchise - If raises a stock request, views a report, etc, all requests will be redirected to DB-1 (SERVER-1) and data will be served from the same server itself. This will be applicable for all ‘Franchise’ users
ii. Customer - If places an order, views a report, etc, all requests will be redirected to DB-2 (SERVER-2) and data will be served from the same server itself. This will be applicable for all ‘Customers’ users
iii. Admin - If registers a new Franchise, views a report, etc, all requests will be redirected to DB-3 (SERVER-3) and data will be served from the same server itself. This will be applicable for all ‘Admin’ users
b. We will take care of which request to direct to which database
3. Just need suggestion is this possible below things ?,
a. Any change in database structure or any INSERT/UPDATE/DELETE statement is executed in 1 database, the same should get mirrored automatically in the other 2 databases,
i. Any change in DB-1 (SERVER-1), the same should get mirrored automatically on DB-2 (SERVER-2) & DB-3 (SERVER-3)
ii. Any change in DB-2 (SERVER-2), the same should get mirrored automatically on DB-1 (SERVER-1) & DB-3 (SERVER-3)
iii. Any change in DB-3 (SERVER-3), the same should get mirrored automatically on DB-1 (SERVER-1) & DB-2 (SERVER-2)
4. We would like to know,
a. Whether our requirement is possible or not?
b. How many more databases and database servers can be added into that cluster?
c. What will be the disaster recover strategy for the database cluster ?
