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.

Monday Mar 30, 2015

A Single Command to Backup MySQL Cluster Data

The MySQL Cluster training course is packed full of useful information, hints, tips and hands-on practices. For example, did you know that you can back up the entire cluster's data on all data nodes by issuing a single START BACKUP command on the management node.

You can take the 4-day instructor-led MySQL Cluster 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 timezones including 27 April, 5 May, 26 May, and 30 June 2015 delivered in English and 22 April 2015 delivered in Traditional Chinese.
  • 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
26 May 2015 English
Sao Paulo, Brazil
22 April 2015 Brazilian Portuguese
London, England
13 April 2015 English
Seoul, Korea
27 April 2015 Korean
Utrecht, Netherlands 26 May 2015 English
Singapore 27 April 2015 English
Madrid, Spain 7 April 2015 Spanish
Bangkok, Thailand 12 October 2015 English

 

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

Thursday Mar 26, 2015

The MySQL Central @ OpenWorld 2015 Call for Papers is Open!

Part of Oracle OpenWorld 2015, MySQL Central @ OpenWorld will be held in San Francisco, October 25–29, 2015.
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA8cAAADuCAYAAAAURHU5AAAACXBIWXMAAC4jAAAuIwF4pT92AAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAANBZJREFUeNrs3c9x20jax/H21NypPfpETgTiRCA4AnGq9uTDio7AnAC2TNcGYDoC03vwaauGisBQBENFMNTJx1eKwG8/5MMxDAPoBtAgQOD7qULJlvgH/9E/dKP72devXw0AAAAAAEP2E6sAAAAAAEA4BgAAAACAcAwAAAAAAOEYAAAAAADCMQAAAAAAhGMAAAAAAAjHAAAAAAAQjgEAAAAAIBwDAAAAAEA4BgAAAACAcAwAAAAAAOEYAAAAAADCMQAAAAAAhGMAAAAAAAjHAAAAAAAQjgEAAAAAIBwDAAAAAEA4BgAAAACAcAwAAAAAAOEYAAAAAADCMQAAAAAAhGMAAAAAAAjHAAAAAAAQjgEAAAAAIBwDAAAAAEA4BgAAAACAcAwAAAAAAOEYAAAAAADCMQAAAAAAhGMAAAAAAAjHAAAAAAAQjgEAAAAAIBwDAAAAAEA4BgAAAACAcAwAAAAAAOEYAAAAAADCMQAAAAAAhGMAAAAAAAjHAAAAAAAQjgEAAAAAIBwDAAAAAEA4BgAAAACAcAwAAAAAAOEYAAAAAADCMQAAAAAAhGMAAAAAAAjHAAAAAAAQjgEAAAAAIBwDAAAAANA3P7MKMFT//M9/J/bHJPm7//37XzFrBgAAABieZ1+/fmUtYGih+ML+2NjpKucld/r3jQ3LO9YYAAAAQDgG+hiMJfCOPN9ya6cVNcoAAABAv/HMMYZmVSIYi2s7fbahOrbTlNUHAAAAEI6BPpgl/n1vp9/s9EJ/vtffZZEm2H/agLxkFQIAAAD9Q7NqDIoNt8kd/vf//ftfq4zXTOyPhZ3mJruWWQL0jOeRAQAAAMIx0Idw/N4G3EXBa+X55KWdXmf8+clOazvFdno8/pJnkwEAAADCMXAO4Xhrf1zqfx9smJ14vGeqQfjS82skOG81OG/td2xY8wAAAADhGOhSOJ7bHx8Sv3prw+vS873yujcVvlbCsgTkNTXLAAAAAOEY6EpA3tkf48SvfrWhdev53qkG3XHFr5cxlJeEZAAAAIBwDLQdjiP743PiV1KzO7GB9bHEZ0hIvkj9Wj53oj9d4VlC8sI3lAMAAAAgHANNBGTpiOtd4lf3NqhOA36+hGQZNmpuip9V/qgh+ZGtAgAAABCOgTYC8tr+uEn8qrD36hrfI6F7kfquJKm5XmYNKwUAAACAcAycIiAne68Wr2xIXTf0XRNzGBoqLyRLU+s54ycDAAAAhGPg1OFYnhuWMDrSX0kt7rTJgKrPPK9MdnNrapEBAAAAwjHQSkCWsJrsoOvOhtPIM1jvn1Ou0vu0Pve8TATzpFtzqEXmWWQAAADgBH5iFWDoNNi+T/zqSsdDdok1VH+2r3/UZ4vLfO9Kw/Vdxp+v7bQt+5kAAAAACMdAHUs7PaT+7xIl3iO1v7E+V1wmIO+0lvptxp/H+plzNg8AAABAOAYap82Xk4F4bEPpzOM9ydeMUv8v8/3y3S/M4Zljk/rMD9oEGwAAAADhGGg8IK/N97XHc4/3SG/XyVrfixrfH9sfEzvdZ/z5nQ49BQAAAIBwDDQu2Uv0tXa65Qq1y0SorhVgtTY6stPHjD/fEJABAAAAwjFwCnHq/77NpCUgvw0xBJQEZDvNCcgAAADA6TCUE5Biw6cE3LH+99YG1VmL8yLPGr/L+NNHDdAAAAAAAqDmGPhRnPi3V9PqpuhwT68y/nRDJ10AAAAA4Rho0ib1/1mbM6MdhWUF5HcM8wQAAAAQjoGmwqiE41K9Vp8oIGeNhbyyAXnKVgMAAAAIx0ATkr1WX9kAOulAQF6aHzvpknGQN202/QYAAAAIx0B/re30lPh/J57v1U647lK/HpuaQ0gBAAAAhGMAWSFUxhtO1h7PO1Q7K89A36d+Jx2HzdhyAAAAAOEYCE3C8bH2eJQKy20H97n5vmZbrGleDQAAABCOgSZCaDIQy/BJUUfmbWt+bOotAX7NlgMAAADKe/b161fWAlDABuKdOTzXK6QX66kG5y7Mm/SsfZ369Qs7fzFbDgAAAPBHzTHgNk/8W0Jy3KHmyzJvPzSvZpMBAAAAhGMgKK2FfZ/41WVXArLWYKebV4/tvM3ZcgAAAADhGAgdQiWAfkwF5HlH5m1tfhzeaUXnXAAAAADhGGgihEoYTg6h1KXwuUz9XzrnWrDVAAAAAMIx0IRkIN51KLjH5sfa4zmbCwAAACAcA0H98z//nZlvvVaLTcdmcZn6P88eAwAAAIRjILhk0LztynBOR1p7/OAIzAAAAAAIx0A12rlVcjzhTUdnNR2GqT0GAAAACMdAMFHi30/aQ3Tn6HxRewwAAAAQjoFGzBL/Xnd8XtNheKzPSwMAAAAgHAO1TBP/jjs+r9Lk+yn1O4Z1AgAAAAjHQG2X5xKOtaOwVerXV//8z38jNiMAAABAOAYqSYXKp671Up1DwnG69njJ1gQAAAAIx0AI23OYSQ3w69SvqT0GAAAACMdAZecaKFcZv1uyOQEAAADCMXAyOjZya/7373/t7I+PqV9TewwAAAAQjoHavJpV2wC6Nt2opV16/g4AAAAgHAPwNvUIxnP748Z8PzZyK6g9BgAAAAjHwMlpU+rjs75j+/9ZB2Zr6fk7AAAAgHAMIFeZHqolGI8S/6f2GAAAACAcA72QHNf4Ku9FWmt8k/r1jf39pAPLsPT8HQAAAEA4BpBpmwrBeWF3XiKYnlRB7fGczQsAAAAQjgGfYCk1xw+JX0Ulw/Gs7WGd1MJOT6nfrTpSsw0AAAAQjoEzEBeFYw2Yl4lfJWtp5RnkVUdCfno+ZN7+kqGneAYZAAAAQ/bs69evrAXAQXud/kP/K7WvEw2bx7/P7Y8Pibf8Q4No8hnkX7R5c9vLsk0F+aR7ne9NcvkAAACAvqPmGPBgg+LGfGuSLLWt6V6oJ4l/32mwXJrvmzGvOrI4c/Nj8+qjSw35O61NnrD1AQAAQDgGkLROBt3Uc8RR4t+xBuqd+b4zrusuNF2287XVMP/WfP8sdZLcAJBa778IyQAAACAcA0iSmt9k7fEy53XbRBCV99zlBOw2A/KjnZZ2ktD7qwbl+5yXH0PyqiMdiwEAAACEY6DFQLkz3zeNfp0YCik5/nH6Wd1ZIlSP7XuWHVuurQblqf3vL3b63WTXKL82h+bWc/YGAAAA9A0dcgElpTq0ktArYfGPxEt+6HhLm1N/TvzqV23e3OXllHlepoL/kdSGz7vQwRgAAAAQAjXHQHnJmuBRKhibrMBofxfbH68Sv1p3fSFlnu0kAfmF+b5puNHAvNVevAEAAADCMTA0Gn4lND6UfJ8E4uP4x5dda17tGZKTzyXvbwzIs8jsFQAAADh3NKsGKtLOqSTwXqfC5DPH++Q9x/GPX2it8jkt98IcmluPEr+W0BwxNjIAAAAIx8BwQ3JkDs8dSxPjR+0B2vUeCcTSNFmaZ0/OLVTm3BiQgDzv+rPUAAAAAOEY6Fa4lIAsHXvdabPlc1wOuSkgzaqPtcgS9iMCMgAAAM4NzxwDLdCaYgnE8gzylTa1PsflWOtyHJ9FlpAc2+WZspUBAABwTqg5BlqWeAb5lYbNc1wGCcOx+b4GecpQTwAAACAcAygTLuf2x4cuB2R9tlpC8CTxc1zwFjrpAgAAAOEYQOnwKYFzY6dlFwKyhmHpZEx+Xlb8mFu7LIyFDAAAAMIxgFKB9NgL9KaNgGy/f2IOPW/LcE2jEm+9s5N0wrU7/qRJNQAAAM7Jz6wCoDu0CfLMhtS2alsjO71xvEaeJ95oCI7pmRoAAAB9QM0xgL9pzfXO/Fhr/KCBeE0YBgAAAOEYwBACsjSpfpf6Nc8OAwAAgHAMYHABObY/rlK//mgD8py1AwAAgD76iVUAIIPUEt+nfncjYzJr02sAAACgV6g5BpBJQ3BsfhzGSULznGePAQAA0CfUHAPIpD1nR+bHGmQJy3/a8LxkLQEAAKAvqDkG4KRBOGuIJ+nFWmqRY9YSAAAACMcAhhCQp/bHyvzYUZe41ZD8yJoCAAAA4RjAEELy3P5Y2mmc+tOTnWbUIgMAAIBwDICQbMx7G5AXrCEAAAAQjgEMKSRHGpKTza3vzKEWmWbWQPljam5/TApesrbH1o41BQAA4RjAeYRk6eU6IiADpY+l2GQ/23/0gscXAAAI72dWATrj03MZV3eq00XGK2Rc3Ufz8kvcgXmVIDgxxbU7Mr87O7+DGA9YC+uRLdjP7M+1OQz5FEtoDhWQNYDnrfedrHPGXwYAAEAVva051mZp8xJvmTfdTE1Dg++zmNtBPLf56flUt5Osm3GJd0qtZLyfXn7ZnHA+Iw19ZUlvzpv99PLLY6B5WumNhCKLNsK53dcvNCBfm5o1yHosz/SzfDzoul7R9BRnev2Scxs1xwAAnFifa44njsJFmhS+Vw3P07zEPF30PBRLyFyW3EZJlzq9tp/1oEFsbYPgrmPzeXSt0wf7mR/3n1l/Xqce89XKfqRBeGYL+QtdfytT7mZVUYdfLuP9fmEn+xlv7bwsOdUDKPLs2bOsFkuPX79+pSUKwLEEwnEvTEu+ft5kONaatOsSb7ns5VY5NJ1el1wXPmHozX769Py9Bs/HmvM50fm8amAt3OynT8/f2vnsdXCzwXSltWBrbV4dex4rm0Dr/o222ODZ54Zpk/e0R5q5o6MFeNlf9+eGouutfZ38kNYvsh9vbAF/U/N78x4bKmNr5+Mx0DpolJ3POMR8+HyO5zJf5JQPC9dpwTwGC30e+8bOftcu4P4fZHnsZ830WJp6HkuxHktxl/bhUPuYY1sG24Yl9+9WzjGE4+4pe/G5tIW7SYPNMGdVAnWvCvSHwLlpOPi/1sLOtMZ8Hm+UjBpeIxLmD4WzUE2tuxmQtxqcLjz2+aleOEOue9nfdvLZNLNuNBh/zvjTnR6PQFdCsZzfl6Zci5RjS6Ub+35pqbS0Bcd1xVmQa8tVgOV4OoYMDRpVriGfT7HKQ8yHXd5XNdZ50jTn+17o+syzybkuPZlwLbTWjvJRkPOpBre8df7WHG4ENX0svQ5wLAXdh1PhfVUzxOYd5291nTVlGmqdJM4xMq2HFJZ/6vGyVbn4NPmM76ziTt6nYLw1p6kRX9WYT3nvhxME4+SFItYa9d6SmzyuYNpQMD6Sz9xorTTCY70OM2hGUmtkp2XGFGkhvCvzemGnWM/v4xofJe/9IJ+ltTRtkXPatS7PTtd5n4/DZcvfnxecR3a9TwKWB05RJowqLGefj6X0NpBKlr/sPK16fkz5nmPe2en/hrQ+fjKoG2CdKjSp7qNNhdAjdxXvEtO9x3uezMsv64rBeK0nxTZOxr0PyI5jZNJgME6u57VBE6asgkGE4YkWkLZ2kt48pYbiD3N8rOX7Sf72p33do53Wp2jCW1SY1/NLyMdkrjSUdmHfH+k6j7t0QyKwcZv7kCM0RgH2UZ/PCBXEc/cRV9Ni3b92DRxLccCbDKG81vni5u+39bHr8Tmm3+FYa6AqnXxrvLfIvOL7ol5skE/Pl8a/xlhC8G92+ocNuRM7RYlpaqdn+78dmkC9zQjMq4rzKNvopkRof7+fB5mf9PRt3h4Ibo3cPJGmPtKp2Std18fpd91/ilznPBuLeiasgl6H4qnWFP2lBaQyLYBGem79rKE6OvG8H4NxE62WRh0rPF92NGSEsuxoOA5RbowCv67KZ9x6HkujhvbdTQeD6KXxqE0fkOM5r9cBua/PHNc5uCQkhW5ePR/sYXSoDfVdn6+8an0Pz+fGOi21yfaxQ4hVhXmUg/yD56vdnWgdxmE+ztvc+D+/fL1/fdWa7zNlw2qZmydy02GV8yy+rPOV3uBaF3zmmjBHOIZ3uJTj803AgqaE5N+/fv26OtEirD3OL/f6Onn05zFRjpjqdeXKUVjcmO7czD7OTx8Lr1dSKG+j12P5Tn0Gc3TiwBo0iOuNk3GFGwDG+N3EvtPXHY+li8R8u46lYyXBrGP73aWcB+0+sOSK8F1AjvraA3lfw3Gdk0eZsYh9Cv4TU/2OddSDbTH3DIa/VR6v+DAk0spUf9bYJ4w+mUPHWduS87a2gTc2/h2RrezrN33uoCvj+Hjjuf5nPr1da+/IU/vZsl2zWgNwgWug0Moq6GUwzjuG6nqnIWfe8PzLNbTokSZp3TMvaEoqv1/p56wKzuES2mY1e7L+6HEtmmj5xnVdlcL8vEZHR78bz06ZWrAw7VU4xDn7U4hWCdPAr6tSrowLjiVXsJUbTAvPY2ldENCvNXTFNZfTdx+eJoJ70TH1Rh4pOfNOqV54ro+Jro+xIyCvTU8fqaLm+Edj7dU21IVhZobN5yL2vnIwruvT84XHha1aME6G98N4yTuPGwUjvfgPJcD5LqdXME6F5Lk9lk2icC/bcW5/vzEIeYOD542HGYxvtcC7ryFK1iBoAfhCC+J5QU56fo4D9UBc5fwihfnIp7ArBXVdprjgeiHhuc65ZVciECw8avSXpvqjOtuQw9pU9FSw3yybHA6nQjg2dQKdNlEdea6Dujci887XT45awJDH0tRxLC1N/coh33041m3gM8zo3DQ45GvTyqwPPcdEpvimYN2bcJ3V1w65JjXfH7JZ9bzGe/tQ6PSrLW0nGF94hrNl5WD8LSA/lrhRMjcDoLXGPrVSb8sG42RA1gv3/gYHwbiT51t0Lxgvco5NOY7k0YZ/2AKR1JRKTUqcLlTr72R4IalJkvPs7/reH879TT0fq597VRC8ZmVqgfS1Uc5yiPEpn8PTJp6vCl4y1tq+cyX71N0Jymhlw3ET5bUoZx+NC8J0yO8qXDb9vsuCYymqcCzNCo6lq1M/Ny/zJOc0U9xvySDKZqkwHZniznCXfVz2oYZjV0dJQS4oWqNyWXEexOist8KhttTlXptFt2HmsY4f7PyFCe+HZ5FvPV451vGP+87nQvNgA+0ywHaOArYGQbhCIboXjCc5BR4pNE4klJVtWqjPF2cVskYNFq6KzqGVxjDV5V50pfCsNTYfKwShc7HOW89tdNykN4GeGljX05ywug35XbrO8sqkm4r79aJKU2M9/lZNl8MDl0suh9ZzdeKmYF5mGfexc66fzfAcB/guGrJnZIPtLEAtU9FBduzA49IRsC9yOh/qizaXbRnoNWW/02dYr5mp10SvL+G4dmHTNb5yVTpEW9ZFYdfUdwaax8fANwo6WwBP9EwedJvk9Hjeme0e4ByVvmn4se7zwdqh0UwL/MnPb6qZbNF+uaqxHDIsVV4ni9OWttdNidB1TgXztTYfTz/72ObjR3HONTx0be4xHL8J+F2RY7lMyf3oqWY5ZWXyHw2YmRZaFcp5yO5ztwXltKkZWO/VEpD1OPxQsK16VfnQ13B85Qhja+MezzZEOCm687X2PMHlHojay6/z5FM3XHt8jxQK1xU/vp2L96GHatfg9Q/Be46W5tmfnt8bd3PzXtcca6sK5/qv2py6wfk+9ooeFc2/Put8q+eQTdVjUJue54WSTVbI1fcsTMHNN/uaY6Fm7buONRBGJc+3E5/zVF7rAMfyx1nzrjcEFjqNEr9/0PPhqsT6j/QcJT8nxn0zU37ca0Fhc27N+LVWJB207k2gZqxa8JTt+UfqT/MGgk5eELgL0KlOXkA6ecd0uk7vcr67DzU6eYXyJvYZH9ucbS81aJOyN3kKeo+WfWwXuNyU974Hx3zn7ddxnWNJQ1cX992N8avEGFJAzrtR5brpQjg+F1Kg1ILSuKlw4ij8P+g87GpeTKceB/DO1Bg/VwuHrt6E39ZYhtG++fWhyfEpzT1PkE2Q7fGuo+vlVHyOr850fKGheOUR6JOudZLhpVYVm4dPHMffNnXOWXmeU45jz97Y98mY3UuPAO9zLvihwOj5nmXF5Y8zzld5w43IvFx4buvjVOXRlkudbvQ6s6xx8/DUss6Li5A9tMqzyBkF4iaCzshnnwkckEyVgBRAnHPcn/ejWd+uw1k19eOWOgOKC85J04JAWyqwHp/jt8uYdTM99AgosSO8O68/Pdt3dwZ5x+Lrjt3IaETvnjn26Dl15xl8RlpIaiJ8bUocgFHN8Fa3BtLn+Yq85fAtUC1b2FUiz5N2UxfXyhfNnvBZ/63XukktpJ1kPv4oGYzTF/k39nO2WqsZyiQxj1J4/NNUu9kmF7s48LydwkVqW8k593OVQpXUUMs6tNOjbuubQIUz2Wc+2M89l/Wbvl7cFfVwKgVn6bxLahR0ijy/Z5URdCahFsLxDFyIoB+7jksEu5nyaPJvlC5bmJ848DU765i5cwXQEsda0lWFa+2k4TLSY8FxHHEEdEpcUMYhHJ9TgakgyK1rBtw6oXQdaFl9wsN1zULZtPIB49/D85X59Px0F7lDL9XuO69NDS91WC9PAw/HrhB33/bzm3rcyL4dqnnVZeAQOtGbgbFxPybiM2/nNkTFNBWMP9S4uEe6DkcN7u/nEJCvHCE2WXCVv/1lDq1g3uj02f7+UZtOy2ukljhOTDMNGJuMc2DIgnDReqZjvvOTtx+OWwpQdyWCbpVwHHucs0qVDxzrKW5x23I8nn847t2NjJ+GuoX1WT1Xj9GVgqXWOBc2qS5xQpoULIPccfPp/bhO7fHE8fcnR4i59fyeNycMyD4XlfsOXBAmfTz2PMfFjVuex2Mwvgz80fJ5m4D7cch5vKnZWqatbeUbjMVji/ubbKdlV9djVuFGQ2zWa9cm/4aM3GD4oAH5WgP3cXosWOf0eo5MWnuc1yt3G8dU3vniquJ5oejzQ/VYnff6+5CPTfTERYVryFCOw0HoYzguc8JoqlnyrOZ3lglITTetdn3/NsD8JQPyRmt2295Hdi1dXOteaM+BT+hv+27y2iN0ys01ed7+hU6vtADnahVwpYGurpEJX9N5TrXHV3qjxTcYm7xeuvUG34PH9r7LmJ5KzPNr7WTsHK6ddznBWK4nPuOTf3AULAnHpz2nnru8EHzVwlAyudfvMvNSUNu2TQSSvJZmZZd5WqMsMjR52+UpPab7AN0HyF6dN8QOueJUAdin1+p1wHC8zikoVLXxKBxe1xgS6qrE+vyR9PZ8qBH2fV7zeh9MPz1fBO8pulvhbMh3an0u6ru2Zk5rT11Nqd/mdLC19qx1Xplwj1dkhbiN+f7GlKzzhcdxOJZOrXJ6sF7nBJp3jgvposHNVaZg9+TxWTeJ18bHyTX0lYb0pfFrgr9oeJ2EOi/GoW+gpAqWW8JxMLOCc0EvOIbYkeNpfsJ5kUcEiq5vvuWHrECRVZO7zSiLSZPyixK1eRHh2Nu8oLw9dIMou/YxHHvXOnr2Wl0qWGrBOq825z5ZyNLvrxUkZL7sZ9x6FMpKh3zPGg6fE6ucaD6X+Op9szwN1csGQvKkA/up38VThpzyf3a7T8doK8uswdZV+H9V1PuwHpORIyBLh3/zwL0YF/WMLM+7ro1fM+x51nGttau71PpyXkgbHo5rVLQuEvMbeex3x4JP6SGY9Lw+82ziPTuTcLxLv0BrxcYF6/u4//i0etl5bksU0Obroy6dRxu0yinrNDVWdpG8IYiiEmWtyLNMFZv84Y5ij31kmreP5D06MeDjaVFwPC1ZQ8PQx3Bc9u5zXtfkVYNl6I64Rp7LEDwce65L98VXhiP69PyVKdH8UY01JM81JIcqZPuEs7gj+/PFEI/RumNz11DUX4C49Qm0GpBlv/2z4GULE6722DkcUyK07xznlejM96/3dlkXZY9nDcS1Coqyb2gt8mvHea2LLlzh2GTXqEgt+zRRg7XWAua7jDCRLJTv0rVvLQ2DdM4FedfNvLhPy6s1tnmh9NQtMooCa51rYVyinBV5buOoIODj+5sIeS2h3nNuqrSPnaWf2J7heq3WWqcbR4jNKljU1VSv1a6T/L13iDnU/r6quHxyAfpsQ3K8H/u3vssO7HecZLtp6fi7d+FLaxOLOqS7DNB7sZw/XkgY9DkW9TWumvFxh5+LdXmVEYxPzdnsWG9SdE36vJi1P2Xd/F2lm3ba/68qXtsmBr4F+YkGo1HNskFfymxzvVlwynCceRz5zEdBbe62xHf5nkd43ti9PRYF6+PeUGs8KENsVr1NF2A9mlZLxy8Tj6FlZo4gucuZnytXQaqoaWKDTatdJ95yJ9bD88ePOg9VmtAdQ/LtPqS8/HK+AVPm/dNzzkDZWrmbrTV+rlrjsvucq1VHVLMAu63QbFm+741HSDm34+tV4Gbqlcg+Yvele9ONm3CVpTue0QL/uEQAS1/b4pxjva8dDzYZiufmcKOu6Dr6sUZN1zzA0Cw7+/3rBvZLaZmwzNgXR7pOlic6PlzPHbvOy1nr9yFrm8nNJ/tdWeVU31rqaEA3T8ruw5Gux1FBMI7o0ZtwfO4uHQWXx5wThE/T6pXHa/I0XWjzaVodlZwP14k3Lj2XMnawPEd7uIDdVFzW6/306flHc2huveNQPitdbSru6tW9yjG89TjGTlpA0RuCT8bdtDo+o32qE8E4oY8FqazrAb23nrYwPzF+zfKfaobEmwDLc9dguUeWLesxrbk5bQ1f3k0wn/NnVLJMFWdsl5HrUQS9mTIe4LEbYh+W0ShWBOPhoVm1f6F3XvRHbR557QivVQtRzjChBUNXMzbvIZ20WaWrdrda4VnC7Msvsj5fmHq1hHLy+2vfcVfzwz8hnK7WqEWh93dXL8emvR56+1QoetuxYNxXUc39iBBdTALMlWPyfV593vPnIzc55Z2xdlB2KnGN8/q05DGyrfhdUdDyW//JDY/f7fSLPYaWBGPC8WBpAdY15MGl4zm8Kk2qfQsMvgVoVw3USHvTDhEU7mt3miQdbL38EmlIvq/xSdJEVJopz9ibUUNR886HGvt70U2rtm7quApGk3MpyOQMqYXwLkpev9LXLQqZp/Gq7z0Qa2DJa8l3yvNBXKX8VFCbGzcQxHneuJxLLc9HJ36GHYTjZnh0cvJUI1i6AnBRJzDrE62CustQ5oQb7sR6CMnyfa9M9XEZpZb7DxuQVxzWZ+/kwcyjA6pdjY/f1jjOBrMNKiJwBeD5bN605PoflTgOUJ9cO1808ZxvR+Vd68cBnpeuG45HGoBNifBc2My54G+uZY0Ix6XJjXJpti896lPpMkA/D2x5t44A63rueJF1QtaC9WXN0FqbDEXi8SxhqJrj8CfWQ4/Wax26aWWqddr1et/E+tBsG90txBU1D2xjqBtXGJzYY2vZwGcztuuZ0fN9cjrnmwt1bzLEvmHbs3kiNTXVzqfLAYXiv/cnu59JvyNZz5YuzQmGltF5KHruOG+b+A7hlJbVgV1uiyet+cyatwf6CvCyr3Sx61FuOnEzgXA8PJ69VssQJ9OM5wirNql2BXbfoJoO4kUdEeybVuuYnnmFvwvjfi60uRPFoVfrjfk2bmHZAHGz7wm6XkCeNrqMn55PPNdFH0/IO9O9sV5dNbgyv296tA3ini1Pk2F4quf4yPS0Z2UpKBf0vBvieHrwvIlASwC/gPSoZYdNQyHnd1O/pv8U23KZU965kqGSThQA45zy0rRkmc5nXjNHNylY1ujk5bfucAZaHU4r0nJmUZlkbRhmjnB8xuredfbptXpufmxCPXccVKe8gLjC8THMb2qE8bvazxu7Q+Hj/sJ3aCa9qFCQv9kHbOkdu519yYUTbb/OHehfKD6e6y9ZG7XD8S6jYHphuneTrE1vpQOgjszL9hxqyqTTsYLa44WjbBYyHL/2DccFtblxze/algjoMYfb303VZVrp8GB55Uxpqj/r+7P8+KZvHXLVfX5v7fGaWaoANTEdaFJ9pDXCdXutdoXj0y2ThOSXX+Sk9Ysp32lX3jNJPs81dyEsPZiB8ug/AGhs37OThLkPQw7GNTuj8Tl+ZxmFVQrtCFVuu3E89xsyHGe5KlNO9dz3y/ZYHRGOvYOylDM/1ig3g3DcT569Vo+1md3RvOC1ribVTYX+ur1Wz2p+fhMheaeddn0s8a5xTg/WuwbWeROFx11PDzWf5aImF20EY7mh9tlQo+l7DpxmhOp5xvrLCinL9PWSVY4KoUaCXt6QkIsTfP9j3r6b0zFY1u/uPL9rl1NGjUoE9PueD/NVx6JmmW3IevUM+9CeOY49g2WZptVF4XgdaIcq+8xt5abVWhNeVDB8CBT4q4bk+f55Yv8B3rOW06dJ+KThJbkItL/2NRxPTRs3YfI9GXrb7XswXpc4rxzD3PHZz8eMa8S5Bex0Zz8XGeejq4zC5CoRBqYmu8XOOPlcpP33OmP9rNkLUdEqJwjOpbnsCcaqlWMj77nj2CNklR0vPH3sXHoG8z6XK4Lc6LDr7db+8zrrHMYaKtSr/iJ45jg70LrCsQSuhdYgjx0htZA8u2s/J+hKqNlrdeQRvNt1CMgT49c5ziTn4nLteN9Ye71u6oD3qZXpaxjzCcdRx+Z5a4+ryKCvwXjuGYyl5cra7gux4/OiHhSm0jeotjmhN9YC98SxDmP72q2+Lr1ungjHqBFqNnbfyupQVcpAcgNn2fT1oeA6lr5ZdFUzsMZZ5RcJw6mm2YTj6tsys3yYsY7RUzxz/GOw9G1aLeFyXvCa+1ZrWP2aVk9LhObkzYMu8G0udVUjdDYZhnyC/ZDD8dQApwnGFya/f4IjqVX9xZ7T565gfMbiomNQO6N5yjmXvfG4uTDS12bdNDhF7R76LS8Az1s4djKPIW1ZUTew+j53TGdc1XAeqlZ23fVpIXnmuFqwPIbI2alCZIUOinyWIeuiUVSj+pAxjFU7Xn6R+aj6jFq74Tj7Oei0+/1z1j3kGS5GdMrVqt2AltU1XJz0zh+1fLPzFLYe57+V52c9GP8OBT/aYLwKvCxFBVxuvPWQjvOcdfNmrM/BN/ndu5z9fZzq2C7rmHooc2OooOZy6nH83nfwJtSkY0GVx6coMxCOawRbCTi1mlQ3HEA2HoWTdM/b3euIq4mT2CF0Pnhu4yb4fG7c82PMpwOS+Qnnx7W++1agdi3PkMLxvEP7YZfOpyMZviQjHLtGQ3jSc5xP6x4Zvij4+nWMb3vR8PFDzVN78m6yLFu8hkSOwFrlWn9ftE9qDfUoUBlu1/B1cVLxOG5DNOSDq+A5dsLxEHg2rS6qaSjbpPquoUVxnQjH2gGXb2hb92gz+1yQxp61vP7kOWa/cLzq+WHms/5n2uS1C0YdmpcQ6A3ceHVAeDeAGuNjQXSXcd2bpV7zqAXEp4JgvJBCrTbD/tUcntO+S1zrZHprp19aGtf3osnP6GCBfmjhOK/2uOlgE3sEyGmgcJz1nstELXVU47qbdV5o5VhC50wr7ieE465uOFXmjm6dWtKuhEif+Yg8w/F9Z5pU+2/vohsPvts39FAQriach3nuaZPqkut/FHL9p24EfcezqTfjHPbPpGKBdyjH5Sw93rGGPzn3vk+E3Tv9/1Sbt/79WqkZtpN0ZPNMf8q0PEFh6q7GdaPqteeJQ6o9evMm79qybCkc78tYOubyONA5xvXccZ2xlLM8tHAsMbRb90Qlz7WE445whY4y4a5OwG2i+fGk7Bs8a8AjDQ4zx/pbd2pLH3qrvvR4ZXYB7OWXjWdB5ipY7fFhnhcN73tnwXPf3N9MKAq1JYKxrNNtTid0vhfjOdfG3uH50+JzzygrVEiwtdMiEXYj/f+uQ8uyyz2nN7ffUGvcvrwQfFXQIVaIYL7LuaZdFQSLp4rHTOwIL1nfddvAsdRkOG7rXMIxnEFv7lwPZZ3RrLp+4f2HE1BDzfCqBgRXUD+emM6tSfUqwPL7fsZam0PXtTHuGzjSEdd6IIeZz3KOTM2bTYnxa+Wz4oLm0bHjo67oJOxk561Tuaj5917RWuH0TaLXTYaKNgq5Gc9SlykkFg3hGHPIt74PS/nrY86fFw1/fVywz4RqUn1cxqyb+9PANdSu947rnBu0qfuoS8eSo8OyIV//lxX2D8JxT21O9J42A8ilhoWiYTg+ynjMlefg0/PjuMRhyOe5xyk2+4vHoYa4KBz71B7vQ1WtgPzpuWwHn5ruxYCOL9/1L/vouuwzv1LjbKdtat8uCsg+YX3Vs2ePm9b1sX53jr+XLgxp64TpmR+XP1zX0s2r64RLO52iT4WiAlud1kDzIRUSz1TeuVyuBZMW9rmpCdcZV9F7i849cUPH0pxjqd+0t/e8jPCk/UsQjjnBnk849qwBXzSwHo6hUC5EH+z0l/33plYTZQmnn56v9POqFvK+efnl0fjXHkuw3drvj0ov/6fnsXGPASre23kazAVBb7j4rv8bDbXO9S/h1U5Lc6g5uszZlnHFY+XSFNc+G8/5m8vUg82481je2RnP/2WZ1gL2tQvdt0YNz3djN2j0meG7jJsccd2ArLVMsn5en2B4naLj+aZKjZfWys0LCokU6DtAt8NdxfJOE+F4lnMtqtMcNeu945z986lOR3G6PvNuZM/1uKhyLsgrFz10tGO7wd0Y1/P0h3PJPKH83JcFaaI2RwrL9nMfjH/tx23FGlY58Vw1uHpk531d8Pc3BX+79+ysKM8y8e/r/fTp+ZPO02a/7IeQ6grYx6FBfLfFg2fwWunFxOdz5TWf7fzc7d9XVCv96flU5/fGc37vTTMdhkztvNT7hGYDe5n1L4WLz/aYvNN9Ry6eWznmtLbuuJ+4np8vOqEvPW6+7G+USAC33732PD9F5nBHf5Y41mWbr80Zk0dI7LK5XrYouoBqeN621Cu0z3dKq4VZUYeEun2XDZ/Hk6KGCyWyzf7M2O93UliqUlOgTSiTj5Z8sL97bLjWYV1wfVvLPPmO+6o3BooejTnrY7mHVjnH42VTXyjNne1+8pSxj1wXhM46QTxr374uEdrLHktZ5cj9o08VjqW147u66HIoB48+erLwuKYt+7j8P/doWZpqxuYKlqe6g1In/K9LLEPWBaaaQy3rTc7J9Obvv316LiHhMeMEfgw8ZU9Ih3E2XaH7EPwetTY7Nv61PVfm0FHXMeA8Zsz3qJH5Le9diPNkg+HqUWtQP5d421XyhO0RztLkJtYyZ37WWvvn2uckzH+wr11pSI8zjtep/sz7LKmVnPRgqCDXDUR5VnuXKvAc189xO/5mWuiARcO9a/73tab67PpG5/PRfGvCOG+h0CQtD2Ld9ya6LHGoD5daG1s4emV+vFEk57U/7N/udHtuXAViRyFLAurEt1Bd8fqVN0LAvhWI/f6FK6RoLdfasZ37NPzePODQR+s2OmqTmy52GcpUboQSG7/Hvur28FumZnUT6Fh6XRAaY71xtnUcS5F+1mVBeajtY+kuLxRKsK95vorsZyzbOK48vjd9XXZ527chnPoYjptSJlg2GY4rh3+tAX8y5Zv6PfjWjOXwPQFcJkJPCAsbNP0vHPLaT88Xxr+5dta8VyXhOmooGJ8FKdTb/fP3QEHeZ33PXQVD82OtWZ5ROqyXvVCa869xksKgq4WEFFDfOM5vbTXPWjvm7bidX5vqNxnLevSYnz+Sv7DH0K8hh9uT5tVakM3atsd9/oMG5V3q5sZF4uZB0XVn02Aw3neuowXCdwXn78/2NffmW2uUx9TxGXkc330rJN4EPj+0tW6WFa/rpwjHcYB9+96zDBIHOJakVvxtwblS5uNPPR/Eqe88ng9mHvO7avKcEKgsXmd91ikv1D2u3gRcDx9bGqf+JHjm2CNYGr9eq29rdVrVvCoFz7o7vm+HS6HId/1Wqbfnw3tetTC/syEH48RxJvvK+4a/Ri7akes41WP+1YkWvQ9jJ4cItVGL89/EeUoKrXWGTqkScoM/WiRjFEvw8yjs3WjB6zi91t+PHIWredMb137Hyrhr6S51vuWGw+fE9MajIHvf50LiOdPn50899nQc+HV1zxMPoW7c6H5+73E+eJM6jv7Q37mC8V1HjqWi9TXhyDrNuZtw3H0+TTy6/lB62RNx3Vrj41jCEy1cNX2BOtbAbmrM71oL6acafH5kDp18LYP25n2+AXnR4A2K9/bzI98bWLrvN32z5M70oCmmXVebAMfMpMX5fwx8k+LW1H8meN2V7auF1Rem2tCGed6euHA1a+i8fm+GPbxLX8pvIY+Xred1I0QrjzjQa8qIGjyWunKzeEs4zs4Fdvqt78F4iOF4V/F9m0Cv6erBnmUZ5FulVvTll2UiJD80cLC+st8xLdWUOn9+t/vPOk2gPwZkuaP61364p4GHZA2lU1P/eaxkAH2hwbvKvEQB58XoPiVjcP6iYT3uyaab1zxe4pb3O/n+32ouw4PuazMN3Lsa8yPvfd+VjSvP5NpJzk2/1zyH7/f9U9cOaTPNyNSrzc86t0QdbwKK07dg8zmf3Qfab3zKPJuGjqWQ18Xbjh1LsePmwNDcm0NlwbSPwzYNPhxX7fhG31d0p6zrTapNyWfR6tca54Xkl18mWgj9WPOCdauheFKpGbV7fmVeL/SEcHuizXSTCMlTM1ByvElwtP/8tcZ+cqtBpVYAleNG5+W3GvvBgy7Hb/azLuw070EnXFnnl4kuZ5kL7u96o2DegWXYJJbhqeRyvLLvn6T2tW3N+VmUDMiTE4TMlYZkOTbfagH5wREg3+t59B9S49DWs7lS8LbTTI/lOjVf+xuy9rMIxmdAt9GpC/Rxzb/7LptPLXXc0LEU6XFd52aZHIdSEznr0rHkGAbuqueHzJOetz/q9pWbmRKK10M63z2zC9uLBdGhnKaOwkZc4/MnBYWPXZ3CruOzjx7rdrZiv8d3Y784WY3WIQQee6WOCl4py77b/2xjLGAZY/kwn5H51gtx+kT5lCgQH+c31tfL3euyHaLJCWqZu7yHddf8uHsdGHs5MRTSJOc43x3Xd5P7rp5njvOSt/6Pnfoch5rqVRD2PJ9FGcf03+vkHNaLDjGVt52PyxE3vRypfS7zvBiyI67BFH4OPVDPEut2VFBYPPZIv6k7/qp+b9Z5Y3fqGwcBe6QusvXo0TxrPh5DjXWrQwdN685nwO8Ltq0L9qdj0Iv7eiw59uFa21PHbp5UXaeu7dLUceW5rze27xOOcY43D/7P46VSCz5jjTUSrhcmf1iRwpsVXQioADCA0BydKlQAPT6O/g5pHEs4N3TINRw+gVfu6s1ZVQ349uy1XCzKND29IxgDwGno89Wcc4F6x9EjxxLOFTXHA6C1xtJ8Zex46W/63B2aduh4a23cz6/8YsPxjhUGAAAANIua42FYeQTjjwTjE5LA+/JLZA5DpOR1DvOWYAwAAAAQjhHAP//z37U59IJcRMLZgrXVSkiOdeiodK+PD9oMGwAAAMAJ0Ky6v6E4Moca40vHS+U54+nQetTtpO877ZrxrDEAAABAOIY7/M7NoZv547AxQgLxhTl0vjX2+BgJxhHDgAAAAAAYup9ZBWdLwnGdwcgJxgAAAACgeOZ4mO4JxgAAAABAOB6yW4IxAAAAAHyPZtXDIT0hz20ojlkVAAAAAEA47gvpiVo64rp2vE5qijc2FK9ZZQAAAACQjd6qe0CHbZKxci/0VxKat9QSAwAAAADhGAAAAAAAL3TIBQAAAAAgHLMKAAAAAACEYwAAAAAACMcAAAAAABCOAQAAAAAgHAMAAAAAQDgGAAAAAIBwDAAAAAAA4RgAAAAAAMIxAAAAAACEYwAAAAAACMcAAAAAABCOAQAAAAAgHAMAAAAAQDgGAAAAAIBwDAAAAAAA4RgAAAAAAMIxAAAAAACEYwAAAAAACMcAAAAAABCOAQAAAAAgHAMAAAAAQDgGAAAAAIBwDAAAAAAA4RgAAAAAAMIxAAAAAACEYwAAAAAACMcAAAAAABCOAQAAAAAgHAMAAAAAQDgGAAAAAIBwDAAAAAAA4RgAAAAAAMIxAAAAAACEYwAAAAAACMcAAAAAAPTb/wswALgGM1cHg/O+AAAAAElFTkSuQmCC
MySQL customers, partners and community members are encouraged to submit proposals to present best practices, case studies and insights gained working with the world’s most popular open source database. Proposals can be submitted for conference sessions, Birds-of-a-Feather sessions and tutorials.

MySQL Central @ OpenWorld will feature six tracks:

  • Performance & Scalability
  • High Availability
  • NoSQL & Big Data
  • Cloud and DevOps
  • Database Administration
  • Architecture and Application Development

Details and submission guidelines are available here. The call for proposals will be open until April 29, 2015.

Go ahead and submit your sessions now!

Monday Mar 23, 2015

Harness the Power of MySQL By Learning to Build Databases

Harness the power of MySQL by learning how to design a robust and efficient database. By taking the MySQL for Beginners training course you will learn SQL and use it to build databases, populate them with data and query that data through extensive hands-on practices.

You can take the MySQL for Beginners training course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture at your own pace through streaming video and booking a time that suits your schedule to get hands-on experience.
  • 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. Events on the schedule include 14 April, 27 April, 25 May and 2 June 2015.
  • In-Class Event: Travel to an education center to take this training. Events on the schedule include:

 Location  Date  Delivery Language
 Brussels, Belgium
 27 April 2015
 English
 Sao Paulo, Brazil
 6 July 2015
 Brazilian Portuguese
 London, England
 11 May 2015
 English
 Berlin, Germany
 27 April 2015
 German
 Hamburg, Germany
 21 September 2015
 German
 Munich, Germany
 27 July 2015
 German
Milan, Italy
4 May 2015
 Italian
Rome, Italy
 27 April 2015
 Italian
 Turin, Italy
 8 June 2015
 Italian
 Kuala Lumpur, Malaysia
 8 June 2015
 English
 Petaling Jaya, Malaysia
 2 May 2015
 English
 Pulau Pinang, Malaysia
 2 June 2015
 English
 Mexico City, Mexico
 15 June 2015
 Spanish
 San Pedro Garza Garcia
 4 May 2015
 Spanish
 Lisbon, Portugal
 21 September 2015
 European Portuguese
 Utrecht, Netherlands
 27 April 2015
 English
 Cape Town, South Africa
 11 August 2015
 English
 Johannesburg, South Africa
 11 August 2015
 English
 Pretoria, South Africa
 23 November 2015
 English
 Madrid, Spain
 27 April 2015
 Spanish
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Friday Mar 20, 2015

Hot Off The Press: MySQL March Newsletter

The MySQL March Newsletter is published! Find out what's new in MySQL Cluster 7.4 GA and MySQL 5.7.6 DMR in this edition, and mark your calendar for upcoming webcasts. Below are the highlights in this edition:

  • Blog: 200M Reads Per Second in MySQL Cluster 7.4
  • Get Ready for the MySQL Central 2015 Call for Papers
  • Webcast: NoSQL and SQL--The Best of Both Worlds on March 26
  • Webcast: What's New in MySQL Cluster 7.4 on April 9
  • Blog: More Awesome Replication Features in MySQL 5.7.6 DMR

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 tips and resources in the MySQL newsletter!

Monday Mar 16, 2015

MySQL for Developers Training Now Available Online

The popular MySQL for Developers course is now available as a Training-on-Demand offering. Start training within 24 hours of registration, following lecture materials at your own pace via streaming video and booking time to get hands-on experience when it suits your schedule.

The MySQL for Developers training covers everything a developer needs to know when planning, designing and implementing applications using MySQL. Learn through realistic examples using languages like Java and PHP.

You can now take this course in the following formats:

  • Training-on-Demand: Train at your own pace and avoid travel costs.
  • 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. Events currently on the schedule include 20 April, 11 May and 25 May 2015 for delivery in English and 25 May 2015 in Traditional Chinese.
  • In-Class Event: Travel to an education center to attend an event. Below is a selection of events already on the schedule.

 Location  Date  Delivery Language
Vienna, Austria
20 April 2015 German
Brussels, Belgium
18 May 2015 English
Sao Paulo, Brazil
13 July 2015 Brazilian Portuguese
Munich, German
18 May 2015 German
Budapest, Hungary
13 April 2015 Hungarian
Nairobi, Kenya
13 April 2015 English
Kuala Lumpur, Malaysia
20 July 2015 English
Petaling Jaya, Malaysia
20 April 2015 English
San Pedro Garza Garcia, Mexico
25 May 2015 Spanish
Makati City, Philippines  27 April 2015 English
Pasig City, Philippines 15 June 2015 English
Lisbon, Portugal 19 October 2015 European Portuguese
Utrecht, Netherlands 18 May 2015 English
Cape Town, South Africa 25 May 2015 English
Johannesburg, South Africa 13 July 2015 English
Pretoria, South Africa 13 April 2015 English

The MySQL for Developers course helps prepare you to take the MySQL 5.6 Developer OCP certification exam.

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

Monday Mar 09, 2015

Secure Web Pages By Using Session Handling with PHP

Use session handling within PHP to secure web pages. By taking the MySQL and PHP - Developing Dynamic Web Applications training course, among many other topics you learn to:

  • Describe session handling
  • Explain session handling tasks
  • Use session handling for security
  • Use MySQL for database authentication

You can take this 4-day instructor-led course from your own desk as a virtual event or by traveling to an education center. Below are some of the events already on the schedule:

 Location  Date  Delivery Language
Petaling Jaya, Malaysia 23 March 2015 English
Virtual Event 24 March 2015 English
Virtual Event 21 April 2015 English
Causeway Bay, Hong Kong 26 May 2015 English
Virtual Event 26 May 2015 English

To continue your learning as a MySQL developer, consider taking the MySQL for Developers training course.

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

Monday Mar 02, 2015

Upcoming MySQL Tech Tours in USA and Canada

Oracle's MySQL Team is busy in March. We're traveling to many places to bring the latest MySQL news and product development to a city near You!


Do you want to learn more about building a security enterprise platform with MySQL? Want to hear what's new in MySQL 5.7 and MySQL Enterprise Monitor 3.0? Get ready to discover which of the MySQL high availability solutions is the best fit for your infrastructure?


Plan to join one of the following MySQL events:

For more details and additional events, check MySQL Events page.

The Tech Tours offer you a unique chance to meet with the MySQL team, learn how MySQL solutions can help you achieve your goals and get all your questions answered.

Space is limited so register today. We look forward to seeing you there!

About

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

Twitter


Facebook

Search

Archives
« April 2015
SunMonTueWedThuFriSat
   
1
3
4
5
7
8
9
10
11
12
14
16
17
18
19
21
22
23
25
26
27
28
29
30
  
       
Today