MySQL Newsletter
October 2007
newsletter mysql.com
Articles in this newsletter:
Highlights
- MySQL Conference & Expo 2008 - Submit Your Proposal by
Oct. 30th
- Case Study: Scholastic Helps Schools Raise Reading
Achievement
- Interview: CIO of BT Global Services, JP Rangaswami
- MySQL Enterprise for Service Providers
- Oracle Users Indicate Increase in Use of Open Source
- 30 Day Trials for MySQL Enterprise with Monitoring
Services
- MySQL is Hiring
New Product Releases
- MySQL Community Server 5.1.22 (Release Candidate)
- MySQL Connector/ODBC 5.1.5 (GA)
Hints & Tips
- Article: MySQL 5.1 Article Recap
- Article: Load and Search MySQL Data Using VB.NET
- Sample Chapter: Writing MySQL Programs Using C
- Interview: Christopher Cordray, Co-Founder and CTO,
ScienceLogic
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: Improved Handling of Large Falcon
Transactions
- PlanetMySQL Blog: MySQL Backups using LVM Snapshots
- PlanetMySQL Blog: How to get your Session Accepted to
MySQL Conference 2008
- PlanetMySQL Blog: Questions and Answers from the Backup
Webinar
- PlanetMySQL Blog: Slides from ZendCon Performance Coding
Session
- PlanetMySQL Blog: Memory Allocation and Deallocation in
MySQL Cluster
Events
- Live Web Seminar: MySQL AB in Italy, Learn How to Reduce
Your Database Costs by over 90%
- Live Webinar: Designing, Evaluating and Benchmarking MySQL
Cluster
- Live Webinar: MySQL vs. SQL Server Express: an ISV
Perspective
Training, Consulting & Certification
- Consulting: MySQL Scale-Out, High-Availability and
Replication Jumpstart (4 Days)
- Training: MySQL Partitioning MySQL (Virtual Course, 1
Day)
Partner Corner
- Rippletech White Paper
- Winning the War Against Inside Threats: Actionable
Strategies for Safeguarding Critical MySQL Data
------------------------------------------------------------
-------
Highlights
MySQL Conference & Expo 2008 - Submit Your Proposal by
Oct. 30th
The 2008 MySQL Conference and Expo promises to be the most
well-attended technical MySQL conference to date. What's the
best way to get a free conference pass? Well, be a speaker
of course!
- Do you have experience building MySQL applications?
- Managing MySQL databases or data warehouses?
- Deploying and configuring Windows or LAMP environments?
- Managing development organizations in a modern
environment?
- Scaling and tuning today's largest web applications?
- Contributing to open source projects?
Submit Your Proposal, it only takes 10 minutes:
(Deadline October 30th)
http://e
n.oreilly.com/mysql2008/public/cfp/2
Case Study: Scholastic Helps Schools Raise Reading
Achievement
The Scholastic Achievement Manager (SAM) is a powerful
dashboard for managing reading achievement that uses MySQL.
Built to scale across large districts, it powers
Scholastic's student technology applications including READ
180, Scholastic Reading Inventory (SRI), and ReadAbout.
Download the Case Study:
http://www.mysql.com/why-mysql/case-studies/m
ysql_cs_scholastic.php
Interview: CIO of BT Global Services, JP Rangaswami
JP Rangaswami, CIO of BT Global Services since 2006, is a
highly respected voice in the UK IT-industry, a fellow of
both the British Computer Society and the Royal Society of
Arts. Before joining BT Global Services he was the global
CIO of the investment bank Dresdner Kleinwort Wasserstein,
where he introduced a MySQL-based system.
Read the Interview:
http://www.mysql.com/why-mysql/cio-corner
/interviews/jp-rangaswami.html
MySQL Enterprise for Service Providers
MySQL Enterprise is a comprehensive offering of database
software, services and support that enables Service
Providers to cost-effectively implement database
applications. Learn how MySQL Enterprise can help SaaS,
Managed Hosting and Mobility Service Providers gain a
competitive edge.
Learn More:
htt
p://www.mysql.com/why-mysql/service-providers/
Oracle Users Indicate Increase in Use of Open Source
The Independent Oracle Users Group (IOUG) has released its
second major research study focusing on open source adoption
trends. 35% of the respondents indicated they are also using
open source databases. Read the survey and learn more about
how deeply open source products have penetrated enterprises
with Oracle data centers.
Download Now:
http://www.mysql.com/why-mysql/white-papers/mysql_w
p_ioug.php
30 Day Trials for MySQL Enterprise with Monitoring Services
You can experience the power of the MySQL Enterprise Monitor
at no charge for 30 days. This Service continuously monitors
your MySQL servers and alerts you to potential problems
before they impact your system. It is like having a
"Virtual DBA Assistant" at your side to recommend
best practices to eliminate security vulnerabilities,
improve replication, optimize performance and more.
Register for the Trial:
http://www.m
ysql.com/ent-trial-reg-2007/
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:
- Support Engineers
- Senior Software Developers
- QA Engineers
- Senior Sales Representatives
- Sales Engineers
- And More ...
Apply Now:
http://www.mysql.com/jobs/
------------------------------------------------------------
-------
New Product Releases
New Release of MySQL Community Server 5.1.22 (Release
Candidate)
MySQL Server 5.1.22-rc release is the first 5.1
"Release Candidate" version of MySQL. Following is
a partial list of changes and bug fixes:
- There is a new innodb_autoinc_lock_mode system variable to
configure the locking behavior that InnoDB uses for
generating auto-increment values.
- Bug fix: MySQL Cluster: (Replication): Multi-master
replication setups did not handle --log-slave-updates
correctly.
- Bug fix: Row-based replication from a pre-5.1.22 MySQL
Server to a MySQL 5.1.22 was unstable due to an
uninitialized variable.
View the complete list of changes:
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-22.html
Download Now:
http://
dev.mysql.com/downloads/mysql/5.1.html
New Release of MySQL Connector/ODBC 5.1.5 (GA)
MySQL Connector/J 5.1.5, the first production release of the
5.1 branch has been released. Connector/J is the Type-IV
pure-Java JDBC driver for MySQL. Version 5.1.5 is suitable
for use with any MySQL version including MySQL-4.1,
MySQL-5.0, MySQL-5.1 RC or the MySQL-6.0 Falcon development
release. The following is a partial list of changes:
- Added Support for JDBC-4.0 NCHAR, NVARCHAR and NCLOB types
- Added JDBC-4.0 support for setting per-connection client
information
- Added autoSlowLog configuration property, overrides
slowQueryThreshold* properties
View complete list of changes:
http://dev.mysql.com/doc/refman/5.0/en/cj-news-5-1-5.ht
ml
Download Now:
h
ttp://dev.mysql.com/downloads/connector/j/5.1.html
------------------------------------------------------------
-------
Hints & Tips
Article: MySQL 5.1 Article Recap
So, someone had a great idea to go back through the
Developer Zone and put together an article with links and
summaries for all the Dev Zone articles that discussed MySQL
5.1 features.
Read the Article:
http://dev.mysql.com/tech-resources/articles/my
sql-5.1-recap.html
Article: Load and Search MySQL Data Using VB.NET 2005 in
Windows Applications
MySQL data load and search are very important business
requirements in any Windows or Internet web application
development. In general, any application needs to show a
result set of data and/or a single record to the end-users.
Read the Article:
http://dev.m
ysql.com/tech-resources/articles/ebonat-load-and-search-mysq
l-data-using-vbnet-2005.html
Sample Chapter: Writing MySQL Programs Using C
Here is the full chapter from Paul DuBois' industry-standard
work, MySQL, Third Edition, from Pearson Publishers. It
covers numerous topics including:
- How to write client programs that communicate with the
server over secure connnections using the Secure Sockets
Layer (SSL) protocol.
- How to write applications that use libmysqld, the embedded
server library.
- How to send multiple statements to the server at once and
then process the result sets that come back
- How to use server-side prepared statements
Read the Sample Chapter:
http://dev.mysql.com/tech-resources/articles/mysql-
c-api.html
Interview: Christopher Cordray, Co-Founder and CTO,
ScienceLogic
Christopher Cordray, a ScienceLogic founder and the
principal software architect behind the EM7 appliances, has
more than fifteen years experience with networking,
management systems and technology-related operations.
Read the Interview:
http://dev.mysql.com/tech-resources/interviews/
chris-cordray.html
PlanetMySQL Blog Posts
The following blog posts are from PlanetMySQL. PlanetMySQL
is an aggregation of blogs and news from MySQL developers,
users and employees. It is an excellent source of all things
MySQL, including technical tips and best practices.
Visit PlanetMySQL:
http://www.planetmysql.org
Submit Your Blog Feed:
http://www.pla
netmysql.org/newfeed.php
PlanetMySQL Blog: Improved Handling of Large Falcon
Transactions
Robin Schumacher
The Falcon team should get some good kudos for putting out
the latest alpha release that has much improved handling of
large transactions. Below are just a few examples of large
inserts on a Fedora Core box with a single CPU. Falcon was
given a 200MB record cache size and InnoDB got a comparable
200MB buffer pool size.
Read the PlanetMySQL Blogpost:
http://blogs.mysql.com/ro
bin/2007/10/03/improved-handling-of-large-falcon-transaction
s/
PlanetMySQL Blog: MySQL Backups using LVM Snapshots
Paul Moen
There are a couple of options available to get consistent
backups from MySQL. We are going to demonstrate how to use
LVM snapshots to reduce time required to hold MySQL
consistent. I used these two good articles as a basis for
this one.
Read the PlanetMySQL Blogpost:
http://blog.dbadojo.com/2007/09/mysql-back
ups-using-lvm-snapshots.html
How to get your Session Accepted to MySQL Conference 2008
Baron Schwartz
I'm on the select board of elite people who were duped into
reviewing proposals for the upcoming MySQL Conference and
Expo 2008, and I'm here to tell you how to get your proposal
accepted. Aside from bribing me with chocolate, that is.
Read the PlanetMySQL Blogpost:
http://www.xaprb.
com/blog/2007/10/05/how-to-get-your-session-accepted-to-mysq
l-conference-2008/
PlanetMySQL Blog: PlanetMySQL Blog: Questions and Answers
from the Backup Webinar
Ivan Zoratti
Ivan Zoratti answers the questions he received on the recent
webinar: MySQL Backup and Recovery - Today and Tomorrow.
- What is your suggestion to backup databases with tables
with mixed engines?
- Can I use replication and then a binary copy of the data
from a slave?
- What tool do you recommend to backup a MyISAM database
that is about 50 GB? We want to do a hot backup, or at least
a warm backup.
- More ...
Read the PlanetMySQL Blogpost:
http://onlinesolutionsmys
ql.blogspot.com/2007/10/questions-and-answers-from-backup.ht
ml
View the MySQL Backup and Recovery Webinar:
http://www.mysql.com/news-and-events/o
n-demand-webinars/display-od-59.html
PlanetMySQL Blog: Slides from ZendCon Performance Coding
Session
Jay Pipes
I presented at ZendCon on performance MySQL coding
techniques. The session was packed, and I got a bunch of
great questions from the audience. I figured I would post
the slide deck in both ODP and PDF formats. Feel free to
download!
Read the PlanetMySQL Blog Post:
http://jpipes.com/i
ndex.php?/archives/202-Slides-from-ZendCon-Performance-Codin
g-Session.html
Memory Allocation and Deallocation in MySQL Cluster
Johan Andersson
In this post I will explain how memory management works
inside MySQL Cluster. Memory management differs between
different versions of MySQL Cluster.
Read the PlanetMySQL Blog Post:
http://johanandersson.blogs
pot.com/2007/10/memory-allocation-and-deallocation-in.html
------------------------------------------------------------
-------
Events
Live Web Seminar: MySQL AB in Italy
Learn How to Reduce Your Database Costs by over 90%
Thursday, November 8, 2007 (Italian)
MySQL AB, the company behind the MySQL Server, expands its
presence in Italy and invites you to:
- Learn more about open source and MySQL
- Learn about functionalities and services to better plan
your MySQL deployments
- Understand how to select the right MySQL solution for your
applications
- Get your questions answered by the MySQL experts and
provide the MySQL team with input
- Meet the MySQL Italy team members and build relationships
Whether you are a developer, a DBA, or an IT decision maker,
the MySQL AB in Italia event is an opportunity to learn more
about open source, the MySQL offerings and how to make best
use of it.
Register for the Webinar:
htt
p://www-it.mysql.com/news-and-events/milano07/
Live Webinar: Designing, Evaluating and Benchmarking MySQL
Cluster
Thursday, November 08, 2007
In this webinar learn the fundamentals of how to design and
select the proper components for a successful MySQL Cluster
evaluation. We will explore hardware, networking and
software requirements. Work through a basic installation,
functional testing and ongoing best practices for
maintaining the system. Finally, we will close with an
examination of the recent benchmark results performed in
conjunction with Intel and Dolphin Interconnect Solutions.
Register for this Webinar:
http://www.mysql.com/news-and-events/web-semina
rs/display-68.html
Live Webinar: MySQL vs. SQL Server Express: an ISV
Perspective
Wednesday, November 14, 2007
ISVs face a number of key decisions when designing,
developing, and delivering a new solution to market. One of
the most important determinations revolves around selecting
an embedded database to include with their new product.
Hundreds of successful ISVs have already done their homework
and chosen MySQL as their data storage architecture. This
has radically altered the dynamics of the relational
database market, especially with regard to embedded
solutions.
Register for the Webinar:
http://www.mysql.com/news-and-events/web-semina
rs/display-69.html
------------------------------------------------------------
-------
Training, Consulting, and Certification
Consulting: MySQL Scale-Out, High-Availability and
Replication Jumpstart (4 Days)
In this engagement, a dedicated MySQL certified consultant
will work closely with your team to:
- Analyze your Scale-out and High-Availability database
requirements
- Identify potential issues and limitations
- Install, Configure and Fine-Tune MySQL
- Configure MySQL or MySQL Cluster to work with HA
Technologies (e.g. DRBD, SAN, Shared SCSI, Heartbeat, etc),
as required
- Secure your database environment against failures and
downtime
- And more ...
Schedule your Schedule Your Engagement Now:
http://www.mysql.com/consulting/packaged/scaleout.html
Training: MySQL Partitioning MySQL (Virtual Course, 1 Day)
November 2007
This instructor-led course is designed for MySQL users who
would like to use the new partitioning features available in
the MySQL 5.1. This course provides in-depth information in
an E-Learning classroom format that is easily accessible and
affordable.
Register Now for an Upcoming Date:
http://www.mysql.com/training/courses/mysql_partiti
oning.html
------------------------------------------------------------
-------
Partners
Rippletech White Paper
Winning the War Against Inside Threats: Actionable
Strategies for Safeguarding Critical MySQL Data
Today's headlines confirm the potential outcomes of
ineffective IT security systems. Companies are suffering
serious consequences-from stolen customer data and
intellectual property to insider threats who can compromise
the comprehensive perimeter security. In addition,
increasing privacy and security regulation presents a
complex challenge for organizations that must secure massive
amounts of data, monitor complex applications, and manage
large numbers of users. Read about how RippleTech is help
MySQL Enterprise users win the war against inside threads
at:
Download the White Paper:
http://www.rippletech.com/up
loads/Informant/Internal%20MySQL%20Threat_Whitepaper.pdf
The MySQL Team
About the Newsletter
You can send us queries and give us feedback online.
http://www.mysq
l.com/company/contact/
You can unsubscribe from this newsletter online:
http://www.my
sql.com/unsub?email=nesstosharedlog.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.
|