MySQL Newsletter October 2003

Introduction

• Emic Networks Platinum Sponsor of the MySQL Users Conference & Expo 2004
  Emic Networks is proud to announce its Platinum Sponsorship of the MySQL Users Conference & Expo 2004, the MySQL event of the year to be held in Orlando, Florida, April 14-16.

  Emic offers grid computing solutions for open-source web platforms and applications built on MySQL databases and web servers. The Emic Application Cluster (EAC) software provides an efficient and cost-effective solution for creating on-demand, high performance, highly available database applications with dynamic load balancing and seamless failover and recovery.
  
   

• Who Works For MySQL?
  First, let's dispense with the notion that MySQL is a troop of Vikings who punch time clocks every day in the MySQL AB head office near Stockholm. Less than 10% of the employees are Swedish nowadays, and both the American and the German contingents outnumber them. Full-time and part-time workers hail from Argentina, Australia, Brazil, Bulgaria, Canada, Denmark, Estonia, Finland, France, India, Mexico, Russia, Serbia, and Ukraine. And when you count all the contributors to the open source code, you find representatives from all the world's major countries.
   

Products

• MySQL-4.0.16 has been released
  MySQL 4.0.16, a new version of the popular Open Source/Free Software Database, has been released. It is now available in source and binary form for a number of platforms from our download pages athttp://www.mysql.com/downloads/ (http://www.mysql.com/downloads/) and mirror sites.
   
• MySQL Connector/J 3.0.9 STABLE Has Been Released
  MySQL Connector/J 3.0.9, a new version of the Type-IV all-Java JDBC driver for MySQL has been released.

  It is now available in source and binary form from the Connector/J download pages athttp://www.mysql.com/downloads/api-jdbc-stable.html (http://www.mysql.com/downloads/api-jdbc-stable.html) and mirror sites.
   

Bugs

• Bugs fixed for MySQL-4.0.16
  Please refer to our bug database athttp://bugs.mysql.com/ for more details about the individual bugs fixed in this version.
   

MySQL Tips & Hints

• Protecting MySQL Sessions With SSH Port Forwarding
  When the MySQL client communicates with the MySQL server, all communication (with the exception of the user password) is done in plain text. The same holds true for the Connector/ODBC driver and all software communicating through it.

  In his article at http://www.vbmysql.com/articles/sshtunnel.html
  Mike Hillyer shows, how you can protect your MySQL Sessions with SSH Port Forwarding.
  
   

• What is the limit to the length of primary keys
  What restrictions, if any, does MySQL have on the length of primary keys.

  In MySQL by default the maximum lenght for any index is 500 bytes for MyISAM tables and 1024 bytes for InnoDB. An index can contain from 1 to 16 columns or parts of columns. The default maximum lenght of index can be changed at compile.
   

• Error 28, how to avoid it.
  What is error 28 and how can I avoid it?

  Error 28 means, that there is not enough diskspace available for the MySQL Process. To avoid it, you need to ensure, that especially MySQL's temporary directory has plenty of space available.
   

• From the Manual: MySQL Full-text Search
  I need to store huge amount of documents into database and I need to be able to do full text searches to those documents. Can I do that with MySQL? Short answer is yes.
   

Events

• COMDEX Las Vegas 2003
  COMDEX Las Vegas 2003 (comdex.com) November 16-20, 2003 Your business depends on technology and only COMDEX brings it all together. Every part of COMDEX, from exhibits to educational programs to special events, is designed around the seven themes impacting the future of your business. Come to Las Vegas to discover just how exciting the future of technology will be. Register at http://www.comdex.com/lasvegas2003/register/ today.
   
• MySQL at the COMDEX Las Vegas 2003
  MySQL AB will be present at the COMDEX Las Vegas 2003 show. You can visit us at our booth #9940 and hear the latest MySQL News or get answers to your MySQL questions. At the booth we'll also have MySQL Partner Pavilion including: Arkeia, High-Availability, Emic Networks and SQL Fusion.
   
• Webcast: More Bang for the Buck -- Open Source Databases
  Join MySQL AB CEO Mårten Mickos and key VERITAS executives in an October 30 Webcast titled, "More Bang for the Buck - Open Source Databases," as they examine how high performance, reliable open source databases are delivering business-critical functionality to enterprise applications.

  For more information register:http://placeware.viewcentral.com/events/cust/single_event.asp?cid=veritas&pid=2&lid=5&cbClass=163
   

• MySQL User Conference and Expo 2004 in Orlando
  MySQL AB is proud to host our second annual MySQL Users Conference, to be held in Orlando, Florida, April 14-16, 2004.
   
• MySQL participates Forum PHP Conference in Paris (26 Nov. - 27 Nov. 2003)
  MySQL AB employees will be giving two presentations at the Forum PHP conference in Paris. More information and registrations athttp://www.afup.org/forumphp/
   
• MySQL AB at the Industry Events
  MySQL AB founders and employees will be available for meetings and discussions at many industry events. Seehttp:// www.mysql.com/events/ for a list of coming events.
   

Training

• Upcoming MySQL Training
  MySQL AB is holding numerous training courses in the following countries: USA, Germany, Canada, France, UK, Australia, India and Sweden. Check out dates and locations athttp://www.mysql.com/training/ (http://www.mysql.com/training/)
   

Partners' Corner

• SQLyog makes MySQL data synchronization and migration a piece of cake!
  Webyog, developers of SQLyog - the most popular GUI front-end to MySQL has partnered with MySQL AB. The partnership would enable Webyog to deliver the next generation of MySQL tools and utilities. Webyog develops products exclusively on the MySQL platform.

  SJA is a high-performance, multithreaded, multi platform application to automate and schedule Synchronization of Data between two MySQL hosts. On Windows, it is included with SQLyog 3.6 - the latest version of the award winning MySQL Client. The Linux version of SJA is FREE and can be downloaded fromhttp://www.webyog.com.