Contact Sales

USA/Canada - Toll Free: +1-866-221-0634
USA - From abroad: +1-208-338-8100
USA/Canada - Subscription Renewals: +1-866-221-0634

Latin America: +1 512 535 7751
Brazil: +55 11 5187 6193
South Africa: +27 113194408
UK: +44 207 553 8447
Ireland: +353 1 8031050
Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Benelux: +31 30 662 7960
Italy: +39 02 249 59 120
Israel: +353 1 8031123
Spain & Portugal: +34 916312182
Sweden: +46 84773853
Other EMEA countries: +353 1 8031050
Asia Pacific: Toll Free

Contact Us Online »

MySQL Enterprise Edition Trial - Try Now

White Papers

» MySQL Enterprise Edition

MySQL Enterprise Edition Product Guide
English »
Español »
Portuguese »
MySQL Enterprise Monitor 2.3: What's New
MySQL Query Analyzer: Overview
View More »

» MySQL Embedded Database

» MySQL on Windows

» MySQL Cluster

All White Papers

MySQL 中文白皮书 » (MySQL White Papers in Chinese)

Oracle Premier Support for MySQL: Rely on The Experts & Get Unique Benefits

Organizations choose to purchase technical support from software vendors for various reasons, many seeing it as an insurance policy. Indeed, much as they would not drive a car without insurance, IT managers consider it good practice to be able to call on the company behind the software they are using should they encounter any issue. At the same time, Oracle Premier Support for MySQL offers benefits far beyond "insurance" -- value you can leverage even if you never experience problems.

In this white paper, we will help you better understand the value Oracle Premier Support for MySQL represents for your organization.

Guide to MySQL as an Embedded Database

MySQL is the most popular open source database in the world. Though best known for its use in Web properties such as Google, Facebook and Yahoo!, MySQL is also an extremely popular embedded database. It's relied on by over 3,000 ISV and OEM customers including seven of the top ten largest software companies in the world. This paper first looks at embedded databases in general - what they are, the embedded database market, and the benefits of "OEMing" an embedded database over supporting your customers' databases or building your own embedded database. We next look at the ways in which using MySQL as an embedded database impacts the three most fundamental measures of business success -- costs, revenue, and risk -- by lowering COGS (cost of good sold), increasing customer satisfaction, and mitigating risk.

The goal of this paper is to answer the questions: Why should I use an embedded database? and, Why should I use MySQL as my product's embedded database? This is a good reference document, a compendium of facts and information with numerous links to more information - mostly technical, or about our customers and their experiences with MySQL.

Guide to MySQL and NoSQL - Delivering the Best of Both Worlds

MySQL enables users to blend the best of both relational and NoSQL technologies into solutions that reduce cost, risk and complexity including:

Concurrent NoSQL and SQL access to the database;
Simple multi-master and master / slave replication with failover and recovery within and across data centers;
Auto-sharding and scale-out across commodity hardware;
Online scaling and schema changes;
ACID compliance and support for complex queries;
Integration with big data stores and frameworks

MySQL Workbench: Database Design. Development. Administration

This paper looks at the various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how the MySQL Workbench product from MySQL can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

MySQL Guide to High Availability Solutions

Databases are the center of today’s web and enterprise applications, storing and protecting an organization’s most valuable assets and supporting business-critical applications. Just minutes of downtime can result in significant lost revenue and dissatisfied customers. Ensuring database highly availability is therefore a top priority for any organization.

Download this guide to learn more:

Causes, effect and impact of downtime;
Methodologies to map applications to HA solution;
Overview of MySQL HA solutions;
Operational best practices to ensure business continuity.

MySQL Enterprise Edition Product Guide

MySQL Enterprise Edition includes the most comprehensive set of advanced features and management tools to achieve the highest levels of scalability, security, reliability, and uptime. It reduces the risk, cost, and complexity in developing, deploying, and managing business-critical MySQL applications.

MySQL with Windows Server 2008 R2 Failover Clustering - Delivering High Availability with MySQL on Windows

Microsoft Windows is consistently ranked as the top development platform for MySQL, and outranks any individual Linux distribution as the leading platform for MySQL deployments, according to surveys of the MySQL user community.

For Windows customers, the advantages of using MySQL are clear: low Total Cost of Ownership (TCO); broad platform support and ease-of-use.

With the release of MySQL 5.5, Oracle demonstrated the benefits of focused development activity for the Windows platform with significant enhancements in performance and scalability. MySQL delivered over 5x higher throughput than previous MySQL releases on Windows.

Following the certification and support of MySQL with Windows Server Failover Clustering (WSFC), organizations can now safely deploy business-critical applications demanding high levels of availability, powered by the MySQL database.

This whitepaper discusses how Windows Server Failover Clustering with MySQL provides a solution to reduce downtime and guard against data loss, and then steps a user through the processes necessary to configure, provision and run MySQL on a Windows Server 2008 R2 cluster.

By the end of this paper, developers and administrators will be able to deploy business critical applications with MySQL on Windows Server, with the added reassurance of knowing that the solution has been certified and is fully supported.

Top 10 Reasons to Choose MySQL for Web-based Applications

MySQL powers 9 of the 10 top Web sites worldwide, as well as thousands of corporate web-based applications. When you are using Facebook, Twitter or Wikipedia, you are relying on MySQL to do so. When you are watching videos on YouTube, you are using MySQL. Anytime you search for events tickets on Ticketmaster, you are using MySQL.

In this whitepaper, we will help you better understand the top 10 reasons why MySQL has become the default choice for Web based applications, and how the world's most popular database keeps evolving to address the needs of the next generation of highly demanding web applications.

Guide to Scaling Web Databases with MySQL Cluster

9 of the top 10 most trafficked web properties on the planet including Facebook, Google, YouTube and Yahoo power their sites using MySQL. This provides unique insight into the challenges of scaling web databases, which in turn has driven the development of MySQL Cluster, integrating key technologies to enable the scaling of rapidly growing, write-intensive web databases, including:

Auto-sharding for write-scalability;
SQL and NoSQL interfaces;
Real-time responsiveness;
Active / active geographic replication;
Online scaling and schema upgrades;
99.999% availability.

This Guide explores the technology that enables MySQL Cluster to deliver web-scale performance with carrier-grade availability, and provides the resources to get you started in building your next successful web service.

Oracle VM Template for MySQL Enterprise Edition

As organizations increasingly deliver web-based services and as ISVs more broadly offer SaaS/on-demand versions of their software, they face the challenges of a rapidly expanding data center: increased operating costs, inefficient resource utilization and an appetite for real estate. Many are turning to virtualization technologies to provide solutions to these challenges, and enable a cloud infrastructure.

The Oracle VM Template for MySQL Enterprise Edition has been engineered to address these challenges, helping users to rapidly & safely deploy and manage web and cloud-based MySQL applications, with a lower TCO (Total Cost of Ownership) than other virtualization technologies in the marketplace.

Unlocking New Value from Web Session Management

Session Management with MySQL Cluster

As organizations seek to enhance their users' web experience through personalization based on historic browsing and buying behaviors, session data is becoming increasingly critical. Larger volumes of session data need to be managed, persisted and analyzed in real-time, and so session management has become more performance-intensive, while also demanding very high levels of availability to ensure a seamless customer experience. For rapidly growing web properties, it makes sense to evaluate the MySQL Cluster database.

This is a practical whitepaper featuring code samples that further discusses the challenges and solutions to session management, covering:

The demands of session management;
An overview of MySQL Cluster and how it can meet the challenges of today’s session management requirements;
Configuring session management with PHP and MySQL Cluster;
Configuring session management the memcached API with MySQL Cluster;
A case study of session management built with MySQL Cluster.

MySQL Enterprise Monitor for ISVs & OEMs

Over 2000 ISVs and OEMs such as Adobe, CA, F5, Sage, and Symantec rely on MySQL as their product’s database for its performance, quality, ease of use, and low-cost. Using MySQL Enterprise Monitor, you can further improve on those four qualities, even as you add more sophisticated capabilities to your application and your customers’ data volumes increase. MySQL Enterprise Monitor is now available to ISVs and OEMs to help ensure that MySQL is optimized for your particular product requirements, and in your customers’ specific environments. MySQL Enterprise Monitor helps your product perform at its peak – right out of the box and over time as your application’s and customers needs change.

MySQL Enterprise Backup - Fast, Consistent, Online Backups

Implementing proper database backup and disaster recovery plans to protect against accidental loss of data, database corruption, hardware/operating system crashes or any natural disasters has become one of the most important responsibilities of the Database Administrator (DBAs).

MySQL Enterprise Backup provides DBAs with a high-performance, online "hot" backup solution with data compression technology to ensure your data is protected in case of downtime or an outage.

MySQL 5.5: Storage Engine Performance Benchmark for MyISAM and InnoDB

With the release of MySQL 5.5, InnoDB has become the default storage engine.

InnoDB is designed to handle transactional applications that require crash recovery, referential integrity, high levels of user concurrency and fast response times. The purpose of this whitepaper is to directly compare performance of the latest InnoDB 1.1 release included with MySQL 5.5 and MyISAM, using a benchmark that is commonly run to measure MySQL throughput.

The paper also discusses the most common use cases for both InnoDB and MyISAM, enabling readers to assess the best storage engine for their specific application requirements.

MySQL - Powering The Online Media & Entertainment Industry

The Media & Entertainment industry experienced a spectacular transformation during the past decade.The once fairly well defined boundaries between the different types of media (i.e. Print, TV, Radio, Internet) have become increasingly blurred as we've gradually come to perform more and more of our daily activities "online."

As the term "Online Media" seems to become a pleonasm, we examine the following questions in this whitepaper:

What are some of the key trends shaping the evolution of the media & entertainment industry?
What are their implications and what requirements do those trends place on the infrastructure of information and entertainment services providers?
How can you leverage Oracle's MySQL technologies in order to win in the new world of media and entertainment?

What's New in MySQL 5.5

This white paper provides a look at what's new in MySQL 5.5, including greatly improved performance, scalability, and usability specifically on today's modern, multi-processing hardware, software, and middleware architectures. Sysbench benchmarks demonstrate performance improvements of up to 370% and 540% faster performance on Linux and Windows respectively. Also, new Semi-synchronous Replications and MySQL Performance Schema provide developers and DBAs with improved tools for building high performance, scalable applications

MySQL on Windows - Why, Where and How

While MySQL is famously known as the "M" of the popular LAMP stack (Linux, Apache, MySQL, PHP/Perl/Python), Microsoft Windows consistently ranks as the #1 development platform for MySQL users in our surveys. As a matter of fact, Windows now also ranks higher than any Linux distribution as a deployment platform among MySQL Community Edition users.

Why is the world's most popular open source database so popular on Windows? What are the applications for which one should consider MySQL on Microsoft's platform? How should Windows shops relying on Microsoft databases get going with MySQL?

MySQL Reference Architectures for Massively Scalable Web Infrastructure

MySQL is deployed in 9 of the top 10 most trafficked sites on the web including Google, Facebook and YouTube. This gives MySQL unique insight into how to design database-driven web architectures that deliver the highest levels of scalability and availability with the lowest levels of cost, risk and complexity.

This whitepaper presents a series of Reference Architectures for small, medium and large Web properties. You will learn about the components common to most web properties including Session Management, Authentication, eCommerce and Content Management. Optimum deployment architectures and topologies are defined based on sizing and availability requirements for each environment. The paper also discusses the unique requirements for Large Social Networking applications.

Top 10 Reasons to Choose MySQL for Online Retail

Online and Web-influenced in store sales will grow to 53 percent of total retail sales by 2014 according to independent research firm, Forrester Research, Inc. *

New technologies have offered people greater choice in the way they shop. Winning retailers adopt Web 2.0 technologies and best practices in order to improve their customers' online experience, cost-effectively create "buzz" about their offerings and boost their revenues.

This Whitepaper will help you better understand how to leverage MySQL to get the most of the opportunity the social web represents.

* US Online Retail Forecast, 2009 To 2014, Forrester Research, Inc., March 5, 2010

MySQL Replication - Enhancing Scalability and Availability with MySQL 5.5

MySQL Replication has been widely deployed by some of the leading properties on the web and in the enterprise to deliver extreme levels of database scalability. It provides a simple mechanism for users to rapidly create multiple replicas of their database to elastically scale-out beyond the capacity constraints of a single instance, enabling them to serve rapidly growing database workloads.

Replication is also used as the foundation for delivering highly available database services, providing a means of mirroring data across multiple hosts to withstand failures of individual systems.

This white paper introduces the concepts behind replication and what can be achieved with MySQL Replication. It steps through setting up replication as well as handling failover. In addition, the changes introduced to replication in MySQL 5.5 are covered as well as the differences when replicating with MySQL Cluster.

MySQL Query Analyzer: Overview

The MySQL Query Analyzer helps developers and DBAs improve application performance by monitoring query performance and accurately pinpointing SQL code that is causing a slow down. This paper explores common use cases and challenges faced by MySQL developers and DBAs in tuning SQL code. It also introduces the MySQL Query Analyzer and explains how it can be used to optimize queries during development and then to monitor applications in production environments.

MySQL Enterprise Monitor 2.3: What's New

MySQL is proud to announce the new release of MySQL Enterprise Monitor 2.3. This release can be used to monitor MySQL Servers that are part of a MySQL Cluster deployment. MySQL Enterprise Monitor 2.3 also improves general monitoring for MySQL and the Operating System by adding a set of new graphs for monitoring transactions and the new features available in InnoDB 1.1.

MySQL Enterprise Monitor: Business Overview

Whether they are working for large companies or for small businesses with only a handful of MySQL servers, the MySQL Enterprise Monitor is designed to scale DBA resources to include MySQL expertise by providing a unified, informed view into the health, security, performance and availability of the entire MySQL server environment. This paper explores the MySQL Enterprise Monitor in detail and explains how it can be leveraged as a "Virtual MySQL DBA" assistant to help over-extended DBAs proactively manage more MySQL servers with less time and effort.

Scaling Web Services with MySQL Cluster: An Alternative Approach to MySQL & memcached

MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web.

There are classes of web services however that are highly transactional and update-intensive, demanding real-time responsiveness and continuous availability. In these cases, MySQL Cluster provides the familiarity and ease-of-use of the regular MySQL Server, while delivering significantly higher levels of write performance with less complexity, lower latency and 99.999% availability.

This whitepaper will discuss the use-cases for both approaches, and provides an insight into how MySQL Cluster is enabling users to scale update-intensive web services.

MySQL Cluster Connector for Java

The MySQL Cluster Connector for Java implements a high performance and easy-to-use native Java interface and OpenJPA plug-in that directly maps Java objects to relational tables stored in the MySQL Cluster database.

By eliminating data transformations into SQL, users get lower data access latency and higher throughput, with a complete, feature-rich solution for Object/Relational Mapping.

This purpose of this whitepaper is to introduce the reader to the technology behind the MySQL Cluster Connector for Java (aka "ClusterJ") and to provide worked tutorials demonstrating how to compile and run code.

MySQL Cluster Manager

MySQL Cluster Manager simplifies the creation and management of the MySQL Cluster database by automating common management tasks. As a result, Database Administrators (DBAs) and Systems Administrator are more productive, enabling them to focus on strategic IT initiatives and respond more quickly to changing user requirements.

A Guide to Securing MySQL Embedded Server on Windows

Windows is the most popular platform for MySQL's ISVand OEM customers: 72% of those surveyed use Windows for development and 59% use Windows as their deployment platform. This white paper provides the best practices to secure a Windows-based installation of MySQL Embedded Server 5.1. The paper covers the following MySQL security-related topics:

Understanding the MySQL Security Model
Post-Installation Tasks
User Accounts
Password Management
Encryption
Data Communication
Database Replication

A Guide to Migrating from Microsoft SQL Server to MySQL Embedded Server

Many ISVs and OEMs have begun to look for a way to move away from embedding or bundling expensive proprietary databases with their products to a more cost effective database solution. This is especially important for ISVs / OEMs as all of the embedded / bundled database’s associated costs -- licensing, integration, support, maintenance, and administration -- are added to their products’ cost of good sold (COGS), which can negatively impact their profit margins and pricing flexibility. In particular, many ISVs / OEMs are migrating their applications from Microsoft SQL Server because of MySQL Embedded Server’s combination of cost-savings, platform freedom, and feature set.

Of course, a migration from any database is not something to be taken lightly; this being the case, many vendors are educating themselves as to the benefits and true effort/costs of moving to an alternative embedded database management system such as MySQL Embedded Server.

This paper provides insight into what is needed when considering a move from SQL Server to MySQL Embedded Server and presents a number of options that help make the transition easy. Both the business and technical sides of migrating to MySQL will be dealt with, so whether you are a product manager or a senior development engineer with years of database experience, you will find the answers you need in order to successfully migrate to the world’s most popular open source database - MySQL.

Guide to Optimizing Performance of the MySQL Cluster Database

This guide explores how to tune and optimize the MySQL Cluster database to handle diverse workload requirements. It discusses data access patterns and how to build distribution awareness into applications, before exploring schema and query optimization, tuning of parameters and how to get the best out of the latest innovations in hardware design.

The Guide concludes with recent performance benchmarks conducted with the MySQL Cluster database, an overview of how MySQL Cluster can be integrated with other MySQL storage engines, before summarizing additional resources that will enable you to optimize MySQL Cluster performance with your applications.

MySQL Cluster for Presence & Location-Based Services

With revenue from Location-Based Services forecast to reach $12bn by 2013, and nearly 1/3rd of all new mobile handsets expected to ship with GPS this year, mobile network operators and "Over The Top" web services providers are looking to rapidly develop and launch enriched mobile services that take advantage of location and presence capabilities.

This whitepaper explores the different types of services that can take advantage of location and presence awareness, and considers their unique requirements for data management. A solution is then presented, based on MySQL Cluster, that allows operators to fully leverage the market opportunity and differentiation presented by these new services.

Using MySQL Cluster 7.1 for Web and eCommerce Applications

As your on-line services expand, so too can the demands on your web infrastructure.

Challenges include:

Growing revenue streams and customer loyalty from your web and eCommerce applications
The need for continuous application availability and real time responsiveness to ensure a quality customer experience
Constant pace of innovation to quickly deliver compelling new services to market

MySQL Cluster is a proven key component of web infrastructure that can help you cost-effectively deploy online applications to generate new revenue streams and build vibrant user communities.

Read the white paper to learn how deploying MySQL Cluster with your web and eCommerce services enables you to grow revenue and enhance customer loyalty.

A Visual Guide to Installing MySQL on Windows

The following guide is meant to make getting started with MySQL easily for Windows developers, system administrators and Microsoft SQL Server DBAs that are new to MySQL. This paper will guide you through the steps and tools needed to get up and running quickly with MySQL on Windows using familiar terms, comparisons, and language. Its goal is to put in place basic knowledge and building blocks you will need in conjunction with added references to resources as you continue to drill down further into the more advanced features of MySQL.

A Visual Guide to Microsoft SQL Server 2008 Reporting Services and MySQL

For many years, Microsoft Windows has been the most popular development platform and second most popular production platform for organizations developing MySQL applications. In early 2009 we conducted our annual survey in which we found that 66% percent of those surveyed used Windows for development and 48% ultimately deployed into production on Windows. For some, this fact may come as a surprise given MySQL is the "M" in the open source Linux, Apache, PHP, Perl and Python (LAMP) stack. We also found that roughly one in three MySQL Enterprise shops also made use of Microsoft SQL Server. When we asked what motivated an organizations interest in MySQL, we found that cost savings, performance and freedom from vendor lock in to be the most compelling reasons to deploy MySQL in conjunction with SQL Server. In this paper we will visually show you how to connect MySQL into some of the existing tools that the SQL Server DBA will already be familiar with. Specifically in this paper we will look at how configure connectivity to MySQL with your existing reporting infrastructure based on SQL Server 2008 Reporting Services.

Delivering Scalable & Highly Available Authentication & Accounting Services

This whitepaper discusses the concepts of current data storage solutions for Authentication, Authorization and Accounting (AAA) environments and their potential limitations as network use grows and services become more dynamic.

The paper then presents an alternative deployment scenario based on the FreeRADIUS Server and MySQL Cluster serving as the back-end AAA database, providing an infrastructure for high growth and availability, with low complexity. A sizing study and user case study are presented to demonstrate how the solution performs in real-world AAA environments

Deploying FreeRADIUS with the MySQL Cluster Database

This Guide documents a best-practice approach to configuring and testing a FreeRADIUS server deployed with the MySQL Cluster database storage engine serving as the back-end data store for user and accounting data. Deployment topologies and configurations are presented, enabling users to quickly and simply replicate the solution in their own environment.

MySQL Storage Engine Comparison Guide

The MySQL Server is unique among database management systems in that it offers the ability to use many different types of database engines via its storage engine architecture. Not only are these engines developed by MySQL/Sun, but a number come from MySQL partners and ISV's as well. The end result is a very flexible and innovative environment that offers many benefits including higher performance and more efficient usage of hardware resources.

Because the different storage engines have distinct characteristics and use cases where they excel, questions sometimes arise as to which storage engine(s) are best for various types of application scenarios. This paper compares and contrasts in detail all the current internal and external storage engines so MySQL professionals will have a better understanding of the different features of each engine and when to employ the different engines in their database architectures.

IDC Analysis of Open Source Adoption in Telecommunications Service Delivery Infrastructure

Reducing cost, accelerating time to market and enhancing subscriber experience are key drivers for investment by Communications Service Providers (CSPs) today, and open source technologies are playing a transformational role in enabling CSPs to meet these strategic goals.

Get the latest research from IDC and MySQL and learn where and why CSPs and technology providers are adopting open source technologies to power the next generation of network service infrastructure.

Best Practices for MySQL on Amazon EC2

Currently, the most popular cloud computing platform is Amazon Web Services (AWS) and the most popular database in the cloud is MySQL. Although Amazon originally launched AWS in 2002 and since has made available many new computing services including infrastructure, e-commerce and Web information services. For the purposes of this paper we will focus on those most relevant to deploying MySQL - specifically Elastic Computing Cloud (EC2), Simple Storage Service (S3) and Elastic Block Store (EBS). These are services which developers can access using web services, specifically REST and SOAP protocols.

Designing and Implementing Scalable Applications with Memcached and MySQL

Memached is an open-source, distributed memory caching system designed to tackle today's web-scale performance and scalability challenges. Many of the largest and most heavily trafficked web properties on the Internet like Facebook, Fotolog, YouTube, Mixi.jp, Yahoo, and Wikipedia deploy Memcached and MySQL to satisfy the demands of millions of users and billions of page views every month. By integrating a caching tier into their web- scale architectures, these organizations have improved their application performance while minimizing database load. In doing so, they manage to increase their scalability to accommodate more concurrent users and spikes in traffic while at the same time making the most efficient use of their existing computing infrastructure.

MySQL Enterprise Edition for Managed Hosting and SaaS Providers

Whether a SaaS provider chooses to host their applications in-house or remotely at either a collocation or a managed hosting facility, a subscription to MySQL Enterprise Edition helps ensure that the databases comprising the core elements of their technology platform meet or exceed the expected Service Level Agreements (SLAs) concerning performance, scalability and uptime. In this paper we explore the SaaS marketplace, its associated business and technical challenges, and offer some solutions in the process. Finally, we will present several case studies concerning how existing SaaS providers and transitioning ISVs, leverage MySQL Enterprise Edition to deliver a new class of scalable, high performance online business applications.

MySQL Cluster Evaluation Guide

Designing, Evaluating and Benchmarking MySQL Cluster

MySQL: Embedded Database for ISVs

Embedded relational database management systems (RDBMS's) are databases that ISV's (Independent Software Vendors) and OEM's (Original Equipment Manufacturers) bundle with their software products. These embedded databases are normally "invisible" to the end user of the software with standard database management functions being automatically handled either by the database itself or through an application interface exposed through the ISV's own software.

The technology-centric analyst group IDC forecasts a growing dependence on embedded databases. Reasons cited for this trend include an increasing emphasis on self-contained packaged applications, the need of small businesses for robust but lower-priced data-driven systems, and a shortage of complex database technical expertise in the overall market. The Forrester Group, another IT analyst group, has found that open source databases are quickly becoming a leading force in the embedded application market, being found at all levels of applications - from large network embedded systems to very small appliances.

The MySQL server, the world's most popular open source database, has been named a leader in the overall and embedded database management market by Forrester and other analyst groups. The reasons for this include the benefits that the open source paradigm brings to OEM's and ISV's, numerous technical advantages of the MySQL database, strong ease-of use, complete technical support, a dual-licensing model, and a very low total cost of ownership.

This paper explores these benefits in detail and showcases why MySQL is the ideal choice for OEM's and ISV's when it comes to selecting an embedded database for their application.

Building Subscriber Databases with MySQL Cluster Carrier Grade Edition

MySQL Cluster Carrier Grade Edition is a clustered real-time database based on the Network Database (NDB) storage engine, which is deployed in some of the most demanding subscriber database systems found in the telecommunications industry. In this paper we describe how MySQL Cluster Carrier Grade Edition can be used to build a scalable, highly available, geographically replicated Subscriber Database. We show how user-defined partitioning and distribution keys help a subscriber database to scale its performance near-linearly with cluster size, while maintaining the benefits of a relational database, with a SQL API.

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.

How MySQL Powers Web 2.0

Web 2.0 can be thought of as the technologies and web sites that leverage users and developers in a socially collaborative manner in order to rapidly develop data and applications with a high level of integration across platforms and other services.

MySQL enables up-and-coming Web 2.0 sites like Wikipedia, FeedBurner and digg, - as well as established web properties like Craigslist, Google and Yahoo! - to scale out and meet the ever-increasing volume of users, transactions and data.

The information presented here will be valuable to entrepreneurs about to create their own Web 2.0 business, existing web properties wishing to bring their applications to the next level, but also to the large number of enterprises interested in leveraging Web 2.0 technologies. You will also gain an understanding of how MySQL can be used in conjunction with other open source components to deliver low-cost, reliable, scalable, high performance Web 2.0 applications.

A Practical Guide to Migrating From Microsoft SQL Server to MySQL

With the rapid growth of MySQL in the database market, many corporations, government agencies, educational institutions, and others have begun to migrate away from their expensive and proprietary databases. Of course, a migration from any database is not something to be taken lightly, and so countless organizations are considering their options for migrating to MySQL.

In particular, many MySQL customers are migrating from SQL Server because they have reached the conclusion that the combination of cost-savings, platform freedom, and feature set of MySQL make for a compelling business case to offload some or all their database-driven applications to the MySQL database server.

This paper provides insight into what is needed for considering a move from SQL Server to MySQL, and presents a number of options that help make the transition easy. Both the business and technical sides of migrating to MySQL will be dealt with, so whether you are a manager or a seasoned DBA, you will find the needed answers to questions that revolve around migrating to the world's most popular open source database - MySQL.

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.

Contact Sales

Related Pages:

White Papers

All White Papers