【MySQL 系列文档】俊哥儿张 吐血推荐～～

zhangzongjun

【Database Handling with PHP/MySQL】

zhangzongjun

【Advanced MySQL Performance Optimization】

zhangzongjun

【MySQL Support White Paper】

zhangzongjun

MySQL 5.0 New Features Series：
【[MySQL 5.0 New Features Series – Part 1] MySQL 5.0 Stored Procedures】
【[MySQL 5.0 New Features Series – Part 2] MySQL 5.0 Triggers】
【[MySQL 5.0 New Features Series – Part 3] MySQL 5.0 Views】

zhangzongjun

【Database Tiering】
Achieving Scale-Out by Combining MySQL
with your Existing Database
Many organizations are facing a double threat of increasing volumes of data and transactions while at the same time needing to reduce their IT organizations' resources. As a result, many are turning to a new, modern scale-out architecture that is built on using low-cost commodity Intel / Opteron hardware running an open source LAMP (Linux, Apache, MySQL, PHP / Perl / Python) stack.

While many might advocate migrating existing database applications to an open source solution, there may be practical reasons to not undertake such migration projects. Is there an architecture that enables organizations to keep their current database systems running as-is while adding open source to the solution? Yes, in fact the notion of "database tiering" has become a common way for many IT organizations to add open source software to provide greater cost-effective scale-out while minimizing change to existing systems.

By using a database tiering methodology, MySQL can complement existing database infrastructures and allow IT organizations to scale-out their data processing capabilities effectively at a low cost. When placed at the front-end of legacy systems, the MySQL database co-exists with existing databases by means of data synchronization.

zhangzongjun

【Enterprise Data Warehousing with MySQL】
Although the MySQL database server has been the proven leader in database management for online businesses, many have wondered if it has the capabilities to also lead in the area of data warehousing and business intelligence. This paper examines the MySQL strategy for data warehousing and showcases the unique abilities and advantages that come with choosing MySQL as a provider for data warehousing and business intelligence needs.

zhangzongjun

【MySQL High Availability Solutions】
High availability solutions from MySQL and its certified partners should appeal to organizations interested in making their applications more highly available, and in some cases, available to the point where they approach mainframe reliability. MySQL offers a wide array of options when selecting a high availability solution. In this paper, we will examine in greater detail MySQL Replication, MySQL Cluster, free and open-source solutions, as well as, products from our network of certified partners.

zhangzongjun

【Guide to Cost-effective Database Scale-Out using MySQL】
The current economic environment is forcing CIOs and IT Managers to focus on supporting key business requirements with less expensive IT infrastructure. Specifically, as more and more organizations rely on the Internet, they must be able to cost-effectively increase capacity of their infrastructure without sacrificing performance in order to grow their business.

For example, online companies such as Friendster, Citysearch, and Yahoo must be able to accommodate the exponential grow in their online community and the data being delivered. In addition, traditional companies in telecom, retail, and financial industries are building more self-service applications to improve efficiencies and cut costs. These applications must also scale in order for these organizations to increase their revenues and improve customer satisfaction. No businesses are unaffected by the growing volume of online data and the need for greater analysis and faster responsiveness. What will separate the strong companies from the weak is their ability to meet the growing demands in a cost-effective fashion.

For growing organizations, adding more infrastructure capacity using a proprietary solution requires large up front software and hardware investments. Many companies find that with a proprietary solution they will not be able to execute on their business plan because the cost of software alone is prohibitive. When you factor in the cost of large Symmetrical Multiprocessing (SMP) hardware, the cost problem is further exacerbated. MySQL enables organizations to eliminate the "database tax" associated with proprietary closed source software and reduce the Total Cost of Ownership (TCO) enabling them to more readily accommodate growing demands for database capacity.

zhangzongjun

【Guide to Data Integrity, Availability and Security】
DBAs, architects, developers and business managers who are building business-critical applications need to be sure that their database systems have complete data integrity, availability and security. These three factors determine the overall level of "data assurance" that your data is accurate, available at required service levels and safe from human and technology threats. This paper discusses the three areas of data integrity, availability and security and outlines the features and capabilities of MySQL that help to improve data assurance and eliminate risks.

zhangzongjun

【Guide to MySQL 5.1 Partitioning】Partitioning is a physical database design technique that many data modelers and DBAs are quite familiar with. Partitioning allows large objects within a database to be split into small, more manageable pieces. There are a number of benefits that come with partitioning, but the two main advantages are:

·Increased performance - during scan operations, the MySQL optimizer knows what partitions contain the data that will satisfy a particular query and will access only those necessary partitions during query execution.

·Simplified data management - partitioning allows a DBA to have more control over how data is managed inside of the database. By intelligently creating partitions, a DBA can simplify how certain data operations are performed.

Learn more about how MySQL 5.1 supports all the major forms of partitioning; Range, Hash, Key, List and Composite.