Monday Feb 25, 2013

Learn Developer Skills on MySQL, Most Trusted Open-Source Database

MySQL enables innovative Developers to create and deploy the next generation of web, embedded and Cloud/SaaS/DaaS applications on the latest generation of development frameworks and hardware platforms.

By taking the MySQL for Developers course, you will learn to write applications with the MySQL database server.

This course examines the tools used by MySQL development professionals. Expert instructors reference real-world examples when illustrating how to generate complex queries, and consume them in your application. You will perform lab work with Java and PHP, connecting to MySQL databases and executing queries and stored routines.

You can take this five-day, live instructor-led course as a:

  • Live-Virtual Class Event: No travel required. Follow the class from your own desk. Choose from a wide variety of events already on the schedule covering different timezones. Delivery available in English and German.
  • In-Class Event: Travel to an education center to take this class. Below is a selection of events already on the schedule.

 Location

 Date

 Delivery Language

 London, England

4 March 2013 

English 

 Munich, Germany

 15 April 2013

 German

Budapest, Hungary 

 15 April 2013

Hungarian 

Milan, Italy

 15 April 2013

 Italian

 Rome, Italy

 20 May 2013

 Italian

 Turin, Italy

 3 June 2013

 Italian

 Nieuwegein, Netherlands

 13 May 2013

Dutch 

 Warsaw, Poland

 8 April 2013

 Polish

 Lisbon, Portgual

 13 May 2013

 European Portugese

 Porto, Portugal

13 May 2013 

 European Portugese

 Madrid, Spain

 13 May 2013

Spanish 

 Bern, Switzerland

11 April 2013 

German 

 Zurich, Switzerland

11 April 2013 

German 

 Nairobi, Kenya

18 March 2013 

English 

 Tunis, Tunisia

20 May 2013 

 French

Sao Paolo, Brazil 

 11 March 2013

Brazilian Portugese 

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

Monday Feb 18, 2013

Great Time to Start on MySQL with MySQL for Beginners Training

What better time to start learning about the world's most popular open-source database - now that MySQL 5.6 has been released. With its increased performance, scalability, reliability and manageability, MySQL 5.6 helps users meet the most demanding Web, Cloud and embedded application requirements.

Virtual Developer's Day for MySQL

The first Virtual Developer Day for MySQL will take place on March 12 at 9:00 a.m. US, Pacific Time. The event will include presentations and hands-on labs to educate MySQL users on essential skills and the latest features in MySQL 5.6. Register  here.

MySQL for Beginners Training

In the MySQL for Beginners course, you learn to:

  • Install the MySQL server
  • Describe the features and benefits of MySQL
  • Describe the basics of relational databases
  • Install the MySQL server
  • Describe the features and benefits of MySQL
  • Describe the basics of relational databases
  • Describe the features of MySQL Workbench, MySQL Enterprise Monitor, MySQL Enterprise Backup and MySQL Performance Schema

You can take this 4 day instructor-led course as follows:

  • Training-on-Demand: Follow the lecture material through streaming video and book time to work through the lab exercises, all at a time that suits you and your pace, from your own desk.
  • Live-Virtual Class: Follow a live event from your own desk, avoiding travel costs. Delivery available in English and German.
  • In-Class: Travel to an education center to attend this class. Below is a sample of events already on the schedule.

 Location

 Date

 Delivery Language

Mechelen, Belgium 

 22 April 2013

English 

London, England 

1 July 2013

English

Hamburg, Germany 

25 March 2013

German 

Munich, Germany 

3 June 2013 

German

 Milan, Italy

 25 March 2013

Italian

 Rome, Italy

 4 November 2013

 Italian

 Riga, Latvia

26 August 2013 

Latvian 

Amsterdam, Netherlands 

 21 May 2013

Dutch

 Warsaw, Poland

 6 May 2013

Polish

Lisbon, Portugal 

25 March 2013 

 European Portugese

Porto, Portugal 

 25 March 2013

 European Portugese

 Barcelona, Spain

 15 April 2013

Spanish 

 Madrid, Spain

22 April 2013 

Spanish

 Capetown, South Africa

22 July 2013 

English

 Pretoria, South Africa

22 April 2013 

English

 Banjul, Gambia

3 June 2013 

English

 Nairobi, Kenya

11 March 2013 

English 

Petaling Jaya, Malaysia

 25 March 2013

English

Seoul, Korea 

 25 March 2013

Korean 

Montreal, Canada 

25 March 2013 

English

Ottawa, Canada 

 25 March 2013

 English 

 Toronto, Canada

 25 March 2013

English

Mexico City, Mexico 

 4 March 2013

Spanish

 Sao Paolo, Brazil

7 October 2013 

 Brazilian Portugese

To learn more about this class or other courses on the authentic MySQL Curriculum, go to http://oracle.com/education/mysql.

Monday Feb 11, 2013

New MySQL Administrator Training on MySQL 5.6

Get the most out of the great new release, MySQL 5.6, by taking the MySQL for Database Administrators training course.

During this 5 day instructor-led course you configure replication between multiple instances, design advanced replication topologies and recover from replication, network, or hardware failure taking advantage of MySQL 5.6 replication performance.

You also gain knowledge on the following:

Set up the Server and Databases

This course teaches you how to install, configure, maintain and tune databases for a wide variety of workloads and environments. You will install and configure MySQL and set appropriate configuration options. You will also connect to the server, using both graphical and command-line clients, while creating and populating databases.

Maintain and Secure Data

Expert Oracle instructors will also help you examine the structure of tables, their columns and data types and the different ways to check and repair tables. You will learn to program MySQL stored routines, events and triggers to process data in complex and automated ways. Explore how to partition tables, work with locking and transactions as well as the key features of InnoDB and other storage engines. You will develop an understanding of how data is processed, stored, and retrieved.

Configure for Performance

To help prevent and handle failures, this course teaches you to tune databases. Learn to choose and set the most appropriate options, while performing logical and physical backups.

Learn by Doing

Extensive hands-on practices guide you through each concept. You will install MySQL products, partition data, check and repair tables, perform backups and configure replication, create secured users and enable SSL security, and much more. Explore real-world problems and discover best practices as you work with the tools and techniques used by professional MySQL database administrators.

You can take this class as a live-virtual offering where there is no travel involved or as an in-class offering by traveling to an education center.

For full information on the authentic MySQL Curriculum go to http://oracle.com/education.

Monday Feb 04, 2013

Learn to Develop Dynamic Web Applications with PHP and MySQL

Learn to create best-of-breed web applications with the MySQL and PHP - Developing Dynamic Web Applications course

After taking this course you will be able to:

  • Describe the LAMP architecture
  • Use the basic components of PHP to build a foundation for more complex web applications
  • Understand the basic components of MySQL
  • Use SQL query commands to retrieve data from the MYSQL database
  • Change table data using the SQL Data Manipulation Language (DML) commands
  • Retrieve data from multiple MySQL tables using Joins
  • Create web based forms that interact with the end user and the data within MySQL
  • Use session handling to authenticate and monitor user identities
  • Describe the purpose of template systems

You can take this instructor-led course as a:

  • Live Virtual Class: Take this course from your own desk. No travel required. Choose from the many events already on the schedule suiting different timezones.
  • In-Class: Travel to an education center. Below are some of the events already on the schedule.

 Location  Date  Delivery Language
 Rome, Italy
6 May 2013
 Italian
Warsaw, Poland
 25 March 2013
Polish
 Lisbon, Portugal  15 April 2013
European Portuguese
 Porto, Portugal  15 April 2013
European Portuguese
 Barcelona, Spain  2 April 2013
Spanish
 Madrid, Spain  4 March 2013
Spanish
Tunis, Tunisia  18 March 2013
French

To register for this course, request another event or learn more about the authentic MySQL Curriculum, go to http://oracle.com/education/mysql.

Monday Jan 14, 2013

Take the Authentic MySQL for Developers Training Course

The authentic MySQL for Developers course will introduce you to tools used by MySQL development professionals and you get the opportunity to work through examples specific to Java and PHP development cases.

In this course you will learn to:

  • Use MySQL tools to connect to databases.
  • Examine database structure and contents.
  • Generate database structure diagrams.
  • Execute complex queries.
  • Manipulate numeric, text, spatial and temporal data.
  • Execute complex subqueries and joins.

You can take this 5 day live-instructor course via these two delivery methods:

  • Live-Virtual Class: Take this class from your own desk by choosing from the many events already on the schedule.
  • In-Class: Travel to a training center to take this class. Below is a selection of events already on the schedule.

 Location

 Date

 Delivery Language

Vienna, Austria

 4 March 2013

 German

 London, England

 4 March 2013

 English

 Gummersbach, Germany

 11 February 2013

 German

 Munich, Germany

 15 April 2013

 German

 Budapest, Hungary

 15 April 2013

 Hungarian

 Milan, Italy

 21 January 2013

 Italian

 Rome, Italy

 11 March 2013

 Italian

 Turin, Italy

 25 February 2013

 Italian

 Nieuwegein, Netherlands

13 May 2013

 Dutch

 Warsaw, Poland

 18 February 2013

 Polish

 Lisbon, Portugal

 18 February 2013

 Portugal

 Porto, Portugal

 18 February 2013

 Portugal

 Barcelona, Spain

 18 February 2013

 Spanish

 Madrid, Spain

 13 May 2013

 Spanish

 Bern, Switzerland

 11 April 2013

 German

 Zurich, Switzerland

 11 April 2013

 German

 Nairobi, Kenya

 18 May 2013

 English

 Tunis, Tunisia

 20 May 2013

 French

 Mexico City, Mexico

 28 January 2013

 Spanish

 Sao Paulo, Brazil

 11 March 2013

 European Portugese

To register for an event or to learn more about this course or other parts of the authentic MySQL curriculum, go to http://oracle.com/education/mysql.

Friday Jan 04, 2013

Gain MySQL Database Administrator Skills to Access Top Data Jobs

As 2013 begins, MySQL is way ahead for job openings in the data area. So perfect your MySQL database administration skills with the authentic MySQL for Database Administrator course.

In this 5 day course, you learn to install the MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL database.

You can take this course through one of the following delivery methods

  • Training-on-Demand: Take the course at your pace from your own desk, following the instructor delivery of lecture material through streaming video and scheduling your lab exercises at a time that suits you.
  • Live-Virtual: Follow a live event from your own desk - no travel required - with live virtual delivery
  • In-Class: Travel to a classroom to take this event. Below is a sample of in-class events on the scheduled:

 Location

 Date

 Delivery Language

 Vienna,  Austria

 25 February 2013

German

 Mechelen, Belgium

 25 February 2013

English

London, England 

 11 February 2013

English 

Paris, France 

11 February 2013 

French 

Dresden, Germany 

18 February 2013

German 

Dusseldorf, Germany 

 11 March 2013 

German 

Gummerbach, Germany 

4 February 2013 

German 

Hamburg, Germany 

28 January 2013 

German 

Munich, Germany 

11 February 2013 

German 

Budapest, Hungary

18 March 2013 

Hungarian

Belfast, Ireland

 24 June 2013

 English

 Milan, Italy

11 March 2013 

Italian 

 Rome, Italy

 18 February 2013

Italian

 Turin, Italy

 11 February 2013

Italian

 Amsterdam, Netherlands

 24 June 2013

Dutch

 Nieuwegein, Netherlands

 8 April 2013

Dutch

 Warsaw, Poland

 14 January 2013

Polish

Lisbon, Portugal 

15 April 2013 

 European Portugese

Porto, Portugal 

 15 April 2013

 European Portugese

 Barcelona, Spain

4 February 2013 

Spanish 

 Madrid, Spain

 21 January 2013

Spanish

 Bern, Switzerland

7 February 2013 

German 

 Zurick, Switzerland

 7 February 2013

German

 Istanbul, Turkey

 25 February 2013

Turkish

 Nairobi, Kenya

 28 January 2013

 English

 Johannesburg, South Africa

 9 December 2013

 English

 Tunis, Tunisia

 25 March 2013

 French

 Bangalore, India

 28 January 2013

 English

 Tokyo, Japan

 4 February 2013

Japanese

 Tokyo, Japan

25 April 2013 

Japanese 

 Petaling Jaya, Malaysia

4 March 2013 

 English 

 Singapore

28 January 2013 

 English

 Brisbane, Australia

 4 March 2013

 English

 Auckland, New Zealand

 21 January 2013

 English

 Ottawa, Canada

 28 January 2013

 English

 Toronto, Canada

 28 January 2013

 English

 Montreal, Canada

 28 January 2013

 English

 Curitiba, Brazil

7 January 2013 

 Brazilan Portugese

 Sao Paolo, Brazil

14 January 2013 

 Brazilan Portugese 

 Mexico City, Mexico

21 January 2013 

Spanish 

To find out more about this course or 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.

Monday Dec 17, 2012

Learn about MySQL with the Authentic MySQL for Beginners course

Learn about the MySQL Server and other MySQL products by taking the authentic MySQL for Beginners course. This course covers all the basics from MySQL download and installation, to relational database concepts and database design. This course is your first step to becoming a MySQL administrator.

You can take this course through one of the following delivery types:

  • Training-on-Demand: Start the class from your desk, at your base and within 24 hrs of registering. Read Ben Krug on Day 3 of his experience taking the MySQL for Beginners course Training-on-Demand option.
  • Live-Virtual Class: Attend this live class from your own office - no travel required. Choose from a selection of events on the schedule to suit different timezones. Delivery languages include English and German.
  • In-Class event: Attend this class in an education center. Events already on the schedule include:

 Location

 Date

 Delivery Language

 Mechelen, Belgium

 14 January 2013

 English

 London, England

 5 March 2013

 English

 Hamburg, Germany

 25 March 2013

 German

 Munich, Germany

 3 June 2013

 German

 Budapest, Hungary

 5 February 2013

 Hungary

 Milan, Italy

 11 February 2013

 Italian

 Rome, Italy

 4 March 2013

 Italian

 Riga, Latvia

 18 February 2013

 Latvian

 Amsterdam, Netherlands

 21 May 2013

 Dutch

 Nieuwegein, Netherlands

 18 February 2013

 Dutch

 Warsaw, Poland

 18 February 2013

 Polish

 Lisbon, Portugal

 25 March 2013

 European Portugese

 Porto, Portugal

 25 March 2013

 European Portugese

 Barcelona, Spain

 11 February 2013

 Spanish

 Madrid, Spain

 22 April 2013

 Spanish

 Nairobi, Kenya

 14 January 2013

 English

 Capetown, South Africa

 22 July 2013

 English

 Pretoria, South Africa

 22 April 2013

 English

 Petaling Jaya, Malaysia

 28 January 2013

 English

 Ottawa, Canada

 25 March 2013

 English

 Toronto, Canada

 25 March 2013

 English

 Montreal, Canada

25 March 2013 

 English

Mexico City, Mexico 

14 January 2013 

 Spanish

 San Pedro Garza Garcia, Mexico

 5 February 2013

 Spanish

 Sao Paolo, Brazil

 29 January 2013

 Brazilian Portugese

For more information on this or 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.

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

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!

Monday Oct 29, 2012

Harness MySQL's Continued Performance Tuning Improvements

To fully harness the continued improvements in performance tuning you get with MySQL, take the MySQL Performance Tuning course.

This 4 day class teaches you practical, safe, highly efficient ways to optimize performance for the MySQL Server. You will learn the skills needed to use tools for monitoring, evaluating and tuning. 

You can take this course in the following three ways:

  • Training-on-Demand: Follow this course at your own pace and from your own desk with streaming video of instructor delivery and booking time to follow hands-on exercises at your own convenience.
  • Live-Virtual: Attend a live instructor-led event from your own desk. Choose from the numerous events on the schedule.
  • In-Class:  Travel to an education center to follow this class. A sample of events on the schedule is shown below:

 Location

 Date

 Delivery Language

 Tokyo, Japan

 19 November 2012

 Japanese

 Mechelen, Belgium

 4 February 2013

 English

 London, England

 19 November 2012

 English

 Budapest, Hungary

 21 May 2013

 Hungarian

 Milan, Italy

 14 January 2013

 Italian

 Rome, Italy

 3 December 2012

 Italian

 Riga, Latvia

 10 December 2012

 Latvian

 Amsterdam, Netherlands

 7 January 2013

 Dutch

 Nieuwegein, Netherlands

 26 November 2012

 Dutch

 Warsaw, Poland

 3 December 2012

 Polish

 Lisbon, Portugal

 4 February 2013

 European Portugese

 Porto, Portugal

 4 February 2013

 European Portugese

 Barcelona, Spain

 25 March 2013

 Spanish

 Madrid, Spain

 17 December 2012

 Spanish

 Sydney, Australia

 26 November 2012

 English

 Edmonton, Canada

 10 December 2012

 English

 Montreal, Canada

 26 November 2012

 English

 Ottawa, Canada

 26 November 2012

 English

 Toronto, Canada

 26 November 2012

 English

 Vancouver, Canada

 10 December 2012

 English

 Sao Paolo, Brazil

 26 November 2012

 Brazilan Portugese

For more information on this class or to know more about other courses on the authentic MySQL curriculum. see 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 Oct 08, 2012

Training on Demand Certification Packages for DBAs

The demand for Database Administrators continues to grow.*

Almost two-thirds of IT hiring managers indicate that they highly value certifications in validating
IT skills and expertise.**

* Job satisfaction and DBA work growth rate: CNN Money's 2011 Best Jobs in America survey.
** Survey among nearly 1,700 respondents by CompTIA, the nonprofit trade association for the IT industry, cited in Certification Magazine, Feb. 14 th., 2012.

Get Certified with Training on Demand

Are you an experienced Database professional eager to achieve certification?
Is time your most precious resource?

Then try our new Training On Demand Certification Value Package with 20% discount. These all-in-one packages give you everything you need to get certified with success:

Why Training On Demand:
 
  • Expert training from Oracle’s top instructors
  • Sophisticated streaming video recording
  • Available for 90 days, 24 hours a day, 7 days a week
  • White boarding and training labs for hands-on experience
  • Start, stop, pause, jump or rewind sections of the course as needed 
  • Oracle University instructor Q&A 
  • A full-text search leads to the right video fragment in a matter of seconds.
Watch this demo to see how it works.
Getting certified has never been easier!
For assistance contact your local Oracle University Service Desk.
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 11g training courses and MySQL training courses. Even if you're only managing Oracle Databases at this point of time, getting familiar with MySQL Database will broaden your career path with growing job demand.

These Value Packages are also available with the following training formats:
In-Class, Live Virtual Class and Self Study:

MySQL Database Administration Value Packages
Your Savings plus get a FREE Retake 
save 5%
save 20%
save 20%
save 20%
 
In Class Edition
Live Virtual Class Edition
Self-Study Edition
Training On Demand
MySQL Database Administrator Certification Value Package
view
                                          package
View Package
view
                                          package
View Package
view
                                          package
View Package
view
                                          package
View Package
MySQL Developer Value Packages
Your Savings plus get a FREE Retake 
save 5%
save 20%
save 20%
save 20%
 
In Class Edition
Live Virtual Class Edition
Self-Study Edition
Training On Demand
     
MySQL Developer Certification Value Package
view
                                          package
View Package
view
                                          package
View Package
   

Oracle Database 10g Value Packages
Your Savings plus get a FREE Retake 
save 5%
save 20%
save 20%
save 20%
 
In Class Edition
Live Virtual Class Edition
Self-Study Edition
Training On Demand
Oracle Database 10g Administrator Certified Associate Certification Value Package
view
                                          package
View Package
view
                                          package
View Package
view
                                          package
View Package
 
Oracle Database 10g Administrator Certified Professional Certification Value Package
view
                                          package
View Package
view
                                          package
View Package
view
                                          package
View Package
 

Oracle Database 11g Value Packages
Your Savings plus get a FREE Retake 
save 5%
save 20%
save 20%
save 20%
 
In Class Edition
Live Virtual Class Edition
Self-Study Edition
Training On Demand
Oracle Database 11g Administrator Certified Associate Certification Value Package
view
                                          package
View Package
view
                                          package
View Package
view
                                          package
View Package
view
                                          package
View Package
Oracle Database 11g Administrator Certified Professional Certification Value Package
view
                                          package
View Package
view
                                          package
View Package
view
                                          package
View Package
view
                                          package
View Package
Exam Prep Seminar Value Package: Oracle Database Admin 1      
view
                                          package
View Package
Oracle Database 11g Administrator Certified Professional UPGRADE Certification Value Package      
view
                                          package
View Package
Oracle Real Application Clusters 11g and Grid Infrastructure Administraton Certified Expert Certification Value Package      
view
                                          package
View Package
Exam Prep Seminar Value Package: Oracle Database Admin 2       
view
                                          package
View Package
Exam Prep Seminar Value Package: Oracle RAC 11g and Grid Infrastructure Administration      
view
                                          package
View Package
Exam Prep Seminar Value Package: Upgrade Oracle Certified Professional (OCP) to Oracle Database 11g      
view
                                          package
View Package

SQL and PL/SQL Value Packages
Your Savings plus get a FREE Retake 
save 5%
save 20%
save 20%
save 20%
 
In Class Edition
Live Virtual Class Edition
Self-Study Edition
Training On Demand
Oracle Database Sql Expert Certification Value Package
view
                                          package
View Package
view
                                          package
View Package
view
                                          package
View Package
view
                                          package
View Package
Exam Prep Seminar Value Package: Oracle Database SQL      
view
                                          package
View Package



View our Certification Value Packages

Find your Certification

Mention this code at the time of booking: E1245
Connect
FacebookLinkedInTwitterGoogle+
For a full list of MySQL Training courses and events, go to http://oracle.com/education/mysql.

New Options for MySQL High Availability

Data is the currency of today’s web, mobile, social, enterprise and cloud applications. Ensuring data is always available is a top priority for any organization – minutes of downtime will result in significant loss of revenue and reputation.

There is not a “one size fits all” approach to delivering High Availability (HA). Unique application attributes, business requirements, operational capabilities and legacy infrastructure can all influence HA technology selection. And then technology is only one element in delivering HA – “People and Processes” are just as critical as the technology itself.

For this reason, MySQL Enterprise Edition is available supporting a range of HA solutions, fully certified and supported by Oracle. MySQL Enterprise HA is not some expensive add-on, but included within the core Enterprise Edition offering, along with the management tools, consulting and 24x7 support needed to deliver true HA.

At the recent MySQL Connect conference, we announced new HA options for MySQL users running on both Linux and Solaris:

- DRBD for MySQL

- Oracle Solaris Clustering for MySQL

DRBD (Distributed Replicated Block Device) is an open source Linux kernel module which leverages synchronous replication to deliver high availability database applications across local storage. DRBD synchronizes database changes by mirroring data from an active node to a standby node and supports automatic failover and recovery. Linux, DRBD, Corosync and Pacemaker, provide an integrated stack of mature and proven open source technologies.


DRBD Stack: Providing Synchronous Replication for the MySQL Database with InnoDB

Download the DRBD for MySQL whitepaper to learn more, including step-by-step instructions to install, configure and provision DRBD with MySQL

Oracle Solaris Cluster provides high availability and load balancing to mission-critical applications and services in physical or virtualized environments. With Oracle Solaris Cluster, organizations have a scalable and flexible solution that is suited equally to small clusters in local datacenters or larger multi-site, multi-cluster deployments that are part of enterprise disaster recovery implementations. The Oracle Solaris Cluster MySQL agent integrates seamlessly with MySQL offering a selection of configuration options in the various Oracle Solaris Cluster topologies.


Putting it All Together

When you add MySQL Replication and MySQL Cluster into the HA mix, along with 3rd party solutions, users have extensive choice (and decisions to make) to deliver HA services built on MySQL

To make the decision process simpler, we have also published a new MySQL HA Solutions Guide.

Exploring beyond just the technology, the guide presents a methodology to select the best HA solution for your new web, cloud and mobile services, while also discussing the importance of people and process in ensuring service continuity.

This is subject recently presented at Oracle Open World, and the slides are available here.

Whatever your uptime requirements, you can be sure MySQL has an HA solution for your needs


Please don't hesitate to let us know of your HA requirements in the comments section of this blog. You can also contact MySQL consulting to learn more about their HA Jumpstart offering which will help you scope out your scaling and HA requirements.

Friday Aug 24, 2012

Interview with Lenz Grimmer about MySQL Connect

Keith Larson: Thank you for allowing me to do this interview with you.  I have been talking with a few different Oracle ACEs   about the MySQL Connect Conference. I figured the MySQL community might be missing you as well. You have been very busy with Oracle Linux but I know you still have an eye on the MySQL Community. How have things been?

Lenz Grimmer: Thanks for including me in this series of interviews, I feel honored! I've read the other interviews, and really liked them. I still try to follow what's going on over in the MySQL community and it's good to see that many of the familiar faces are still around. Over the course of the 9 years that I was involved with MySQL, many colleagues and contacts turned into good friends and we still maintain close relationships.

It's been almost 1.5 years ago that I moved into my new role here in the Linux team at Oracle, and I really enjoy working on a Linux distribution again (I worked for SUSE before I joined MySQL AB in 2002). I'm still learning a lot - Linux in the data center has greatly evolved in so many ways and there are a lot of new and exciting technologies to explore.


Keith Larson: What were your thoughts when you heard that Oracle was going to deliver the MySQL Connect conference to the MySQL Community?

Lenz Grimmer: I think it's testament to the fact that Oracle deeply cares about MySQL, despite what many skeptics may say. What started as "MySQL Sunday" two years ago has now evolved into a full-blown sub-conference, with 80 sessions at one of the largest corporate IT events in the world. I find this quite telling, not many products at Oracle enjoy this level of exposure! So it certainly makes me feel proud to see how far MySQL has come.


Keith Larson: Have you had a chance to look over the sessions? What are your thoughts on them?

Lenz Grimmer: I did indeed look at the final schedule.The content committee did a great job with selecting these sessions. I'm glad to see that the content selection was influenced by involving well-known and respected members of the MySQL community. The sessions cover a broad range of topics and technologies, both covering established topics as well as recent developments.

Keith Larson: When you get a chance, what sessions do you plan on attending?

Lenz Grimmer: I will actually be manning the Oracle booth in the exhibition area on one of these days, so I'm not sure if I'll have a lot of time attending sessions. But if I do, I'd love to see the keynotes and catch some of the sessions that talk about recent developments and new features in MySQL, High Availability and Clustering . Quite a lot has happened and it's hard to keep up with this constant flow of new MySQL releases.

In particular, the following sessions caught my attention:


Keith Larson: So I will ask you just like I have asked the others I have interviewed, any tips that you would give to people for handling the long hours at conferences?

Lenz Grimmer: Wear comfortable shoes and make sure to drink a lot! Also prepare a plan of the sessions you would like to attend beforehand and familiarize yourself with the venue, so you can get to the next talk in time without scrambling to find the location. The good thing about piggybacking on such a large conference like Oracle OpenWorld is that you benefit from the whole infrastructure. For example, there is a nice schedule builder that helps you to keep track of your sessions of interest. Other than that, bring enough business cards and talk to people, build up your network among your peers and other MySQL professionals!

Keith Larson: What features of the MySQL 5.6 release do you look forward to the most ?

Lenz Grimmer: There has been solid progress in so many areas like the InnoDB Storage Engine, the Optimizer, Replication or Performance Schema, it's hard for me to really highlight anything in particular. All in all, MySQL 5.6 sounds like a very promising release. I'm confident it will follow the tradition that Oracle already established with MySQL 5.5, which received a lot of praise even from very critical members of the MySQL community. If I had to name a single feature, I'm particularly and personally happy that the precise GIS functions have finally made it into a GA release - that was long overdue.

Keith Larson:  In your opinion what is the best reason for someone to attend this event?

Lenz Grimmer: This conference is an excellent opportunity to get in touch with the key people in the MySQL community and ecosystem and to get facts and information from the domain experts and developers that work on MySQL. The broad range of topics should attract people from a variety of roles and relations to MySQL, beginning with Developers and DBAs, to CIOs considering MySQL as a viable solution for their requirements.

Keith Larson: You will be attending MySQL Connect and have some Oracle Linux Demos, do you see a growing demand for MySQL on Oracle Linux ?

Lenz Grimmer: Yes! Oracle Linux is our recommended Linux distribution and we have a good relationship to the MySQL engineering group. They use Oracle Linux as a base Linux platform for development and QA, so we make sure that MySQL and Oracle Linux are well tested together. Setting up a MySQL server on Oracle Linux can be done very quickly, and many customers recognize the benefits of using them both in combination.

Because Oracle Linux is available for free (including free bug fixes and errata), it's an ideal choice for running MySQL in your data center. You can run the same Linux distribution on both your development/staging systems as well as on the production machines, you decide which of these should be covered by a support subscription and at which level of support. This gives you flexibility and provides some really attractive cost-saving opportunities.

Keith Larson: Since I am a Linux user and fan, what is on the horizon for  Oracle Linux?

Lenz Grimmer: We're working hard on broadening the ecosystem around Oracle Linux, building up partnerships with ISVs and IHVs to certify Oracle Linux as a fully supported platform for their products. We also continue to collaborate closely with the Linux kernel community on various projects, to make sure that Linux scales and performs well on large systems and meets the demands of today's data centers. These improvements and enhancements will then rolled into the Unbreakable Enterprise Kernel, which is the key ingredient that sets Oracle Linux apart from other distributions. We also have a number of ongoing projects which are making good progress, and I'm sure you'll hear more about this at the upcoming OpenWorld conference :)

Keith Larson: What is something that more people should be aware of when it comes to Oracle Linux and MySQL ?

Lenz Grimmer: Many people assume that Oracle Linux is just tuned for Oracle products, such as the Oracle Database or our Engineered Systems. While it's of course true that we do a lot of testing and optimization for these workloads, Oracle Linux is and will remain a general-purpose Linux distribution that is a very good foundation for setting up a LAMP-Stack, for example. We also provide MySQL RPM packages for Oracle Linux, so you can easily stay up to date if you need something newer than what's included in the stock distribution.

One more thing that is really unique to Oracle Linux is Ksplice, which allows you to apply security patches to the running Linux kernel, without having to reboot. This ensures that your MySQL database server keeps up and running and is not affected by any downtime.

Keith Larson: What else would you like to add ?

Lenz Grimmer: Thanks again for getting in touch with me, I appreciated the opportunity. I'm looking forward to MySQL Connect and Oracle OpenWorld and to meet you and many other people from the MySQL community that I haven't seen for quite some time!

Keith Larson:  Thank you Lenz!


Friday Aug 10, 2012

Interview with Giuseppe Maxia "the datacharmer" about MySQL Connect

Keith Larson: Thank you for allowing me to do this interview with you. What have you and Continuent been up to lately?

Giuseppe Maxia:  Hi Keith. It's my pleasure.  I (and the whole team at Continuent) have been quite busy releasing version 1.5.1 of our flagship clustering and HA product, Tungsten Enterprise. Apart from the pleasure of the growing business that makes us all very happy, we enjoy the rare geeky joy of working at a product at the highest levels of innovation and technical effectiveness.


 I am also happy, at a personal level, because my current job keeps me in touch with the MySQL community. The products that we develop, both the open source and the commercial solutions, depend heavily on the ubiquity of MySQL. When I dedicate some time to the MySQL community, I am doing at the same time something that I like and that is ultimately beneficial for my company's business. For this reason, my company has no objections to my work in open source projects that I started long ago, such as MySQL Sandbox.

Keith Larson: MySQL Sandbox is great, thank you for that!

Giuseppe Maxia:You're welcome! This one of the many MySQL related open projects that are maintained by community members. The MySQL world is a better place thanks to this distributed effort.

Keith Larson: What were your thoughts when you heard that Oracle was going to provide the community the MySQL Conference ?

Giuseppe Maxia: I had mixed feelings. On one hand, I was happy that Oracle has dedicated more attention to the MySQL community, by creating this event. On the other hand, I was a bit taken aback, because the decision to organize MySQL Connect came at the same time when Oracle made it known that it was not sending anyone to the April conference in Santa Clara. I understand very well the reasoning. That conference is organized by a competitor, and Oracle didn't want to help a competing business. However, there were more than one thousand MySQL users at that event, and many of them would have been quite pleased to meet and listen to Oracle engineers.

I also understand that Oracle wants to give the MySQL community a proper home within its conference infrastructure. All in all, I consider MySQL Connect a positive step in the right direction. I hope and expect that MySQL Connect will grow in next editions, and that Oracle will offer an event that matches the scope of MySQL conferences that we are used to in the past.


Keith Larson: Since you are part of the content committee, what did you think of the submissions that were received during call for papers?

Giuseppe Maxia:  Reviewing the submissions for this event was a difficult task. We had to limit the entries to the allotted number of sessions (56), and thus we had to leave out many proposals that would have been quite nice to have in a conference. The level of the proposals was quite high. In my initial screening, I found about 90 sessions that I wanted to get in, and the hard was to cut off the ones over the quota.

Keith Larson: What sessions do you look forwarding to attending?

Giuseppe Maxia: Surely I will attend most of the sessions where Oracle engineers explain the latest features and improvements of MySQL products. I will also attend sessions by other professionals who talk about my fields of interest, namely replication, high availability, performance, cloud integration.

Keith Larson: How do you feel the MySQL Community has changed in the recent years ? Do you feel it is different outside of the United States?


Giuseppe Maxia: The MySQL community has grown. In several directions. The community has followed many leads. There were some prophets of doom that announced the death of MySQL. They gathered credit because sometimes the ones who shout louder get more followers, regardless of their merits.
 There were more people, including several Oracle competitors, who believed that Oracle doesn't have any interest in killing MySQL, and instead it will be better off keeping MySQL alive and thriving. Which is what Oracle has been doing in the last few years, quite effectively so! The way I see it, the MySQL community is getting the message that MySQL is improving under Oracle stewardship, and concentrating on practicalities rather than philosophical diatribes.


 The places where the masses are less inclined to being practical and keep pursuing forks and changes for the sake of it are in the associated communities, those that depend in some extent by MySQL, or where MySQL is an important component, like content management projects, Linux distros, language infrastructures. I often see discussions that say "we should abandon MySQL and use instead a fork, because Oracle can't be depended upon for keeping the project alive." There is no amount of reasoning that can be injected in discussion that start by denying the current evidence, so I know that the community will keep this state of fluidity for a while.
 I haven't attended many events in Europe this year, so my feelings are based on what I see online. I feel that the community in the US is being more empirical than in Europe.


 My personal stand is that as long as Oracle keeps the work on MySQL to the current level, there is no need to worry for the open source community about the fate of MySQL.

Keith Larson: What features of MySQL 5.6 do you look forward to the most ?

Giuseppe Maxia: The improvement on the binary logging API and replication are among the most interesting ones. There are the obvious advances in performance, which everyone should expect from a new MySQL release. I have tested MySQL 5.6 replication features quite a lot. At the time of my testing (in April), there were some gaps in the integration between the main features. I hope such gaps will be filled in the final release.

Keith Larson: Would you consider the MySQL 5.6 release a major/big step forward in terms of Replication ?

Giuseppe Maxia: MySQL 5.6 is certainly a big step forward. I am cautious about its final outcome, as I have mentioned above, since I wait to see if the new features will become better integrated among them and with the rest of the server. There are great features, but you surely know that MySQL has historically had integration problems with new code, which sometimes resulted in the so-called "half-baked features."  I am not saying that this is the case with 5.6, but my first tests show that some features do not play well with the others in the same release. To give you an example: we have Global Transaction ID (GTID) and multi-thread slaves. If you enable GTID, the multi thread slaves still keep track of their work using binary log file names and position. This is the status for 5.6.5. I don't know if it has already been addressed.

Keith Larson:You attend a lot of conferences. What would you recommend for people who attend this conference.

Giuseppe Maxia: There are two main benefits by attending this kind of conferences: the first and most obvious is what you get by attending well selected sessions. The second, and sometimes more productive benefit is given by meeting other people who share your interests, and exchanging views with them. I would say that I have learned as much during social events and corridor chats as at the sessions themselves. The greatest benefit of this conference is the chance of talking with the people who work at the products that we use on a daily basis, and give them feedback about our experience.

Keith Larson: Since your often speaker at conference, what would you consider the ideal audience? What do you want or prefer from them?

Giuseppe Maxia: I am a geek. As such, I love talking to technically oriented users. It's very rewarding when you can address an advanced audience about demanding topics. But I also like explaining things to beginners. I remember my learning curve when I was a rookie, and I try to give my audience what I would have liked to get when I was in their position. So, while my ideal audience is a crowd of hackers, I feel perfectly at home talking to a roomful of motivated beginners.
 What I would like from my audience is to be inquisitive, and not to take anything for granted. When I talk at a conference, I often learn something new from the audience questions. For this reason, I encourage questions at any time during my presentations, unless the time is really short.

Keith Larson: So any tips you would give to people for handling the long hours at conferences?

Giuseppe Maxia: The first thing to do is getting organized by knowing what sessions you want to attend. Once you prioritize what you can't possibly miss, you can start organizing the rest of the time. There is no obligation to attend a session if there is nothing that appeals to you in a give slot. No need to feel guilty if you skip one slot to do something else, like visiting the expo hall or meeting friends. However, you should get organized, so you won't waste time.
 It's quite effective using Twitter with appropriate hashtags before and during the conference, to find people you know and to meet new ones with the same interests. Reading blogs and forums in the weeks before the conference will give you most of the ideas. For the ones who didn't do their homework, hanging around the MySQL community booth can give you useful information about who's there, what's going on, and what you can do productively in the next 50 minutes.

Keith Larson: What would you consider to be the top argument to persuade a boss to allow you to attend MySQL Connect?

Giuseppe Maxia:  It's the conference where we meet the creators of MySQL. If this is the main tool for our company, that's the place where we need to go to get first hand information. Besides, San Francisco is a great place!

Keith Larson: Anything else you want to add...

Giuseppe Maxia:  I am glad that Oracle is keeping the doors open for the MySQL community. My personal opinion is that it can open way more than that, and I hope that such further opening will happen in the time being. As an Oracle ACE Director, I feel it's my duty to smooth the path in that direction, by advising Oracle on what the community expects, and by giving objective and useful information to my fellow community members.
 I wish to see a 4 days MySQL event next year!

Wednesday Jun 27, 2012

Interview with Ronald Bradford about MySQL Connect

Ronald Bradford,  an Oracle ACE Director has been busy working with  database consulting, book writing (EffectiveMySQL) while traveling and speaking around the world in support of MySQL. I was able to take some of his time to get an interview on this thoughts about theMySQL Connect conference.

Keith Larson: What where your thoughts when you heard that Oracle was going to provide the community the MySQL Conference ?

Ronald Bradford: Oracle has already been providing various different local community events including OTN Tech Days and  MySQL community days. These are great for local regions both in the US and abroad.  In previous years there has been an increase of content at Oracle Open World, however that benefits the Oracle community far more then the MySQL community.  It is good to see that Oracle is realizing the benefit in providing a large scale dedicated event for the MySQL community that includes speakers from the MySQL development teams, invested companies in the ecosystem and other community evangelists.

I fully expect a successful event and look forward to hopefully seeing MySQL Connect at the upcoming Brazil and Japan OOW conferences and perhaps an event on the East Coast.

Keith Larson: Since you are part of the content committee, what did you think of the submissions that were received during call for papers?

Ronald Bradford: There was a large number of quality submissions to the number of available presentation sessions. As with the previous years as a committee member for the annual MySQL conference, there is always a large variety of common cornerstone MySQL features as well as new products and upcoming companies sharing their MySQL experiences.

All of the usual major players in the ecosystem will in presenting at MySQL Connect including Facebook, Twitter, Yahoo, Continuent, Percona, Tokutek, Sphinx and Amazon to name a few.  This is ensuring the event will have a large number of quality speakers and a difficult time in choosing what to attend.

Keith Larson: What sessions do you look forwarding to attending?

Ronald Bradford: As with most quality conferences you can only be in one place at one time, so with multiple tracks per session it is always difficult to decide. The continued work and success with MySQL Cluster, and with a number of sessions I am sure will be popular. The features that interest me the most are around the optimizer, where there are several sessions on new features, and on the importance of backups. There are three presentations in this area to choose from.

Keith Larson: Are you going to cover any of the content in your books at your MySQL Connect sessions?

Ronald Bradford: I will be giving two presentations at MySQL Connect. The first will include the techniques available for creating better indexes where I will be touching on some aspects of the first Effective MySQL book on Optimizing SQL Statements.  In my second presentation from experiences of managing 500+ AWS MySQL instances, I will be touching on areas including SQL tuning, backup and recovery and scale out with replication.   These are the key topics of the initial books in the Effective MySQL series that focus on performance, scalability and business continuity.  The books however cover a far greater amount of detail then can be presented in a 1 hour session.

Keith Larson: What features of MySQL 5.6 do you look forward to the most ?

Ronald Bradford: I am very impressed with the optimizer trace feature. The ability to see exposed information is invaluable not just for MySQL 5.6, but to also apply information discerned for optimizing SQL statements in earlier versions of MySQL.  Not everybody understands that it is easy to deploy a MySQL 5.6 slave into an existing topology running an older version if MySQL for evaluation of many new features.  You can use the new mysqlbinlog streaming feature for duplicating master binary logs on an older version with a MySQL 5.6 slave.  The improvements in instrumentation in the Performance Schema are exciting.   However, as with my upcoming Replication Techniques in Depth title, that will be available for sale at MySQL Connect, there are numerous replication features, some long overdue with provide significant management benefits. Crash Save Slaves, Global transaction Identifiers (GTID)  and checksums just to mention a few.

Keith Larson: You have been to numerous conferences, what would you recommend for people at the conference?

Ronald Bradford: Make the time to meet and introduce yourself to the speakers that cover the topics that most interest you. The MySQL ecosystem has a very strong community.  The relationships you build with presenters, developers and architects in MySQL can be invaluable, however they are created over time. Get to know these people, interact with them over time.  This is the opportunity to learn more then just the content from a 1 hour session.

Keith Larson: Any additional tips to handling the long hours ?

Ronald Bradford: Conferences can be hard, especially with all the post event drinking.  This is a two day event and I am sure will include additional events on Friday and Saturday night so come well prepared, and leave work behind. Take the time to learn something new.   You can always catchup on sleep later.

Keith Larson: Thank you so much for taking some time to do this I look forward to seeing you at the MySQL Connect conference.

 Please stay tuned here for more updates on MySQL. 


About

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

Twitter


Facebook

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
5
6
9
10
11
12
13
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today