AboutKrishna Prasad Expertise Data Warehousing and Data Modelling, Cube Building, Data Migration Strategies and Middleware aspects
Experience Several large scale data warehousing and data migration projects. Built a data warehouse of 7 Terrabytes for an organization. Was involved in cradle-to-grave (data architecture to implementation and testing) of a large scale data warehouse effort, in a control position.
Education/Credentials Bachelor of Technology and MBA
Question hi
I have two dell servers ,one dell power edge 2950 and one power edge 1950,I want to use the 2950 as a main server that will provide a service as web based for the customers thought the Internet ,the issue that I want to use the second server as standby server because in case first server fails then the second one will continue immediately and it must have all the customer records and data founded in the main server.
please what is the way to do achieve this goal,and is there a software to do this ,please advice.
also additional question ,I have a firewall watchguard x750e core,if you can help what I must configure in it so that it will transfer all traffic going to the main server ,to the backup server in case of the main fails.
thanks
Answer Hussein,
Depending on the sophistication you want and the money that you are willing to spend, you can devise several ways to do this.
At the high end, you can have a cluster configuration where one server takes over from another automatically, and a mirroring facility (available on all high end databases) that will post data directly to both servers as users or systems update the data. Needless to say, this costs a lot of money.
At the low end, you can take a daily backup from one server to the other - this is not real time switch but you will at least have all the data at the end of the day and explore with your website provider to see if you can have alternate IP sites for the same domain name, to switch seamlessly. If you want to set it up yourself on your servers, there are options available that are highly technical and complex.
