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.

Thursday Jun 19, 2014

Discover the MySQL Central @ OpenWorld Content Catalog

MySQL Central @ OpenWorld, taking place in San Francisco September 28 - October 2, will feature keynotes, conference sessions, tutorials, hands-on labs, as well as birds-of-a-feather sessions.

The Content catalog listing the MySQL Central @ OpenWorld sessions is available here.

Some of the sessions you will be able to attend include:

Keynotes:

The State of the Dolphin
Join Edward Screven, Oracle’s Chief Corporate Architect, and Tomas Ulin, vice president of MySQL Engineering, for the “State of the Dolphin” keynote address. You’ll learn about Oracle’s MySQL strategy as well as the latest MySQL innovations and plans.


We will shortly announce additional customer keynotes, stay tuned!


Conference Sessions:

  • MySQL 5.7: InnoDB, What’s New - Sunny Bains, Oracle
  • The MySQL SYS Schema - Mark Leith, Oracle
  • MySQL 5.6 and WebScaleSQL at Facebook - Yoshinori Matsunobu, Facebook
  • User Management in MySQL @ Twitter – Thomas Krouper, Twitter
  • NoSQL and MySQL: Dynamic Schemas - Sheeri Cabral, Mozilla
  • Elastic Scalability in MySQL Fabric Using OpenStack - Mats Kindahl, Oracle Corporation
  • MySQL@ King, Scaling Candy Crush – Olle Nilsson, King
  • MySQL Performance: Demystified Tuning & Best Practices - Dimitri Kravtchuk, Oracle
  • MySQL Cluster Scaling For the Masses - Bernhard Ocklin, Oracle
  • Yahoo!: Performance Monitoring and Tuning at Scale - Ashwin Nellore & Xiang Rao, Yahoo!
  • Basic MySQL troubleshooting for Oracle DBAs - Svetlana Smirnova, Oracle
  • and a lot more


Tutorials:

  • MySQL Fabric Tutorial – Lars Thalmann, Oracle Corporation
  • A hands-on exploration of InnoDB on-disk storage with innodb_ruby – Davi Arnaut, LinkedIn & Jeremy Cole, Google
  • MySQL Replication Tips and Tricks – Luis Soares, Oracle  
  • and more


Birds-of-a-Feather Sessions:

  • MySQL & GIS – Alexander Rubin, Percona
  • MySQL High Availability & Backup – Oracle team
  • MySQL Server (InnoDB, Optimizer & more) – Oracle team
  • and more


Additionally, we will also run 8 Hands-on Labs. Those will soon get listed in the content catalog as well and they include:

  • MySQL Troubleshooting with the Performance Schema – Svetlana Smirnova, Oracle 
  • Using MySQL Workbench Performance Tools – Alfredo Kojima, Oracle  
  • DevOps Made Easy with MySQL Utilities - Chuck Bell, Oracle
  • MySQL EXPLAIN in Practice  - Øystein Grøvlen, Oracle
  • …and more
And, you also get access to all the Oracle OpenWorld keynotes and extensive content!


Finally, not only will you have the opportunity to meet Oracle’s MySQL engineers and ask all your questions but you’ll also have ample time to network with your peers during several social events:

  • The Oracle OpenWorld Welcome Reception on Sunday night
  • The MySQL Community Reception on Tuesday
  • The Appreciation Event on Wednesday


Thank you very much to the MySQL Central @ OpenWorld content committee, especially our external members, for their efforts and help to build this fantastic program.

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 Jun 16, 2014

Normalize Your MySQL Database For Efficient Data Access, Query Flexibility and Maintenance

Before you start creating database entities, spend some time designing your database to ensure that it is fit for your purpose. The time you invest in this process saves a lot of time and trouble later. Professional database designers fine-tune their design using a process called 'normalization'. The normalization process takes your database design through a number of 'normal forms', which aim to ensure efficient data access, greater query flexibility, and easier maintenance.

For example, the First Normal Form (or '1NF') ensures that all your database columns contain only a single value. A column that contains multiple data values is difficult to access and keep up to date. It also ensures that each table row only represents a single 'real world' item. Like all the other normal forms, this encourages you to split your data across multiple tables, with less rows in each table. You can quickly see the benefits of this approach as your database grows.

To learn more about normalization and other topics that help you get started with the MySQL database, take the MySQL for Beginners training course. You can take this 4-day training course as:

  • Training-on-Demand: Start training within 24 hours of registering. Follow lectures through streaming video at your own pace and 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 on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to attend this class. Below is a selection of the events already on the schedule.

 Location  Date  Delivery Language
 Brussels, Belgium
 7 July 2014
 English
 Sao Paulo, Brazil
 23 June 2014
 Brazilian Portuguese
 Cairo, Egypt
 14 September 2014
Arabic
 London, England
 28 July 2014
 English
 Milan, Italy
 14 July 2014
 Italian
 Nairobi, Kenya
 7 July 2014
English
Riga, Latvia
 3 November 2014
Latvian
 Petaling Jaya, Malaysia
 14 July 2014
 English
 Utrecht, Netherlands
 7 July 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.

Thursday Jun 12, 2014

FairWarning Privacy Monitoring Solutions Rely on MySQL to Secure Patient Data

FairWarning® solutions have audited well over 120 billion events, each of which was processed and stored in a MySQL database. FairWarning is the world's leading supplier of privacy monitoring solutions for electronic health records, relied on by over 1,200 Hospitals and 5,000 Clinics to keep their patients' data safe. In January 2014, FairWarning was awarded the highest commendation in healthcare IT as the first ever Category Leader for Patient Privacy Monitoring in the "2013 Best in KLAS: Software & Services" report[1].

FairWarning has used MySQL as their solutions’ database from their start in 2005 to worldwide expansion and market leadership. FairWarning recently migrated their solutions from MyISAM to InnoDB and updated from MySQL 5.5 to 5.6. Following are some of benefits they’ve had as a result of those changes and reasons for their continued reliance on MySQL (from FairWarning MySQL Case Study).

Scalability to Handle Terabytes of Data FairWarning's customers have a lot of data:

  • On average, FairWarning customers receive over 700,000 events to be processed daily.
  • Over 25% of their customers receive over 30 million events per day, which equates to over 1 billion events and nearly one terabyte (TB) of new data each month.
  • Databases range in size from a few hundred GBs to 10+ TBs for enterprise deployments (data are rolled off after 13 months).

Low or Zero Admin = Few DBAs "MySQL has not required a lot of administration. After it's been tuned, configured, and optimized for size on initial setup, we have very low administrative costs. I can scale and add more customers without adding DBAs. This has had a big, positive impact on our business.”
- Chris Arnold, FairWarning Vice President of Product Management and Engineering.

Performance Schema  As the size of FairWarning's customers has increased, so have their tables and data volumes. MySQL 5.6’ new maintenance and management features have helped FairWarning keep up. In particular, MySQL 5.6 performance schema’s low-level metrics have provided critical insight into how the system is performing and why.

Support for Mutli-CPU Threads MySQL 5.6' support for multiple concurrent CPU threads, and FairWarning's custom data loader allow multiple files to load into a single table simultaneously vs. one at a time. As a result, their data load time has been reduced by 500%.

MySQL Enterprise Hot Backup Because hospitals and clinics never stop, FairWarning solutions can’t either. FairWarning changed from using mysqldump to MySQL Enterprise Hot Backup, which has reduced downtime, restore time, and storage requirements. For many of their larger customers, restore time has decreased by 80%.

MySQL Enterprise Edition and Product Roadmap Provide Complete Solution "MySQL's product roadmap fully addresses our needs. We like the fact that MySQL Enterprise Edition has everything included; there's no need to purchase separate modules."  - Chris Arnold

Learn More>>


[1] 2013 Best in KLAS: Software & Services report, January, 2014. © 2014 KLAS Enterprises, LLC. All rights reserved.

Tuesday Jun 10, 2014

MySQL User Camp - Bangalore, India

Another MySQL User Group meeting called "MySQL User Camp-Bangalore" is announced for Jun 20 in Bangalore, India!! Please find more details below:

  • Date and time: June 20, 2014 at 3PM IST
  • Place: Bangalore, Kalyani Magnum campus
  • Registration: Registration is needed, please contact mysql.bangalore@gmail.com
  • URL

Agenda:

  • MySQL 5.7 New Features and NoSQL support in MySQL
  • Sharding as implemented in MySQL Fabric
  • Open discussion with MySQL developers
We are looking forward to seeing you on Jun 20!!

Upcoming EMEA, APAC & US Events with MySQL in 2014

As an update to the previous announcement from Mar 25, 2014 please find below the updated list of events where MySQL Community team is attending and/or supporting. This time you can find not only EMEA & APAC ones but also conferences & events we are covering in the US & Canada. You are invited to meet our engineers at the events below.  

EMEA 

  • NEW!! BGOUG, Sandanski, Bulgaria, June 13, 2014
    •  Georgi Kodinov will attend and speak at this local Oracle User Group event. Feel free to come.
  • PHP Tour Lyon, Lyon, France, June 23-24, 2014
    • MySQL team is going to be part of this show as well, we are not going to have a booth here but very active networking by our french MySQL team around the event. Come to meet us and talk to us!
  • NEW!! Converge Conference, Glasgow, Scotland, August 15-16, 2014
    •  MySQL Community Manager, David Stokes attends with MySQL talk.
  • NEW!! CakeFest, Madrid, Spain, August 21-24, 2014
    •  A talk on "Scaling Your MySQL instances AND keeping your Sanity" will be given by the MySQL Community Manager, David Stokes.
  • Froscon 2014, St.Augustin, Germany, August 23-24, 2014
    • Please visit our booth as well as watch the Froscon website for the schedule updates.
  • NEW!! SymfonyLive, UK, London, September 25-26, 2014
    • MySQL Community Magers, David Stokes & Morgan Tocker submitted MySQL talks for this show. Schedule will be announced later on.
  • DrupalCon Amsterdam, The Netherlands, September 29-Oct 3, 2014
    • Meet us at our booth at DrupalCon Amsterdam. For the schedule please watch the DrupalCon website.
  • All Your Base, Oxford UK, October 17, 2014 
    • Come to visit our MySQL booth and talk to our MySQL experts.
  • NEW!! WebTechCon / IPC, Munich Germany, October 26-29, 2014
  • NEW!! DOAG, Nuremberg, Germany, November 18-20, 2014
    • There will be a full day of MySQL talks and one full day of MySQL workshop & sessions with live demo. This event is simply hard to miss!
  • NEW!! Forum PHP Paris, France, November 21-22, 2014
    • More details: TBD
  • NEW!! UK OUG, Liverpool, UK, December 8-10, 2014
    • MySQL will be part of the Oracle booth and we hope to get more space for MySQL talks. 

USA

APAC

  • OpenSourceConference Japan, Hokkaido, June 13-14, 2014
    • MySQL is represented by Ryusuke Kajiyama with the talk on "MySQL Technology Updates".
  • NEW!! db tech showcase, Osaka Japan, June 18-20, 2014
    • Three MySQL talks are scheduled for this show, "MySQL for Oracle DBA" & "MySQL Technology Updates" by Ryusuke Kajiyama. The last talk will be on MySQL Fabric by Yoshiaki Yamasaki.
  • NEW!! PyCon Singapore, Singapore, June 18-20, 2014
    • Ryusuke Kajiyama will be talking about "Sharding and scale-out using Python-based MySQL Fabric".
  • NEW!! COSCUP, Taipei, Taiwan, July 19-20, 2014
    • We are going to run a technical session on MySQL Workbench & one talk on how to make MySQL better MySQL.
  • NEW!! PyCon New Zealand, Wellington, New Zealand, September 13-14, 2014
    • MySQL talks were submitted as well as one talk by Solaris Modernization team on Python & Solaris, watch the website for schedule updates.
  • NEW!! PyCon Japan, Tokyo Japan, September 13-15, 2014
    • MySQL will be a MySQL session speaker, no schedule is announced yet.
  • Ruby Kaigi, Tokyo, Japan, September 18-20, 2014
    • Another event MySQL supports and attends in APAC region. Ruby Kaigi is the international Ruby Conference in Japan, Tokyo. Ruby started in Japan, so Ruby Kaigi has excellent speakers and developers! MySQL team is going to be present at this conference with MySQL talks and active networking around the venue.
  • NEW!! PyCon India, Bangalore, India, September 26-28, 2014
    • A MySQL talk on "MySQL Utilities scaling MySQL with Python" has been submitted, please watch the PyCon website for the schedule updates.
  • NEW!! OpenSourceConference Japan, Tokyo, October 18-19, 2014
  • NEW!! OpenSource India, Bengaluru, India, November 7-8, 2014
  • NEW!! OpenSourceConference Japan, Fukuoka, November 14-15, 2014
You can check the MySQL wikis for updates on the conferences we are attending. Next time I hope to have more details for each event above (especially for the US ones).

Monday Jun 09, 2014

Optimizing MySQL, Improving Performance of Database Servers

Optimization involves improving the performance of a database server and queries that run against it. Optimization reduces query execution time and optimized queries benefit everyone that uses the server. When the server runs more smoothly and processes more queries with less, it performs better as a whole. To learn more about how a MySQL developer can make a difference with optimization, take the MySQL Developers training course.

This 5-day instructor-led course is available as:

  • Live-Virtual Event: 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 Event: Travel to an education center to attend an event. Below is a selection of the events on the schedule.

 Location

 Date

 Delivery Language

 Vienna, Austria

 17 November 2014

 German

 Brussels, Belgium

 8 December 2014

 English

 Sao Paulo, Brazil

 14 July 2014

 Brazilian Portuguese

London, English

 29 September 2014

 English

  Belfast, Ireland

 6 October 2014

 English

 Dublin, Ireland

 27 October 2014

 English

 Milan, Italy

 10 November 2014

 Italian

 Rome, Italy

 21 July 2014

 Italian

 Nairobi, Kenya

 14 July 2014

 English

 Petaling Jaya, Malaysia

 25 August 2014

 English

 Utrecht, Netherlands

 21 July 2014

 English

 Makati City, Philippines

 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

 7 July 2014

 Spanish

 Madrid, Spain

 3 November 2014

 Spanish

 Valencia, Spain

 24 November 2014

 Spanish

 Basel, Switzerland

 4 August 2014

 German

 Bern, Switzerland

 4 August 2014

 German

 Zurich, Switzerland

 4 August 2014

 German

The MySQL for Developers course helps prepare you for the MySQL 5.6 Developers 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.

Wednesday Jun 04, 2014

The MySQL Community talks in Japan, Tokyo

There will be 2 community meetups in Tokyo in Japan scheduled for June 2014. Please check and join following: 

Monday Jun 02, 2014

Securing User Account Details with MySQL

Keeping user account details secure is always at the forefront of a Database Administrator's mind. However, users want to get up and running as soon as possible without complex login procedures.

You can learn more about this and many other topics in the MySQL for Database Administrator course.

For example, MySQL 5.6.6 introduced a new utility: mysql_config_editor, which makes secure access via MySQL client applications much easier to establish, while still providing a good measure of security.

The mysql_config_editor stores a user's authentication details in an encrypted login file called mylogin.cnf. This login file is readable and writable for the user who invokes the utility, and invisible to everyone else. You can use it to collect all your hard-to-remember server locations and paswords safe in the knowledge that your passwords are never invoked using clear text.

The MySQL for Database Administrators course is a 5-day instructor-led course which is available as a:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material 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, choosing from a selection of events 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 events already on the schedule.

Location

 Date

 Delivery Language

 Brisbane, Australia

 18 August 2014

 English

 Brussels, Belgium

 25 August 2014

 English

 Sao Paulo, Brazil

 2 June 2014

 Brazilian Portuguese

 Cairo, Egypt

 28 September 2014

 Arabic

 London, England

 14 July 2014

 English

 Belfast, Ireland

 15 September 2014

 English

 Dublin, Ireland

 29 September 2014

 English

 Rome, Italy

 16 June 2014

 Italian

 Seoul, Korea

 9 June 2014

 Korean

 Petaling Jaya, Malaysia

 16 June 2014

 English

 Utrecht, Netherlands

 25 August 2014

 English

 Edinburgh, Scotland

 26 June 2014

 English

 Madrid, Spain

 6 October 2014

 Spanish

 Tunis, Tunisia

 27 October 2014

 French

 Istanbul, Turkey

 14 July 2014

 Turkish

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

To read more about MySQL security, consult the MySQL Reference Manual - http://dev.mysql.com/doc/refman/5.6/en/security.html.

Wednesday May 28, 2014

MySQL User Group Meeting in Madrid, Spain

We are pleased to announce another MySQL User Group meeting scheduled for June 5 in Madrid, Spain. Keith Hollman, the MySQL Principal Sales Consultant will be talking about MySQL & Oracle strategy and MySQL Cluster. A small demo of MySQL Cluster will be part of the presentation. 

Details about the event:
Date: June 5, 2014
Time: 7:00 pm-8:30 pm
Place: Edificio Telefonica, Gran via 28, Madrid, Entrada por C/ Valverde 2

We are looking forward to seeing you in Madrid!

About

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

Twitter


Facebook

Search

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