Re: question about mach11 capabilities

Floyd Wellershaus wrote: > Hi, > I was just reading the white paper on ids11 availability and have a > question. > The solutions seem explicitly cover every scenario except one. > If I need to reorg a very large table that the application needs, but > I don't want to take any outages. > > Can anyone tell me ( high level ) how that would work ? Only doable using ER really. With that you would shift all users away from the one (or the few) machine(s) that you want to reorg, stop replication to that server, reorg the table, restart replication and let it catch up. That done you can shift users around again and reorg another ER node. If you are mixing ER and other MACH11 solutions, you can reorg a block of HDR, RSS, & SDSS servers together if you have multiple such machine clusters kep in synch using ER. If you want to eliminate maintenance windows and eliminate downtime altogether ER's the way to go, or ER in combination with other options to maximize data security/safety. Art S. Kagel Oninit > > Thanks, > floyd > > ------------------------------------------------------------------------ > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > =========================================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ===========================================================================================