This is the last post about HADR, I think I covered most of the basics of HADR finishing off with how it switches primary and standby. What I have gone over is the basics of HADR. There are many other topics within HADR. One important thing to remember is to NEVER do unlogged operations (careful [...]
|
||||||
|
Okay, so here we go …. setting up an hadr environment…. HADR in it’s lowest form is very straight forward to set up. Here are the steps to start HADR [...] HADR is a very easy and effective way to maintain a DR and/or standby for any given database. You can implement it very quickly and simply and it works well. In essence it is basically log shipping, but done in real time and elegantly. It is not replication, so the standby database is not really [...] Excel is a wonderful tool that can be used to write sql using substitution from cells to cusomize and update or insert. One problem has always been dates… they never come out right [...] Have you ever had a requirement to number the results of a sql query? There are some occassions wheer you want to identify the nth record of a result and it can sometimes be a tricky thing to do. One of the reasons you might want to number the results is to create a mechanizm [...] Some time ago, we upgraded our DB2 from version 7 to 8.2. One of the first things we noticed was that connection times from our client were very long – in the area of about 15 to 20 seconds just to connect to an active database. [...] |
Site hosted by:
|
|||||
|
Copyright © 2012 DBMSguy.com - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
