September 2011
This is a special edition of the MySQL Newsletter. A MySQL Newsletter Special Edition is issued each quarter, highlighting information on topics most relevant to MySQL DBAs and developers. This edition is focused on Oracle OpenWorld, the most important educational and networking event of the year for Oracle technologists, customers, and partners.
Articles in this newsletter:
Highlights
- Event: Oracle OpenWorld 2011 - Register Now!
- Event: OTN Developer Day, MySQL - London, October 18th - Register Now!
- New Whitepaper: Top 10 Reasons to Choose MySQL for Web-based Applications
- New Whitepaper: Guide to Scaling Web Databases with MySQL Cluster
- Live Webinar: MySQL Essentials for ISVs & OEMs, Part II: Deployment and Data Security
- Live Webinar: Building High Performance and High Traffic PHP Applications with MySQL (in Italian)
- Live Webinar: MySQL Replication Essentials (in German)
- MySQL Enterprise Edition Flash Demo
Focus on MySQL at Oracle OpenWorld 2011:
Sunday Sessions - IOUG/MySQL Community
- Improving MySQL Performance with Better Indexes
- MySQL: Don't Be a Rookie Forever - Be in Command (Line)
- MySQL and SSD - Usage Patterns
- Jailbreaking MySQL Replication
- Maatkit Tools - Like a MySQL Guru in a Box
- Importing and Exporting Data Between Hadoop and MySQL
- SQL Injection Myths and Fallacies
- MySQL High Availability
- Explaining the MySQL Explain
- Lessons Learned from Managing Way Too Many Database Servers
- Bridging MySQL and Oracle Databases with Open Source Replication
- Challenges of Big Databases with MySQL
- Implementing Online Backup for Large-Scale MySQL Environments
- Securing MySQL
Database Track Sessions, Mon-Thu
- MySQL Authentication Options
- Accelerating Telecom Transformation with Web 2.0
- Being a Rock Star MySQL DBA
- Introduction to MySQL Replication
- MySQL Executive Keynote: The State of the Dolphin
- Operational Wins in MySQL Release 5.5
- Scaling and Monitoring MySQL for Rapidly Growing Social Gaming
- Ticketmaster: Building the Fastest Ticketing Site with MySQL and Oracle Database
- Getting to Know MySQL Enterprise Monitor
- Advanced MySQL Replication Architectures
- MySQL Performance Tuning at Ning
- Getting the Most Out of MySQL on Windows
- Introduction to InnoDB, MySQL's Default Storage Engine
- MySQL for Oracle DBAs, or How to Speak MySQL for Beginners
- InnoDB Performance Tuning
- The MySQL Roadmap: Discover What's New
- Diagnosing Scalability Issues in Java Applications on MySQL
- Building Highly Available and Scalable Real-Time Services with MySQL Cluster
- Monitoring MySQL with Oracle Enterprise Manager Grid Control
- NoSQL Access to MySQL: The Best of Both Worlds
- Using MySQL with Other Oracle Products
- Data Protection and Recovery for MySQL
- Customer Success Stories: MySQL as an Embedded Database
- MySQL Enterprise Backup
- MySQL Monitoring Mechanisms: How the Different Pieces Fit Together
- NoSQL Interfaces to MySQL Cluster
- What Causes Downtime in MySQL, and How Can You Prevent It?
- MySQL Crash Course: Overview of Basic MySQL Concepts
- MySQL Server Performance Tuning 101
- Cloud Computing Solutions for MySQL
- MySQL Efficiency on NetApp
MySQL Hands-on Lab
MySQL Demos
MySQL Community Reception
-------------------------------------------------------------------
Highlights
Event: Oracle OpenWorld 2011 - Register Now to attend the session packed MySQL Track!
Register Now!
http://www.oracle.com/openworld/register/packages/index.html
Event: OTN Developer Day, MySQL - London, October 18th - Register Now!
The MySQL Developer Day is a one-stop shop for you to learn all the essential MySQL skills. In this free, one-day seminar, we will cover everything you need to know to successfully design, develop, and manage your MySQL databases. You'll also learn the guidelines and best practices in performance tuning and scalability.
Attend this event and gain the knowledge to:
- Develop your new applications cost-effectively using MySQL
- Improve performance of your existing MySQL databases
- Manage your MySQL environment more efficiently
Don't miss this exclusive opportunity to learn tips and tricks from the MySQL experts at Oracle, and network with your peers. Whether you're a DBA or a developer, find out how you can make the best of MySQL in your IT infrastructure or in your commercial products and applications.
Space is limited, Register Now!
http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=140663&src=7314534&src=7314534&Act=97
New Whitepaper: 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.
Read the White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-top10-webbased-apps.php
New Whitepaper: 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.
Read the White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_scaling_web_databases.php
Live Webinar: MySQL Essentials for ISVs & OEMs, Part II: Deployment and Data Security
Thursday, September 22, 2011
The way your product's database deploys impacts your customers' experience of your product - from trial and installation, to administration and customization / optimization options. Your product's data security can have great impact on your customers' overall satisfaction. Both are important to getting and keeping your customers.
Deployment: MySQL deployments are typically fast and easy - even for your non-technical customers. MySQL may be bundled with or deeply embedded to run as a process in your application with invisible installation and zero administration. MySQL Engineer and Expert, Dale Dasker, will help you determine which deployment option is best for your product. He will show you step-by-step how to:
- Develop a silent install process
- Run MySQL as an executable process
- Deeply Embed MySQL library (libmysqld) in your application
Security: MySQL database's default settings assume restricted access to the physical server and restricted file systems privileges but this is often not the case with embedded or bundled databases. Dale will show you how to use the following strategies to prevent data file tampering:
- Set MySQL to install securely
- Obscure InnoDB data files
- Make your application aware of database tampering
Register for the webinar:
http://www.mysql.com/news-and-events/web-seminars/display-657.html
Live Webinar: Building High Performance and High Traffic PHP Applications with MySQL (in Italian)
Thursday, September 15, 2011
In this webinar you will learn the essentials to build high performance and high traffic PHP applications with MySQL. As part of the open source LAMP Stack, PHP is the most popular language for web applications, and the combination of MySQL and PHP has enabled numerous developers to implement ideas and build up websites quickly, and subsequently becomes the foundation of many well-known web properties.
We will walk through the fundamentals of creating dynamic web content using MySQL and PHP. We will also discuss many of the building blocks and key considerations when you architect your PHP applications, including the frameworks, APIs, security features, and asynchronous queries. By attending this Webinar, you can obtain the essential knowledge to get started building PHP applications with MySQL!
Register for the webinar:
http://www.mysql.com/news-and-events/web-seminars/display-655.html
Live Webinar: MySQL Replication Essentials (in German)
Thursday, September 29, 2011
In this webcast we'll share the technical and business reasons for deploying MySQL Replication and give an overview of how to deploy a master/slave configuration. You'll learn the fundamentals on how to install, configure, and manage a replicated environment, including the following topics:
- MySQL Replication Architecture
- Replication types and topologies
- Installation procedures
- Monitoring your Replication
We will also cover semi-synchronous replication, introduced in MySQL 5.5, as well as the latest replication features included in MySQL 5.6 Development Milestone Release. Join this technical Webinar and learn how you can leverage MySQL replication to achieve better scalability and high availability!
Register for the webinar:
http://www.mysql.com/news-and-events/web-seminars/display-652.html
MySQL Enterprise Edition Flash Demo
Discover in only 3 minutes how Oracle's MySQL Enterprise Edition reduces the risk, cost and time required in developing, deploying and managing business-critical MySQL applications.
Watch the Demo Now:
http://www.oracle.com/pls/ebn/swf_viewer.load?p_shows_id=10146324
-------------------------------------------------------------------
Focus on MySQL at Oracle OpenWorld 2011
You can find more information on the below sessions in the Oracle OpenWorld Content Catalog:
https://oracleus.wingateweb.com/scheduler/eventcatalog/eventCatalog.do
Sunday Sessions - Organized by the IOUG/MySQL Community
- Improving MySQL Performance with Better Indexes
Session ID 28980, 9.00 am, Moscone West, Room 2012
- MySQL: Don't Be a Rookie Forever - Be in Command (Line)
Session ID 29060, 9.00 am, Moscone West, Room 2016
- MySQL and SSD - Usage Patterns
Session ID 29121, 9.00 am, Moscone West, Room 2018
- Jailbreaking MySQL Replication
Session ID 29021, 10.15 am, Moscone West, Room 2014
- Maatkit Tools - Like a MySQL Guru in a Box
Session ID 29101, 10.15 am, Moscone West, Room 2016
- Importing and Exporting Data Between Hadoop and MySQL
Session ID 29080, 10.15 am, Moscone West, Room 2018
- SQL Injection Myths and Fallacies
Session ID 29081, 12.15 pm, Moscone West, Room 2016
- MySQL High Availability
Session ID 29120, 12.15 pm, Moscone West, Room 2018
- Explaining the MySQL Explain
Session ID 29000, 1.30 pm, Moscone West, Room 2016
- Lessons Learned from Managing Way Too Many Database Servers
Session ID 27680, 1.30 pm, Moscone West, Room 2018
- Bridging MySQL and Oracle Databases with Open Source Replication
Session ID 27661, 2.45 pm, Moscone West, Room 2016
- Challenges of Big Databases with MySQL
Session ID 28682, 2.45 pm, Moscone West, Room 2018
- Implementing Online Backup for Large-Scale MySQL Environments
Session ID 31500, 4.00 pm, Moscone West, Room 2016
- Securing MySQL
Session ID 31520, 4.00 pm, Moscone West, Room 2018
-------------------------------------------------------------------
Database Track Sessions, Mon-Thu
Monday Sessions
- MySQL Authentication Options
Session ID 19181, 11.00 am, Marriott Marquis, Room Golden Gate B
- Accelerating Telecom Transformation with Web 2.0
Session ID 20263, 11.00 am, Marriott Marquis, Room Golden Gate C2
- Being a Rock Star MySQL DBA
Session ID 20880, 11.00 am, Marriott Marquis, Salon 8
- Introduction to MySQL Replication
Session ID 15762, 2.00 pm, Marriott Marquis, Room Golden Gate C2
- MySQL Executive Keynote: The State of the Dolphin
Session ID 20281, 12.30 pm, Marriott Marquis, Salon 9
- Operational Wins in MySQL Release 5.5
Session ID 20882, 2.00 pm, Marriott Marquis, Salon 8
- Scaling and Monitoring MySQL for Rapidly Growing Social Gaming
Session ID 14882, 3.30 pm, Marriott Marquis, Room Golden Gate C2
- Ticketmaster: Building the Fastest Ticketing Site with MySQL and Oracle Database
Session ID 21340, 5.00 pm, Marriott Marquis, Room Golden Gate B
Tuesday Sessions
- Getting to Know MySQL Enterprise Monitor
Session ID 15619, 10.15 am, Marriott Marquis, Room Golden Gate C1
- Advanced MySQL Replication Architectures
Session ID 15587, 10.15 am, Marriott Marquis, Room Golden Gate C2
- MySQL Performance Tuning at Ning
Session ID 20265, 11.45 am, Marriott Marquis, Room Golden Gate C2
- Getting the Most Out of MySQL on Windows
Session ID 20264, 1.15 pm, Marriott Marquis, Room Golden Gate C2
- Introduction to InnoDB, MySQL's Default Storage Engine
Session ID 10042, 1.15 pm, Marriott Marquis, Room Golden Gate C3
- MySQL for Oracle DBAs, or How to Speak MySQL for Beginners
Session ID 15143, 3.30 pm, Marriott Marquis, Room Golden Gate B
- InnoDB Performance Tuning
Session ID 20020, 3.30 pm, Marriott Marquis, Room Golden Gate C2
- The MySQL Roadmap: Discover What's New
Session ID 14740, 5.00 pm, Marriott Marquis, Room Golden Gate C2
Wednesday Sessions
- Diagnosing Scalability Issues in Java Applications on MySQL
Session ID 15742, 10.15 am, Marriott Marquis, Room Golden Gate B
- Building Highly Available and Scalable Real-Time Services with MySQL Cluster
Session ID 13702, 10.15 am, Marriott Marquis, Room Golden Gate C1
- Monitoring MySQL with Oracle Enterprise Manager Grid Control
Session ID 30280, 10.15 am, Marriott Marquis, Room Golden Gate C2
- NoSQL Access to MySQL: The Best of Both Worlds
Session ID 14141, 11.45 am, Marriott Marquis, Room Golden Gate C1
- Using MySQL with Other Oracle Products
Session ID 20261, 11.45 am, Marriott Marquis, Room Golden Gate C2
- Data Protection and Recovery for MySQL
Session ID 15715, 1.15 pm, Marriott Marquis, Room Golden Gate C1
- Customer Success Stories: MySQL as an Embedded Database
Session ID 20600, 1.15 pm, Marriott Marquis, Room Golden Gate C2
- MySQL Enterprise Backup
Session ID 20260, 5.00 pm, Marriott Marquis, Room Golden Gate C1
- MySQL Monitoring Mechanisms: How the Different Pieces Fit Together
Session ID 20280, 5.00 pm, Marriott Marquis, Room Golden Gate C2
Thursday Sessions
- NoSQL Interfaces to MySQL Cluster
Session ID 15702, 9.00 am, Marriott Marquis, Room Golden Gate C1
- What Causes Downtime in MySQL, and How Can You Prevent It?
Session ID 09304, 9.00 am, Marriott Marquis, Room Golden Gate C2
- MySQL Crash Course: Overview of Basic MySQL Concepts
Session ID 15423, 10.30 am, Marriott Marquis, Room Golden Gate C2
- MySQL Server Performance Tuning 101
Session ID 16040, 12.00 pm, Marriott Marquis, Room Golden Gate C2
- Cloud Computing Solutions for MySQL
Session ID 15713, 1.30 pm, Marriott Marquis, Room Golden Gate C2
- MySQL Efficiency on NetApp
Session ID 08584, 3.00 pm, Marriott Marquis, Room Golden Gate C2
MySQL Hands-on Lab
- MySQL Workbench: Developing MySQL Applications on Windows
Tuesday Oct 4th, 11.45 am - 12.45 pm, Marriott Marquis, Salon 10/11
MySQL Demos
Monday & Tuesday: 9.45 am - 5.30 pm; Wednesday: 9.00 am - 4.00 pm - Moscone South
- MySQL Enterprise Edition
- MySQL Cluster
- MySQL Workbench
MySQL Community Reception
7.00 pm to 9.00 pm, Marriott Marquis, Foothill G
Come celebrate the growth of the MySQL community with Oracle's MySQL team! Whether you are attending Oracle OpenWorld, a member of local MySQL user groups, a MySQL user in the San Francisco Bay Area, or simply interested in MySQL technology, you're all invited to Oracle's MySQL Community Reception.
Meet with others in the MySQL ecosystem, and have a casual conversation over a glass of beer, wine or vodka - the famous tradition of MySQL.
RSVP today and reserve your spot for a fun night!
http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=140041&src=7314534&src=7314534&Act=83&evite=83
-------------------------------------------------------------------
Want to receive the latest MySQL updates and interact with the MySQL Community?
Read Oracle's MySQL Blog:
http://blogs.oracle.com/mysql/
Join MySQL on Facebook:
http://www.facebook.com/mysql
Follow MySQL on Twitter:
http://twitter.com/mysql
Want to evaluate the advanced capabilities in the MySQL Enterprise Edition?
Try Now with MySQL Enterprise Edition Trial:
http://www.mysql.com/trials/
-------------------------------------------------------------------
About the Newsletter
You can send us queries and give us feedback online.
http://dev.mysql.com/contact/?topic=newsletter
You can unsubscribe from this newsletter online:
http://dev.mysql.com/unsub?email=johandontmessup@gmail.com
Read more about the newsletter and view previous issues.
http://dev.mysql.com/news-and-events/newsletter/
Problems reading the newsletter in your email client? View the newsletter on the web.
http://dev.mysql.com/news-and-events/newsletter/2011/2011-09.html
--
Copyright (c) 2011, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.
DB2 Query Management Facility V10 for z/OS
