MySQL主要有以下产品,现就每种产品的用途做一个简单介绍,以后会对每种产品的使用做详细分析(英文内容来源于MySQL官网)
本文一方面使初用者对MySQL产品有一个大体的认识;另一方面是提高自己的外文翻译能力.有不足的地方请大家指正
 
官网地址 : http://www.mysql.com
 
产品列表:
一. MySQL Enterprise
二. MySQL Cluster
三. MySQL Embedded(OEM/ISV)
四. MySQL Data Warehouse
五. MySQL Backup & Recovery
六. MySQL Workbench
七. MySQL Connectors
 
具体内容:
一. MySQL Enterprise
@MySQL 企业版
当前版本: 5.1
简介
  MySQL Enterprise Server software is the most reliable, secure and up-to-date version of MySQL for cost-effectively delivering E-commerce, Online Transaction Processing (OLTP), and multi-terabyte Data Warehousing applications. It is a fully integrated transaction-safe, ACID compliant database with full commit, rollback, crash recovery and row level locking capabilities. MySQL delivers the ease of use, scalability, and performance that has made MySQL the world's most popular open source database.
      
MySQL 企业服务器软件是最可靠 , 安全和最新版本的 MySQL 。它成本低廉地提供电子商务,联机事务处理 (OLTP) 和高达数 TB 的数据库仓储应用。它是一个完全集成的数据安全,事务提交,回滚 , 崩溃恢复和行级锁定能力的数据库。 MySQL 提供的易用性,可扩展性和其性能使 MySQL 成为世界上最流行的开源数据库。
@MySQL Enterprise Monitor
The MySQL Enterprise Monitor continuously monitors your MySQL servers and alerts you to potential problems before they impact your system. Its like having a "Virtual DBA Assistant" at your side to recommend best practices to eliminate security vulnerabilities, improve replication, optimize performance and more. As a result, the productivity of your developers, DBAs and System Administrators is improved significantly.
MySQL 企业监控器持续的监控你的 MySQL 服务器 , 并且在可能出现的问题影响你的系统前给出提醒 . 它就像是一个 虚拟的 DBA 助手 在你旁边建议最佳做法 , 以消除安全隐患 , 改善复制 , 优化性能和更多 . 因此 , 你的开发者的生产力 ,DBA 和系统管理员有了显著的提高 .
@MySQL Enterprise Production Support
MySQL Enterprise includes 24x7 Production Support that helps you deliver continuous availability for your production database applications. MySQL Production Support gives you priority access with fast response times to assist you with the development, deployment and management of your MySQL applications. MySQL Enterprise gives you the flexibility to choose a service level (Basic, Silver, Gold, Platinum) that matches your requirements.
MySQL 企业包括 24x7 产品支持 , 帮助你提供连续可用性的生产数据库应用 .MySQL 的产品支持 , 你可以优化获得与快速的反应时间为您提供发展帮助 , 部署和管理你的 MySQL 应用 .MySQL 企业允许你灵活地选择服务水平 ( 基本服务 , 白银会员服务 , 黄金会员服务和更高级别的服务 ) 以符合你的要求 .
@High Availability Solutions for MySQL
Databases are at the center of modern enterprise applications and store an organization’s most valuable assets including customer information, product information, order information and historical data. Plus, organizations rely on databases to run their business-critical applications. Hours or even minutes of downtime often result in significant amounts of lost revenue and unsatisfied customers. Therefore, making database applications highly available is a top priority for all organizations.
以数据库为中心的现代企业应用 , 存储着一个组织最重要的资产 , 包括客户信息 , 产品信息 , 订单信息和历史数据 . 此外 , 组织依赖数据库运行他们的关键业务应用 . 数小时甚至几分钟的停机往往会导致大量的收入损失和客户投诉 . 因此 , 实现数据库应用高可用性对所有组织来说 , 都是优先考虑的事情 .
MySQL provides a number of options to make their database infrastructure highly available. Selecting which high availability solution is right for you will largely depend on how many “nines” of availability you require and the type of application you are deploying. MySQL provides you with the following options:
MySQL 提供了多项选择 , 使他们的数据库基础结构高可用性 . 选择怎样的高可用性解决方案才是正确的 , 这在很大程序上取决于要求几个 9 的可用性和你部署的应用类型 .MySQL 提供以下几种选择 :
( 以下是关于几个 9 的意思 , 简单来说 ,9 的个数越多 , 表明一年停机的时间就越短 )
      
       ( 图片来源 : http://en.wikipedia.org/wiki/Uptime)
方案1 <MySQL Replication>
Using MySQL Replication, organizations can cost-effectively deliver a high availability solution. Master/Slave Replication enables operations to manually fail-over to another server in the event of a hardware or software problem. In addition, with MySQL replication, organizations can incrementally scale out their infrastructure to accommodate exponentially growing capacity demands. MySQL Replication ships out of the box and is used by some of the world’s most highly trafficked Web sites including YouTube, Yahoo!, flickr, Wikipedia and craigslist.
使用 MySQL 复制 , 组织可以经济有效的提供一个高可用性的解决方案 . 主从 / 复制能够使业务在发生硬件或软件问题的时候手动故障转移到另一台服务器 . 此外 , 使用 MySQL 复制 , 组织能够逐步进行他们的基础结构 , 以适应急剧增长的容量需求的能力 .MySQL 被一些世界上高流量的网站包括 YouTube,Yahoo,Flickr, Wikipedia and craigslist. 所使用 .
 
方案2 <DRBD for MySQL >
DRBD for MySQL is a solution that combines MySQL, Linux Heartbeat, and Distributed Replicated Block Device (DRBD) so organizations can deliver a synchronously replicated high availability solution. Linux Heartbeat manages failover and DRBD synchronously propagates data to another node in an Active/Passive configuration. In the event the Active Server fails, Linux Heartbeat will promote the Passive node to an Active state, while DRBD will ensure the resynchronization of data after the failure. DRBD for MySQL is ideal for adding High Availability to new and existing MySQL applications.
DRBD MySQL 一个解决方案 . 它结合 MySQ L linux 心跳和分布式复制块设备 (DRBD), 以便组织能够一个同步复制的高可用性解决方案 .linux 心跳管理故障转移和 DRBD 同步传播数据到另一个节点的主动 / 被动配置 . 如果主服务器失败 , DRBD 确保重新同步数据失败后 ,linux 心跳会提升被动节点成为活动状态 .DRBD MySQL 是理想的高可用以增加新的和现有的 MySQL 应用 .      
方案3 < MySQL Cluster >
MySQL Cluster enables organizations to deliver 5 Nines (99.999%) availability using a parallel server architecture with no single point of failure. MySQL Cluster is an in-memory storage engine that synchronously replicates data to all data nodes in the cluster. This results in sub-second response time and extremely fast failover. Data partitioning, fail-over, and recovery are all automatically handled by MySQL Cluster. MySQL Cluster is used by the world’s leading telecom organizations including Alcatel-Lucent, Nortel and Nokia.
MySQL 簇能够使组织提供 5 9(99.999%), 使用一个并行的服务器架构 , 并且没有单点故障的可用性 .MySQL 簇是一个内存中的存储引擎 , 同步复制数据到集群中其它所有节点 . 这一结果堪称秒级响应时间和极速的故障转移 . 数据分区 , 失效转移和恢复都交由 MySQL 簇自动处理 . MySQL 簇使用者有世界领先电信组织包括阿尔卡特 , 北电和诺基亚 .
 
@Caching Solutions for MySQL
High-volume web applications require caching to improve application performance and scalability. Integrating a caching tier into Web application architectures can:
高容量的 WEB 应用需要缓存来提高应用的性能和可扩展性 . 集成缓存到 WEB 应用架构能够 :
Improve application performance by caching data and objects in memory and alleviating database load.
Increase scalability and accommodate more concurrent users without impacting performance
Efficiently use resources enabling you to save on hardware and power costs.
Memcached for MySQL
Memcached is a high-performance, open source distributed memory caching system that is used by leading web sites like YouTube, Facebook, LiveJournal and Wikipedia. Memcached can help organizations manage exponential growth by scaling their sites to handle millions of users and billions of page views.
通过缓存数据和对象到内存中提高应用程序性能 , 减轻服务器负载 .
在不影响性能的前提下 , 提高可伸缩性和容纳更多的并发用户 .
有效的使用资源能够让你节省硬件和电力成本 .
使用 Memcached MySQL
Memcached 是一个高性能的 , 开源的分布式内存缓存系统 , 它的使用者有世界级领先的站点像 YouTube,Facebook,LiveJournal Wikipedia.Memcached 能够帮助组织者管理指数级增长的百万计的用户和数十亿的页面访问 .
@Cloud Computing Solutions for MySQL
Cloud computing environments are proving to be the next wave of cost-effective architectures for delivering web-scale database-driven applications. Because cloud computing environments allow for scalability on demand, combined with a "pay as you go" pricing model, applications can be scaled up or down dynamically to accommodate changing workloads and business requirements. At the same time, users only incur costs for the capacity they actually use. This removes the high costs associated with idle resources and dedicated maintenance for CPU, memory, network bandwidth and data storage. Cloud computing solutions for MySQL makes it easy to develop, deploy, and manage your new and existing MySQL-backed applications in a virtual computing environment.
云计算环境被证实是下一波有成本效益的架构 , 它提供网络规模的数据库驱动应用程序 . 由于云计算环境允许可扩展性的需求 , 再加上一个 现收现付 的定价模式 , 应用能够向上向下动态伸缩 , 以适应不断变化的工作量和业务需求 . 同时 , 用户仅担负他们实际使用能力的成本 . 这消除了闲置资源和 CPU, 内存 , 网络带宽和数据存储带来的高成本 . 云计算解决方案使 MySQL 更容易开发 , 部署和管理于新的和现有基于 MySQL 的应用程序在一个虚拟计算环境下