|
LinuxDig.Com : Linux News : June 2004 MySql Newsletter
Author: mysql | Friday June 25, 2004
June 2004 MySql Newsletter
MySQL Newsletter
June 2004
newsletter@mysql.com
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
* MySQL Swell Geek Cruise
* O'Reilly Open Source Conference 2004
* AO2004: The Innovation Summit
Training & Certification
* Free Certification Voucher
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
Register now:
http://www.hpbroadband.com/program.cfm?key=MySQLHP
MySQL Case Study: S2 Security Breakthrough Security Appliance
S2 Security Corporation has embedded MySQL in its S2 NetBox(TM). 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:
http://lists.mysql.com/announce/201
Download:
http://dev.mysql.com/downloads/mysql/4.1.html
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:
http://lists.mysql.com/announce/202
Download:
http://dev.mysql.com/downloads/connector/j/3.1.html
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:
http://dev.mysql.com/doc/maxdb/changes/changes_7.5.00.14.html
Download:
http://dev.mysql.com/downloads/maxdb/7.5.00.html
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.
Read the full article:
http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html
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.
Read the full article:
http://dev.hosting.stage.mysql.com/tech-resources/articles/mysql-cluster-for-mysql-users.html
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.
Read the full article:
http://www.zend.com/php5/articles/php5-mysqli2.php
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.
Read the Replication chapter:
http://dev.mysql.com/books/hpmysql-excerpts/ch07.html
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.
Register now:
http://www.alwayson-network.com/events
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.
|
