MySQL Transactions and Replication Handbook [Illustrated] [Paperback]

Daniel Solin (Author), Christopher Harshman (Author), James Cox (Author), Alison Gianotto (Author), James McMurry (Author), Krzysztof Karski (Author), David Axmark (Author)

Book Description

Publication Date: March 25, 2003

MySQL today offers a rich functionality that did not exist in previous versions. Many developers earlier felt that lack of transactional support was a serious shortcoming in the design of MySQL Server. With the recent releases, however, MySQL has included full transactional support for both BDB and InnoDB tables. Transactional processing comes with many advantages as well as performance considerations. In this book we will cover the configuration settings, the implementation, and the tables that support transactions in MySQL. It will also include tips on modifying the server's settings to tweak the performance limitations that are posed by transactions.

MySQL also is an integral component of a large number of OLTP applications, which requires it to meet performance criteria in a production environment. Replication support has been introduced in MySQL to enhance the performance and availability of databases in an OLTP environment. This handbook examines in detail a replicated setup, the configuration, and the various architectures that can be implemented with MySQL. It also explores the limitations in the MySQL server and their respective workarounds. The MySQL Transactions and Replication Handbook is a repository for all those looking at augmenting the performance of their server who at the same time want to maintain the integrity of data available on the server.

The MySQL Transaction and Replication handbook will serve to educate the reader on Transaction and Replication strategies that may be undertaken with MySQL, from the point of view of the application as well as administration. This book will cover Transaction and Replication from the configuration stage, explore and appraise the options available to us, and help us make suitable decisions as per our needs.

Editorial Reviews

From the Publisher

The MySQL Transaction and Replication handbook, focuses on important aspects of a database server, and is aimed at developers and administrators to assist them in creating and maintaining highly available mission-critical applications based on MySQL. It is assumed that the reader is already familiar with the MySQL database server and its basic administration tasks. The coverage in this book includes: An Introduction to Transactions MySQL Transaction Implementation, MyISAM Tables, BDB Tables, InnoDB Tables, MySQL Transaction Performance tips, Introduction to Replication and its Mechanics, Slave and Master Configuration, Replication Scenarios and Strategies, Troubleshooting, and Workarounds to Known Limitations.

Product Details

• Paperback: 300 pages
• Publisher: Wrox Press; 1st edition (March 25, 2003)
• Language: English
• ISBN-10: 1861008384
• ISBN-13: 978-1861008381
• Product Dimensions: 9.4 x 6.7 x 1.6 inches
• Shipping Weight: 2.9 pounds
• Amazon Best Sellers Rank: #9,298,201 in Books (See Top 100 in Books)