MySQL Newsletter November 2003

Introduction

• The Rhyme and Reason of Dual Licensing
  MySQL AB is a second-wave open source company that employs the popular "dual licensing" business model. This business model is becoming increasingly popular among open source companies, as it paves the way for long-term financial viability and profitable business. Dual licensing lets companies provide warranted commercial software licenses to their customers, while at the same time offering their software under an open source license to all who wish to use, modify and distribute it freely.

  What is the secret formula, and how does dual licensing work? Here is the logic behind this business model.
   

• MySQL Case: Sabre Holdings
  Travel industry leader Sabre Holdings has chosen MySQL for high speed search engine used by travelocity, travel agencies and airlines.
   

Products

• How to Study MySQL Internals
  Sometimes you might want to know, how certain MySQL feature was implemented or how it is supposed to be working. The standard advice "Research Thy Foundation Matter", usually abbreviated RTFM, is only useful if you know where to look. The "MySQL Internals" section in MySQL's online manualhttp://www.mysql.com/doc/en/MySQL_internals.html (http://www.mysql.com/doc/en/MySQL_internals.html) is quite short. Where are the low-level descriptions?
   

MySQL Tips & Hints

• JDO support for MySQL
  If you plan to use Java Data Objects (JDO) with MySQL, here is
  little piece of information, which could be helpful in you quest. We don't have our own implementation of JDO, but MySQL works fine with pretty much every third party JDO vendor, whether commercial or Open source.
   
• How to Configure a Relay Replication Server
  If you want to configure a relay replication server, i.e. make the replication to pass data from slave to another slave as
  A->B->C
  you need to start B with --log-bin and --log-slave-updates. You can read more about this from the section "Replication Startup Options" of our manual at at http://www.mysql.com/doc/en/Replication_Options.html (http://www.mysql.com/doc/en/Replication_Options.html)
   
• Speeding up InnoDB Insert by Changing Default Settings
  InnoDB default options are very conservative and in several situations increasing the buffers can have a high impact on the performance.
   
• Can I Revert MySQL Back to an Earlier State?
  Q: I want to be able revert my MySQL database "back in time". E.g.
  if a programmer makes a mistake, having such a feature could be
  a life saver. Is there any way, I can revert the MySQL database
  to an earlier state?

  A: Yes you can. The binary log keeps a complete history of all
  queries that change the state of the database. This log can be used
  to restore the database to a particular state if desired.
   

Events

• 2nd Annual MySQL Users Conference
  MySQL AB will host the second annual MySQL Users Conference in Orlando, Florida, April 14-16, 2004. This event promises to be the biggest gathering of MySQL database users ever in one location.
   

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 at http://www.mysql.com/training/ (http://www.mysql.com/training/)
   

Partners' Corner

• Backup Watcher for MySQL Available from Desktop Software
  Backup Watcher for MySQL, as the name implies, is an automatic backup solution for MySQL database with a built-in task scheduler, profile wizard, convenient user interface and multilingual support. Importantly, the software allows databases to be backed up from remote server (even for Firewall users), as well as computer hard-drive, floppy disk, CD-R/RW or external drives, such as Iomega Zip; local backup is available too.
  
   
• Failover and Load Balancing Cluster for MySQL
  As online business applications grow in popularity and importance, keeping systems up and running continuously is part of the expected norm. Nearly every business is looking for more reliable infrastructures. Your customers expect your systems to be online 24/7, whether you're a small retailer or a global conglomerate. Database servers play a significant role in today's online business applications and are increasingly called upon to provide highly reliable, scalable performance for client connectivity and transactional support.