Thursday Aug 28, 2014

Second MySQL User Group Korea meeting

We are pleased to announce the second MySQL User Group meeting in Seoul, South Korea.

This time Daesang Information & Technology sponsors venue and snack. Please find more information below.

Date & Time: 29th Aug, 2014, 7pm to 9 pm

VenueTOZ Kangnam tower, 2nd floor

Agenda:

1. MySQL Fabric intro

2. MySQL Cluster intro & demo

3. Select MUG Staff

See more details

We are looking forward to talking to you! 

Tuesday Aug 26, 2014

MySQL at the Malaysian OpenSource Conference

MySQL team attends and speaks at the MOSC 2014 on September 24-25, 2014 in Kuala Lumpur, Malaysia. We are having a MySQL booth and above that our local colleague Ricky Setyawan has secured one 45 minutes talk scheduled for Wed, Sep 24 @2:15-3:00pm on the MySQL Web Reference Architecture.

We will also run two hours workshop on MySQL Fabric scheduled for Thursday, Sep 25 @2:30-4:30pm. If you are around do not forget to come to our booth and/or visit our MySQL session & workshop!

Monday Aug 25, 2014

Learn All About MySQL Cluster

Just released - the all new MySQL Cluster training course.

This MySQL Cluster training teaches you how to install and configure a real-time database cluster at the core of your application. Expert instructors will teach you how to design and maintain your clusters for high availability and scalability by using MySQL Cluster's open-source and enterprise components.

This 4-day training course is a must for those who want to learn about MySQL Cluster as you will not only learn about the concepts and features but you will get extensive hands-on experience. You can follow this training course from your own desk via a live-virtual training or by traveling to an education center to follow this course.

Be the first to influence the schedule for this newly released course by registering your interest on the Oracle University portal.

For more information about the authentic MySQL curriculum, go to http://education.oracle.com/mysql

Monday Aug 18, 2014

Items Affecting Performance of the MySQL Database

To learn about the many factors that can affect the performance of the MySQL Database, take the MySQL Performance Tuning course.

You will learn:

  • How your hardware and operating system can affect performance
  • How to set up and logging to improve performance
  • Best practices for backup and recovery
  • And much more

You can take this 4-day instructor-led course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registering for training, following lectures at your own pace through streaming video and booking time on a lab environment to suit your schedule.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events on the schedule to suit different time-zones.
  • In-Class Event: Travel to an education center to attend this course. Below is a selection of events already on the schedule.

 Location

 Date

 Delivery Language

 Brussels, Beligum

 10 November 2014

 English

 Sao Paolo, Brazil

 25 August 2014

 Brazilian Portuguese

 London, England

 20 October 2014

 English

 Milan, Italy

 20 October 2014

 Italian

 Rome, Italy

 1 December 2014

 Italian

 Riga, Latvia

 29 September 2014

 Latvian

 Petaling Jaya, Malaysia

 22 September 2014

 English

 Utrecht, Netherlands

 10 November 2014

 English

 Warsaw, Poland

 1 September 2014

 Polish

 Barcelona, Spain

 14 October 2014

 Spanish

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

Tuesday Aug 12, 2014

Top 10 Reasons to Attend MySQL Central @ OpenWorld

MySQL Central @ OpenWorld is less than 7 weeks away, have you registered?


The event represents a unique opportunity to boost your MySQL skills and hear from Oracle's MySQL engineers along with customers, partners and MySQL community members.

Here are the top 10 reasons why you should join us:

  • Better understand Oracle's MySQL strategy. Hear straight from the source how Oracle is driving MySQL innovation, and what are the latest news and plans.
  • Meet the engineers developing and supporting the MySQL products. You'll have the opportunity to ask them all your questions, which can save you significant time and money.
  • Learn about real-world experiences from other organizations. You'll hear from MySQL experts at Facebook, Twitter, Dropbox, Booking.com, Ticketmaster, Yahoo! and others.
  • Acquire in-depth knowledge about InnoDB, best of both worlds "SQL & NoSQL" strategies, MySQL Fabric, MySQL Cluster, performance and scalability tuning, security and numerous other topics.
  • Take a deep dive into MySQL Fabric, MySQL Replication, Getting started with MySQL and more with 6 tutorials.
  • Get hands-on experience using MySQL EXPLAIN, MySQL Utilities or the new MySQL Workbench performance tools with eight different Hands-On Labs.
  • Express your ideas and engage into great discussions during six Birds-of-a-feather sessions about InnoDB, High Availability, Backup, GIS and other topics.
  • Immerse yourself into the MySQL universe and network with MySQL experts for several days. You’ll love the passion and the energy, and you’ll likely get many new ideas.
  • Access all of the Oracle OpenWorld keynotes and extensive content.
  • Have fun! You’ll meet both old and new faces, have a lot of fun during the OpenWorld and MySQL receptions, and be able to enjoy world-class entertainment.


Don’t miss out on this great opportunity, Register Now to save US$200 over the onsite price!


We look forward to seeing you at MySQL Central @ OpenWorld!

Monday Aug 11, 2014

Database Modelling is Key to Getting Started on the MySQL Database

Database modelling is the process of defining the logical structure of a database. This structure determines how data is stored, organized and manipulated. This enables you to:

  • Understand your data before building the database
  • Consider what questions your data must answer

The entity relationship model (ERM) is the most common model for an RDBMS.

Learn more about database modelling, design and much more in the MySQL for Beginners training course.

You can take this 4-day instructor-led training course via the following formats:

  • Training-on-Demand: Start training within 24 hours of registration. Follow lectures at your own pace through streaming video. Book time on a lab environment to suit your own schedule.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events already on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to attend this course. Below is a selection of the in-class events already on the schedule.

 Location

 Date

 Delivery Language

 Brussels, Belgium

 8 September 2014

 English

 Sao Paolo, Brazil

 6 October 2014

 Brazilian Portuguese

 Cairo, Egypt

 14 September 2014

 Arabic

 London, England

 11 November 2014

 English

 Rome, Italy

 3 November 2014

 Italian

 Dehli, India

 19 August 2014

 English

 Nairobi, Kenya

 8 September 2014

 English

 Riga, Latvia

 3 November 2014

 Latvian

 Petaling Jaya, Malaysia

 20 October 2014

 English

 San Pedro Garza Garcia

 24 November 2014

 Spanish

 Utrecht, Netherlands

 8 September 2014

 English

 Lisbon, Portugal

 22 September 2014

 European Portuguese

 Porto, Portugal

 22 September 2014

 European Portuguese

To register for an event, request an additional event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Aug 04, 2014

Handling Error Messages and Warnings with MySQL

To ensure that your MySQL Database works as efficiently as possible, it is important to know how to handle error messages and warnings.

Error messages have three components:

  • A MySQL-specific error code, such as 1146
  • A SQLSTATE error code. These codes are defined by standard SQL and the ODBC standard.
  • A text message that describes the problem

MySQL Server generates a warning when it is not fully able to comply with a request or when an action has possibly unintended side effects. You can display these warnings with the SHOW WARNINGS statement.

To learn about handling error messages and warnings along with other developer topics, consider taking the MySQL for Developers training course.

You can take this 5-day course as a:

  • Live-virtual event: Attend a live training event from your own desk, no travel required. Choose from a selection of events on the schedule to suti different timezones.
  • In-class event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.

 Locaation

 Date

 Delivery Languaage

 Vienna, Austria

 27 November 2014

 German

 Brussels, Belgium

 8 December 2014

 English

 Sao Paolo, Brazil

 13 October 2014

 Brazilian Portuguese

 London, England

 29 September 2014

 English

 Belfast, Ireland

 6 October 2014

 English

 Dublin, Ireland

 27 October 2014

 English

 Milan, Italy

 10 November 2014

 Italian

 Rome, Italy

 13 October 2014

 Italian

 Nairobi, Kenya

 15 September 2014

 English

 Petaling Jaya, Malaysia

 25 August 2014

 English

 Utrecht, Netherlands

 8 December 2014

 English

 Makati City, Phillippines

 29 September 2014

 English

 Warsaw, Poland

 25 August 2014

 Polish

 Lisbon, Portugal

 13 October 2014

 European Portuguese

 Porto, Portugal

 13 October 2014

 European Portuguese

 Barcelona, Spain

 29 October 2014

 Spanish

 Madrid, Spain

 3 November 2014

 Spanish

 Valencia, Spain

 24 November 2014

 Spanish

 Basel, Switzerland

 13 October 2014

 German

 Bern, Switzerland

 13 October 2014

 German

 Zurick, Switzerland

 13 October 2014

 German

The MySQL for Developers course is the recommended training for the MySQL 5.6 Developers OCP certification exam.

To register for the MySQL for Developers course, request an additional event, or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Jul 21, 2014

Setting up and Using MySQL Replication

MySQL Replication allows servers to copy changes from one instance to another. Take the MySQL for Database Administrators course to learn about replication, including:

  • How to set up a replication environment
  • Complex topologies
  • Replication types
  • Global transaction IDs (GTIDs)
  • MySQL Utilities
  • Logs and threads

Replication is one of the many topics covered in the MySQL for Database Administrators course. You can take this 5-day instructor-led course as  

  • Training-on-Demand: Start training within 24 hours of registration. Follow lectures at your own pace and book time to take the lab exercises to suit your schedule.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to take this class. Below is a selection of the events already on the schedule:

 Location

 Date

 Delivery Language

 Brisbane, Australia

 4 August 2014

 English

 Brussels, Belgium

 25 August 2014

 English

 Sao Paolo, Brazil

 18 August 2014

 Brazilian Portuguese

 Egypt, Cairo

 28 September 2014

 Arabic

 London, England

 22 September 2014

 English

 Belfast, Ireland

 15 September 2014

 English

 Nairobi, Kenya

22 September 2014 

 English 

 Dublin, Ireland

29 September 2014 

 English 

 Tel Aviv, Israel

 16 November 2014

 Hebrew

 Milan, Italy

 22 September 2014

 Italian

 Rome, Italy

 15 September 2014

 Italian

 Petaling Jaya, Malaysia

 29 September 2014

 English

 Utrecht, Netherlands

 25 August 2014

 English

 Edinburgh, Scotland

 29 September 2014

 English

 Madrid, Spain

 6 October 2014

 Spanish

 Tunis, Tunisia

 5 November 2014

 French

 Istanbul, Turkey

 15 September 2014

 Turkish

The MySQL for Database Administrators course helps prepare for the MySQL 5.6 Database Administrator OCP certification exam.

To register for an event, request an additional event or learn more about the authentic MySQL curriculum go to http://education.oracle.com/mysql.

Monday Jul 14, 2014

Save 20% With MySQL Training and Certification Packages

Get the best from both worlds with bundled packages: a training course and a certification exam voucher. You save 20% when you buy training and certification in discount packages.

Training helps you acquire product expertise. Certification proves this expertise to your future employers.

There are two MySQL Discount Packages: MySQL Database Administration and MySQL Developer.

For more information about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Tuesday Jul 08, 2014

MySQL Central @ OpenWorld Keynotes

A few weeks ago we announced the availability of the MySQL Central @ OpenWorld content catalog.


We're now pleased to announce additional keynotes delivered by MySQL power users. They will follow the "State of The Dolphin" keynote address by Oracle's Chief Corporate Architect Edward Screven and VP of MySQL Engineering Tomas Ulin, and include:

High Speed Event Logging at Booking.com
Nicolai Plum, Senior Systems Architect, will provide an overview of Booking.com's MySQL-based event logging application, recording data from all customer interactions in order to develop the best customer experience.



MySQL at Dropbox
You’ll learn about MySQL at Dropbox with Renjish Abraham, Tech Lead DBA.



MySQL 5.6 at Twitter
Calvin Sun, Senior Engineering Manager, will walk us through Twitter's upgrade to MySQL 5.6. How did they do it, and what are the results?



The keynotes will take place on Monday, September 29, from 4.15 pm to 6.15 pm.

Check out all the MySQL Central @ OpenWorld sessions and Register Now if you haven't yet! You can save US$500 with the Early Bird Discount until July 18!


We look forward to seeing you at MySQL Central @ OpenWorld!

Monday Jul 07, 2014

MySQL Cluster High Availability Through Data Replicas

MySQL Cluster enables high availability by storing data replicas on multiple hosts. MySQL Cluster maintains connections between data nodes by using high-speed interconnects over TCP/IP - standard or direct connections - or SCI (Scalable Coherent Interface) sockets.

To learn more about MySQL Cluster, take the MySQL Cluster training course.

This course is currently scheduled for the following locations:

 Location

 Date

 Delivery Language

 Sao Paulo, Brazil

 28 July 2014

 Brazilian Portuguese

 Berlin, Germany

 11 August 2014

 German

 Hamburg, Germany

 29 September 2014

 German

 Munich, Germany

 15 December 2014

 German

 Rome, Italy

 8 September 2014

 Italian

Seoul, Korea

28 July 2014 

 Korean 

Petaling Jaya, Malaysia

16 July 2014 

English 

Warsaw, Poland

28 July 2014 

Polish 

Singapore

 29 July 2014

 English 

Edison, NJ, United States

18 August 2014 

English 

San Francisco, CA, United States

13 August 2014 

English 

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

Monday Jun 30, 2014

P for PHP, M for MySQL in LAMP, Learn Their Roles in Web Application Development

Understanding and installling the components of the LAMP stack are the first steps to learning the role of Linux, the Apache Server, MySQL and PHP in developing web applications. To learn more, take the MySQL and PHP - Developing Dynamic Web Application training course.  

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

  • Live-Virtual Event: Take this class from your own desk, no travel required. Choose from events already on the schedule to suit different time-zones. These events are delivered in English.
  • In-Class Event: Travel to an education center to take this class, for example at

 Location

 Date

 Delivery Location

 Rome, Italy

 29 September 2014

 Italian

 Warsaw, Poland

 22 September 2014

 Polish

To register for an event, request an additional event, or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Wednesday Jun 25, 2014

Genoscope Makes Genomic Data Available to Scientists with MySQL Enterprise Edition

Genoscope, the French National Sequencing Center, was created in 1997 and is one of the largest sequencing centers in Europe. Its mission is to acquire, to "sequence" and to analyze the genetic information of various organisms presenting a scientific, medical or economic interest. DNA sequencing is the process of determining the precise order of nucleotides within a DNA molecule. Genoscope produces various types of data, such as complete or partial genome sequences, that are then compared and analyzed. Following its role as a major actor in the Human Genome Project, Genoscope has changed its orientation toward environmental genomics. Since 2007, Genoscope is part of CEA, the French Alternative Energies and Atomic Energy Commission.



Challenges

  • Make a large amount of scientific data available to biologists worldwide via a database combining performance, ease of use and cross-platform availability.
  • Rapidly and easily deploy new database applications to address the constantly growing needs of genomic analysis.

Solution
  • Genoscope initially relied on Sybase for its database applications but faced a number of constraints, especially in terms of ease of use and administration as well as of cross-platform availability.
  • Evaluation and selection of MySQL as new database standard to eliminate those constraints.
  • About 300 MySQL databases storing 8 terabytes of data have been deployed so far by the sequencing center, including :
    • 250 MySQL databases enabling the scientific community to access genomic data via web applications. Each application is dedicated to a specific type of data, for example "metagenomes" or the comparison of different genomes. The most important one handles over 5 terabytes of data, relying on approximately 30 MySQL databases.
    • About 50 MySQL databases are used for Business Intelligence as well as project management applications.
  • Genoscope relies on MySQL 5.6 for new applications; and on MySQL Workbench for their design and development. Sylvain Bonneval, DBA in the Genoscope systems team underlines "Beyond the performance and ease of use of MySQL, we particularly appreciate the fast pace of innovations delivered by Oracle. MySQL 5.6 integrates numerous very useful new features, and there’s no doubt that tremendous progress is being made with MySQL."
  • MySQL Enterprise Edition was implemented to allow the teams to access Oracle’s MySQL technical support, and to benefit from monitoring tools including the MySQL Enterprise Monitor and MySQL Query Analyzer.

"MySQL allowed us to significantly increase database usage in our organization. It is a tool perfectly suited to public research applications considering both its performance and open source nature." Sylvain Bonneval, DBA, Genoscope

Le Genoscope met les données génomiques à disposition des scientifiques avec MySQL Enterprise Edition

Créé en 1997, le Genoscope - Centre National de Séquençage - est un grand équipement au service de la communauté scientifique. Sa mission est d'acquérir, de "séquencer", et d'analyser l'information génétique de divers organismes d'intérêt scientifique, médical ou économique. Concrètement, le séquençage consiste à déterminer l'ordre dans lequel s'enchaînent les molécules élémentaires qui constituent les molécules d'ADN. Le Genoscope produit des données de nature diverse - séquences entières ou partielles de génomes ou de produits d'expression des gènes - qu'il compare et interprète. Après avoir été l'un des acteurs du projet génome humain, le Genoscope met aujourd'hui le cap vers la génomique environnementale. Depuis 2007, le Genoscope est intégré à l'institut de Génomique du CEA, le Commissariat à l'énergie atomique et aux énergies alternatives.



Défis

  • Mettre un volume important de données scientifiques à disposition des biologistes du monde entier via une base de données alliant performance, portabilité et simplicité d’utilisation.
  • Rapidement et simplement déployer de nouvelles applications de bases de données pour répondre aux besoins croissants d’analyse génomique.

Solution

  • Le Genoscope a initialement utilisé Sybase comme base de données mais faisait face à plusieurs contraintes, notamment en termes de portabilité sur différentes plateformes ainsi que de simplicité d’utilisation et d’administration.
  • Evaluation et sélection de MySQL comme nouveau standard de base de données pour répondre à ces contraintes.
  • Environ 300 bases MySQL contenant 8 téraoctets de données sont déployées par l’institut à ce jour, incluant:
    • 250 bases MySQL utilisées pour mettre les données génomiques à disposition de la communauté scientifique via des applications Web. Chaque application est dédiée à un type particulier de données, par exemple les "métagénomes" ou la comparaison de différents génomes. L’application la plus importante gère plus de 5 téraoctets de données, s’appuyant sur une trentaine de bases MySQL.
    • Une cinquantaine de bases de données MySQL utilisées pour des applications d’informatique décisionnelle et de gestion de projets.
  • Le Genoscope utilise MySQL 5.6 pour les nouvelles applications, ainsi que MySQL Workbench pour leur modélisation et développement. Sylvain Bonneval, DBA de l’équipe système, souligne "Outre la performance et la simplicité d’utilisation de MySQL, nous apprécions particulièrement le rythme des innovations délivrées par Oracle. MySQL 5.6 intègre de nombreuses nouvelles fonctionnalités très utiles et nous constatons à quel point MySQL est une base de données en pleine progression."
  • MySQL Enterprise Edition a été mis en place pour permettre aux équipes de bénéficier de l’accès au support technique MySQL d’Oracle ainsi que des outils de monitoring comme le MySQL Enterprise Monitor et MySQL Query Analyzer.


"MySQL nous a permis de largement accroître l'usage des bases de données au sein de notre organisation. C’est un outil parfaitement adapté aux applications de recherche publique, tant par sa performance que par sa nature open source." Sylvain Bonneval, DBA, Le Genoscope

Monday Jun 23, 2014

InnoDB, The Choice for High Concurrency Database Systems

InnoDB has proven to be a reliable data storage engine for modern, high concurrency database systems. It is fully ACID compliant, and supports a wide range of isolation modes, from READ-UNCOMMITEED to SERIALIZABLE.

InnoDB multiversion concurrency control (MVCC) enables records and tables to be updated without the overhead associated with row-level locking mechanisms. The MVCC implementation in InnoDB largely eliminates the need to lock tables or rows during updates, and enables good performance for high concurrency workloads.

To learn more about this subject and related performance tuning topics tuning, take the MySQL Performance Tuning training course. This 4-day, instructor-led course is available as:

  • Training-on-Demand: Start training within 24 hours of registration. You will follow lecture material at your own pace through streaming video and you can book time on a lab environment to suit your schedule.
  • Live-Virtual Events: Attend a live class from your own desk, no travel required. Choose from a selection of events on the schedule to suit different timezones.
  • In-Class Events: Travel to an education center to take this class. Below is a selection of the in-class events already on the schedule.

 Location

 Date

 Delivery Language

 Sao Paulo, Brazil

 24 June 2014

Brazilian Portuguese 

 Brussels, Belgium

 4 August 2014

English 

 Shanghai, China

 5 August 2014

Simplified Chinese 

 London, England

 20 October 2014

English 

Milan, Italy 

 28 July 2014

Italian 

 Riga, Latvia

 29 September 2014

 Latvian

Petaling Jaya, Malaysia 

22 September 2014  

 English

 Utrecht, Netherlands

4 August 2014  

 English 

 Warsaw, Poland

 14 July 2014 

 Polish

 Barcelona, Spain

 14 October 2014

 Spanish

 Istanbul, Turkey

 4 August 2014

 Turkish

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

About

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

Twitter


Facebook

Search

Archives
« February 2015
SunMonTueWedThuFriSat
1
4
5
6
7
8
13
14
15
17
19
20
21
22
24
25
28
       
       
Today