- Live Webinar: Migrating from Access to MySQL - White Paper: A Guide for Migrating From Microsoft Access to MySQL - Case Study: MySQL Cluster Helps Mapion to Improve its User Experience - Quick Poll: What information do you find most useful in the MySQL Newsletter? - New Java and MySQL Resources Page - Upcoming MySQL University Sessions - Test Drive MySQL Enterprise Monitor for 48 Hours
New Product Releases
- New Release of MySQL Community Server 5.1.40 (GA) - New Release of MySQL Community Server 5.0.87 (GA) - New Release of MySQL Cluster 7.0.8a (GA)
Hints & Tips
- White Paper: A Visual Guide to Installing MySQL Embedded Server on Windows - White Paper: Best Practice Guide: Developing Subscriber Databases with MySQL Cluster - Case Study: be2 Scales Fast Growing Matchmaking Web Site with MySQL Enterprise - PlanetMySQL Blog Posts - PlanetMySQL Blog: Silent Install Instructions - PlanetMySQL Blog: Long running transactions - PlanetMySQL Blog: PHP/C: Does MYSQL[I]_OPT_CONNECT_TIMEOUT work? - PlanetMySQL Blog: Agents, Hosts and Instances, Oh My!
- PlanetMySQL Blog: Data type confusion: what is an int(11)? - PlanetMySQL Blog: InnoDB Plugin (With some Windows focus) - Part 1 - PlanetMySQL Blog: Some friendly advice for bootstrapping your OSS - PlanetMySQL Blog: MySQL and hardware information - PlanetMySQL Blog: PHP: 150 performance tuning screws for mysqlnd - PlanetMySQL Blog: Secure Your Server - Tips for DBAs - PlanetMySQL Blog: MySQL Cluster 7.0.9a source release now available - replaces 7.0.9 - PlanetMySQL Blog: MySQL Cluster: Errors faced while importing data - PlanetMySQL Blog: Configuring MySQL Cluster for Large Databases - PlanetMySQL Blog: Make MySQL refuse connections until data nodes are started - PlanetMySQL Blog: How MySQL Cluster Executes Queries
Events
- Live Webinar: Memcached and MySQL for Rapidly Scaling High Traffic Websites (November 12) - Live Webinar: MySQL Cluster: Geographic Replication Deep-Dive (November 24) - Live Webinar: Migrating from SQL Server to MySQL (December 3) - Live Webinar: For ISVs and OEMs: Getting Maximum Scalability and Availability with Java and MySQL (December 8) - Live Webinar: Optimizing Queries for Performance (December 9) - Live Webinar: Why LiveTime Software Provides SQL Server to MySQL Migration for its Customers (December 15) - Live Webinar: Windows Server Failover Clustering with MySQL (December 3, 17) - On Demand Webinars: Java, Windows & More - MySQL Seminar: The Revolution of the Open Source Data Warehouse (November 18, Milan)
Training, Consulting, & Certification
- Consulting: MySQL Developer (4+ Days) - Training: MySQL High Availability (3 Days)
Partners
- Calpont: MySQL Database Analytics with InfiniDB from Calpont - Joyent: Read/Write Load Balancing for MySQL with ZXTM in the Joyent Public Cloud (Webinar, November 17)
Live Webinar: Migrating from Access to MySQL Thursday, November 19, 2009 10:00 PST (Americas) Thursday, November 19, 2009 15:00 CET (EMEA)
In this webinar we will explore the benefits of migrating Microsoft Access data to MySQL including migration best practices, migration tools, scripts and datatype mapping. Finally, we will demonstrate how to leverage Access front-ends with a MySQL-backend.
Register Now (Americas): http://www.mysql.com/news-and-events/web-seminars/display-442.html
Register Now (EMEA): http://www.mysql.com/news-and-events/web-seminars/display-451.html
White Paper: A Guide for Migrating From Microsoft Access to MySQL
Many MySQL customers are migrating from Microsoft Access because they have reached the conclusion that the combination of enhanced scalability (both in terms of concurrent userload and overall data volume), cost-savings, platform freedom, and feature set of MySQL make for a compelling business case to offload some or all their Access applications to the MySQL database server.
Case Study: MySQL Cluster Helps Mapion to Improve its User Experience
Headquartered in Tokyo, Japan, Mapion Co. Ltd delivers Japan's leading online map search service, with over 700,000 page views per day, and over 200 enterprise customers. Mapion's shareholders include Toppan, NTT East, Dentsu, Yahoo Japan, and Sharp.
Read this Case Study: http://www.mysql.com/why-mysql/case-studies/mysql_cs_mapion.php
Newsletter Quickpoll: What information do you find most useful in the MySQL Newsletter?
Take the Quickpoll: http://dev.mysql.com/tech-resources/quickpolls/newsletter-interests.html
New Java and MySQL Resources Page
Java is the number one most popular language for developing MySQL applications according to our most recent Annual MySQL Survey. The mysql.com/java page is a compilation of the variety of resources - from formal tutorials to discussion forums - that can help you develop and optimize your Java and MySQL applications.
Visit the Java Resources Page: http://www.mysql.com/why-mysql/java/
Upcoming MySQL University Sessions
MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals. MySQL University sessions are open to anyone, not limited to Sun employees. Sessions are recorded with slides and audio, so if you can't attend the live session you can review the recording anytime after the session.
Upcoming sessions include:
- November 12: Gearman for MySQL (Giuseppe Maxia) - November 19: memcached Functions for MySQL (UDFs) (Patrick Galbraith) - November 26: The Spider Storage Engine (Giuseppe Maxia) - December 3: Practical Full-Text Search in MySQL (Bill Karwin)
You can now Test Drive the MySQL Enterprise Monitor with no download or installation required. MySQL will provide you access to demo servers to test MySQL Enterprise Monitor for 48hrs.
New Product Releases
New Release of MySQL Community Server 5.1.40 (GA)
MySQL Community Server 5.1.40, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.40 is recommended for use on production systems.
View the complete list of changes: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-40.html
Download Now: http://dev.mysql.com/downloads/mysql/5.1.html
New Release of MySQL Community Server 5.0.87 (GA)
MySQL Community Server 5.0.87, a new version of the popular Open Source Database Management System, has been released. This and future releasesin the MySQL Community Server 5.0 series share version numbers with their MySQL Enterprise Server counterparts.
View the complete list of changes: http://dev.mysql.com/doc/refman/5.0/en/news-5-0-87.html
This release includes a fix for Bug#47844, which was discovered in MySQL Cluster NDB 7.0.8 shortly after release. The MySQL Cluster NDB 7.0.8a release is identical in all other respects to MySQL Cluster NDB 7.0.8.
White Paper: A Visual Guide to Installing MySQL Embedded Server on Windows
The goal of this guide is to make getting started with MySQL Embedded Server on the Windows platform easy for commercial application developers (ISVs/OEMs) who are new to MySQL and/or are used to using SQL Server. This paper will guide you through the steps and tools needed to get up and running quickly with MySQL Embedded Server on Windows using familiar terms, comparisons, and language.
Read the White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_embedded_visual_guide.p hp
White Paper: Best Practice Guide: Developing Subscriber Databases with MySQL Cluster
In this new paper we describe how MySQL Cluster Carrier Grade Edition can be used to build a scalable, highly available, geographically replicated Subscriber Database. We show how user-defined partitioning and distribution keys help a subscriber database to scale its performance linearly with cluster size, while maintaining the benefits of a relational database, accessed via an SQL API.
Read this White Paper: http://www.mysql.com/why-mysql/white-papers/mysql_wp_subscriber_db.php
Case Study: be2 Scales Fast Growing Matchmaking Web Site with MySQL Enterprise
be2 started in 2004 with its German web site be2.de and is now one of the world's leading matchmaking services with more than 17 million members in 36 countries and 20,000 new members joining be2 every day.
Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_be2.php
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.planetmysql.org/newfeed.php
PlanetMySQL Blog: Silent Install Instructions Lee Stigle
This entry provides instructions for "silently" installing MySQL on a Microsoft Windows server. I use the term "silent install" to describe the method of passing parameters to the Microsoft Installation Package (MSI) to bypass installation screens. This allows you to deploy MySQL with your application and to install MySQL without end-user intervention. The developer can define the install location, the appropriate storage engines, the root password and the server configuration.
Read the PlanetMySQL Blogpost: http://lstigile.wordpress.com/2009/11/02/silent-install-instructions/
PlanetMySQL Blog: Long running transactions Mark Callaghan
I was debugging a server that had too many concurrent queries. From SHOW INNODB STATUS output, there were many long running transactions with uncommitted work and there were many more transactions blocked on InnoDB locks. This is not a good state for a busy OLTP server and I am trying to figure out if the problem is the application or InnoDB.
Read the PlanetMySQL Blogpost: http://www.facebook.com/note.php?note_id=172915805932
PlanetMySQL Blog: PHP/C: Does MYSQL[I]_OPT_CONNECT_TIMEOUT work? Ulf Wendel
C and PHP MySQL clients can set a connection timeout before a connection is established to MySQL. The MySQL C API manual states about MYSQL_OPT_CONNECT_TIMEOUT, which is equal to PHPs MYSQLI_OPT_CONNECT_TIMEOUT:
That is half of the story. The actual behaviour depends on the library you use, the operating system and the transport protocol (TCP/IP, Unix domain sockets, Windows named pipes, Shared Memory).
Read the PlanetMySQL Blogpost: http://blog.ulf-wendel.de/?p=273
PlanetMySQL Blog: Agents, Hosts and Instances, Oh My!
Jonathon Coombes
The MySQL Enterprise Monitor (MEM) is designed to collect data from installations of MySQL and report back to the service manager so that information can be correlated and displayed in an easy to read form on the dashboard. What does become confusing sometimes for people is that the item displayed on the dashboard gives a hostname, but you have multiple databases running on that host?! How does MEM distinguish between all these installs of MySQL versus the hosts they are running on and how the data is collected for each one?
Read the PlanetMySQL Blogpost: http://blogs.sun.com/DatabaseEmporium/entry/agents_hosts_and_instances_oh
PlanetMySQL Blog: Data type confusion: what is an int(11)? Sarah Sproehnle
Over and over I see customers that don't understand what int(11) really means. Their confusion is understandable. Many know what defining a char(10) means (a fixed-sized character string that allows up to 10 characters). However, ints are different.
Read the PlanetMySQL Blogpost:
http://everythingmysql.ning.com/profiles/blogs/data-type-confusion-what-is-a n
PlanetMySQL Blog InnoDB Plugin (With some Windows focus) - Part 1 Anders Karlsson
So InnoDB is now, from 5.1.38, distributed with MySQL. It is still not enabled by default though. What this means is that there are 2 InnoDB implementations that comes with your MySQL installation. The old-school standard one, which is compiled in with the MySQL binary and is enabled by default, and one plugin.
PlanetMySQL Blog: Some friendly advice for bootstrapping your OSS project Lenz Grimmer
So you're a small startup company, ready to go live with your product, which you intend to distribute under an Open Source License. Congratulations, you made a wise decision! Your developers have been hacking away frantically, getting the code in good shape for the initial launch. Now it's time to look into what else needs to be built and setup, so you're ready to welcome the first members of your new community and to ensure they are coming back!
PlanetMySQL Blog: MySQL and hardware information Sheeri Cabral
People often ask "what's the best hardware to run a database on?" And the answer, of course, is "it depends". With MySQL, though, you can get good performance out of almost any hardware.
If you need *great* performance, and you have active databases with a large data set, here are some statistics on real life databases - feel free to add your own.
Read the PlanetMySQL Blogpost: http://www.pythian.com/news/3893/mysql-and-hardware-information
Yes, 150 means we added some 30 performance statistics to the MySQL native driver for PHP (mysqlnd) since monday. The new statistics are explained in three words: counting COM_* commands. COM_* commands refers to the command packets of the MySQL client server protocol. For example, COM_QUERY is used to execute nonprepared SQL statements.
Read the PlanetMySQL Blogpost: http://blog.ulf-wendel.de/?p=271
PlanetMySQL Blog: Secure Your Server - Tips for DBAs Everything MySQL
It has been the responsibility of the DBA to implement a security strategy, at least on the database level. All DBAs should take action, if not already, by taking a proactive approach to this crucial part of database administration. For this post I have compiled a list of general best practices below.
Read the PlanetMySQL Blogpost: http://everythingmysql.ning.com/profiles/blogs/secure-your-server-tips-for
PlanetMySQL Blog: MySQL Cluster 7.0.9a source release now available - replaces 7.0.9 Andrew Morgan
The source version for MySQL Cluster 7.0.9a has now been made available at ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.39-ndb-7.0.9a /
PlanetMySQL Blog: MySQL Cluster: Errors faced while importing data Umang Gopani
Here is the list of errors I have faced while importing a 25G .sql file into my cluster setup.
This is a test setup and to get maximum RAM availability, I have 3 data nodes and 1 Management node with replication factor of 1. The solutions provided are the ones which helped me.
Read the PlanetMySQL Blogpost: http://umangg.blogspot.com/2009/10/mysql-cluster-errors-faced-while.html
PlanetMySQL Blog: Configuring MySQL Cluster for Large Databases Johann Andersson
If you need to create a big database into MySQL Cluster with:
- A lot of tables indexes, columns, and tables - A lot of records
PlanetMySQL Blog: Make MySQL refuse connections until data nodes are started Geert JM Vanderkelen
MySQL Cluster 6.3.28 and 7.0.9 introduce the MySQL server option --ndb-wait-setup. This makes sure that clients can not connect the SQL Node when no Data Nodes are available within, by default, 15 seconds. When the timeout is reached, and no Data Nodes are available, the NDB storage engine will be marked as unavailable.
PlanetMySQL Blog: How MySQL Cluster Executes Queries Sarah Sproehnle
This post describes how MySQL Cluster executes queries. First of all, Cluster is a storage engine. It doesn't actually execute queries because it doesn't speak SQL. That is why you use a MySQL server, which parses your queries and sends low-level storage engine API calls to the Cluster data nodes. The data nodes know how to retrieve or store data. Or you can talk to the data nodes directly using the NDB API(s).
Read the PlanetMySQL Blogpost: http://everythingmysql.ning.com/profiles/blogs/how-mysql-cluster-executes
Events
Live Webinar: Memcached and MySQL for Rapidly Scaling High Traffic Websites Thursday, November 12, 2009 - 10:00 am PST
Please join us for this informative technical webinar with MySQL, Glam Media and Gear6. Glam Media was the 2nd fastest growing US-based web property in 2008 and continues to increase its unique visitor count by over 100% annually.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-458.html
Live Webinar: MySQL Cluster: Geographic Replication Deep-Dive - EMEA Tuesday, November 24, 2009 - 10:00am CET (EMEA)
MySQL Cluster has been deployed into some of the most demanding web, telecoms and enterprise/government workloads, supporting 99.999% availability with real time performance and linear write scalability.
Tune into this webinar where you can hear from the MySQL Cluster product management team provide a detailed "deep dive" into one of MySQL Cluster's key capabilities - Geographic Replication.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-463.html
Live Webinar: Migrating from SQL Server to MySQL Thursday, December 03, 2009 - 10:00am PST
Join us for Part 5 of the Windows and MySQL webinar series with Jimmy Guerrero and Mike Frank of the MySQL group at Sun Microsystems. In this presentation we will explore the benefits of migrating from Microsoft SQL Server to MySQL. We will also cover migration best practices, as well as, an overview of migration tools, scripts, datatype mapping and functional equivalents. If you are interested in learning how to migrate from SQL Server to MySQL, this webinar is for you.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-443.html
Live Webinar: For ISVs and OEMs: Getting Maximum Scalability and Availability with Java and MySQL Tuesday, December 08, 2009 - 10:00am PST
In this technical webinar, Mark Matthews will review the various MySQL-provided and third-party options for horizontally scaling J2EE applications that use MySQL on commodity hardware and making those applications highly available. He will provide the information you need to determine which option is best for your particular application.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-462.html
Live Webinar: Optimizing Queries for Performance Wednesday, December 09, 2009 - 10:00am CET (EMEA)
In this webinar we will show different methods to analyze and optimize queries to increase the performance of your MySQL database. We will focus on identifying problematic queries, analyzing their impact and possible optimizations. Examples will be shown during a live demo.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-465.html
Live Webinar: Why LiveTime Software Provides SQL Server to MySQL Migration for its Customers Tuesday, December 15, 2009 - 10:00am PST
LiveTime has been providing ITIL Service Management and Help Desk products to global 2000 companies for more than 8 years and has recently witnessed significant interest from customers in migrating from SQL Server to MySQL. In this webinar you will learn why LiveTime decided to offer a free migration service for its customers as well as optimizations and performance characteristics.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-466.html
Live Webinar: Windows Server Failover Clustering with MySQL Thursday, December 03, 2009 - 15:00 CET (EMEA) Thursday, December 17, 2009 - 10:00am PST (Americas)
Join us for Part 6 of the Windows and MySQL webinar series with Jimmy Guerrero and Mike Frank of the MySQL group at Sun Microsystems. In this presentation we will explore the benefits of leveraging Microsoft Windows 2008 Server Failover Clustering with MySQL. We will also cover step by step, how to get started installing and configuring Failover Clustering. Finally, we will look at best practices concerning MySQL storage engine selection and behaviors with Failover Clustering. If you are interested in learning how to leverage Windows 2008 Server Failover Clustering with MySQL, this webinar is for you.
Register for this Webinar (EMEA): http://www.mysql.com/news-and-events/web-seminars/display-452.html
Register for this Webinar (Americas): http://www.mysql.com/news-and-events/web-seminars/display-444.html
On Demand Webinars
MySQL is pleased to make the following On-Demand Web Seminars available. They are recorded replays of our most popular live Web Seminars:
Introduction to MySQL on Windows (German): http://www.mysql.de/news-and-events/on-demand-webinars/display-od-454.html
Introduction to MySQL on Windows (Italian): http://www.mysql.it/news-and-events/on-demand-webinars/display-od-421.html
All On Demand MySQL Web Seminars: http://www.mysql.com/news-and-events/on-demand-webinars/
MySQL Seminar (Italian): The Revolution of the Open Source Data Warehouse November 18, 2009 - Milan
This event is designed *for decision makers* to learn more about how to use MySQL and complementary partner products from Talend and Infobright in order to lower the Data Warehouse TCO by up to 90%. During this event you will have plenty of opportunities to discuss the topic with our presenters and network with your peers.
A dedicated MySQL certified consultant will work closely with your team to:
- Analyze your current database application - Analyze your database requirements - Identify potential issues and limitations - Benchmark, load test, and optimize critical SQL queries - Help them implement best practices and recommend tools for developing your database infrastructure
Training: MySQL High Availability (3 Days) London, Paris, Milan, Chicago, Hamburg
This course is designed for experienced database administrators and system architects that want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL. This course will provide the tools required to make the decision of what high availability solution is appropriate and how to implement a system with the correct design.
Register Now for an Upcoming Date: http://www.mysql.com/training/courses/mysql_5_ha.html
-------------------------------------------------------------------
Partners
Article: MySQL Database Analytics with InfiniDB from Calpont
Let's be honest: working with big databases is a lot of fun. There's something cool about dealing with tables that have hundreds of millions or billions of rows in them, loading huge amounts of data, building star and snowflake schemas for data warehouses/marts, optimizing query performance, and all that jazz.
Read the Article - Part 1:
http://dev.mysql.com/tech-resources/articles/mysql_datawarehouse_calpont1.ht ml
Read the Article - Part 2:
http://dev.mysql.com/tech-resources/articles/mysql_datawarehouse_calpont2.ht ml
Live Webinar: Read/Write Load Balancing for MySQL with ZXTM in the Joyent Public Cloud Tuesday, November 17, 2009 - 10:00am PST
Join us for this informative technical webinar with Raja Srinivasan - Zeus Technology, Rod Boothby - Joyent, and Jimmy Guerrero - Sun Microsystems, where we will explore how to load balance MySQL in the Joyent Public Cloud with ZXTM.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-441.html
It's true that Apple is just as proprietary a company as Microsoft. Some might say more so. But there is a big difference between competing with proprietary products and holding a monopoly with them which you use to keep open source down.
There is a reason that history records a case called U.S. vs. Microsoft. Microsoft has both a monopoly and a proven record of using its power to keep open source from gaining a foothold.
Apple, meanwhile, has just a 10% share of the operating system market. Sure, if they had more they might be dangerous, just like if I looked like Antonio Banderas I might be a movie star.
Microsoft did not really change its tune after the court case wound down.
* Microsoft subsidizes the channel so every PC in the store runs Windows, even netbooks where that's more trouble than it's worth. * Sharepoint is designed specifically to extend its monopoly. * Remember the OOXML standards battle, where Microsoft corrupted the standards process itself to maintain control of the applications market? * The Novell deal, in which Linux vendors admit that 2+2=5 so Microsoft won't assert non-existent patent claims against them, still gets me mad every time I think about it.
Now it's true that Apple supports Digital Rights Management (DRM), and limits what users can do. The Free Software Foundation is dead set against DRM. But this was the industry's price for even letting Apple offer a product like the iPod.
The music industry's reaction led to Apple offering to forego DRM and may be the biggest victory open source won in this decade.
Or take the iPhone. Sure it's designed to enforce AT&T's control of bits, and in so doing enforce Apple's control of what you do with the device. But it's the Apple-AT&T relationship that is objectionable. The handset market is increasingly competitive.
The whole idea that the Free Software Foundation should go against Apple rather than Microsoft, then, is a straw man. Apple may want the control over users and markets that Microsoft has enjoyed this decade, but it doesn't have that control, nor is it likely to achieve it.
The Nooku team is delighted to announce that the Nooku Framework has been publicly released — made available at Sourceforge.net
The framework - which was announced last May - empowers Joomla! 1.5 to new levels and is designed to provide third-party developers with Joomla's missing MVC.
Lead architect, Johan Janssens, said the framework will provide developers with "future-proof" tools to "enable exciting and efficient ways to make Joomla better through extendable developement."
For the time being access is only available using Subversion (SVN). Installable packages will be made available once we hit our 0.7 milestone. There's a good reason for that: there's little documentation at the moment, and we don't want to get flooded by emails from people with support questions. The SVN serves as a simple filter.
So where do you go if you have questions ? Simply fill out the form to request access. It only takes two minutes of your time. It's a win-win: We get to know a little about you, and you get access to our discussion mailing list, where all the good stuff happens.
... oh, and you get to use the most advanced framework ever built for Joomla.
Nooku Framework is created by award-winning developers and founding members of Joomla who have been responsible for creative innovation in code for many years.
- The MySQL Librarian is Here - Find and Add MySQL Content! - Twitter: Follow the MySQL Community on Twitter! - Meet MySQL Experts at OpenSQL Camp Europe (August 22-23, Germany) - Case Study: MySQL Helps Simply Accounting by Sage Increase Revenue, Market Share, and Customer Satisfaction - Case Study: TweetMeme Manages Explosive Growth with MySQL Enterprise - Live Webinar: Introduction to MySQL Scale Out and Replication Services (Tuesday, August 18, 2009) - Live Webinar: MySQL at Clickability - Growing Small and Mid-Sized Businesses Fast on MySQL (Thursday, August 27, 2009)
New Product Releases
- New Release of MySQL Server 5.0.84 (GA) - New Release of MySQL Server 5.1.37 (GA) - New Release of MySQL Workbench 5.2.2 (Alpha) - New Release of MySQL Connector/Net 5.2.7 (GA) - New Release of MySQL Connector/Net 6.1.0 (Alpha) - New Release of MySQL Connector/J 5.1.8 (GA)
Hints & Tips
- White Paper: Open Databases White Paper - MySQL Provides Scalability, Reliability & Enterprise Support at a Lower Cost - White Paper: Guide to Using Open-source Software to Develop Web Applications - White Paper: MySQL Enterprise for Small and Mid-sized Businesses - Article: MySQL - Five More Dials To Turn - PlanetMySQL Blog Posts - PlanetMySQL Blog: OPTIMIZE TABLE on MySQL Cluster (revisited) - PlanetMySQL Blog: Understanding Different MySQL Index Implementations - PlanetMySQL Blog: Setting up MySQL Asynchronous Replication for High Availability - PlanetMySQL Blog: Possible Improvements to MySQL Administration - PlanetMySQL Blog: Disabling binary logging when restoring a MySQL dump - PlanetMySQL Blog: Auto-create relationships for MyISAM tables in MySQL Workbench
Spotlight: MySQL on Microsoft Windows
- White Paper: A Visual Guide to Installing MySQL on Windows - White Paper: A Visual Guide to Microsoft SQL Server 2008 Reporting Services and MySQL - White Paper: Guide to MySQL Embedded Server for Microsoft Windows - PlanetMySQL Blog: MySQL Windows Install Troubleshooting - Live Webinar: For ISVs - What's New in MySQL Connector/NET 6.1? (Tuesday, September 15, 2009)
Events
- Live Webinar: Tuning and Optimizing MySQL for Maximum Performance (Thursday, September 03, 2009) - Live Webinar: Advanced Techniques for High Traffic Sites (Thursday, September 17, 2009) - Live Webinar: For ISVs - Architecting Embedded Databases for High Performance Applications (Wednesday, September 23, 2009) - Live Webinar: High Availability Architectures for Online Applications (Tuesday, September 29, 2009)
Training, Consulting, & Certification
- Training: MySQL Performance Tuning (4 Days) - Consulting: MySQL Architecture and Design (2+ Days)
Partners
- Press Release: MySQL on the optimized Joyent Cloud is 3x faster than Amazon EC2! - Live Webinar: Kimball Group Data Warehousing Educational Webinar Series - Part II: Dimensional Modeling 101 (Wednesday, September 9, 2009)
The MySQL Librarian is Here - Find and Add MySQL Content!
We're pleased to announce the MySQL Librarian, a collection of community-generated and cross referenced content related to MySQL. It's a place where the community collaboratively builds and maintains MySQL content. Everyone is encouraged to add articles, presentations, videos, and pictures to the librarian.
Visit the MySQL Librarian: http://dev.mysql.com/librarian/
Read the Article "Introducing the MySQL Librarian": http://dev.mysql.com/tech-resources/articles/introducing-librarian.html
Read the Tutorial:
http://datacharmer.blogspot.com/2009/07/automating-mysql-librarian-tasks.htm l
Twitter: Follow the MySQL Community on Twitter!
In addition to MySQL, the MySQL Community has a separate Twitter account, with more than 1,000 followers. This account listens to and interacts with the MySQL community, by answering requests, announcing community related information, and giving advice. Join this big family by following the MySQL Community Twitter account.
Follow MySQL Community on Twitter: http://twitter.com/mysql_community
Meet MySQL Experts at OpenSQL Camp Europe (August 22-23, Germany)
The OpenSQL Camp Europe is being held in Sankt Augustin, Germany, in conjunction with FrOSCon on August 22 and 23. Many MySQL and open-source database talks will be presented, so if you are in Europe, it's definitely worth a visit. FrOSCon is one of the most charming and well organized open source events in Europe.
Learn More about OpenSQL Camp: http://opensqlcamp.org
Learn More about FrOSCon: http://froscon.org
Case Study: MySQL Helps Simply Accounting by Sage Increase Revenue, Market Share, and Customer Satisfaction
The Sage Group plc, is one of the world-wide market leaders in accounting and business management software and services for small and medium-sized businesses (SMBs), with over 5.8 million customers. In the Canadian market, Simply Accounting by Sage is the established market share leader in the small to mid-size business accounting software market with 54% of the Canadian retail market.
MySQL is now the new Sage database standard for Sage's small-to-medium targeted products. At present this includes Simply Accounting by Sage in Canada, Sage 50 HR in the UK and Sage's GS product line in Germany.
Read this Case Study: http://www.mysql.com/why-mysql/case-studies/mysql_cs_sage.php
Case Study: TweetMeme Manages Explosive Growth with MySQL Enterprise
Like many social network products, TweetMeme was initially developed in PHP using the MySQL open source database. With Twitter users growing at a month-over-month rate of approximately 82% for the first half of 2009, TweetMeme needed to manage incredible scalability demands being placed upon its database infrastructure. The nature of real-time search also meant that to stay competitive, TweetMeme needed to be highly available, offer lightning fast service delivery capability, while ensuring that management and administration costs didn't grow out of control.
Read this Case Study: http://www.mysql.com/why-mysql/case-studies/mysql_cs_Tweetmeme.php
Live Webinar: Introduction to MySQL Scale Out and Replication Services Tuesday, August 18, 2009 - 10:00am PDT
Join us for the first in a series of 4 webinars that will explore the different aspects of using MySQL as the database for online applications. With real life experience gained working with MySQL Customers such as Facebook, Alcatel-Lucent, and Google, this webinar series will give you the information you need to run scalable, highly available online applications.
In this first installment we look at the basics for deploying MySQL for a scalable online application. Whether you are already using MySQL for your online application or considering it for a new project, register today to learn how you can make best use of the world's most popular database for online applications.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-400.html
Live Webinar: MySQL at Clickability - Growing Small and Mid-Sized Businesses Fast on MySQL Thursday, August 27, 2009 - 10:00am PDT
MySQL is a proven business-critical database that provides incredible scale and performance at a significantly lower total cost of ownership. At the same time, MySQL is also easy to deploy, easy to use, and requires low administration which makes it ideal for small and mid-sized businesses.
In this informative webinar, Jeff Freund, CTO and Co-Founder at Clickability, will discuss how the company builds its core application on MySQL and grows from a small start-up to a global leader in on demand Web Content Management. You'll also learn from Alex Roedling, Sr. MySQL Product Marketing Manager at Sun Microsystems, regarding MySQL's benefits and how it can be leveraged to build a scalable, reliable and high performance platform in your fast-growing business.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-395.html
MySQL Community Server 5.0.84, a new version of the popular Open Source Database Management System, has been released. This and future releases in the MySQL Community Server 5.0 series share version numbers with their MySQL Enterprise Server counterparts.
View the complete list of changes: http://dev.mysql.com/doc/refman/5.0/en/news-5-0-84.html
MySQL Community Server 5.1.37, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.37 is recommended for use on production systems.
View the complete list of changes: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-37.html
Read the Documentation: http://dev.mysql.com/doc/refman/5.1/en/index.html
New Release of MySQL Workbench 5.2.2 (Alpha)
The MySQL Workbench team announces the availability of version 5.2.2 - the 3rd alpha release - of our database development tool. Since the last alpha release, several bugs have been fixed and fixes from the 5.1 branch were also included.
View the complete list of changes: http://dev.mysql.com/workbench/?page_id=49
MySQL Connector/Net 5.2.7, a new version of the all-managed .NET driver for MySQL has been released. This release is of GA quality and is suitable for use in production environments. We have many fixes in this release so please review the changelog and see if your favorite bug has been fixed. This version officially supports all versions of MySQL from 4.1 and later.
View the complete list of changes: http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-5-2-7.html
MySQL Connector/Net 6.1.0, a new version of the all-managed .NET driver for MySQL has been released. This is an alpha release and is intended to introduce you to the new features and enhancements we are planning. This release should not be used in a production environment. Additional functions include:
- Support for native output parameters - Session State Provider - Website Configuration Dialog
View the complete list of changes: http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-6-1-0.html
MySQL Connector/J 5.1.8, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.8 is suitable for use with any MySQL version, including version 4.1, 5.0, 5.1 and the 5.4 performance release.
View the complete list of changes: http://dev.mysql.com/doc/refman/5.1/en/cj-news-5-1-8.html
White Paper: Open Databases White Paper - MySQL Provides Scalability, Reliability & Enterprise Support at a Lower Cost
Enterprises are looking for the best, most cost-effective way to manage the ever-increasing amount of data, an ever-growing pool of users, and unrelenting demands for high availability. As proprietary database systems have grown increasingly complex with features that many companies don't need, they have also become harder to manage and more expensive in terms of upgrades and staffing, training, and support. The Sun MySQL database delivers the scalability and features that companies need but with less complexity and lower costs than proprietary systems.
Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_open_online_database.ph p
White Paper: Guide to Using Open-source Software to Develop Web Applications
As enterprises struggle to develop and deliver new and more dynamic services to more people, they must do so with severe budget constraints. They need a Web infrastructure that can enable higher developer productivity at a lower cost. While many enterprises are looking to open-source software to meet these complex requirements, managing and supporting a range of disparate software solutions is a huge challenge for the IT staff.
Read this White Paper: http://www.mysql.com/why-mysql/white-papers/mysql_wp_open_web_platform.php
White Paper: MySQL Enterprise for Small and Mid-sized Businesses
This paper explores the database, monitoring and support components of MySQL Enterprise and how Small and Mid-Sized businesses under pressure to "do more with less" can confidently deploy it as part of a cost-effective and low-maintenance platform, ideal for delivering Internet-based applications for fast-growing businesses.
Read this White Paper: http://www.mysql.com/why-mysql/white-papers/mysql_wp_Enterprise_SMB.php
Article: MySQL - Five More Dials To Turn Sean Hull
Last month we talked about some things to set and tune in a new MySQL database installation. We touched on connections, query cache, temp tables, session memory, and the slow query log. This second part in the series hits on some other very important things to tune in a new MySQL database.
Read this Article:
http://www.databasejournal.com/features/mysql/article.php/3828566/article.ht m
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 about MySQL, including technical tips and best practices.
Visit PlanetMySQL: http://planet.mysql.com/
Submit Your Blog Feed: http://planet.mysql.com/new
PlanetMySQL Blog: OPTIMIZE TABLE on MySQL Cluster (revisited) Johan Andersson
Before, OPTIMIZE TABLE hardly freed up any pages and to defragment you had to do a rolling restart of the data nodes. Now, there is only a 2% discrepancy between OPTIMIZE TABLE and doing a rolling restart. This is great stuff. This fix will make into MySQL Cluster 6.3.26 and 7.0.7.
PlanetMySQL Blog: Understanding Different MySQL Index Implementations Ronald Bradford
It is important to know and understand that while indexing columns in MySQL will generally improve performance, using the appropriate type of index can make a greater impact on performance.
PlanetMySQL Blog: Setting up MySQL Asynchronous Replication for High Availability Andrew Morgan
MySQL replication is often positioned as a solution to provide extra throughput for your database. What tends to be overlooked is how it can be used to provide high availability (HA) - no matter how much redundancy you have at a local level, your system remains at risk from a single catastrophic failure - loss of power, earthquake, terrorist attack etc.
PlanetMySQL Blog: Possible Improvements to MySQL Administration Simon Mudd
One thing you learn when you start to manage several servers is that life is easier if things are done the same way. I manage a few MySQL database instances on a few different hosts and here are a list of some things which I think could do with improvement.
Read the PlanetMySQL BlogPost: http://blog.wl0.org/2009/07/possible-improvements-to-mysql-administration/
PlanetMySQL Blog: Disabling binary logging when restoring a MySQL dump Geert JM Vanderkelen
There is a cool option for mysqlbinlog for disabling the binary log when doing recovery using binary logs, namely --disable-log-bin. How, one would think it is also available for something like mysqldump or even the mysql CLI?
PlanetMySQL Blog: Auto-create relationships for MyISAM tables in MySQL Workbench Alfredo Kojima
Over a chat on the #workbench IRC channel, Collin Cusce has written a handy little Lua script to automatically create relationships (through foreign keys) for his reverse engineered database.
Read the PlanetMySQL BlogPost: http://dev.mysql.com/workbench/?p=271
White Paper: A Visual Guide to Installing MySQL on Windows
This guide is meant to make getting started with MySQL easily for Windows developers, system administrators and Microsoft SQL Server DBAs that are new to MySQL. This paper will guide you through the steps and tools needed to get up and running quickly with MySQL on Windows using familiar terms, comparisons, and language.
White Paper: A Visual Guide to Microsoft SQL Server 2008 Reporting Services and MySQL
For many years, Microsoft Windows has been the most popular development platform and second most popular production platform for organizations developing MySQL applications. We also found that roughly one in three MySQL Enterprise shops also made use of Microsoft SQL Server. In this paper we will visually show you how to connect MySQL into some of the existing tools that the SQL Server DBA will already be familiar with.
Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_MSReporting_Services.ph p
White Paper: Guide to MySQL Embedded Server for Microsoft Windows
This Guide outlines the reasons why MySQL on Windows continues to be a popular choice for independent software vendors, original equipment manufacturers, and hosting providers. In addition, it provides tips and links to various resources on how to develop and optimize MySQL applications on Windows.
PlanetMySQL Blog: MySQL Windows Install Troubleshooting Lee Stigile
If you're having trouble installing MySQL 5.1 on a Windows server, I'd recommend the following process. Don't skip the first steps that describe the uninstall and removal of the previous install as this seems to clear up most issues.
Live Webinar: For ISVs - What's New in MySQL Connector/NET 6.1? Tuesday, September 15, 2009 - 10:00am PDT
MySQL Connector/Net 6.1.0 is the latest version of the all-managed .NET driver for MySQL. In this Web seminar, Reggie Burnett, the creator of MySQL Connector/NET 6.1, will introduce you to its new features and enhancements and explain how and when to use them for optimal results with your Windows applications.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-407.html
Live Webinar: Tuning and Optimizing MySQL for Maximum Performance Thursday, September 03, 2009 - 10:00am PDT
Join us for the second of our 4 part webinar series exploring the different aspects of using MySQL as the backend database for online applications.
For our second installment we will look at performance tuning. You will get expert insight and learn best practices to help you identify those areas of database and application design that will give you the greatest benefits for performance.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-401.html
Live Webinar: Advanced Techniques for High Traffic Sites Thursday, September 17, 2009 - 10:00am PDT
Join us for the 3rd of our 4 part webinar series exploring the different aspects of using MySQL as the database for online applications. In the 3rd part of this webinar series we examine some of the advanced techniques available to service complex, high traffic, online applications.
We will discuss guidelines, best practices and customer examples in the following areas: caching services such as memcache, session management, intelligent load balancing via MySQL Proxy, use of Cloud services for on demand scalability, and using MySQL Enterprise and the new MySQL Query Analyzer.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-402.html
Live Webinar: For ISVs - Architecting Embedded Databases for High Performance Applications Wednesday, September 23, 2009 - 10:00am PDT
In this Web seminar you'll learn the tips and tricks for architecting your application's embedded or bundled database for higher performance and customer satisfaction.
Using MySQL Embedded Server as our example, the MySQL Consulting pros will take you through the steps they use to optimize MySQL Embedded Server to achieve highest database and application performance. They will also help you find the right answers to important architecture choices that can impact your application's performance.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-405.html
Live Webinar: High Availability Architectures for Online Applications Tuesday, September 29, 2009 - 10:00am PDT
Join us for the last of our 4 part webinar series exploring the different aspects of using MySQL as the backend database for online applications. In this last installment we look at MySQL high availability technologies and architectures. We will explore the use cases for implementing MySQL Replication, MySQL Cluster, Distributed Replicated Block Device (DRBD), and other high-availability technologies
Also covered will be the fundamentals of how these technologies work and how they can be combined to create a more scalable and highly available database infrastructure. Several case studies will be presented to show how these technologies have been implemented in the real world.
Register for this Webinar: http://www.mysql.com/news-and-events/web-seminars/display-403.html
More free MySQL Webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.
View the full list of MySQL Webinars: http://www.mysql.com/news-and-events/web-seminars/index.html
Training: MySQL Performance Tuning (4 Days) Paris, Nashville, Sao Paulo, Portland
The MySQL Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL. This course will prepare you with the skills needed to utilize tools for monitoring, evaluating and tuning. You will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts.
Register Now for an Upcoming Date: http://www.mysql.com/training/courses/performance_tuning.html
Consulting: MySQL Architecture and Design (2+ Days)
A dedicated MySQL certified consultant will work closely with you to review your database application plans and provide an analysis of how to architect them for current and future requirements. Sun's MySQL consultants can provide expertise in the following areas:
- Web Applications - Online Transaction Processing (OLTP) - Data Warehousing - Online Analytical Processing (OLAP) - High Availability - Load Balancing - Embedded Systems - Search Applications
Press Release: MySQL on the optimized Joyent Cloud is 3x faster than Amazon EC2!
Joyent, the industry leading Enterprise-Class Cloud Computing provider is excited to announce the launch of the Joyent Virtual Appliance for MySQL! The Joyent Virtual Appliance for MySQL is pre-configured to maximize the database's performance on Joyent's powerful, secure and stable virtualization technology. The most recent performance benchmarks have demonstrated that the Joyent Virtual Appliance for MySQL can deliver 3 times the number of Transactions per Second or more than comparable deployments of XEN based clouds, such as Amazon's EC2.
Read the Full Press Release: http://www.mysql.com/news-and-events/generate-article.php?id=1625
Learn More about MySQL Enterprise on the Joyent Cloud: http://www.mysql.com/products/enterprise/joyent.html
Register for the Webinar to Learn More: http://www.mysql.com/news-and-events/web-seminars/display-414.html
Live Webinar: Kimball Group Data Warehousing Educational Webinar Series - Part II: Dimensional Modeling 101 Wednesday, September 9, 2009 - 10:00am PDT
According to a recent Aberdeen Group report, top-performing companies deploy business intelligence (BI) at a rate of 2.5x more than their peers. The foundation for any successful BI deployment is the data warehouse (DW). Understanding how to properly design and deploy a DW is therefore key.
In this second webinar presented by Kickfire and Sun, Joy Mundy of The Kimball Group explains the fundamentals of dimensional modeling - the logical design technique for building data warehouses.
Copyright (c) 2009 Sun Microsystems. All rights reserved.
SugarCRM, the world's leading provider of commercial open source customer relationship management (CRM) software, announced three new dates and destinations for its 2009 CRM Acceleration Road Show. MySQL/Sun and Talend will serve as global sponsors.
Event Details:
* September 15 - Austin, Texas * September 16 - Houston, Texas * September 17 - Denver, Colo.
CRM Accelerations are one-day, intensive sessions that help business leaders develop and implement a CRM strategy. These sessions provide attendees with a basic overview of customer relationship management, and progress quickly into real-life demo scenarios, as well as interactive panels with members of the SugarCRM team of experts. CRM Accelerations are geared towards company leaders, both business and technical.
"CRM Accelerations help companies quickly see the value CRM can bring to their business, and how Sugar provides a unique and powerful approach to optimizing your key sales, marketing and support processes," said Chris Harrick, vice president of marketing at SugarCRM. "These hands-on sessions provide the chance for customers to cut through the noise in the CRM marketplace and learn how to get up and running quickly."
Highlights of each CRM Acceleration include:
* "Getting Started With Sugar" will uncover the basics of customer relationship management, and reveal some key aspects of the Sugar solution. * "Creating Leads and Managing Opportunities" will discuss how to better organize and manage the demand generation cycle and better connect your marketing and sales teams. * "Pipeline Management and Reporting" will provide some examples of common metrics used to measure sales effectiveness and how to create, share and manage sales reports within SugarCRM to ensure individuals and teams are aligned around common goals. * "Avoiding CRM Pitfalls" will reveal best practices, as well as bad habits to avoid, while on your way to a successful CRM deployment. * "Ask the Experts" will offer participants an opportunity to interact with SugarCRM product and deployment experts, who will address general CRM concerns, as well as Sugar-specific questions regarding your CRM initiative.
To register or to learn more about CRM Acceleration events, please visit: www.crmacceleration.com.
About SugarCRM
SugarCRM is the world's leading provider of commercial open source customer relationship management (CRM) software for companies of all sizes. SugarCRM easily adapts to any business environment by offering a more flexible, cost-effective alternative than proprietary applications. SugarCRM's open source architecture allows companies to more easily customize and integrate customer-facing business processes in order to build and maintain more profitable relationships. SugarCRM offers several deployment options, including on-demand, on-site and appliance-based solutions to suit customers' security, integration and configuration needs.
Community Builder suite (CB) extends the Joomla! user management system.
Key features:
extra fields in profile, enhanced registration workflows, user lists, connection paths between users, admin defined tabs and user profiles, image upload, front-end workflow management, integration with other components, like PMS, Newsletter, Forum, Galleries.
CB has many CB plugins from CB Team and from third parties, including Profile Gallery, Profile Blog, Profile Guestbook, Profile Wall, Paid Subscriptions Membership management, Donations management, Shop, Captcha and many more.
Over 180 extensions for CB are listed here. CB is compatible with all Joomla! 1.5 native, Joomla! 1.0.x native and Mambo 4.5.2-4.6.5. CB allows multi-criteria user searches, full field controls of core fields, ajax email and username checkers, image and integer fields, custom validations and many more features. CB 1.2.1 Stable is open-source and free.
[!] Introduced support SSL certificates for user authentication [!] v8.4.0 client libraries added [!] v8.4.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added [+] doNoTablespace option added to TPSQLDump.Options [+] dsoForceCreateFields flag to TPSQLDataset.Options property added [+] dsoPopulateFieldsOrigin flag to TPSQLDataset.Options property added [+] dsoTrimCharFields flag to TPSQLDataset.Options property added [+] dsoUseGUIDField flag to TPSQLDataset.Options property added [+] Extended SQL editor added for TPSQLQuery [+] roNoTablespace option added to TPSQLRestore.Options [+] TPSQLDatabase.DesignOptions property added [+] TPSQLDatabase.SelectStrings procedure added [+] TPSQLDataset.Options property added [+] TPSQLDump.LockWaitTimeout property added [+] TPSQLDump.Role & TPSQLRestore.Role properties added [+] TPSQLRestore.Jobs property added [*] ByteaAsEscString & OIDAsInt properties of TPSQLDataset are represented in TPSQLDataset.Options property now [*] Deprecated properties TPSQLDump.TableName and TPSQLDump.SchemaName removed [*] doIgnoreVersion & roIgnoreVersion options marked as deprecated since PosgreSQL v8.4 and will be ignored [*] Results of TPSQLDatabase.GetTableNames method are more readable now [*] TPSQLDatabase.GetCharsets method includes SHIFT_JIS_2004 encoding into result from now [*] TPSQLDatabase.UseSSL property removed as deprecated in favor of the SSLMode property [*] UUID fields processing improved [-] "Dump fails if TPSQLDump.ExcludeSchemas property is used" bug fixed [-] "TPSQLDataset.Locate failed for TWideStringField columns after Update3\4" bug fixed [-] "TPSQLDataset.Tablespace property has incorrect value" bug fixed
There are both Trial and Full versions of installer of PostgresDAC v2.5.2 available.
You're welcome to download the PostgresDAC v2.5.2 right now at http://microolap.com/products/connectivity/postgresdac/download/ , or login to your private area on our site at http://microolap.com/my/downloads/
Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/
PART I: WHAT IS "OPENNESS" AND WHERE DOES LINUX FIT INTO AN OPEN MOBILE LANDSCAPE?
The term "openness" can be defined in a number of ways within the mobile industry.
* An operating system is said to be open if it exposes its APIs to third-party developers. * If these third-party developers can develop services without undue reliance on device manufacturers and operators for certification, verification and signing, it can be said that the development model is open. * Open distribution occurs when content providers and developers can directly market and deliver applications to the consumer without requiring approval from the network operator or device manufacturer. * In a broad sense, "openness" also refers to the extent to which the platform, interfaces, and development language are standardized and easy to understand and use.
Perhaps most important is an open market in which third-party developers can have a free and viable opportunity to capitalize on their efforts.
Generally speaking, mobile communications were largely closed until recently. Operating systems and content were operator-specific, thereby creating "walled gardens" that restricted user experience and developer opportunity.
This business approach is not unnatural for an industry in maturation stage; however, in the mobile industry it resulted in dozens of proprietary operating systems (OS), rendering application development across different handsets and networks both tedious and costly, ultimately hindering innovation and market growth.
A poor browsing experience coupled with unexciting applications could not trigger consumers' interests and as a result, the mobile Internet was slow to take off.
The mobile industry has since realized that in order to provide demanding customers with more compelling and differentiated next-generation mobile experiences, coalescence is required around two or three global platforms built on underlying principles of openness and collaboration, rather than proprietary development behind closed doors.
Linux is undoubtedly well placed to be the foundation for one of these global platforms. Not only highly functional and scalable, Linux also has a long, successful history in embedded systems, setting the stage for "cross-platformization" between mobile and other categories such as desktop and consumer electronics.
One of Linux' core strengths is that it can support multiple application development platforms and graphical user interfaces, each providing a very different look and feel. This inherent flexibility allows OEMs and operators to target specific developer communities, in turn allowing those developers to micro-segment the user base so that they can provide more customized and personalised applications.
Additionally, Linux is not tied to the brand or agenda of any other major company, as is the case for Nokia's Symbian OS and Microsoft with its Windows Mobile OS, which creates unfettered business model flexibility that can fully support a highly customisable user experience.
Mobile Linux solutions share APIs with the desktop and enterprise solutions. As a result, previously developed third-party Linux applications can be ported to the mobile environment more efficiently and cost-effectively.
Shared APIs also provide economies of scale for the developer community, as developers can write applications for both the desktop and mobile environments with only a minimal duplication of effort.
With this commonality between mobile Linux and mobile desktop platforms, there is already a vast pool of developers working on the Linux platform. From an operator and manufacturer's perspective, this means there are enough developer resources to provide a rich, broad ecosystem of applications. For the Linux developer community, the mobile landscape is now open for business without the hindrance of a steep programming learning curve.
Last but not least, the use of Linux in the mobile environment is being supported throughout the handset value chain and in all global regions. This offers a large targetable user base for developers and makes development of Linux applications financially appealing.
In Part II of this look at how openness and Linux are unlocking innovation, I will review the keys for successful establishment of an open mobile ecosystem.
Orlando, FL - Aspire Technologies QuoteWerks integrates with SugarCRMAspire Technologies Inc., a provider of sales quoting software solutions for the global small and mid-markets, announced its newly developed QuoteWerks integration with SugarCRM (Commercial Open Source CRM) and a new partnership with the leading provider of open source CRM solutions for small, medium, and large enterprises worldwide. Under terms of the partnership, announced July 8, QuoteWerks will be offered through the SugarExchange marketplace.
How a tightly integrated CRM can help
The following advice for customer relationship management (CRM) integration is based on features of the new Aspire Technologies QuoteWerks integration for SugarCRM. Tightly integrated CRM can help manufacturing processes by:
• Searching the CRM database for a contact or account to use in the quote; • Creating a note record for the contact, save it with the quote, and make it available for review and modification later; • Creating or updating a sales opportunity when saving a quote; • Converting the quote to an order when a sale is made and close the sales opportunity as a "closed as won" sale. • Offering to schedule a follow up call when saving a quote or revision; • Inserting data fields into the print layout as needed; and • Pulling lookup list information from the CRM.
Aspire Technologies QuoteWerks SugarCRM search contact The QuoteWerks integration for SugarCRM is included in Build 47, which was commercially released July 8 by Aspire Technologies. Aspire Technologies explains more about QuoteWerks and SugarCRM integration.
"Sales quoting and CRM go hand in hand," said Keith Carrington, vice president of sales and marketing for Aspire Technologies. "Companies want to have a seamless, accurate, and efficient sales quoting process which makes use of vital customer and sales opportunity data that typically reside in disparate CRM, Accounting, and quoting systems. This integration makes it possible to achieve both quoting automation and a competitive advantage affordably and with minimal effort," Carrington says. QuoteWerks integrates with SugarCRM versions 5.1 and 5.2 including Community, Express, Professional, and Enterprise editions.
"The market for on-demand CRM applications such as SugarCRM is expected to grow by an estimated CAGR of 17.4% between now and 2013," said Carrington. SugarCRM currently has over 500,000 users in 195 countries, while QuoteWerks has 50,000 users in 101 countries. Given the seamless integration between the two applications, both companies anticipate strong demand for their products across multiple industries and markets.
QuoteWerks and SugarCRM partner to deliver sales quoting efficiencies to the Open Source and On-Demand CRM communities.
Orlando, FL (Vocus/PRWEB ) July 8, 2009 -- Aspire Technologies, Inc., a leading provider of sales quoting software solutions for the global small and mid-markets, today announced its newly developed QuoteWerks integration with SugarCRM and a new partnership with the leading provider of open source CRM solutions for small, medium, and large enterprises word wide. Under terms of the partnership, QuoteWerks will be offered through the SugarExchange marketplace. "Sales quoting and CRM go hand in hand," said Keith Carrington, vice president of sales and marketing for Aspire Technologies, Inc. "Companies want to have a seamless, accurate, and efficient sales quoting process which makes use of vital customer and sales opportunity data that typically reside in disparate CRM, Accounting, and quoting systems. This integration makes it possible to achieve both quoting automation and a competitive advantage affordably and with minimal effort."
Features of the new QuoteWerks integration for SugarCRM include:
* QuoteWerks lets users search the SugarCRM database for a Contact or Account to use in the quote. * When saving a quote, QuoteWerks automatically creates a Note record for the contact and will attach a linked document to the Note, from which the user can, at a later time, launch QuoteWerks and open the quote for review and modification. * When saving a quote, QuoteWerks will automatically create or update a Sales Opportunity under the Sales tab for the Contact in SugarCRM. * When a sale is made, QuoteWerks will convert the quote to an order and also convert the existing SugarCRM Sales Opportunity into a "Closed as Won" sale. * QuoteWerks will also offer to schedule a follow-up call, in SugarCRM, for the user when saving a quote or quote revision. * With the built-in QuoteWerks print layout designer, users can easily insert data fields from SugarCRM directly into the QuoteWerks print layout. * QuoteWerks can pull lookup list information from SugarCRM.
QuoteWerks integrates with SugarCRM versions 5.1 and 5.2 including Community, Express, Professional, and Enterprise editions. For detailed descriptions of the integration features and to view screenshots, please visit http://www.quotewerks.com/sugarcrm.asp.
SugarCRM currently has over 500,000 users in 195 countries, while QuoteWerks has 50,000 users in 101 countries. Given the seamless integration between the two applications, both companies anticipate strong demand for their products across multiple industries and markets.
"The market for on-demand CRM applications such as SugarCRM is expected to grow by an estimated CAGR of 17.4% between now and 2013," said Carrington. "Given the quality and stability of our product and its integration with SugarCRM coupled with the leadership role we hold in the marketplace, QuoteWerks is ideally positioned to serve the growing needs of small, medium, and large enterprise organizations."
The QuoteWerks integration for SugarCRM is included in Build 47 which was commercially released earlier today by Aspire Technologies, Inc. Current QuoteWerks 4.0 users who are current on their Update Maintenance Plan may immediately access and download Build 47 from the QuoteWerks website. Build 47 is also shipping on all new orders of QuoteWerks. QuoteWerks 4.0 users who are not current on their UMP and all existing QuoteWerks 3.0 users should contact Aspire Technologies, Inc. or their QuoteWerks reseller to obtain Build 47. To view a complete list of the 27 new enhancements and features included in Build 47, please visit: http://www.quotewerks.com/updates/UpdateAgent.asp?VersionBuild=4.0.47&Version=4.0&Build=47
About Aspire Technologies and QuoteWerks® Aspire Technologies, the creators of the award winning QuoteWerks® sales quoting software, is the leading provider of sales quoting software with its award winning QuoteWerks® application deployed to thousands of businesses and enterprises worldwide. QuoteWerks® integrates with all major and leading CRM packages including ACT!TM, Goldmine®, Maximizer®, MS CRM, Outlook®, TeleMagic®, salesforce.com® and SalesLogix® , SugarCRMTM and such popular accounting applications as QuickBooks® and Peachtree, enabling businesses in all industries to integrate QuoteWerks® seamlessly into their existing environments. Aspire Technologies is headquartered in Orlando, Florida and is a Microsoft Gold Certified Partner, Sage Software Gold Level Development Partner, and an HP DSP Partner. For more information please visit
