January 7th Webinar: Boost Performance with 5.1 and Query Analyzer

This upcoming event will explain how MySQL Enterprise delivers higher performance for large-scale enterprise applications through Partitioning and Row-Based Replication. Robin Schumacher and Rob Young with Sun MySQL will also address how Query Analyzer provides DBAs and developers with a tool to further optimize database performance and manage scale through identifying and analyzing problem SQL code that is causing performance issues and slowdowns. Register for this event which is planned for 10:00 am PDT, 1:00 pm EDT, 18:00 GMT. The presentation is expected to run for 45 minutes, followed by Q&A.

New MySQL Community Blog

The MySQL Community Blog is a new site for the community to gather for information and share thoughts. Guest posts will highlight this blog, which opened with MySQL System QA Manager Trim Perhad's analysis of performance results between version 5.0 and the most recent 5.1. Click over for a read.

Sun News Radio hosts Zack Urlocker

In a 15-minute discussion, Zack Urlocker shares some thoughts about MySQL 5.1 on Sun News Radio. Performance improvements and simplified management features are covered, as is the hardware and software platforms, languages, various offerings of the open source database, migration and its tools, and more.

Tutorial: Connecting to a MySQL Database from NetBeans IDE 6.5

A 30-minute tutorial on the NetBeans Web site demonstrates how to set up a connection to a MySQL database from NetBeans IDE 6.5. Designed for beginners with a basic understanding of database management, the lesson contents include:

• Configuring MySQL Server Properties
• Starting the MySQL Server
• Creating and Connecting to the Database
• Creating Database Tables
• Working with Table Data
• Running an SQL Script

MySQL Migration Toolkit

This graphical tool is for migrating schema and data from various relational database systems to MySQL. The Toolkit supports a variety of source database systems, including the Oracle, Microsoft SQL Server, Microsoft Access, Sybase and even earlier version of MySQL. Charles Ditzel offers the Migration toolkit flow:

• 1) You specify target and source databases.
• 2) You select the objects (tables, views, stored procedures) that will be migrated.
• 3) You choose the method used for mapping and transforming the objects.
• 4) You can manually edit the new objects to ensure a proper transformation.
• 5) The MySQL Migration Toolkit creates the transformed object on the target MySQL server.
• 6) You specify any changes that need to be made to the data as it is migrated.
• 7) The MySQL Migration Toolkit transfers the data from the source server to the target server.
• 8) In the final step the MySQL Migration Toolkit creates a summary report of the migration process for you to review."

For more, see Chapter 9. The Migration Process In-Depth. Also of interest may be the MySQL Forums: MySQL Migration Toolkit.

Register for MySQL Conference & Expo, April 20-23, in Santa Clara, Calif.

Registration is now open for the seventh annual MySQL Conference & Expo to be held at the Santa Clara Convention Center. The four-day event will bring together over 2,000 MySQL enthusiasts, more than 120 sessions encompassing a wide range of skill levels to help organizations build modern Web, Web 2.0, SaaS, Embedded, Telecom, and Enterprise 2.0 applications. Learn more by visiting the conference Web site. [...read more...]

		fullsource
Print Email Current Profile Archive Blog Generate newsletter