MESSAGE
| DATE | 2007-02-22 |
| FROM | Ruben Safir
|
| SUBJECT | Subject: [NYLXS - HANGOUT] [newsletter@mysql.com: MySQL Newsletter: February 2007]
|
----- Forwarded message from MySQL AB -----
Date: Thu, 22 Feb 2007 14:59:29 +0100
To: ruben-at-mrbrklyn.com
From: MySQL AB
Subject: MySQL Newsletter: February 2007
X-Priority: 3
X-Mailer: PHPMailer [version 1.72]
X-Keywords:
X-UID: 31298
MySQL Newsletter
February 2007
newsletter-at-mysql.com
Articles in this newsletter:
Highlights
- MySQL Conference & Expo: Register Now, Save $200
- MySQL Cluster Carrier Grade Edition for Telecom
- Case Study: Alcatel-Lucent Handles Over 60 Million Subscribers
- White Paper: New Enhancements to the MySQL Monitoring & Advisory Services
- MySQL Enterprise Unlimited
- Article: Understanding the Falcon Transaction Storage Engine
- MySQL is Hiring
New Product Releases
- MySQL Enterprise Server 5.0.30 sp1
- MySQL 5.1.15 (Beta)
- MySQL Connector/ODBC 5.00.11 (Beta)
- MySQL Native Driver for PHP 5.0.0 (Alpha)
Hints & Tips
- Documentation: New MySQL Replication Chapter
- MySQL Podcasts for the Community, by the Community
- PlanetMySQL Blog: Transactions and Autocommit
- PlanetMySQL Blog: MySQL Spanning Different Timezones
- PlanetMySQL Blog: Getting Use of Slave in MySQL Replication
- PlanetMySQL Blog: Subqueries
Events
- Live Web Seminar: MySQL Cluster Carrier Grade Edition for Telecom's Next-Generation of Subscriber-Centric Networks
- Live Web Seminar: MySQL Enterprise for DBAs
- Live Web Seminar: Turning Today's Web 2.0 into Tomorrow's Enterprise
- Live Web Seminar: Cost-effective Scale-out with MySQL
Training, Consulting & Certification
- Online Training: Database Design with Joe Celko (4 Hours)
- Training: MySQL 5.0 for Database Administrators (5 days)
Partner Corner
- Showcase Your Solution at the 2007 MySQL Conference and Expo
Highlights
MySQL Conference & Expo: Register Now, Save $200
The MySQL Users Conference and Expo 2007, April 23-26, in Santa Clara, California will be the largest gathering with over 1500 MySQL developers, DBAs and users. New sessions are being added weekly. Session highlights include:
- MySQL Performance Cookbook
Peter Zaitsev, Co-Founder, Percona Ltd
- Managing MySQL the Slack Way: How Google Deploys New MySQL Servers
Michael Still, Corporate Reliability Engineer, Google Inc
Grant Allen, Google, Inc.
- Federation at flickr: Doing Billions of Queries Per Day
Dathan Pattishall, Senior Support Engineer, flickr.com
- The 7 Stages of Scaling Web Applications: Strategies for Architects
John Engates, CTO, Rackspace Managed Hosting
Register Now and Save $200
http://www.mysqlconf.com/
MySQL Cluster Carrier Grade Edition for Telecom
MySQL Cluster Carrier Grade Edition is a cost-effective, open source database solution that is ideally suited for the telecom industry's top carriers, operators and equipment manufacturers building Subscriber Databases and Service Delivery Platforms (SDPs). For example, it provides the extreme scalability and performance to centrally store dynamic session data, subscriber data, call detail records, configuration data and more in real-time.
Learn More
http://www.mysql.com/telecom
Case Study: Alcatel-Lucent Uses MySQL Cluster Carrier Grade Edition to Handle over 60 million Subscribers
Alcatel's legacy HLR system was been based on proprietary database technology. However given the enormous growth in the number of subscribers it became apparent to Alcatel that they needed a new solution. After an extensive evaluation period and numerous performance benchmark tests, Alcatel selected MySQL Cluster Carrier Grade Edition as their database of choice for their next generation HLR solution.
Read the Case Study
http://www.mysql.com/why-mysql/case-studies/mysql_cs_alcatel_lucent.pdf
White Paper: New Enhancements to the MySQL Monitoring & Advisory Services
MySQL AB is proud to announce the newest update to the MySQL Network Monitoring and Advisory Service. This latest release extends the advanced monitoring and expert advisory services to include even more enterprise ready features and functionality, including:
- New Notification Option - SNMP traps allow you to send notifications using your existing infrastructure such as HP OpenView, Tivoli, and others.
- New Advanced Graphing - A new Graphs tab allows you to view more MySQL and operating system specific metrics.
- New Advisor Rules - 20 new Advisor Rules enable you to monitor and leverage expert advice on 600 + MySQL and operating system specific variables.
Any many more including easier installation & configuration, FreeBSD & SuSE 10 support, and custom Advisor categories.
Read the What's New White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_enterprise_whatsnew_spring2007.php
MySQL Enterprise Unlimited
MySQL Enterprise Unlimited is a unique offering that enables you to accelerate your open source initiative and gain control of your software budget by significantly reducing the cost of deploying and managing database software. For the price of a single CPU of Oracle Enterprise Edition ($40,000 per CPU), you can deploy an unlimited number of MySQL Enterprise Servers, with full 24x7 production support.
Learn More:
http://www.mysql.com/products/enterprise/unlimited.html
Article: Understanding the Falcon Transaction Storage Engine - Part 1
MySQL has also just introduced a new transactional storage engine - code named Falcon - that is currently available in an alpha release. Falcon is a next-generation transactional management engine designed to run on all popular hardware/architecture platforms, but it is especially designed to take advantage of the large memory caches available in 64-bit environments.
Read the Article:
http://dev.mysql.com/tech-resources/articles/falcon-transactional-engine-part1.html
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:
- Senior Software Developers
- QA Engineer
- Senior Sales Executive - Telecom Sales
- Product Marketing Manager - OEM and Telecom
- Support Consultants - Professional Services
- Senior Instructor
- IT Support Services
- Accountant - Revenue
Apply Now:
http://www.mysql.com/jobs/
New Product Releases
New Release of MySQL Enterprise Server 5.0.30 sp1 (GA)
This is a Service Pack release of the MySQL Enterprise Server 5.0. The following is a partial list of bugs fixed:
Bug Fix: In MySQL 5.0.13 and up, InnoDB rolls back only the last statement on a transaction timeout. A new option, --innodb_rollback_on_timeout, causes InnoDB to abort and roll back the entire transaction if a transaction timeout occurs (the same behavior as before MySQL 5.0.13). (Bug#24200)
Bug Fix: CONCURRENT did not work correctly for LOAD DATA INFILE.
Bug Fix: Calculation of COUNT(DISTINCT), AVG(DISTINCT), or SUM(DISTINCT) when they are referenced more than once in a single query with GROUP BY could cause a server crash.
View the complete list of changes:
http://dev.mysql.com/doc/refman/5.0/en/releasenotes-es-5-0-30sp1.html
Download Now (login required):
https://enterprise.mysql.com/
New Release of MySQL 5.1.15 (Beta)
This is a new Beta development release, fixing recently discovered bugs. The following is a partial list of changes:
When using MERGE tables the definition of the MERGE table and the MyISAM tables are checked each time the tables are opened for access (including any SELECT or INSERT statement. Each table is compared for column order, types, sizes and associated. If there is a difference in any one of the tables then the statement will fail.
Remote servers for use with the FEDERATED storage engine now can be managed with the new CREATE/ALTER/DROP SERVER syntax.
The --skip-thread-priority option now is enabled by default for binary Mac OS X distributions. Use of thread priorities degrades performance on Mac OS X.
View the complete list of changes:
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-15.html
Download Now:
https://enterprise.mysql.com/
New Release of MySQL Connector/ODBC 5.00.11 (Beta)
MySQL Connector/ODBC is our next generation ODBC driver which allows access to the MySQL 5.x server using the widely used ODBC standard. The ODBC standard is a cross-platform, cross-database, C language, Call Level Interface. The following is a partial list of changes:
- Changed internals to support SQLParamData/SQLPutData and chunking of inputs.
- Fixed connection string parsing for DSN-less connections.
- Fixed certain cases of handling SQL_NUMERIC_C
View the complete list of changes:
http://lists.mysql.com/announce/431
Download Now:
http://dev.mysql.com/downloads/connector/odbc/5.0.html
New Release MySQL Native Driver for PHP: mysqlnd-5.0.0 (Alpha)
The MySQL native driver for PHP is an additional, alternative way to connect from PHP 6 to the MySQL Server 4.1 or newer. The MySQL native driver for PHP requires PHP 6 and can connect to MySQL Servers 4.1 or newer.
View the complete list of changes:
http://lists.mysql.com/announce/432
Download Now:
http://dev.mysql.com/downloads/connector/php-mysqlnd
Hints & Tips
Documentation: New MySQL Replication Chapter
We have completely reworked the replication chapter for the 5.1 manual. This targets a number of issues, including a major redesign (to make it easier to read and find topics), some updates to the information and processes, and incorporation of numerous bug fixes.
Read the Updated Documentation:
http://dev.mysql.com/doc/refman/5.1/en/replication.html
MySQL Podcasts for the Community, by the Community
Sheeri Kritzer
Hosted by Sheeri Kritzer of the Boston MySQL User Group, the weekly 10-20 minute podcast features interviews, performance tips, news and learning resources. Podcast topics include:
- MySQL Security
- Performance Tips
- Backups
- MySQL Cluster
View all the podcasts:
http://technocation.org/index.php?option=com_content&task=category§ionid=4&id=13&Itemid=29
PlanetMySQL Blog: MySQL: Transactions and Autocommit
Roland Bouman
Some people believe that the ability to commit or rollback multiple statements as a single unit is a defining characteristic of the concept of transactions. They draw the -false- conclusion that enabling autocommit is the same as disabling transactions. It is easy to demonstrate why this is not true.
Read the PlanetMySQL Blog post:
http://www.planetmysql.org/entries/6216
PlanetMySQL Blog: MySQL: MySQL Spanning Different Timezones
Paolo Magnoli
So, what if you are planning a centralized MySQL server and many clients all around the world? First of all, check the manual. Then install timezone description tables. Then run a small example to see how the server and client timezones can interact. Here is the standard server setup.
Read the PlanetMySQL Blog post:
http://www.planetmysql.org/entries/6217
PlanetMySQL Blog: Getting Use of Slave in MySQL Replication
Peter Zaitsev
MySQL Replication is asynchronous which causes problems if you would like to use a MySQL Slave, since it can contain old data. I'll list some techniques here which I found to be helpful for offloading workloads to the slave. The same approach can be used in Master-Master replication in Active-Passive mode, just think about passive node as a slave.
Read the PlanetMySQL Blog post:
http://www.planetmysql.org/entries/6228
PlanetMySQL Blog: Subqueries
Sergey Petrunia
MySQL evaluates queries "from outside to inside", i.e. we first get the values of (oe1, .. oeN) and then we run the subquery and capture the rows it produces. An apparent and very useful optimization is to "inform" the subquery that we're looking only for rows that have "ie1=oe1", "ie2=oe2" and so on. This is done by injecting appropriate equalities into subquery's WHERE (or HAVING) clause.
Read the PlanetMySQL Blog post:
http://www.planetmysql.org/entries/6230
Events
Live Web Seminar: An Introduction to MySQL Cluster Carrier Grade Edition for Telecom's Next-Generation of Subscriber-Centric Networks
February 27, 2007, 9:00am PST
MySQL Cluster Carrier Grade Edition is a version of the MySQL Cluster product. It is specifically designed to better serve the business and technical challenges currently facing Telecom Equipment Manufacturers (TEM) and Network Service Providers (NSP) developing subscriber databases for the next-generation of services and applications on converged networks.
Join us for this webinar where you can learn about how MySQL Cluster Carrier Grade Edition is powering telecom's next-generation of converged subscriber-centric networks.
Register for the Webinar:
http://www.mysql.com/news-and-events/web-seminars/mysql-teleco-cluster.php
Live Web Seminar: MySQL Enterprise for DBAs
March 1, 2007, 9:00am PST
This web presentation will focus on how DBAs can utilize all the features and functionality of MySQL Enterprise to ensure their database servers provide the highest possible amounts of uptime, the tightest possible security, and the fastest possible performance. Tactics and strategies will be presented that focus on how DBAs can effectively manage anywhere from one to hundreds of servers with MySQL's new monitoring and advisory service.
Register for this Webinar:
http://www.mysql.com/news-and-events/web-seminars/mysql-enterprise.php
Turning Today's Web 2.0 into Tomorrow's Enterprise
March 7, 2007, 10:00am PST
Web 2.0 is the second generation of services available on the Web that lets people collaborate and share information online. One of the defining characteristics of Web 2.0 is the fact that it's the data that is driving this evolution. In this web seminar we explore how companies are deploying Web 2.0 architectures and applications using MySQL and MySQL Cluster.
Register for this Webinar:
http://www.mysql.com/news-and-events/web-seminars/web2.0-mysql.php
Live Web Seminar (German): Cost-effective Scale-out with MySQL
March, 14, 2007, 14:00 Central European Time Zone
Scaling out (or Horizontal Scaling) means distributing the computing and data workload among multiple commodity servers by load balancing, with the ability to add servers to increase capacity. By distributing the workload, processing resources are spread among multiple low-cost servers, which improves both performance and the availability of the overall service at a dramatically lower cost.
Register for this Webinar:
http://www.mysql.com/news-and-events/web-seminars/scale-out.php.de
Training, Consulting and Certification
Online Training: Database Design with Joe Celko (4 Hours)
Multiple Dates in March & April
- Do you want to learn how to design databases with solid foundations built on good SQL practices?
- Do you want to avoid creating databases with poor structure leading to difficulties in scaling and maintenance?
The online instructor-led course is designed for developers who wish to use sound database design principles while creating MySQL databases.
Register Now for an Upcoming Date:
http://www.mysql.com/training/courses/database_design.html
Training: MySQL 5.0 for Database Administrators (5 Days)
London, Zurich, Paris, Dallas, Vancouver, and more.
- Is your MySQL database secure?
- Do your users have the correct privileges and access rights?
- Is your MySQL database operating at optimal efficiency? Do you want to increase the performance of your database and make sure it scales?
- Do you want to save time using features like Stored Procedures, Triggers and Views?
- Do you want to utilize the new enterprise features of MySQL 5.0?
Register Now for an Upcoming Date:
http://www.mysql.com/training/workshops/mysql_dba.html
Partners
Showcase Your Solution at the 2007 MySQL Conference and Expo
April, 23-26, 2007
The MySQL Conference & Expo is one of the most targeted events in the industry to expose your products and services to the growing open source marketplace. You can enjoy meeting with the hundreds of attendees, speakers, press, and MySQL staff - all with the common goal of promoting the open source community and MySQL database applications.
Download the Brochure (PDF)
http://solutions.mysql.com/MySQLExpo2007_prospectus.pdf
The MySQL Team
About the Newsletter
You can send us queries and give us feedback online.
http://www.mysql.com/company/contact/
You can unsubscribe from this newsletter online:
http://www.mysql.com/unsub?email=ruben-at-mrbrklyn.com
Read more about the newsletter and view previous issues.
http://www.mysql.com/news-and-events/newsletter/
--
Copyright (c) 2007 MySQL AB. All rights reserved.
You are free to distribute this newsletter, as long as you don't make any changes.
----- End forwarded message -----
--
http://www.mrbrklyn.com - Interesting Stuff
http://www.nylxs.com - Leadership Development in Free Software
So many immigrant groups have swept through our town that Brooklyn, like Atlantis, reaches mythological proportions in the mind of the world - RI Safir 1998
http://fairuse.nylxs.com DRM is THEFT - We are the STAKEHOLDERS - RI Safir 2002
"Yeah - I write Free Software...so SUE ME"
"The tremendous problem we face is that we are becoming sharecroppers to our own cultural heritage -- we need the ability to participate in our own society."
"> I'm an engineer. I choose the best tool for the job, politics be damned.<
You must be a stupid engineer then, because politcs and technology have been attacted at the hip since the 1st dynasty in Ancient Egypt. I guess you missed that one."
|
|
