The MySQL database is the most popular Open Source database in the world, boasting more than four million users. While MySQL is used in countless web sites, the database can also support businesses of all sizes. However, up until recently, developers felt that the lack of transactions in MySQL limited its potential and therefore, its usefulness. But with the release of MySQL 4, the database now supports two, key enterprise-like features: transactions - which guarantee the integrity of data - and replication, which persists data to multiple servers in parallel. Combined with the other features of MySQL, transactions and replications make MySQL a very compelling, competitive, and low-cost (or no cost) alternative to commercial databases.
The MySQL Transactions and Replication book presents all of the information required to create highly available, enterprise applications based on MySQL.
Sprache
Verlagsort
Verlagsgruppe
Springer-Verlag Berlin and Heidelberg GmbH & Co. KG
Zielgruppe
Maße
Höhe: 235 mm
Breite: 178 mm
ISBN-13
978-1-59059-223-6 (9781590592236)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
James Cox has been using MySQL since the beginning of version three, when he needed to integrate interactivity into his websites. Since then he has managed to break almost every aspect of MySQL, implementing it in different situations. James also works closely with the PHP project, currently managing the servers to make sure they work correctly. James recently became one of the first people to pass the MySQL Core Certification exam, and so is one of the few certified MySQL engineers.
Stephen Friedl is an independent consultant who has used UNIX for more than 20 years. He is a regular contributor to Linux Magazine.
Alison Gianotto (better known in many dubious circles as 'Snipe') has been a professional geek for eight years, and has been working with PHP for approximately 4 years. She is the technical director at a prominent web development firm.
Christopher Harshman lives in Los Angeles, California. He owns the firm called Harshman Digital, and was been a technical reviewer for many books before taking the plunge into authoring.
Krzysztof Karski is an independent consultant working with small to mid-sized firms in the Twin Cities area and specializes in MySQL, SQL Server, PHP, ASP, and Java.
James McMurry is a systems manager and software developer in St. Louis, Missouri, USA. He works for Object Computing, Inc. James has made extensive use of MySQL and other Open Source software in small companies, huge corporations, and for fun.
Dennis Salguero is a computer programmer based in Los Angeles and is a proud alumni of the George Washington University. He specializes in Windows application development including the .NET framework.
Daniel Solin is a technical writer, reviewer, consultant, programmer, and Linux-enthusiast from Sweden. He has been programming Linux applications and web pages
since 1994. For the last two years, Daniel has been developing various software for
one of Europe's largest ISPs.
Bryan Waters is a freelance software developer, specializing in web-based corporate information systems. He uses PHP, ASP, C++, and Java with database servers such as SQL Server, SQL Anywhere, and MySQL to develop distributed, stand-alone and CD-ROM software for the medical, hospitality, and education industries.
Chapter 1: Introduction to Transactions; Chapter 2: MySQL Transaction Implementation; Chapter 3: MyISAM Tables; Chapter 4: BDB Tables; Chapter 5: InnoDB Tables; Chapter 6: Performance Tuning; Chapter 7: Towards Greater Reliability Using Replication; Chapter 8: The Mechanics of Replication; Chapter 9: Configuring the Master; Chapter 10: Configuring the Slave; Chapter 11: Replication Scenarios and Strategies; Chapter 12: Troubleshooting and Error Recovery; Chapter 13; Known Limitations and Workarounds; Appendix A: Support, Errara, and Downloads
