Thursday Feb 27, 2014

Upcoming EMEA Events with MySQL 2014

As a follow up to the previous blog announcement we are pleased to announce following conferences in EMEA & APAC which MySQL Community Team supports. As usual not only MySQL staff is attending, we are sharing our resources with Oracle VM, Linux and Java (where applicable). Please come to meet us at: 

EMEA 

  • OpenSUSE Conference - Dubrovnik, Croatia, April 24-28, 2014
    • You can meet the MySQL team at our booth or at any of approved talks. Schedule for this event is not yet approved/published. Please watch the OpenSUSE website for current program schedule. 
  • JavaScript UnConference, Hamburg, Germany, Apr 26, 2014
    • Ulf Wendel from MySQL team will attend & talk at the conference. Please come to meet him either at our table or at his talk.
  • PHP UnConference, Island of Majorka, May 17-18, 2014
    • There is no schedule set for such events as UnConference. This event is mostly for PHP experts and engineers and the whole schedule is done usually on the place. MySQL is presented by Ulf Wendel for sure! 
  • Solutions Linux & Open Source, Paris, France, May 27-28, 2014
    • Meet our MySQL, Oracle VM and Oracle Linux staff at our booth in the exhibition area!
    • The schedule is not yet announced, please watch the organizers' website.
  • Drupalcon Amsterdam, Holland, Sep 30 - Oct 3, 2014
    • Come to meet our MySQL team at our booth in Amsterdam!
    • The schedule is not yet announced, please watch the DrupalCon website for news.

 APAC

If you are interested in meeting us in another area, visit our MySQL Community team Wikis with the full list of worldwide events we are supporting.

SIG - MySQL meeting in Berlin, Germany!

We are pleased to announce the SIG MySQL meeting taking place in Berlin, Germany next month! Come to hear news not only from the MySQL world but also on the other topics!

Event details:

Event Name: SIG MySQL

Date: March 27, 2014

Time: 9:30 - 17:30

Place: DOAG e.V. Geschäftsstelle Tempelhofer Weg 64 12347 Berlin  

Event URL & Agenda

We are looking to seeing you there! 

Monday Feb 24, 2014

Beginning on the MySQL Command Line

If you are starting out on the MySQL command line client, you might be interested in the following information.

When you use the MySQL command line client, it is often useful to log the commands you enter and the response you receive back from the MySQL server. The MySQL 'tee' command allows you to do this very simply and conveniently. Just enter 'tee' followed by the path to the file you want to log the session to (normally referred to as the 'tee' file). From that point on, all your session activity is logged to that file. To cancel tee file logging, just execute 'notee'.

To learn more about getting started on the MySQL Database, take the MySQL for Beginners training course. You can take this 4-day course through the following delivery methods:

  • Training-on-Demand: Start training within 24 hours of registration, following the course at your own pace.
  • 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

 Brussels, Belgium

 17 March 2014

 English

 Sao Paolo, Brazil

 5 May 2014

 Brazilian Portuguese

 Cairo, Egypt

 23 March 2014

 Arabic

 London, England

 24 March 2014

 English

 Turin, Italy

 12 May 2014

 Italian

 Nairobi, Kenya

 10 March 2014

 English

 Riga, Latvia

 26 May 2014

  Latvian 

Petaling Jaya, Malaysia 

12 May 2014 

 English

Mexico City, Mexico 

 21 April 2014

Spanish 

 San Pedro Garza Garcia, Mexico

 3 March 2014

 Spanish

  Utrecht, Netherlands

17 March 2014 

English 

 Lagos, Nigeria

14 April 2014 

 English

 Warsaw, Poland

31 March 2014 

 Polish

 Lisbon, Portugal

 14 April 2014

 European Portuguese

 Porto, Portugal

14 April 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.

Tuesday Feb 18, 2014

Zyme Relies on MySQL Enterprise Edition to Deliver High Quality Global Channel Insights to Customers

Zyme, based in Redwood Shores, California, is the global leading provider of Channel Data Management (CDM) solutions to companies selling through indirect channels. For high tech and consumer electronic products alone, over $1 trillion USD worth of goods are flowing through those indirect sales channels every year. However, when companies sell products through multi-tier channel partners and retailers around the world, it has proven to be challenging in acquiring global, standardized channel inventory and sales data cost-effectively. As a result, companies lacking of such critical information often miss the opportunities to make timely and accurate business decisions either to increase revenue, reduce costs or to prevent losses.

Having a vision to solve such channel visibility problems for customers including Symantec, Logitech, Seagate and Xerox, Zyme built its channel data management solutions that not only get reliable, high-quality channel data from thousands of partners worldwide, but also have the capability to integrate with customers’ existing on-premise or cloud CRM, Data Warehousing or Business Intelligence systems to bring such channel visibility and information to the field sales and marketing teams and drive better business results.

The Business Challenge 

Zyme was founded with a mission to improve channel visibility after witnessing the following issues:

  • Lack of a cost-effective infrastructure to capture channel activities globally
  • Lack of a global standard for channel data reporting, such as point-of-sales (POS) data
  • Poor partner compliance and low quality of data reporting 

To build a system that is capable of handling critical channel data across continents cost-effectively, Zyme was looking for a database to support its solution that automatically captures, validates, cleanses and synchronizes the channel data, which then provides a high-quality view of data that correctly reflects Zyme’s customers’ sales and inventory activities on a daily and weekly basis. In addition, the database has to support millions of transactions every day given the huge volume of channel data flowing into Zyme’s channel solution from all over the world.

The MySQL Solution 

Zyme selected MySQL since the launch of its products because it met all the following requirements Zyme needed for its mission-critical channel data solution:

  • ACID compliant
  • Ease of use and administration
  • Open source
  • Cost-effective support services backed by a well-recognized company  

Currently MySQL stores 2.5 Terabytes data, composed by 1 billion records Zyme collects from retailers and distributors across the globe. Deploying the master-slave replication topology, Zyme makes the master MySQL database in charge of receiving incoming data and processing over 50 million transactions per month, with two layers of slave databases handling reporting and backups respectively.  

To ensure the channel activities are captured consistently and correctly, one of the critical missions for Zyme’s DBA team is to minimize unplanned downtime and data corruption, and to restore the data to a previous time in the rare case that something goes wrong. The team had tried out various backup solutions, both commercial and open source ones; however those tools either provided merely file-level backup or required a lot of manual setup and configuration processes which made backup very difficult. Moreover, Zyme has a unique need of creating a lot of temporary tables, as many as 200 to 300 on top of its 600GB to 800GB database, and the other backup tools just couldn’t keep up with the volume of data Zyme needed to archive. MySQL Enterprise Backup, with its “point-in-time recovery” feature, allows Zyme to recover data to a previous time easily when an error happens, without taking the system down. Furthermore, MySQL Enterprise Backup provides many additional benefits to Zyme, including: 

  • One single utility for both backup and recovery
  • Easy-to-find, easy-to-configure backup options
  • Adjustable read, write and compression speeds for better flexibility
  • Easy automation for backup processes
  • Easy-to-access backup data which is stored right in the database – no need for a separate repository
  • Incremental backup for InnoDB tables to save disk space
  • Backward compatibility – using InnoDB Plug-in, the complete backup and recovery features can be used by databases still on MySQL 5.1

Zyme also takes advantage of the audit functionality in MySQL Enterprise Audit to audit users who log into the system. The DBA team is currently in the process of upgrading production servers from MySQL 5.1 to MySQL 5.5 so the audit plug-in, supported in MySQL 5.5.28 and above, can be used more broadly to improve overall database security. In the next phase, the production servers will be upgraded again to MySQL 5.6, the most current GA version of MySQL, to fully leverage the latest features and further enhance the performance, security and reliability of Zyme’s MySQL databases.

“As a DBA, it’s my job to always make sure we have a consistent backup, a good monitoring solution, plus an audit tool to maintain data integrity, performance and security, and that’s why I strongly advocate MySQL Enterprise Edition, where I can find all the features I need in one place, to support the MySQL environment at Zyme”. Prasad Gowda, Associate Director - DBA, Zyme

MySQL Enterprise Backup is a powerful, yet very easy-to-use tool. It offers one utility for both backup and recovery, layouts the options that are easy to find, understand and configure, and provides great flexibility with backup customizations. It’s as easy as using a cookie-cutter: just setting the parameters, pointing to the instances, taking the snapshots, and we got the backup done. More importantly, we achieved much better results with MySQL Enterprise Backup, using less than 10 percent of the time we used to spend just researching other backup tools in the market. It has become an indispensable tool for the DBA team at Zyme”. Prasad Gowda, Associate Director - DBA, Zyme

Learn More about Zyme: http://www.zymesolutions.com/ 
Read more MySQL customer stories: http://www.mysql.com/customers/ 

Monday Feb 17, 2014

MySQL Connectors, a Real Plus for Developers

MySQL Connectors provide connectivity to the MySQL server for client programs. APIs provide low-level access to the MySQL protocol and MySQL resources. Both Connectors and the APIs enable you to connect and execute MySQL statements from another language or environment. Oracle provides a number of these, enabling developers to build database applications in the language of their choice. Among those developed by Oracle are drivers for JDBC and ODBC. Any system that works with JDBC or ODBC can use MySQL. And you can find many more, including drivers for PHP, Perl, Python, Ruby, Tcl and even Eiffel!

To get a head start on developing with MySQL, take the MySQL for Developers training course. This 5-day training course, created with the MySQL experts, is available as a:

  • Live-Virtual Event: Take this course from your own desk - no travel required. You can choose from a selection of events on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to take this course. Below is a selection of the events already on the schedule.

 Location

 Date

 Delivery Language

 Brussels, Belgium

 12 May 2014

 English

 Sao Paolo, Brazil

 12 May 2014

 Brazilian Portuguese

 Milan, Italy

 7 April 2014

 Italian

 Rome, Italy

 10 March 2014

 Italian

 Petaling Jaya, Malaysia

 21 April 2014

 English

 Utrecht, Netherlands

 12 May 2014

 English

 Makati City, Philippines

 17 March 2014

 English

 Lisbon, Portugal

 26 May 2014

 European Portuguese

 Porto, Portugal

 26 May 2014

 European Portuguese

 Singapore

 17 February 2014

 English

 Madrid, Spain

 17 March 2014

 Spanish

 Valencia, Spain

 21 April 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.

Prove your MySQL Developer skills by taking the MySQL 5.6 Developers certification exam which is well aligned with the MySQL for Developers training course.

Tuesday Feb 11, 2014

Hot Off The Press: MySQL February Newsletter

The MySQL February Newsletter is available! Find out the latest news on MySQL products and MySQL Connect 2014, and read the technical tips written by MySQL experts at Oracle and in the community. Below are the highlights in this edition:

  • Start Preparing for MySQL Connect 2014 Call for Papers
  • New GA Release: MySQL for Visual Studio
  • Blog: State of the UNION
  • Blog: New MySQL Web Installer -- Have You Tried It Yet?
  • Blog: MySQL Workbench: Frequent Crashes on Mac OS X? This Might Be The Fix
  • Event: MySQL Seminars Are Coming to a City Near You

You can read it online or subscribe to it to receive the latest updates right in your inbox. Watch this tutorial to see step-by-step instructions for newsletter subscription.

Enjoy!

Monday Feb 10, 2014

MySQL Cluster is a Resilient and Scalable Database Platform

MySQL Cluster is a highly resilient and scalable database platform designed to deliver 99.999% availability with features such as self-healing and online operations, and capable of performing over 1,00,000,000 updates per minute. The full feature set includes development and management platforms alongside monitoring and administration tools, all backed by Oracle Premier Lifetime Support.

To learn more about MySQL Cluster, consider taking the MySQL Cluster training. Events already on the schedule for this 3-day instructor-led course include:

 Location

 Date

 Delivery Language

 Berlin, Germany

 26 May 2014

 German

 Munich, Germany

 14 April 2014

 German

  Rome, Italy

 17 February 2014

 Italian

 Petaling Jaya, Malaysia

 16 July 2014

 English

 Warsaw, Poland

 12 March 2014

 Polish

 San Francisco, CA, United States

 28 May 2014

 English

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

Monday Feb 03, 2014

How Important is the Performance of Your Database

Whether you are a database administrator, database application developer, web developer, system administrator or system architect, if you are working with a database system such as the MySQL Server, you will want to ensure the best possible performance. 

To learn about the great performance you can get from a MySQL Database, visit Dimitri's blog.

If you have experience maintaining a database server, can use MySQL tools and have knowledge of general SQL statements and SQL tuning principles, consider taking the MySQL Performance Tuning course. In this 4-day instructor-led course, you will learn about:

  • What to tune and why
  • Monitoring, benchmarking and stress tools
  • Problem and pitfall identification
  • Evaluating and improving performance
  • Improving query cache results
  • InnoDB's role in MySQL performance
  • Designing for performance
  • MySQL Optimizer
  • Performance impact of choices in hardware, OS, logging and backup

You can take this course through the following three delivery methods:

  • Training-on-Demand: Train at your own pace, starting within 24 hours of registration with streaming-video of classroom delivery and full access to lab environments.
  • Live-Virtual Events: Follow 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 course. Below is a selection of the events already on the schedule.

Location Date Delivery Language
 Brussels, Belgium
 10 June 2014
 English
 London, England
 14 April 2014
 English
 Rome, Italy
 1 April 2014
 Italian
 Tokyo, Japan
 17 March 2014
 Japanese
 Riga Latvia
 29 September 2014
 Latvian
 Petaling Jaya, Malaysia
 5 May 2014
 English
 Utrecht, Netherlands
 10 June 2014
 English
Warsaw, Poland
24 February 2014
 Polish
 Barcelona, Spain
 3 March 2014
 Spanish
 Istanbul, Turkey
 3 March 2014
 Turkish
To learn more about this course, register for an event, 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 2014 »
SunMonTueWedThuFriSat
      
1
2
4
5
6
7
8
9
12
13
14
15
16
19
20
21
22
23
25
26
28
 
       
Today