Cover
title | : | Sybase ASE 12.5 High Availability |
author | : | Garbus, Jeffrey R.; Tyrrell, Gary. |
publisher | : | Wordware Publishing |
isbn10 | asin | : | 1556229097 |
print isbn13 | : | 9781556229091 |
ebook isbn13 | : | 9780585414836 |
language | : | English |
subject | Client/server computing, Sybase. |
publication date | : | 2002 |
lcc | : | QA76.9.C55G39 2002eb |
ddc | : | 005.75/8 |
subject | : | Client/server computing, Sybase. |
Page i
Sybase ASE 12.5 High Availability
Jeffrey Garbus and Gary Tyrrell
Page ii
Library of Congress Cataloging-in-Publication Data
Garbus, Jeffrey R.
Sybase ASE 12.5 high availability / by Jeffrey Garbus and Gary Tyrrell.
p. cm.
ISBN 1-55622-909-7 (pbk.)
1. Client/server computing. 2. Sybase. I. Tyrrell, Gary. II. Title.
QA76.9.C55 G39 2002
005.75'8--dc21 2002016750
CIP
2002, Wordware Publishing, Inc.
All Rights Reserved
2320 Los Rios Boulevard
Plano, Texas 75074
No part of this book may be reproduced in any form or by any means
without permission in writing from Wordware Publishing, Inc.
Printed in the United States of America
ISBN 1-55622-909-7
10 9 8 7 6 5 4 3 2 1
0203
Sybase is a registered trademark of Sybase, Inc. Other product names mentioned are used for identification purposes only and may be trademarks of their respective companies.
Appendixes A, D, E, F, G, H, and I are used with the permission of Sybase, Inc.
All inquiries for volume purchases of this book should be addressed to Wordware Publishing, Inc., at the above address. Telephone inquiries may be made by calling:
(972)423-0090
Page iii
For my lover, my wife, my best friend all the same person
Jeff Garbus
To Helen, for her time, patience, and indulgence
Gary Tyrrell
Page iv
This page intentionally left blank.
Page v
Contents
Foreword | xiii |
Acknowledgments | xiv |
About the Authors | xv |
Part 1: High Availability |
Chapter 1 Introduction to High Availability Architecture | |
Fault Tolerance | |
Goals and Considerations | |
Data Latency | |
Failover Delay | |
Transactional Resubmission | |
Simplicity of Failover and Failback | |
Fault-Tolerance Architectures | |
Dump/Load | |
Replication Server | |
OpenSwitch | |
High Availability Companion Servers | |
Implementing Fault Tolerance with High Availability Companion Server | |
Requirements for Using Sybase HA | |
Resource Requirements | |
High-Availability Architecture Basics | |
High Availability Hot Standby Access | |
High Availability Distributed Access | |
High Availability Concurrent Access | |
Other Options | |
Summary | |
Chapter 2 Asymmetric vs. Symmetric Setup | |
Asymmetric Configuration | |
Performance Implications in an Asymmetric Environment | |
Symmetric Configuration | |
Sequence of Events | |
Page vi
Performance Implications in a Symmetric Environment | |
Choosing Symmetric vs. Asymmetric Failover | |
24x7 Trading Application | |
24x7 Web-based Ordering Application Plus Internal Business Systems | |
Two Independent OLTP Applications | |
Warehouse Operation with Internal Business Systems | |
Auditing Considerations | |
Setting Audit Options | |
Audit Trails | |
Companion Server Name | |
Summary | |
Chapter 3 Failover and Failback: The Basics | |
Failover Methods | |
Mode 1 | |
Mode 2 | |
Mode 3 | |
Failover | |
Security Information | |
Device/Database Metadata | |
User Connections | |
Failback | |
Server States | |
Summary | |
Chapter 4 Failover Modes and sp_companion | |
Companion Modes | |
Resuming Normal Companion Mode from Suspended Mode | |
Dropping Failover Mode | |
Determining Your Companion's Mode | |
Domains | |
Summary | |
Chapter 5 Proxy Databases | |
Creating Proxy Databases | |
When Proxy Databases are Created | |
Size of Proxy Databases | |
Command and Procedure Behavior in Proxy Databases | |
Commands in Proxy Databases | |
System Procedures in Proxy Databases | |
Page vii
User-defined Stored Procedures in Proxy Databases | |
Manually Updating the Proxy Database | |
Proxy System Tables in Master | |
Summary | |
Chapter 6 Preparing for Setting Up HA | |
Granularity | |
Quorum Attributes | |
Groups | |
Application | |
Config | |
Database | |
Devices | |
Logins | |
|
Next page