• Browse
  • Pages
  • News
  • Labels
  • Attachments
  • Bookmarks
  • Advanced
• Log In
• Sign Up
• Help
  • Help Wiki
  • Contact Wiki Admin
• Report an Issue
  • Report a Wiki Space Issue
  • Report a Site Wide Issue

1. Wikis Home
2. Blueprints
3. …
4. Main
5. Archives
6. 2008 Blueprints
7. MySQL Database Scale-Out and Replication for High Growth Businesses

• Log In

MySQL Database Scale-Out and Replication for High Growth Businesses

• Page restrictions apply
• Attachments:1
• Added by Kemer, last edited by Elena_Levashova on Feb 05, 2009  (view change)

Comment:

MySQL Database Scale-out and Replication for High Growth Businesses

by Nick Kloski
November 2008

It is widely recognized that MySQL is the most popular database software in the world. Since its inception in 1995, there have been 11 million product installations around the world in a wide variety of markets. There are more installations of MySQL in use today than any other database architecture. From startup companies hoping to be the next Web2.0 poster child to large global enterprises, the MySQL database architecture has proven to be flexible, extendable, scalable, and more than capable of filling high-capacity database roles in very different venues.

Contents

• Introducing Scale-Out
  • Defining Scale-Out
  • MySQL Database Scale-Out Components
• MySQL Database Replication
  • Statement- versus Row-Based Replication
  • MySL Replication Internals
  • MySQL Replication Topologies
• Basic Scale-Out Architectures
  • Read Scale-Out
  • Application Partitioning
  • Layering Techniques
• Linux Heartbeat
• Distributed Replicated Block Device (DRBD)
  • DRBD and Replication
  • DRBD Clusters, Application Partitioning, and Replication
• Guidelines for Implementing Scale-Out
• MySQL Monitoring and Professional Services
• Summary
• About the Author
• Acknowledgements
• References 
• Ordering Sun Documents
• Accessing Sun Documentation Online
• Appendix: Overview of MySQL Replication Setup
  About the Authors

  Nick Kloski is a Web2.0 Solutions Architect in the Web/HPC group in the Systems Technical Marketing Group at Sun. In his 10 years at Sun, Nick has had a wide exposure to both Sun and competitive systems, including systems administration work, over six years of technical Field Service, internal QA testing, and as a member of the Technical Marketing Department. In the role of Web2.0 Solutions Architect, Nick is responsible for being aware of market trends and discovering ways Sun technology can help uniquely solve customer problems.

  Acknowledgments

  The author would like to recognize Jimmy Guerrero of the MySQL Marketing Team for his contributions to this article.

Rate this blueprint (Log In to vote.)
Choices	Your Vote
Great
Good
Fair
Poor

Labels parameters

Labels

web web Delete

new new Delete

mysql mysql Delete

blueprint blueprint Delete

cmt cmt Delete

Enter labels to add to this page:

 

Looking for a label? Just start typing.

Sign up or Log in to add a comment or watch this page.