Friday Nov 30, 2012

Redehost Transforms Cloud & Hosting Services with MySQL Enterprise Edition

RedeHost are one of Brazil's largest cloud computing and web hosting providers, with more than 60,000 customers and 52,000 web sites running on its infrastructure.

As the company grew, Redehost needed to automate operations, such as system monitoring, making the operations team more proactive in solving problems. Redehost also sought to improve server uptime, robustness, and availability, especially during backup windows, when performance would often dip.

To address the needs of the business, Redehost migrated from the community edition of MySQL to MySQL Enterprise Edition, which has delivered a host of benefits:

- Pro-active database management and monitoring using MySQL Enterprise Monitor, enabling Redehost to fulfil customer SLAs. Using the Query Analyzer, Redehost were able to more rapidly identify slow queries, improving customer support

- Quadrupled backup speed with MySQL Enterprise Backup, leading to faster data recovery and improved system availability

- Reduced DBA overhead by 50% due to the improved support capabilities offered by MySQL Enterprise Edition.

- Enabled infrastructure consolidation, avoiding unnecessary energy costs and premature hardware acquisition

You can learn more from the full Redehost Case Study

Also, take a look at the recently updated MySQL in the Cloud whitepaper for the latest developments that are making it even simpler and more efficient to develop and deploy new services with MySQL in the cloud

Thursday Nov 29, 2012

MySQL and Hadoop Integration - Unlocking New Insight

“Big Data” offers the potential for organizations to revolutionize their operations. With the volume of business data doubling every 1.2 years, analysts and business users are discovering very real benefits when integrating and analyzing data from multiple sources, enabling deeper insight into their customers, partners, and business processes.

As the world’s most popular open source database, and the most deployed database in the web and cloud, MySQL is a key component of many big data platforms, with Hadoop vendors estimating 80% of deployments are integrated with MySQL.

The new Guide to MySQL and Hadoop presents the tools enabling integration between the two data platforms, supporting the data lifecycle from acquisition and organisation to analysis and visualisation / decision, as shown in the figure below

The Guide details each of these stages and the technologies supporting them:

Acquire: Through new NoSQL APIs, MySQL is able to ingest high volume, high velocity data, without sacrificing ACID guarantees, thereby ensuring data quality. Real-time analytics can also be run against newly acquired data, enabling immediate business insight, before data is loaded into Hadoop. In addition, sensitive data can be pre-processed, for example healthcare or financial services records can be anonymized, before transfer to Hadoop.

Organize: Data is transferred from MySQL tables to Hadoop using Apache Sqoop. With the MySQL Binlog (Binary Log) API, users can also invoke real-time change data capture processes to stream updates to HDFS.

Analyze: Multi-structured data ingested from multiple sources is consolidated and processed within the Hadoop platform.

Decide: The results of the analysis are loaded back to MySQL via Apache Sqoop where they inform real-time operational processes or provide source data for BI analytics tools.

So how are companies taking advantage of this today? As an example, on-line retailers can use big data from their web properties to better understand site visitors’ activities, such as paths through the site, pages viewed, and comments posted. This knowledge can be combined with user profiles and purchasing history to gain a better understanding of customers, and the delivery of highly targeted offers.

Of course, it is not just in the web that big data can make a difference. Every business activity can benefit, with other common use cases including:

- Sentiment analysis;

- Marketing campaign analysis;

- Customer churn modeling;

- Fraud detection;

- Research and Development;

- Risk Modeling;

- And more.

As the guide discusses, Big Data is promising a significant transformation of the way organizations leverage data to run their businesses. MySQL can be seamlessly integrated within a Big Data lifecycle, enabling the unification of multi-structured data into common data platforms, taking advantage of all new data sources and yielding more insight than was ever previously imaginable.

Download the guide to MySQL and Hadoop integration to learn more. I'd also be interested in hearing about how you are integrating MySQL with Hadoop today, and your requirements for the future, so please use the comments on this blog to share your insights.

Monday Nov 19, 2012

MySQL at the DOAG Conference this week in Nuremberg

Planning to attend the DOAG Conference this week in Nuremberg? There will be several MySQL presentations, including the three following ones from Oracle team members:

Oracle GoldenGate: Bindeglied zwischen Oracle & MySQL Datenbanken
Ileana Somesan
Wednesday November 21, 12:00

NoSQL and SQL: Blending the Best of Both Worlds

Andrew Morgan
Wednesday November 21, 14:00

MySQL Replikation

Carsten Thalheimer
Wednesday November 21,  16:00

We look forward to seeing you there!

Thursday Nov 15, 2012

Considering Embedding a Database? Choose MySQL!

The M of the LAMP stack and the #1 database for Web-based applications, MySQL is also an extremely popular choice as embedded database.

Access our Resource Kit to discover the top reasons why:


  • 3,000 ISVs and OEMs rely on MySQL as their embedded database
  • 8 of the top 10 software vendors and hundreds of startups selected MySQL to power their cloud, on-premise and appliance-based offerings
  • Leading mobile and SaaS providers ensure continuous service availability and scalability with lower cost and risk using MySQL Cluster.

Learn how you can reduce costs and accelerate time to market while increasing performance and reliability. Access white papers, webinars, case studies and other resources in our Resource Kit.


Tuesday Nov 13, 2012

Top 10 Reasons to Use MySQL and MySQL Cluster as an Embedded Database

If you are considering using MySQL and/or MySQL Cluster as the embedded database solution for your application, you should join us for today's webcast where we will discuss how you can cut costs, add flexibility and benefit from new performance and scalability enhancements that are now available in MySQL 5.6 and MySQL Cluster 7.2.  We will cover the top 10 reasons that make MySQL and MySQL Cluster the best solutions for embedding in both shrink wrapped and SaaS provided applications, how industry leaders leverage MySQL products and how you can get started with the latest innovations and support offerings across the MySQL product line.

You can learn more and reserve your seat here.

As always, thanks for your support of MySQL!

Monday Nov 12, 2012

Attend MySQL Webinars This Week

Interested in learning more about MySQL as embedded database? In building highly available MySQL applications with MySQL and DRBD? Join our webinars this week! All information below.

Tuesday next week (November 20) we will provide an update about what's new in MySQL Enterprise Edition.

We have live Q&A during the webinars so you'll get the chance to ask all your questions.

Top 10 Reasons to Use MySQL as an Embedded Database

Tuesday, November 13
9:00 a.m. PT
Review the top 10 reasons why MySQL is technically well-suited for embedded use, as well as the related business reasons vendors choose MySQL initially, over time, and across product-lines.
Register for the Webcast.

MySQL High Availability with Distributed Replicated Block Device

Thursday, November 15
9:00 a.m. PT
Learn how to build highly available services with MySQL and distributed replicated block device (DRBD). The DRBD high-availability solution comprises a complete stack of open source software that delivers high-availability database clusters on commodity hardware, with the option of 24/7 support from Oracle.
Register for the Webcast.

Technology Update: What's New in MySQL Enterprise Edition

Tuesday, November 20
9:00 a.m. PT
Find out what's new in MySQL Enterprise Edition.
Register for the Webcast.

Thursday Nov 08, 2012

Election 2012: Twitter Breaks Records with MySQL

Twitter VP of Infrastructure Operations Engineering Mazen Rawashdeh shared news and numbers yesterday on his blog:

"Last night, the world tuned in to Twitter to share the election results as U.S. voters chose a president and settled many other campaigns. Throughout the day, people sent more than 31 million election-related Tweets (which contained certain key terms and relevant hashtags). And as results rolled in, we tracked the surge in election-related Tweets at 327,452 Tweets per minute (TPM). These numbers reflect the largest election-related Twitter conversation during our 6 years of existence, though they don’t capture the total volume of all Tweets yesterday."

"Last night, Twitter averaged about 9,965 TPS from 8:11pm to 9:11pm PT, with a one-second peak of 15,107 TPS at 8:20pm PT and a one-minute peak of 874,560 TPM. Seeing a sustained peak over the course of an entire event is a change from the way people have previously turned to Twitter during live events. Now, rather than brief spikes, we are seeing sustained peaks for hours."

Congrats to Jeremy Cole, Davi Arnaut and the rest of the team at Twitter for their excellent work!

Jeremy recently held a keynote presentation at MySQL Connect describing how MySQL powers Twitter, and why they chose and continue to rely on MySQL for their operations. You can watch the presentation here. He also went into more details during another presentation later that day and you can access the slides here.

Below a couple of tweets from Jeremy after what have surely been hectic days...

 Keep up the good work guys!

Monday Nov 05, 2012

MySQL Policy-Based Auditing Webinar Recording Now Availabile

For those who missed the live event, the recording of the "How to Add Policy-Based Auditing to your MySQL Applications" webinar is now available.  You can view it here.

This presentation builds on my earlier blog post on MySQL Enterprise Audit that was announced at MySQL Connect in late September.  The web presentation expands on the introductory blog and covers:

  • The regulatory problem to be solved (internal audit, PCI, Sarbanes-Oxley, HIPAA, others)
  • MySQL Audit solutions for both Community and Enterprise users:
    • General Log - use the basic features of the MySQL server
    • MySQL 5.5 open audit API - or use your time and talent to build your own solution
    • MySQL Enterprise Audit - or use the out of the box, ready for production solution from MySQL
  • Simple, step-by-step process for installing, enabling and configuring the MySQL Enterprise Audit plugin for use with existing apps
  • New variables and options for tuning the MySQL Enterprise Audit plugin for your specific use case
  • Best practices for securing and managing audit log files and archived images
  • Roadmap for adding an integrated solution around MySQL Enterprise Audit for MySQL only and Oracle/MySQL shops

You can learn all the technical details on MySQL Enterprise Audit in the MySQL docs and learn all about MySQL Enterprise Edition and Auditing here.

As always, thanks for your support of MySQL!


Get the latest updates on products, technology, news, events, webcasts, customers and more.




« November 2012 »