MySQL Newsletter June 2004
Newsletters older than 6 months may have links that are out of date. Please use the Search to check for updated links.
Articles in this newsletter:
Highlights
- Web Seminar - Sabre Holdings Reduces TCO by 80%
- MySQL Case Study: S2 Security Breakthrough Security Appliance
Products
- New Release of MySQL (4.1.2 Alpha) is Now Available
- New Release of Connector/J (3.1.2) is Now Available
- New Release of MaxDB by MySQL (7.5.00.14) is Now Available
Tips & Hints
- MySQL Storage Engine Architecture, Part 3: Details and Comparison
- Introduction to MySQL Cluster for MySQL Users
- Using ext/mysqli to bridge between PHP and MySQL: Part II - Extending mysqli
- High Performance MySQL Book by Jeremy Zawodny and Derek Balling
Chapter 7 - Replication
Events
Training & Certification
Partner's Corner
- HP First Major Vendor to Certify, Integrate and Support Open Source Software for Customers
- AdventNet Becomes Authorized MySQL Partner
Highlights
Web Seminar - Sabre Holdings Reduces TCO by 80%
Find out how Sabre Holdings Reduced TCO by 80% at an exclusive web seminar hosted by Hewlett-Packard and MySQL on July 8, 2004. This is a unique opportunity to learn about the issues surrounding the development of an open source strategy, and to get an exclusive look at how it's being implemented today at Sabre Holdings Corporation. Sabre Holdings is the leading online travel reservation system and the largest distributor of travel in the world.
Join us on July 8, 2004 at 8:30 am PDT; 11:30 am EDT; 17:30 CET
MySQL Case Study: S2 Security Breakthrough Security Appliance
S2 Security Corporation has embedded MySQL in its S2 NetBox™. The S2 NetBox is a network appliance that is literally a "security management system in a box" allowing facilities of all sizes to manage their physical security needs from anywhere over IP networks using a simple browser. According to John Moss, CEO of S2, "We had three primary considerations in selecting a database to embed in our system: cost, footprint, and functionality." MySQL was the only choice to meet all three criteria.
Download the case study (http://www.mysql.com/it-resources/case-studies/mysql-s2security-casestudy.pdf)
Products
New Release of MySQL (4.1.2 Alpha) is Now Available
This is a new alpha development release, adding new features and fixes. This release includes:
- Added support for character sets conversion and MYSQL_TYPE_BLOB typecode in prepared statements protocol.
- Added explanation of hidden SELECT of UNION in output of EXPLAIN SELECT statement.
- mysql command-line client now supports multiple -e options.
- New myisam_data_pointer_size system variable.
Detailed information on what is new
New Release of MySQL Connector/J (3.1.2) is Now Available
This is a new feature release of the Type-IV all-Java JDBC driver for the ALPHA tree that is suitable for use with either MySQL-4.1 or MySQL-5.0 (and is required when using server-side prepared statements on MySQL-4.1.2 or newer). This release includes:
- Fixed stored procedure parameter parsing info when size was specified for a parameter (i.e. char(), varchar()).
- Enabled callable statement caching via 'cacheCallableStmts' property.
- Fixed case when no output parameters specified for a stored procedure caused a bogus query to be issued to retrieve out parameters, leading to a syntax error from the server.
Detailed information on what is new
MaxDB by MySQL 7.5.00.14 is Now Available
This is a maintenance release of the production version of MaxDB. This version includes:
- SQL Studio will display the number of affected rows for insert, update and delete in the Trace Window and the number of affected rows for insert, update and delete of the last executed statement in the status bar.
- Joins using the inv_direct strategy may run in parallel
- The command "check table
catalog" now also checks the correctness of the stack entries for columns with a definition length >= 255
Detailed information on what is new
Tips & Hints
MySQL Storage Engine Architecture, Part 3: Details and Comparison
This is the third of a three-part series on the MySQL storage engine architecture on the Developer Zone area of our web site.
In part three of this series we will compare key aspects of the most popular storage engines, and provide you with guidelines and practical examples to help you decide which engine may be best suited for a particular purpose.
Introduction to MySQL Cluster for MySQL Users
MySQL AB sales engineer Anders Karlsson demonstrates how to get the new MySQL Cluster running in a single-machine configuration on Linux, from compiling the source to configuring the storage and management nodes, and the server itself.
Using ext/mysqli to bridge between PHP and MySQL, Part II: Extending mysqli
This is the second of a three-part series on a new MySQL extension for PHP5 that will support new features in MySQL Version 4.1 and higher. In this article, we will discuss how to extend the default mysqli class to provide additional functionality.
High Performance MySQL Book by Jeremy Zawodny and Derek Balling
Chapter 7 - Replication
The authors and publisher of High Performance MySQL have allowed us to post the Replication chapter to our web site. This chapter examines all aspects of MySQL replication. It begins with an overview of how replication works and the problems it solves, followed by various architectures you can construct using a mix of masters and slaves. This chapter also discusses administrative issues including maintenance, security, useful tools, and common problems.
Events
MySQL Swell Geek Cruise
October 10-17, Eastern Mediterranean
Join the founders of MySQL Monty Widenius, David Axmark and other technical experts from MySQL on this unique 7 day high-tech Mediterranean cruise. This is a great opportunity to get comprehensive technical insight into MySQL and attend hands-on workshops with the developers of MySQL and combine it with fantastic sightseeing and world-renowned travel.
Read more and sign up now (http://www.mysql.com/geekcruises)
O'Reilly Open Source Conference 2004
July 26-30, 2004, Portland, OR
The O'Reilly Open Source Conference 2004 will be an excellent event to get detailed information on MySQL including new feature development, performance tuning, and web development. There will be numerous sessions and talks covering MySQL given by the MySQL development team.
Read More (http://www.mysql.com/news-and-events/events/)
AO2004: The Innovation Summit
July 13 - 15, Frances C. Arrillaga Alumni Center, Stanford, CA
Connect with thirty industry heavyweights, a dozen top VCs and bankers from Sand Hill Road to Wall Street, 50 private company CEOs, and the top tech writers in big media and the blogosphere; all debating what (and if) innovation matters. Friends of MySQL can get a 33% discount off the door price by contacting Kathy Osweiler at 415/751-0170 or kathy@alwayson-network.com.
Training & Certification
Free Certification Voucher - Register Before June 30th
Register for the 'Introduction to MySQL' or 'Using and Managing MySQL' training classes and receive a Certification Exam voucher for free. Offer expires June 30th. MySQL AB is holding training courses in the following countries: USA, Germany, Canada, France, UK, Australia, India and Sweden.
Check out dates and locations (http://www.mysql.com/training/free-certification.html)
Partner's Corner
HP First Major Vendor to Certify, Integrate and Support Open Source Software for Customers
HP signs agreements with MySQL AB and JBoss to certify, support and jointly sell their open source software solutions on HP's standards-based servers. Certified on industry-standard HP ProLiant and HP Integrity servers, these Linux-based solutions provide customers with a stable platform for basic databases and business applications software.
Read the Press Release (http://solutions.mysql.com/news/release_587.html)
AdventNet Becomes Authorized MySQL Partner
The AdventNet Micro Agent for MySQL provides out-of-the-box ability to monitor and manage the MySQL database server through both HTTP and SNMP and enables integration with popular enterprise consoles like HP OpenView, IBM Tivoli. The agent does in-depth MySQL monitoring by providing availability, real-time statistics of MySQL parameters such as users, queries, memory, CPU, etc. The micro agent can also notify users of faults through SNMP traps and email. The users can also configure such fault conditions dynamically through the web by using the in-built rule engine.
© 2010, Oracle Corporation and/or its affiliates