Saturday May 23, 2015

20 Years of MySQL with 20% Discount on Training-Certification Packages

MySQL's first release was 20 years ago. And now the most popular open source database is used by a huge number of individuals and companies across the globe.

Join us in celebrating 20 years of MySQL.

If you are a MySQL expert, you might want to prove your knowledge through a MySQL certification.

Those who want to improve and prove their MySQL knowledge could take advantage of the Discount Value Packages, getting 20% off the price of a live-virtual class plus a certification.

Oracle's certifications are a recognized proof of your knowledge and the MySQL certifications are at expert level. Therefore, to pass one of these certification exams, you must do significant preparation.

The MySQL certifications have been created by MySQL engineers and technical consultants with 10 or more years of experience working with MySQL users. So by taking an Oracle MySQL certification, you are measuring yourself against a serious bank of MySQL knowledge.

Here are some steps when preparing to take a MySQL certification:

  1. Go to the web page for the certification you are preparing for: Oracle Certified Professional MySQL 5.6 Database Administrator or Oracle Certified Professional MySQL 5.6 Developer.
  2. Click on the Exam Topics tab to see what subjects will be covered in the exam and do a self-assessment to determine your knowledge gaps. These are the areas you need to concentrate on during your preparation.
  3. Click on the Exam Preparation tab. You will see the recommended training and additional resources such as the MySQL Reference Manual.
  4. In addition to the Recommended Training course(s), your exam preparation plan must include significant hands-on practice or on-the-job experience performing the tasks described on the Exam Topics tab. Oracle University courses may not cover all exam topics and an integrated exam preparation approach is recommended.

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

Monday May 18, 2015

Stored Routines in MySQL for Security, Performance and More

A large number of database administrators are tasked with supporting stored routines even if they do not actually have to create stored routines. Understand the role of stored routines in centralized client functionality, security, performance and function libraries by taking the MySQL for Database Administrators training course

You can take the MySQL for Database Administrators course in the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture materials at your own pace through streaming video and booking time on a lab environment when suits 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 including 22 June and 21 September 2015 in Traditional Chinese, 8 June, 13 July, 27 July, 17 August, 21 September, and 12 October 2015 in English and 5 October 2015 in French.
  • In-Class Event: Travel to an education center to attend an event. Below is a selection of the events already on the schedule.

AUSTRALIA

 Location  Date  Delivery Language
 Brisbane, Australia  6 July 2015  English
 Melbourne, Australia  18 May 2015  English

AFRICA

 Location  Date  Delivery Language
 Nairobi, Kenya  28 September 2015  English
 Pretoria, South Africa  17 August 2015  English

AMERICAS

 Location  Date  Delivery Language
 Sao Paulo, Brazil  20 July 2015  Brazilian Portuguese
 Bogota, Columbia  7 September 2015  Spanish
 Mexico City, Mexico  8 June 2015  Spanish
 San Pedro Garza Garcia, Mexico  8 June 2015  Spanish
 Roseville, MN, United States  15 June 2015  English
 Columbus, OH, United States  22 June 2015  English
ASIA

 Location  Date  Delivery Language
 Shanghai, China
 6 July 2015  Simplified Chinese
 Bangalore, India
 8 June 2015  English
 Causeway Bay, Hong Kong
 27 July 2015  English
 Jakarta, Indonesia
 15 June 2015  English
 Seoul, Korea
 15 June 2015  Korean
 Darul Ehsan, Malaysia
 21 September 2015  English
 Kuala Lumpur, Malaysia
 17 August 2015  English
 Petaling Jaya, Malaysia
 29 July 2015  English
 Pulau Pinang, Malaysia
 17 August 2015  English
 Pasig City, Philippines
 8 June 2015  English
 Taipei, Taiwan
 22 June 2015  Traditional Chinese
 Bangkok, Thailand
 15 June 2015  English

EUROPE

 Location  Date  Delivery Language
Ballerup, Denmark
8 June 2015 English
London, England
8 June 2015 English
Espoo, Finland
8 June 2015 English
Dublin, Ireland
12 October 2015 English
Tel Aviv, Israel
14 June 2015 English
Milan, Italy
15 June 2015 Italian
Rome, Italy
5 October 2015 Italian
Utrecht, Netherlands
15 June 2015 English
Warsaw, Poland
7 September 2015 Polish
Edinburgh, Scotland
26 October 2015 English
Madrid, Spain
27 July 2015 Spanish
Kista, Sweden
8 June 2015 English
Basel, Switzerland
5 October 2015 German
Bern, Switzerland
5 October 2015 German
Zurich, Switzerland
5 October 2015 German
Istanbul, Turkey
19 October 2015 Turkish
The MySQL for Database Administrators training course is the recommended training for those preparing to sit the MySQL 5.6 Database Administrator OCP certification exam.

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

Tuesday May 12, 2015

MySQL User Group Meeting Azerbaijan

We are pleased to invite everyone who is interested and around to the MySQL User Group Azerbaijan KickOff meeting. Please find more details below & at the link of MUG Facebook group:

  • Date: May 14, 2015
  • Place: Baku city, Murtuza Muxtarov str. 179/71  
  • Time: 7:00-9:30 pm
  • Proposed Agenda:
    • MySQL as open source project
    • Helping community improving project by
      • Sending Feature requests
      • Finding bugs, reporting bugs
More information & registration could be found here.

 

Monday May 11, 2015

Starting and Stopping a Cluster with MySQL Cluster Manager

MySQL Cluster Manager makes ti easy to start and stop an entire cluster. You can reconfigure all data nodes in the cluster with a single command that not only changes the setting but also restarts each node in turn without bringing down the cluster.

To learn more about MySQL Cluster and MySQL Cluster Manager take the MySQL Cluster training course. You can take this 4-day instructor-led course as a:

  • 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. Events on the schedule include 23 and 30 June, 11 August, 29 September, 13 October 2015.
  • In-Class Event: Travel to an education center to attend an event. Events already on the schedule include:

 Location  Date  Delivery Language
Sao Paulo, Brazil 8 June 2015 Brazilian Portuguese
Jakarta, Indonesia 29 June 2015 English
Mexico City, Mexico 15 June 2015 Spanish
Singapore 11 August 2015 English
Bangkok, Thailand 12 October 2015 English
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Thursday May 07, 2015

Successful MySQL Tech Tour in Rome

Oracle’s MySQL team held a very successful Tech Tour in Rome last week. The event was arranged jointly with our partner Par-Tec, who recently completed its MySQL specialization in the Oracle partner program.

This is the third Tech Tour we held in Rome during the past year or so and the events keep growing in popularity! Over 120 attendees joined us last week and could learn about:

Additionally, Par-Tec ran a hands-on "MySQL Cluster in action" session where attendees got the chance to better understand how to benefit from real-time in-memory performance and 99.999% availability with MySQL Cluster. They also learned about the new features available in MySQL Cluster 7.4.

Thank you all for joining us at the event, and thank you to our partner par-tec for their support.

We will continue to organize MySQL Tech Tours worldwide and look forward to meeting you there! Check out the MySQL Events page regularly for upcoming events.

Friday May 01, 2015

Oracle Enterprise Manager for MySQL v2 Is Now Available!


[Read More]

Monday Apr 27, 2015

Importing and Backing Up with mysqldump

The mysqldump utility lets you 'dump' table contents to text, either for backup purposes or for importing into other databases. mysqldump supports two types of database backup

  • Physical backup which preserves only the data, typically in comma separated (CSV) or other delimited text files but also in XML format.
  • Logical backup which contains SQL statements that can reproduce table structure, table data or both

To learn about importing and exporting data as well as other key topics for getting started on a MySQL database, take the MySQL for Beginners training course.

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

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material through streaming video and booking access to perform hands on exercises when suits 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; 24 May, 1 June, 2 June, 4 August and 20 October 2015 in English and 15 September and 15 December 2015 in German.
  • In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.

 Location  Date  Delivery Language
Brussels, Belgium
18 May 2015 English
Sao Paolo, Brazil
6 July 2015 Brazilian Portuguese
London, England
1 September 2015 English
Berlin, Germany
27 April 2015 German
Hamburg, Germany
21 September 2015 German
Munich, Germany
27 July 2015 German
Jakarta, Indonesia
1 June 2015 English
Rome, Italy
14 September 2015 Italian
Turin, Italy
8 June 2015 Italian
Darul Eshan, Malaysia
10 August 2015 English
Kuala Lumpur, Malaysia
8 June 2015 English
Petaling Jaya, Malaysia
5 May 2015 English
Pulau Pinang, Malaysia
2 June 2015 English
Mexico City, Mexico
25 May 2015 Spanish
Utrecht, Netherlands
18 May 2015 English
Lisbon, Portugal
21 September 2015 European Portuguese
Capetown, South Africa
11 August 2015 English
Johannesburg, South Africa
11 August 2015 English
Pretoria, South Africa
27 July 2015 English
Madrid, Spain
6 July 2015 Spanish
Bangkok, Thailand 8 June 2015 English
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Friday Apr 24, 2015

Events and conferences where you can find MySQL - May-December 2015

Please find a list of conferences & events where you can find MySQL Community team or our experts talking about MySQL. We are looking forward to meeting to you!

  • May 2015:
    • OpenSUSE, Den Haag, Netherlands, (May 1-4, 2015)
      • Speaker: Georgi Kodinov on "Secure Deployment Changes Coming in MySQL 5.7”
      • Find us at our MySQL booth!
    • OpenWest Conference, Salt Lake City, US (May 7-9, 2015)
    • PHP Unconference, Island of Majorka (May 9-10, 2015)
      • as tradition we are part of this UnConference. 
    • PHP Tour Luxembourg, Abbaye de Neumunster, Luxembourg (June 12-13, 2015)
      • Talk secured by Carsten Thalheimer on the “One last thing about Open Source Databases - The upcoming MySQL 5.7” on June 12 @ 13:30-14:15
    • DrupalCon, Los Angeles, US (May 11-15, 2015)
      • Find our Community staff at MySQL booth!
    • PHP[Tek] 2015, Chicago, US (May 18-22, 2015)
      • Speaker: David Stokes, MySQL Community Manager on “MySQL Replication for Beginners", May 22 @9-10am
    • Linux Solutions & Libres, Paris, France (Date TBD) 
      • the event will be moved to October 2015 and probably joined with Open World Forum.
    • !Joomla JBeyond Developer Conference, Prague Czech Republic, (May 29-31, 2015)
      • Speaker: Andreea Ciobotaru on “MySQL High Availability”, May 29 @4pm
      • Come to vist MySQL booth in expo area!
  • June 2015:
    • db tech showcase, Tokyo, Japan (June 10-12, 2015)
      • We are going to have a talk on MySQL topic. Please watch the conference website for further updates.
    • OpenSource Conference, Hokkaido, Japan, (June 12-13, 2015)
      • We are having a MySQL session at this show. Please watch the conference website for further updates.
    • SouthEast Linux Fest, Charlotte, NC, US (June 12-14, 2015)
      • Please find our staff at MySQL / Oracle booth!
    • PyCon Singapore, Singapore, (June 17-19, 2015)
      • Find us at our MySQL booth!
    • Dutch PHP, Amsterdam, Holland (June 25-26, 2015)
      • Speaker: David Stokes, the MySQL Community Manager on “MySQL 5.7 New Features” on June 25@13:45-17:00
      • Find us at our MySQL booth!
    • OpenSource HK, Hong Kong (June 26-27, 2015)
      • Find us at our MySQL booth!
      • Speakers: 
        • Ryusuke Kajiyama on “State of The Dolphin 2015 - MySQL Technical update, MySQL 5.7 and beyond” (time/date: tbd)
        • Ivan Ma on "Demystifying MySQL for Oracle DBAs and Developers” (time/date: tbd)
        • more will be coming
  • July 2015:
    • OpenSource Conference, Okinawa, Japan (July 4, 2015)
      • Find us at our MySQL booth!
      • Talks - tbd. Please watch conference website for further updates.
  • August 2015: 
    • Mountain Moodle Moot, Minneapolis, MN, US (August 4-6, 2015)
      • Find us at our MySQL booth!
    • COSCUP, Taipei, Taiwan (August 15-16, 2015)
      • Find us at our MySQL booth!
    • Debian Conference, Heidelberg, Germany (August 15-22, 2015)
      • Find us at our MySQL booth!
      • For the approved MySQL talks, please watch the conference website.
    • Texas Linux Fest, San Marcos, TX, US (August 21-22, 2015)
      • Find us at our MySQL booth!
    • Froscon 2015, St.Augustin, Germany (August 22-23, 2015)
      • Find us at our MySQL booth! 
      • For the approved MySQL talks, please watch the conference website.
  • September 2015:
    • Pacific Northwest PHP, Seattle, WA, US (September 11-12, 2015)
    • WebExpo, Prague, Czech Republic (September 19-20, 2015)
      • Find us at our MySQL booth!
      • Speaker: Morgan Tocker, the MySQL Community Manager on MySQL 5.7 + JSON (Intermediate) - date, time - tbd
    • Live 360, NY, US (September 28-October 1, 2015)
  • October 2015:
  • November 2015:
    • All Your Base 2015, London, UK (November 13, 2015)
      • Find us at our MySQL booth!
    • Live 360, Orlando, US (November 16-20, 2015)
    • DOAG, Nuremberg, Germany (November 17-20, 2015)
      • Find us at Oracle booth!
  • December 2015:
    • JCConf, Taipei, Taiwan (December 4-5, 2015)
    • Tech15 UKOUG, Birmingham, UK (December 7-10, 2015)
      • Find us at Oracle booth!

Monday Apr 20, 2015

MySQL April Newsletter is Published!

The MySQL April Newsletter is posted, again bringing the latest news and technical tips and tricks to the MySQL users. In this edition, you'll read what's new in the recently-announced MySQL 5.7 Release Candidate, as well as upcoming activities such as MySQL webinars and events. Below are the highlights:

  • News: Announcing MySQL 5.7 Release Candidate
  • MySQL Central @ OpenWorld 2015 Call for Papers Open Until April 29
  • Webcast: What's New in MySQL Security on April 23
  • Webcast: MySQL Performance Tuning 101 on May 27
  • Blog: JSON Labs Release -- Effective Functional Indexes in InnoDB

You can read it online or subscribe to it to receive the latest updates right in your inbox. If you haven't subscribed to this informative newsletter, watch this short tutorial to learn how, or just go to your oracle.com SSO profile and find MySQL under "Technology" in the Subscriptions tab.

Hope you enjoy the technical resources in the MySQL newsletter!

What a MySQL Developer Needs to Know

To perfect your skills as a MySQL developer, consider taking the MySQL for Developers training course. In this 5-day course, you learn to:

  • Describe the MySQL client/server architecture
  • Use MySQL client programs and common options
  • Program MySQL applications with Java and PHP connectors
  • Use a 'NoSQL' approach to store and retrieve data
  • Design efficient tables
  • Create and delete database objects
  • Use expressions in SQL statements
  • Examine database metadata
  • Use SQL statements to modify table data
  • Maintain database integrity with transactions
  • Write multiple table queries
  • Create 'virtual tables' containing specific data
  • Create user-defined variables, prepared statements, and stored routines
  • Create and manage triggers
  • Identify and deal with errors and exceptions in client programs
  • Write queries that are fast and effective, even under heavy loads

You can take this course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registration following lecture material at your own pace through streaming video and booking time to get hands-on experience at a time that suits you.
  • 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 including 11 May, 25 May, 13 July and 19 October 2015 in English, 25 May 2015 in Traditional Chinese, and 19 October 2015 in German.
  • 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
Sao Paulo, Brazil
13 July 2015 Brazilian Portuguese
 Brussels, Belgium
18 May 2015 English
London, England
7 September 2015 English
Munich, Germany
18 May 2015 German
Jakarta, Indonesia  22 June 2015 English
Kuala Lumpur, Malaysia
20 July 2015 English
Petaling Jaya, Malaysia
30 April 2015 English
San Pedro Garza Garcia, Mexico
25 May 2015 Spanish
Utrecht, Netherlands 18 May 2015 English
Makati City, Philippines
25 May 2015 English
Pasig City, Philippines
15 June 2015 English
Lisbon, Portugal
19 October 2015 European Portuguese
Cape Town, South Africa
25 May 2015 English
Johannesburg, South Africa
13 July 2015 English
Madrid, Spain
8 June 2015 Spanish
Valencia, Spain
22 June 2015 Spanish
Taipei, Taiwan
22 June 2015 Simplified Chinese
Bangkok, Thailand 6 July 2015 English

The MySQL for Developers training course is the recommended training for those preparing to sit the MySQL 5.6 Developer OCP certification exam.

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

Wednesday Apr 15, 2015

On Choosing Mature Technologies

Two recent blogs from engineering managers at successful Web properties have highlighted the wisdom of selecting proven and mature technologies, whether for new startups or projects.

The first one is entitled "Learn to stop using shiny new things and love MySQL", by Marty Weiner, Engineering Manager at Pinterest. Marty starts off explaining "A good portion of the startups I meet and advise want to use the newest, hottest technology to build something that’s cool, but not technologically groundbreaking. I have yet to meet a startup building a time machine, teleporter or quantum social network that would actually require some amazing new tech. They have awesome new ideas with down-to-earth technical requirements, so I kept wondering why they choose this shiny (and risky) new stuff when all they need is a good ol’ trustworthy database. I think it’s because many assume that building the latest and greatest needs the latest and greatest!"

Marty outlines two of the most important lessons he learned building Pinterest:

  • "Don’t be the biggest. If you’re the biggest user of a technology, your challenges will be greatly amplified.
  • Keep it simple. No matter what technology you’re using, it will fail."

At some point the team re-architected the site both to simplify the architecture and ensure scalability. They built a set of questions to help guide their choice of technologies, the last one being "How mature is the technology?" Marty then spends more time expressing how important maturity is:

"The harder and more passionately people push on a technology, the faster they will run across bugs or performance problems, fix them and hopefully contribute fixes back for the whole community to use...

...As a technology hardens, collaboration occurs, understanding gets deeper and a wealth of knowledge is built out. As the technology itself gets more stable and beautiful, documentation and simplification occur and the frontiers and boundaries are tested and widened.

You don’t want to be on the wrong end of the maturity equation. There’ll be dragons there:

  • Hiring will be more difficult: Try searching on Google for MySQL admin and Cassandra admin. Try walking out into a busy San Francisco walkway and yell out that you need a MySQL admin. You’ll find one. Hbase, unlikely.
  • You’ll find minimal community: It’s 2 a.m. and you’re getting a weird error message “48fe1a is opaque” (an actual error message I got from Membase). What the f!*k does that mean? Crap, there are there no answers anywhere on Google. Conversely, I can’t remember the last time a MySQL question I had wasn’t already answered along with somebody calling the questioner a nOObXor.
  • You’re more likely to fail, possibly catastrophically: We had an unexpected loss of data on nearly every technology we used at one time or another, except MySQL. Even on the worst days, when the hard drive crashed, we still managed to find a script somebody wrote to do magic voodoo to get our MySQL data out again and live another day. Other technologies left us dead in our tracks because nobody had encountered the same problems, or they hadn’t taken the effort to dive deep to recover their data or they hadn’t contributed the fix back to the community. Incidentally, I’m super thankful we never trusted the golden copy of our data to any other system except MySQL in those early days.

...If you’re on the frontier, you’ll hit new bugs and issues that the rest of the world has never seen. They'll be 10x harder to debug and will likely require a depth of knowledge that goes outside the comfort zone of your current engineers. You’ll have to dig in, push hard and learn fast. I send you my virtual hugs and admiration. I’ve been there. It will be tough. Blog what you find, collaborate and communicate.

If you’re starting or growing a company, and your scale is smaller than huge, consider maturity to be your most important factor aside from basic requirements. Ask yourself — does MySQL sufficiently meet my needs? If so, use it. If you’re wondering if MySQL will be fast enough, the answer is YES. Even better than fast, MySQL’s performance will be consistent."

Read Marty’s full blog here.

The second blog is by Dan McKinley, sharing some of the experience he acquired during over 6 years at Etsy and entitled "Choose Boring Technology". Dan advocates to "embrace boredom":

"The nice thing about boringness (so constrained) is that the capabilities of these things are well understood. But more importantly, their failure modes are well understood...

...I unapologetically think a bias in favor of boring technology is a good thing, but it's not the only factor that needs to be considered. Technology choices don't happen in isolation. They have a scope that touches your entire team, organization, and the system that emerges from the sum total of your choices.

...One of the most worthwhile exercises I recommend here is to consider how you would solve your immediate problem without adding anything new. First, posing this question should detect the situation where the "problem" is that someone really wants to use the technology. If that is the case, you should immediately abort."

Read the entire blog here.


2015 marks MySQL’s 20 years anniversary (as well as 10 years of Oracle’s stewardship for the InnoDB storage engine and 5 years for MySQL). The world’s most popular open source database is a proven, battle-tested and mature technology. Perhaps boring to some (which you should embrace!) but delivering tremendous benefits to help you scale, safely and cost-effectively. So quoting Marty, love MySQL!


Thanks to both Marty and Dan for their insightful blogs.


Monday Apr 13, 2015

MYSQL User Group Meeting Korea

We are pleased to announce and invite your to the next Korean MySQL User Group meeting on April 15, 2015. Please find more details below:

  • Date: April 15, 2015
  • Time: 7-9 pm
  • Venue: Oracle Korea HQ, ASEM Tower, 159-1 Samsung-Dong, Kangnam-Gu Seoul, Korea
  • Office phone: 82-2-2194-8000
  • Proposed agenda:
    • MySQL 5.7 Updates include Enterprise Firewall, JSON  - Kajiyama Ryusuke , APAC MySQL SC Manager 
    • MySQL Cluster 7..4 Updates  -  Jongse Park, Rockplace Engineer Manager
    • MySQL with TokuDB engine Case Study - Soohyun Park, CDNetworks, DB Manager 
    • Recruiting MUG Staff for 2015 

More information and registration could be found here.

Is The Performance of Your MySQL Database Important?

How important is the performance of your MySQL database? If you want to learn more about tuning the performance of MySQL servers, consider taking the MySQL Performance Tuning training course. In this course you learn to:

  • Understand performance tuning concepts
  • Benchmark your MySQL server
  • Tune MySQL server settings
  • Investigate performance metrics with a range of system databases, command-line and graphic tools
  • Design your database for optimal performance
  • Optimize slow queries
  • Troubleshoot common performance problems
  • Scale your hardware and application environment as your database grows

You can take the MySQL Performance Tuning course in the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material at your own pace through streaming video and getting hands-on experience at a time that suits your schedule.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events on schedule to suit different timezones including 19 May, 23 June, and 11 August 2015 in English,  2 November 2015 in German, and 27 April 2015 in Spanish.
  • In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.
 Location  Date  Delivery Language
 Sao Paulo, Brazil
 25 May 2015  Brazilian Portuguese
 Hvidovre, Denmark
 15 June 2015  English
 Espoo, Finland
 15 June 2015  English
 Causeway Bay, Hong Kong   27 April 2015  English
 Jakarta, Indonesia
 27 April 2015  English
 Utrecht, Netherlands
 19 May 2015  English
 Pasig City, Philippines
 27 April 2015  English
 Kista, Sweden
 20 April 2015  English
 Taipei, Taiwan
 4 May 2015  Traditional Chinese
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Apr 06, 2015

Improve Performance of a MySQL Database with Partitioning

You can improve the performance of a MySQL Database by using partitioning, that is assigning specific table rows into subsets of rows. Partitioning can help in many different situations including improving the efficiency of large tables by:

  • Breaking data into smaller groups for more efficient queries
  • Adhering to file-system file size limits
  • Speeding up runtimes for maintenance and deleting rows

To learn much more about partitioning and other key topics, take the very popular MySQL for Database Administrators training course.

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

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material through streaming video and booking time on a lab environment to get hands-on experience at your own convenience
  • 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 time zones including the 5th October 2015 for delivery in French and the 4th, 11th, and 18th May, 8th June, 13th July, 17th August, and 21th September 2015 in English.
  • In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.

AFRICA

 Location  Date  Delivery Language
Capetown, South Africa 11 May 2015 English
Pretoria, South Africa 17 August 2015 English

AMERICAS

 Location  Date  Delivery Language
Sao Paulo, Brazil
13 April 2015 Brazilian Portuguese
Mexico City, Mexico
22 June 2015 Spanish
San Pedro Garza Garcia, Mexico
20 April 2015 Spanish
Lima, Peru 13 April 2015 Spanish
Roseville, MN, United States 15 June 2015 English
Saint Charles, MO, United States 11 May 2015 English
Columbus, OH, United States 22 June 2015 English

ASIA

 Location  Date  Delivery Language
Shanghai, China
6 July 2015 Simplified Chinese
Causeway Bay, Hong Kong
11 May 2015 English
Bangalore, India
18 May 2015 English
Seoul, Korea
6 April 2015 Korean
Kuala Lumpur, Malaysia
17 August 2015 English
Petaling Jaya, Malaysia
11 May 2015 English
Pulau Pinang, Malaysia
17 August 2015 English
Pasig City, Philippines
8 June 2015 English
Singapore
6 April 2015 English
Bangkok, Thailand
15 June 2015 English
AUSTRALIA

 Location  Date  Delivery Language
Brisbane, Australia 27 April 2015 English
Melbourne, Australia 18 May 2015 English

EUROPE

 Location  Date Delivery Language
Brussels, Belgium
4 May 2015 English
Hvidovre, Denmark 8 June 2015 English
London, England
13 April 2015 English
Espoo, Finland
8 June 2015 English
Dublin, Ireland
25 May 2015 English
Milan, Italy
15 June 2015 Italian
Rome, Italy
15 June 2015 Italian
Utrecht, Netherlands
4 May 2015 English
Oslo, Norway
4 May 2015
English
Edinburgh, Scotland
25 October 2015
English
Glasgow, Scotland
11 May 2015 English
Madrid, Spain
18 May 2015 Spanish
Kista, Sweden 8 June 2015 English
Basel, Switzerland 4 May 2015 German
Bern, Switzerland 4 May 2015 German
Zurich, Switzerland 4 May 2015 German
Istanbul, Turkey 20 May 2015 Turkish
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

The MySQL for Database Administrators course is the recommended training for those preparing to take the MySQL 5.6 Database Administration OCP certification exam.

Thursday Apr 02, 2015

MySQL User Group Meeting Hyderabad, India, April 10, 2015

We would like to inform you about upcoming MySQL User Group Meetup, Hyderabad on April 10, 2015.

There will be two sessions around MySQL New Features and MySQL Replication, to be presented by MySQL Consultants at Oracle followed by open networking session and snacks!

Details:

  • Day: April 10, 2015 
  • Time: 2:30 pm – 5:30 pm 
  • Place: Oracle India Pvt Ltd, Conf room: 3D007, Cyber Park, Salarpuria, Plot No : 67 Hitech city, Madhapur, Hyderabad – 500081 
  • Tel: 040- 67244474 (Oracle reception) 
  • Meetup Page

So explore this opportunity to get more knowledge about MySQL and increase your network with other MySQLers.

For registration please send an email to mysql.india.ug@gmail.com (so we can arrange enough snacks :)) 

About

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

Twitter


Facebook

Search

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