Courses by Category
Click on a category below to see a listing of courses.

This course is available for customized on-site delivery for groups of 3 or more students.
Contact us today at 877-258-8987 for more information or a quote.

Scroll down the page for a list of upcoming course dates in our public calendar.

Upgrading to MySQL 5.1 (3 days)


Designed for MySQL Administrators, this course covers the new features and functions added in MySQL 5.1, and is designed for enterprises migrating from MySQL 5.0 to MySQL 5.1 .

Upgrading to MySQL 5.1 Course Calendar (3 days)

Call for upcoming dates or on-site delivery.

1 Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services.
spacer
2 Include course and course materials only.
spacer
3 Requires a broadband internet connection and microphone. Note that Virtual LIVE courses are led by an instructor, and as such start and end in local time (based on the course location), this my differ from your time zone.
spacer
For government and education pricing, please contact us.

Recommended Pre-requisites

Students attending this course should have basic MySQL administration skills, relevant to the 5.1 release of MySQL

Course Outline/Agenda

This course covers the following topics:

  • Upgrading to MySQL 5.1 from MySQL 5.0
  • MySQL new utilities & application features
    • Using mysql_upgrade for upgrade and repair
    • Performing tablespace backups with mysqldump
    • Using mysqlslap for load emulation
  • Deploying MySQL Table Partitioning
    • Range Paritioning
    • List partitioning (including linear list)
    • Hash partitioning (including linear hash)
    • Key based partitioning
  • MySQL Full Text Search
    • Deploying traditional MyISAM Full-text search
      • Traditional Full-text searches
      • Natural language searches (new)
      • Boolean mode searches (improved)
    • Plug-in full text search mechanisms.
  • Deploying MySQL Replication
    • Deploying traditional statement-based replication
    • Deploying row-based replication
    • Deploying mixed binary replication
    • How to choose a replication strategy
  • Understanding the MySQL pluggable storage engine architecture (hot pluggable)
  • Understanding & configuring server log tables
  • Understanding MySQL's information_schema database, and new tables
  • Using the MySQL event scheduler to schedule in-database events.
  • New XML functions

Class Size

This class is limited to a maximum of 12 students.

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

Instructional Materials
The following materials are used to deliver this course:
  • OTG Course Guide
Adobe PDF Logo View course guide table of contents
Requires Adobe Acrobat Reader

Enroll in this course

View upcoming course calendar

Information Request
Complete the form below to have one of our enrollment specialists contact you.










(Upon submission this page will reload)

info@otg-nc.com
877-258-8987



PHP Logo PostgreSQL Logo SUSE Logo Debian Logo Novell Logo Django Logo
Python Logo GForge Logo MediaWiki Logo MapServer Logo PostGIS Logo

Site Map | LAMP Training | Linux Fundamentals | Linux Training | Learn MySQL Administration | MySQL Courses & MySQL Classes | MySQL Tuning & MySQL Training | Novell CLP & Novell Training | Novell Linux Training & Novell Classes | Open Source Training & OES Linux | PHP Instruction & PHP Courses | PHP Training & PHP MySQL Training | PostgreSQL | Open Source GIS | GForge CDE | MediaWiki | PostgreSQL Training & PostGIS Training | SLES Classes For SUSE Linux Administration | SUSE Training & SUSE Linux Fundamentals | Zend PHP | Advanced PHP | AJAX Training | Bash Training | GroupWise Training | Python Training