MySQL Newsletter October 2007

Articles in this newsletter:

Training, Consulting & Certification

Partner Corner

Rippletech White Paper
Winning the War Against Inside Threats: Actionable Strategies for Safeguarding Critical MySQL Data

Highlights

MySQL Conference & Expo 2008 - Submit Your Proposal by Oct. 30th

The 2008 MySQL Conference and Expo promises to be the most well-attended technical MySQL conference to date. What's the best way to get a free conference pass? Well, be a speaker of course!

Do you have experience building MySQL applications?
Managing MySQL databases or data warehouses?
Deploying and configuring Windows or LAMP environments?
Managing development organizations in a modern environment?
Scaling and tuning today's largest web applications?
Contributing to open source projects?

Submit Your Proposal, it only takes 10 minutes (Deadline October 30th) »

Case Study: Scholastic Helps Schools Raise Reading Achievement

The Scholastic Achievement Manager (SAM) is a powerful dashboard for managing reading achievement that uses MySQL. Built to scale across large districts, it powers Scholastic's student technology applications including READ 180, Scholastic Reading Inventory (SRI), and ReadAbout.

Download the Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_scholastic.php)

Interview: CIO of BT Global Services, JP Rangaswami

JP Rangaswami, CIO of BT Global Services since 2006, is a highly respected voice in the UK IT-industry, a fellow of both the British Computer Society and the Royal Society of Arts. Before joining BT Global Services he was the global CIO of the investment bank Dresdner Kleinwort Wasserstein, where he introduced a MySQL-based system.

Read the Interview » (http://www.mysql.com/why-mysql/cio-corner/interviews/jp-rangaswami.html)

MySQL Enterprise for Service Providers

MySQL Enterprise is a comprehensive offering of database software, services and support that enables Service Providers to cost-effectively implement database applications. Learn how MySQL Enterprise can help SaaS, Managed Hosting and Mobility Service Providers gain a competitive edge.

Learn More » (http://www.mysql.com/why-mysql/service-providers/)

Oracle Users Indicate Increase in Use of Open Source

The Independent Oracle Users Group (IOUG) has released its second major research study focusing on open source adoption trends. 35% of the respondents indicated they are also using open source databases. Read the survey and learn more about how deeply open source products have penetrated enterprises with Oracle data centers.

Download Now » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_ioug.php)

30 Day Trials for MySQL Enterprise with Monitoring Services

You can experience the power of the MySQL Enterprise Monitor at no charge for 30 days. This Service continuously monitors your MySQL servers and alerts you to potential problems before they impact your system. It is like having a "Virtual DBA Assistant" at your side to recommend best practices to eliminate security vulnerabilities, improve replication, optimize performance and more.

MySQL is Hiring

Apply today to join one of the largest and fastest growing open source companies! MySQL is a global organization with over 300 employees in 25 countries. We have openings for the following positions:

Support Engineers
Senior Software Developers
QA Engineers
Senior Sales Representatives
Sales Engineers
And More ...

Apply Now » (http://www.mysql.com/jobs/)

New Product Releases

New Release of MySQL Community Server 5.1.22 (Release Candidate)

MySQL Server 5.1.22-rc release is the first 5.1 "Release Candidate" version of MySQL. Following is a partial list of changes and bug fixes:

There is a new innodb_autoinc_lock_mode system variable to configure the locking behavior that InnoDB uses for generating auto-increment values.
Bug fix: MySQL Cluster: (Replication): Multi-master replication setups did not handle --log-slave-updates correctly.
Bug fix: Row-based replication from a pre-5.1.22 MySQL Server to a MySQL 5.1.22 was unstable due to an uninitialized variable.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/ODBC 5.1.5 (GA)

MySQL Connector/J 5.1.5, the first production release of the 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.5 is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0, MySQL-5.1 RC or the MySQL-6.0 Falcon development release. The following is a partial list of changes:

Added Support for JDBC-4.0 NCHAR, NVARCHAR and NCLOB types - Added JDBC-4.0 support for setting per-connection client information
Added autoSlowLog configuration property, overrides slowQueryThreshold* properties

View complete list of changes »

Download Now »

Hints & Tips

Article: MySQL 5.1 Article Recap

So, someone had a great idea to go back through the Developer Zone and put together an article with links and summaries for all the Dev Zone articles that discussed MySQL 5.1 features.

Read the Article »

Article: Load and Search MySQL Data Using VB.NET 2005 in Windows Applications

MySQL data load and search are very important business requirements in any Windows or Internet web application development. In general, any application needs to show a result set of data and/or a single record to the end-users.

Read the Article »

Sample Chapter: Writing MySQL Programs Using C

Here is the full chapter from Paul DuBois' industry-standard work, MySQL, Third Edition, from Pearson Publishers. It covers numerous topics including:

How to write client programs that communicate with the server over secure connnections using the Secure Sockets Layer (SSL) protocol.
How to write applications that use libmysqld, the embedded server library.
How to send multiple statements to the server at once and then process the result sets that come back
How to use server-side prepared statements

Read the Sample Chapter »

Interview: Christopher Cordray, Co-Founder and CTO, ScienceLogic

Christopher Cordray, a ScienceLogic founder and the principal software architect behind the EM7 appliances, has more than fifteen years experience with networking, management systems and technology-related operations.

Read the Interview »

PlanetMySQL Blog Posts

The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things MySQL, including technical tips and best practices.

Visit PlanetMySQL »

Submit Your Blog Feed »

PlanetMySQL Blog: Improved Handling of Large Falcon Transactions

Robin Schumacher

The Falcon team should get some good kudos for putting out the latest alpha release that has much improved handling of large transactions. Below are just a few examples of large inserts on a Fedora Core box with a single CPU. Falcon was given a 200MB record cache size and InnoDB got a comparable 200MB buffer pool size.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: MySQL Backups using LVM Snapshots

Paul Moen

There are a couple of options available to get consistent backups from MySQL. We are going to demonstrate how to use LVM snapshots to reduce time required to hold MySQL consistent. I used these two good articles as a basis for this one.

Read the PlanetMySQL Blogpost »

How to get your Session Accepted to MySQL Conference 2008

Baron Schwartz

I'm on the select board of elite people who were duped into reviewing proposals for the upcoming MySQL Conference and Expo 2008, and I'm here to tell you how to get your proposal accepted. Aside from bribing me with chocolate, that is.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: PlanetMySQL Blog: Questions and Answers from the Backup Webinar

Ivan Zoratti

Ivan Zoratti answers the questions he received on the recent webinar: MySQL Backup and Recovery - Today and Tomorrow.

What is your suggestion to backup databases with tables with mixed engines?
Can I use replication and then a binary copy of the data from a slave?
What tool do you recommend to backup a MyISAM database that is about 50 GB? We want to do a hot backup, or at least a warm backup.
More ...

Read the PlanetMySQL Blogpost »

View the MySQL Backup and Recovery Webinar »

PlanetMySQL Blog: Slides from ZendCon Performance Coding Session

Jay Pipes

I presented at ZendCon on performance MySQL coding techniques. The session was packed, and I got a bunch of great questions from the audience. I figured I would post the slide deck in both ODP and PDF formats. Feel free to download!

Read the PlanetMySQL Blog Post »

Memory Allocation and Deallocation in MySQL Cluster

Johan Andersson

In this post I will explain how memory management works inside MySQL Cluster. Memory management differs between different versions of MySQL Cluster.

Read the PlanetMySQL Blog Post »

Events

Live Web Seminar: MySQL AB in Italy

Learn How to Reduce Your Database Costs by over 90%
Thursday, November 8, 2007 (Italian)

MySQL AB, the company behind the MySQL Server, expands its presence in Italy and invites you to:

Learn more about open source and MySQL
Learn about functionalities and services to better plan your MySQL deployments
Understand how to select the right MySQL solution for your applications
Get your questions answered by the MySQL experts and provide the MySQL team with input
Meet the MySQL Italy team members and build relationships

Whether you are a developer, a DBA or an IT decision maker, the MySQL AB in Italia event is an opportunity to learn more about open source, the MySQL offerings and how to make best use of it.

Live Webinar: Designing, Evaluating and Benchmarking MySQL Cluster

Thursday, November 08, 2007

In this webinar learn the fundamentals of how to design and select the proper components for a successful MySQL Cluster evaluation. We will explore hardware, networking and software requirements. Work through a basic installation, functional testing and ongoing best practices for maintaining the system. Finally, we will close with an examination of the recent benchmark results performed in conjunction with Intel and Dolphin Interconnect Solutions.

Live Webinar: MySQL vs. SQL Server Express: an ISV Perspective

Wednesday, November 14, 2007

ISVs face a number of key decisions when designing, developing, and delivering a new solution to market. One of the most important determinations revolves around selecting an embedded database to include with their new product. Hundreds of successful ISVs have already done their homework and chosen MySQL as their data storage architecture. This has radically altered the dynamics of the relational database market, especially with regard to embedded solutions.

Training, Consulting and Certification

Consulting: MySQL Scale-Out, High-Availability and Replication Jumpstart (4 Days)

In this engagement, a dedicated MySQL certified consultant will work closely with your team to:

Analyze your Scale-out and High-Availability database requirements
Identify potential issues and limitations
Install, Configure and Fine-Tune MySQL
Configure MySQL or MySQL Cluster to work with HA Technologies (e.g. DRBD, SAN, Shared SCSI, Heartbeat, etc), as required
Secure your database environment against failures and downtime
And more ...

Schedule your Schedule Your Engagement Now » (http://www.mysql.com/consulting/packaged/scaleout.html)

Training: MySQL Partitioning MySQL (Virtual Course, 1 Day)

November 2007

This instructor-led course is designed for MySQL users who would like to use the new partitioning features available in the MySQL 5.1. This course provides in-depth information in an E-Learning classroom format that is easily accessible and affordable.

Partners

Rippletech White Paper

Winning the War Against Inside Threats: Actionable Strategies for Safeguarding Critical MySQL Data

Today's headlines confirm the potential outcomes of ineffective IT security systems. Companies are suffering serious consequences-from stolen customer data and intellectual property to insider threats who can compromise the comprehensive perimeter security. In addition, increasing privacy and security regulation presents a complex challenge for organizations that must secure massive amounts of data, monitor complex applications, and manage large numbers of users. Read about how RippleTech is help MySQL Enterprise users win the war against inside threads at:

Download the White Paper »

The MySQL Team