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 26, 2012

Learn to Create Applications Using MySQL with MySQL for Developers Course

If you are a database developer who wants to create applications using MySQL, then the MySQL for Developers course is for you. This course covers how to plan, design and implement applications using the MySQL database with realistic examples in Java and PHP.

To see more details of the content of the MySQL for Developers course, go to http://oracle.com/education/mysql and click on the Learning Paths tab and select the MySQL Developer path.

You can take this course as a:

  • Live-Virtual Event: Follow this live instructor-led event from your own desk - no travel required. Choose from a selection of events on the calendar in languages such as English, German and Korean.
  • In-Class Event: Travel to an education center to take this class. Below is a sample of events on the schedule.

 Location

 Date

 Language

 Vienna, Austria

 4 March 2013

 German

 London, England

 4 March 2013

 English

 Gummersbach, Germany

 11 February 2013

 Germany

 Hamburg, Germany

 14 January 2013

 Germany

 Munich, Germany

 15 April 2013

 Germany

 Budapest, Hungary

 15 April 2013

 Hungarian

 Milan, Italy

 21 January 2013

 Italy

 Rome, Italy

 11 March 2013

 Italy

 Amsterdam, Netherlands

 28 January 2013

 Dutch

 Nieuwegein, Netherlands

 13 May 2013

 Dutch

 Lisbon, Portugal

 18 February 2013

 European Portugese

 Porto, Portugal

 18 February 2013

 European Portugese

 Barcelona, Spain

 18 February 2013

 Spanish

 Madrid, Spain

 28 January 2013

 Spanish

 Bern, Switzerland

 11 April 2013

 German

 Zurich, Switzerland

 11 April 2013

 German

 Nairobi, Kenya

 21 January 2013

 English

 Petaling Jaya, Malaysia

 17 December 2012

 English

 Sao Paulo, Brazil

 11 March 2013

 Brazilian Portugese

For more information on this class or other courses on the authentic MySQL curriculum, or to express your interest in additional events, go to http://oracle.com/education/mysql.

Note, many organizations deploy both Oracle Database and MySQL side by side to serve different needs, and as a database professional you can find training courses on both topics at Oracle University! Check out the upcoming Oracle Database training courses and MySQL training courses. Even if you're only managing Oracle Databases at this point of time, getting familiar with MySQL will broaden your career path with growing job demand.

Monday Nov 19, 2012

Develop DBA skills with MySQL for Database Administrators course

MySQL is the world's number one open source database and the number one database for the Web. Join top companies by developing your MySQL Database Administrator skills.

The MySQL for Database Administrators course is for DBAs and other database professionals who want to install the MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases.

You can take this 5 day course as

  • Training on Demand: Start training within 24 hours of registration. You will follow the lecture material via streaming video and perform hands-on activities at a date and time that suits you.
  • Live-Virtual Event:  Take this instructor-led course from your own desk. Choose from the 19 events currently on the schedule and find an event that suits you in terms of timezone and date.
  • In-Class Event: Travel to an education center. Here is a sample of events on the schedule:

 

 Location

 Date

 Delivery Language

 Mechelen, Belgium

 25 February 2013

 English

 London, England

 26 November 2012

 English

 Nice, France

 3 December 2012

 French

 Paris, France

 11 February 2013

 French

 Budapest, Hungary

 26 November 2012

 Hungarian

 Belfast, Ireland

 24 June 2013

 English

 Milan, Italy

 14 January 2013

 Italian

 Rome, Italy

 18 February 2013

 Italian

 Amsterdam, Netherlands

 24 June 2013

 Dutch

 Nieuwegein, Netherlands

 8 April 2013

 Dutch

 Warsaw, Poland

 10 December 2012

 Polish

 Lisbon, Portugal

 21 January 2013

 European Portugese

 Porto, Portugal

 21 January 2013

 European Portugese

 Barcelona, Spain

 4 February 2013

 Spanish

 Madrid, Spain

 21 January 2013

 Spanish

 Nairobi, Kenya

 26 November 2012

 English

 Johannesburg, South Africa

 9 December 2013

 English

 Tokyo, Japan

 10 December 2012

 Japanese

 Singapore

 28 January 2013

 English

 Brisbane, Australia

 10 December 2012

 English

 Edmonton, Canada

 7 January 2013

 English

 Montreal, Canada

 28 January 2013

 English

 Ottawa, Canada

 28 January 2013

 English

 Toronto, Canada

 28 January 2013

 English

 Vancouver, Canada

 7 January 2013

 English

 Mexico City, Mexico

 10 December 2012

 Spanish

 Sao Paolo, Brazil

 10 December 2012

 Brazilian Portugese

For more information on this course or on other courses on the authentic MySQL Curriculum, go to http://oracle.com/education/mysql.

Note, many organizations deploy both Oracle Database and MySQL side by side to serve different needs, and as a database professional you can find training courses on both topics at Oracle University! Check out the upcoming Oracle Database training courses and MySQL training courses. Even if you're only managing Oracle Databases at this point of time, getting familiar with MySQL will broaden your career path with growing job demand.

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!


Power Dynamic Database-Driven Websites with MySQL & PHP

Join major names among MySQL customers by learning to power dynamic database-driven websites with MySQL & PHP.

With the MySQL and PHP: Developing Dynamic Web Applications course, in 4 days, you learn how to develop applications in PHP and how to use MySQL efficiently for those applications! Through a hands-on approach, this instructor-led course helps you improve your PHP skills and combine them with time-proven database management techniques to create best-of-breed web applications that are efficient, solid and secure.

You can currently take this course as a:

  • Live Virtual Class (LVC): There are a number events on the schedule to suit different timezones in January 2013 and March 2013. With an LVC, you get to follow this live instructor-led class from your own desk - so no travel expense or inconvenience.
  • In-Class Event: Travel to an education center to attend this class. Here are some events already on the scheduled:

 Where

 When

 Delivery Language

 Lisbon, Portugal

 15 April 2013

 European Portugese

 Porto, Portugal

15 April 2013 

 European Portugese

 Barcelona, Spain

28 February 2013

 Spanish

 Madrid, Spain

4 March 2013 

 Spanish

If you do not see an event that suits you, register your interest in an additional date/location/delivery language.

If you want more indepth knowledge on developing with MySQL and PHP, consider the MySQL for Developers course.

For full details on these and all courses on the authentic MySQL curriculum, go to http://oracle.com/education/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!


Three Ways to Get Started with MySQL Training

Here is your chance to learn how this powerful relational database management system can make your life easier and more fun! The MySQL for Beginners class covers all the basics and will get you on your way, with a solid foundation. This instructor led, hands-on class covers the fundamentals of SQL and relational databases, using MySQL[tm] as a teaching tool.

You can take the MySQL for Beginners, 4 day instructor-led, class in any of the following three ways:

  • Training-On-Demand: See what Ben Krug, MySQL Support Engineer has to say about his experience taking the MySQL for Beginners TOD. With this streaming video delivery, you get started on taking the MySQL for Beginners course within 24 hrs of purchase, and follow the course at your own pace.
  • Live-Virtual-Class: Take this class from your own desk - no travel required. There is a wide range of events on the schedule with delivery in English and German.
  • In-Class: Travel to an education center to follow this class. Below is a sample of event on the schedule:

Location

 Date

 Delivery Language

 Mechelen, Belgium

 14 January 2013

 English

 London, England

 3 December 2012

 English

 Hamburg, Germany

 3 December 2012

 German

 Budapest, Hungary

 5 February 2013

 Hungarian

 Riga, Latvia

18 February 2013 

 Latvian

Amsterdam, Netherlands 

10 December 2012 

Dutch 

Nieuwegein, Netherlands 

18 February 2013 

Dutch 

Warsaw, Poland 

26 November 2012 

 Polish

 Lisbon, Portugal

25 March 2013 

European Portugese 

 Porto, Portugal

 25 March 2013

 European Portugese

 Barcelona, Spain

11 February 2013 

 Spanish

 Madrid, Spain

8 January 2013 

 Spanish

Nairobi, Kenya 

14 January 2013 

 English

 Cape Town, South Africa

 22 July 2013

 English

 Pretoria, South Africa

22 April 2013

 English

Ottawa, Canada

17 December 2012 

English 

Toronto, Canada

17 December 2012 

 English

 Montreal, Canada

 17 December 2012

English 

 

For more information on the Authentic MySQL Curriculum or to register your interest in an additional event, go to http://oracle.com/education/mysql.

Note, many organizations deploy both Oracle Database and MySQL side by side to serve different needs, and as a database professional you can find training courses on both topics at Oracle University! Check out the upcoming Oracle Database training courses and MySQL training courses. Even if you're only managing Oracle Databases at this point of time, getting familiar with MySQL will broaden your career path with growing job demand.

Thursday Nov 01, 2012

MySQL Cluster 7.3: On-Demand Webinar and Q&A Available

The on-demand webinar for the MySQL Cluster 7.3 Development Release is now available.

You can learn more about the design, implementation and getting started with all of the new MySQL Cluster 7.3 features from the comfort and convenience of your own device, including:

- Foreign Key constraints in MySQL Cluster

- Node.js NoSQL API 

- Auto-installation of higher performance distributed, clusters

We received some great questions over the course of the webinar, and I wanted to share those for the benefit of a broader audience.

Q. What Foreign Key actions are supported:

A. The core referential actions defined in the SQL:2003 standard are implemented:

CASCADE

RESTRICT

NO ACTION

SET NULL

Q. Where are Foreign Keys implemented, ie data nodes or SQL nodes?

A. They are implemented in the data nodes, therefore can be enforced for both the SQL and NoSQL APIs

Q. Are they compatible with the InnoDB Foreign Key implementation?

A. Yes, with the following exceptions:

- InnoDB doesn’t support “No Action” constraints, MySQL Cluster does

- You can choose to suspend FK constraint enforcement with InnoDB using the FOREIGN_KEY_CHECKS parameter; at the moment, MySQL Cluster ignores that parameter.

- You cannot set up FKs between 2 tables where one is stored using MySQL Cluster and the other InnoDB.

- You cannot change primary keys through the NDB API which means that the MySQL Server actually has to simulate such operations by deleting and re-adding the row. If the PK in the parent table has a FK constraint on it then this causes non-ideal behaviour. With Restrict or No Action constraints, the change will result in an error. With Cascaded constraints, you’d want the rows in the child table to be updated with the new FK value but, the implicit delete of the row from the parent table would remove the associated rows from the child table and the subsequent implicit insert into the parent wouldn’t reinstate the child rows. For this reason, an attempt to add an ON UPDATE CASCADE where the parent column is a primary key will be rejected.

Q. Does adding or dropping Foreign Keys cause downtime due to a schema change?

A. Nope, this is an online operation. MySQL Cluster supports a number of on-line schema changes, ie adding and dropping indexes, adding columns, etc.

Q. Where can I see an example of node.js with MySQL Cluster?

A. Check out the tutorial and download the code from GitHub

Q. Can I use the auto-installer to support remote deployments? How about setting up MySQL Cluster 7.2?

A. Yes to both!

Q. Can I get a demo

Check out the tutorial. You can download the code from http://labs.mysql.com/ Go to Select Build drop-down box

Q. What is be minimum internet speen required for Geo distributed cluster with synchronous replication?

A. if you're splitting you cluster between sites then we recommend a network latency of 20ms or less. Alternatively, use MySQL asynchronous replication where the latency of your WAN doesn't impact the latency of your reads/writes.

Q. Where you can one learn more about the PayPal project with MySQL Cluster?

A. Take a look at the following - you'll find press coverage, a video and slides from their keynote presentation 

So, if you want to learn more, listen to the new MySQL Cluster 7.3 on-demand webinar 

MySQL Cluster 7.3 is still in the development phase, so it would be great to get your feedback on these new features, and things you want to see!


About

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

Twitter


Facebook

Search

Archives
« November 2012 »
SunMonTueWedThuFriSat
    
2
3
4
6
7
9
10
11
14
16
17
18
20
21
22
23
24
25
27
28
 
       
Today