Open Source Blog | Professionals Blog | Blog Sites | Technology Blog

This is Open Source Universe Blog. You can share your views related to Open Source.

Zend Framework has clearly become the industry favorite web framework over the past couple of years. It has been approved and backed by few of the best companies and individuals in the software universe. It makes full sense to equip yourself with Zend Framework.

You want to learn zend framework but do not have time and means to join a world class zend framework training program ? Get the best zend framework training sitting right in front of your PC. 

Why an online zend framework training ?

  • Get access to world class experienced trainers.
  • 100% Live and interactive sessions.
  • Learn at your own pace with full personal attention.
  • High quality discussions and hands-on exercises.
  • Save time ! No need to travel through thick traffic.
  • No Geographical barriers. Learn from anywhere in the world.
  • Above all, value for your money.
Sounds interesting ? contact us at enquiry (at) zendframework-training (dot) com

MySQL Newsletter: May 2010

Posted by:

Articles in this newsletter:

Highlights

- Oracle Outlines Strategy for MySQL
- MySQL track at Oracle Development Tools User Group Conference
- White Paper: How MySQL Powers Web 2.0
- White Paper: MySQL 5.1 for ISV/OEM Solutions
- Evaluation Guide: Evaluating MySQL Cluster 7.1
- Case Study: UCR Selects MySQL Enterprise to Power the Medical Registries of 1.5 Million Patients
- Case Study: ContactLab Supports its High-Performance e-marketing tools with MySQL Enterprise
- Live Webinar: Building an Architecture for Scalability: myLifetime.com on MySQL (Tuesday, May 18)
- Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA (Thursday, May 20)
- Live Webinar: MySQL Essentials Series - Part 1:  Building, Installing and Configuring MySQL (Thursday, May 27)
- Upcoming MySQL University Sessions

New Product Releases

- New Release of MySQL Community Server 5.1.46 (GA)
- New Release of MySQL Workbench 5.2.21 (RC)
- New Release of MySQL Connector/Net 6.1.4 (GA)

Hints & Tips

- White Paper: Designing and Implementing Scalable Applications with Memcached and MySQL
- White Paper: A Guide for ISVs and OEMs: Migrating From Microsoft Access To MySQL Embedded Server
- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- Tutorial: Developing Database Applications Using MySQL Connector/C++
- Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the MySQL Query Analyzer
- Case Study: Aito Technologies Selects MySQL to Manage Mobile Traffic Data and Customer Information
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: MySQL 5.5.4 is Very Exciting
  - PlanetMySQL Blog: Two quick performance tips with MySQL 5.1 partitions
  - PlanetMySQL Blog: MySQL: The maximum value of an integer
  - PlanetMySQL Blog: MySQL Cluster - SPJ Preview - Feedback welcome
  - PlanetMySQL Blog: Trying out MySQL Push-Down-Join (SPJ) preview
  - PlanetMySQL Blog: Simulating server-side cursors with MySQL Connector/Python
  - PlanetMySQL Blog: The MySQL Community meets the Independent Oracle Users Group
  - PlanetMySQL Blog: Reducing locks by narrowing primary key
  - PlanetMySQL Blog: MySQL Performance: Improving Stability
  - PlanetMySQL Blog: MySQL Random Data Selection
  - PlanetMySQL Blog: A backup today saves you tomorrow
  - PlanetMySQL Blog: Choosing the right data type makes a big difference

Events

- Live Webinar: Better Java Application Scalability and Reliability Using MySQL Connector/J Features (Tuesday, May 25)
- Live Webinar: Getting started with MySQL Replication - Italian (Tuesday, May 25)
- Live Webinar: MySQL Performance Tuning Best Practices - French (Wednesday, May 26)
- Live Webinar: MySQL Replication - Part 2 - German (Thursday, May 27)
- On-Demand Webinar: Introducing MySQL Cluster 7.1
- On-Demand Webinar: Using the latest Java Persistence API 2.0 features with MySQL

-------------------------------------------------------------------

Highlights

Oracle Outlines Strategy for MySQL

Edward Screven, Oracle's Chief Corporate Architect, discussed the current and future state of MySQL in his keynote at the MySQL Conference & Expo.

Watch the Video:
 
http://www.youtube.com/watch?v=C0OkjtlbqVs&feature=PlayList&p=57E661D0569B26
EE&playnext_from=PL&index=0


MySQL track at Oracle Development Tools User Group Conference

The Oracle Development Tools Users Group (ODTUG) is holding its annual conference in Washington, DC, from June 27th to July 1st. By popular demand, there will be a MySQL track organized by the MySQL community. The event includes free sessions. Join us and meet with the MySQL experts!

Learn more:
  http://blogs.sun.com/MySQL/entry/mysql_track_with_free_event


White Paper: How MySQL Powers Web 2.0

MySQL enables up-and-coming Web 2.0 sites like Wikipedia, Facebook and Twitter, as well as established web properties like Craigslist, Google and Yahoo!, to scale out and meet the ever-increasing volume of users, transactions and data.

You will gain an understanding of how MySQL can be used in conjunction with other open source components to deliver low-cost, reliable, scalable, high performance Web 2.0 applications.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_web20.php


White Paper: MySQL 5.1 for ISV/OEM Solutions

The MySQL 5.1 server continues to move MySQL ahead in its mission to make sophisticated database management available and affordable to all. With the release of MySQL 5.1, the MySQL database server provides more enterprise-caliber enhancements that greatly assist those wanting to use MySQL for:

- Managing larger volumes of data
- Applications that have high-availability requirements
- Systems needing a powerful but autonomous-running database

that requires little attention and continually services anywhere from one to thousands of user requests per second.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_51_OEM.php


Evaluation Guide: Evaluating MySQL Cluster 7.1

In this white paper learn the fundamentals of how to design and select the proper components for a successful MySQL Cluster evaluation. We explore hardware, networking and software requirements, and work through basic functional testing and evaluation best practices.

Read the Evaluation Guide:
  http://dev.mysql.com/why-mysql/white-papers/mysql_cluster_eval_guide.php


Case Study: UCR Selects MySQL Enterprise to Power the Medical Registries of
1.5 Million Patients

Uppsala Clinical Research Center, UCR, is a national center of competence for healthcare quality registries in Sweden, and is an independent unit under Uppsala University Hospital and the Disciplinary Domain of Medicine and Pharmacy at the University of Uppsala. UCR's National Quality Registries include treatment and outcome data based on all hospital patients in Sweden, and is used by thousands of doctors, nurses, medical secretaries and representatives within county councils.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_ucr.php


Case Study: ContactLab Supports its High-Performance e-marketing tools with MySQL Enterprise

ContactLab is a leading Italian provider of digital direct marketing services, with offices in Milan, Madrid, Paris, London and Munich.
ContactLab chose to subscribe to MySQL Enterprise to help support the security, availability and scalability of its market-leading platform. Today ContactLab manages more than 3 Terabytes of data with MySQL for sending, tracking and analyzing hundreds of millions of messages every month.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_contactlab.php


Live Webinar: Building an Architecture for Scalability: myLifetime.com on MySQL Tuesday, May 18, 2010 - 9:00am PT

Among the top 500 most visited sites on the Internet, myLifetime.com, which is built on Drupal, receives 6.5 million visitors (3.6 million unique) and 50 million page views per month. Because of online campaigns, and the popularity of associated television shows, the Lifetime family of sites must be prepared to accommodate significant volume spikes.

Nathan Potter, VP of Digital Media Technology at myLifetime.com, cites show-related volume spikes of 150,000 page views per hour as within the normal range of traffic. In this webinar, Nathan will cover the architecture they've developed for scalability as well as the techniques they've used for optimizing their site, including MySQL, for scalability and performance.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-535.html


Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA Thursday, May 20, 2010 - 9:00am PT

Join Jimmy Guerrero and Mike Frank of Oracle for an overview of MySQL's internal architecture including storage engines, security and datatypes.
Also covered will be replication, migration strategies, tools and product comparisons to SQL Server, SQL Server Express and Access. If you are a SQL Server DBA interested in learning how to leverage your current knowledge against MySQL, this webinar is for you.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-536.html


Live Webinar: MySQL Essentials Series - Part 1:  Building, Installing and Configuring MySQL Thursday, May 27, 2010 - 9:00am PT

Join us for Part 1 of the "MySQL Essentials" webinar series with Jimmy Guerrero and Mike Frank from the MySQL Product Management group at Oracle.
In this presentation we'll demonstrate how to setup an environment for building MySQL from source on Windows and Linux, leveraging free or open source tools in the build environment. We'll also examine the various MySQL downloads, packages, distributions and installers available to get up and running in 15 minutes or less. Finally, we'll cover the initial configuration of MySQL including memory allocation, connection limits, security and other options.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-538.html


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 Oracle 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.

View Upcoming and Previous Sessions:
  http://forge.mysql.com/wiki/MySQL_University

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.1.46 (GA)

MySQL Community Server 5.1.46, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.46 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-46.html

Download now:
  http://dev.mysql.com/downloads/mysql/5.1.html#downloads


New Release of MySQL Workbench 5.2.21 (RC)

We're announcing the first Release Candidate of MySQL Workbench. MySQL Workbench 5.2 RC provides:

1. Data Modeling
2. Query (upgrade from MySQL Query Browser) 3. Admin (upgrade from MySQL Administrator)

If you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a single unified MySQL Workbench.

View the complete list of changes:
  http://dev.mysql.com/doc/workbench/en/wb-news-5-2-21.html

Download now:
  http://dev.mysql.com/downloads/workbench/5.2.html


New Release of MySQL Connector/Net 6.1.4 (GA)

MySQL Connector/Net 6.1.4, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against MySQL servers ranging from version 4.1 to 5.5!

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.5/en/connector-net-news-6-1-4.html

Download Now:
  http://dev.mysql.com/downloads/connector/net/6.1.html#downloads

-------------------------------------------------------------------

Hints & Tips

White Paper: Designing and Implementing Scalable Applications with Memcached and MySQL

Memached is an open-source, distributed memory caching system designed to tackle today's web-scale performance and scalability challenges. Many of the largest and most heavily trafficked web properties on the Internet like Facebook, Fotolog, YouTube, Mixi.jp, Yahoo, and Wikipedia deploy Memcached and MySQL to satisfy the demands of millions of users and billions of page views every month. By integrating a caching tier into their web-scale architectures, these organizations have improved their application performance while minimizing database load.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_memcached.php


White Paper: A Guide for ISVs and OEMs: Migrating From Microsoft Access To MySQL Embedded Server

Many ISVs and OEMs have seen that MySQL Embedded Server's superior scalability -- in both concurrent userload and overall data volume, cost-savings, platform freedom, and feature set combine to provide a compelling business case to move some or all of their Access applications to MySQL Embedded Server. This paper provides insight into what is needed when considering a move from Microsoft Access to MySQL Embedded Server and presents a number of options that ease the transition.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_msaccess_to_oem.php


White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs

This paper looks at the various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how the MySQL Workbench product from MySQL can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php


Tutorial: Developing Database Applications Using MySQL Connector/C++

This tutorial will show you the essential steps to build and install the new, elegant MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database. Application developers who are new to MySQL Connector/C++ but not to C++ programming and the MySQL database, are the target audience of this tutorial. Because the focus is on database connectivity from a C++ application, this document assumes that some kind of MySQL database is already up and accessible from the client machine.

Read this Tutorial:
 
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_dbapps_connector-c.php


Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the MySQL Query Analyzer

Launched in 1998, Promovacances is a brand of the Karavel group, the leading provider of vacation packages online in France. Promovacances.com gets about 40 million individual visitors per year and 250,000 per day during the high season.

The MySQL Enterprise Platinum subscription gives Karavel access to 24/7 technical support as well as to the MySQL Enterprise Monitor including the new MySQL Query Analyzer.

Read the Case Study:
 
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_karavel_travelling.php


Case Study: Aito Technologies Selects MySQL to Manage Mobile Traffic Data and Customer Information

Aito Technologies has chosen to employ the MySQL Embedded Database Server in order to successfully analyze up to billions of daily phone calls, text messages and mobile data sessions.

With reference clients such as Nokia, TDC, Blyk, Elisa and Muxlim, Aito's daily traffic load entails several terabytes of data. Consequently, the vendor's application has strict requirements for high database performance and scalability on a multiprocessor architecture.

Read the Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_Aito.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 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: MySQL 5.5.4 is Very Exciting Jeremy Zawodny

Yesterday at the MySQL Conference, I spent time in a few sessions discussing the performance enhancements in the MySQL 5.5.3 and 5.5.4 milestone releases. What I saw made me very, very happy. In fact, the timing couldn't be better.

Read the PlanetMySQL BlogPost:
  http://blog.zawodny.com/2010/04/14/mysql-5-5-4-is-very-exicting/


PlanetMySQL Blog: Two quick performance tips with MySQL 5.1 partitions Giuseppe Maxia

While I was researching for my partitions tutorial, I came across two hidden problems, which may happen often, but are somehow difficult to detect and even more difficult to fix, unless you know what's going on, and why. I presented both cases during my tutorial, but there were no pictures to convey the mechanics of the problem. Here is the full story.

Read the PlanetMySQL BlogPost:
 
http://datacharmer.blogspot.com/2010/05/two-quick-performance-tips-with-mysq
l.html


PlanetMySQL Blog: MySQL: The maximum value of an integer Roland Bouman

Did you ever have the need to find the maximum value of an integer in MySQL?
Yeah, me neither. Anyway, some people seem to need this, and this is what I came up with.

Read the PlanetMySQL BlogPost:
  http://rpbouman.blogspot.com/2010/05/mysql-maximum-value-of-integer.html


PlanetMySQL Blog: MySQL Cluster - SPJ Preview - Feedback welcome Johan Andersson

SPJ (preview, not production ready) is a new feature allowing some types of JOINs to be pushed down and executed inside the data nodes! This allows for, in many cases, much faster JOIN execution.

Read the PlanetMySQL BlogPost:
 
http://johanandersson.blogspot.com/2010/04/mysql-cluster-spj-preview-feedbac
k_27.html


PlanetMySQL Blog: Trying out MySQL Cluster Push-Down-Join (SPJ) preview Andrew Morgan

At the 2010 MySQL User Conference, Jonas Oreland presented on the work he's been doing on improving the performance of joins when using MySQL Cluster - the slides are available for download. While not ready for production systems, a preview version is available for you to try out. The purpose of this blog is to step through testing an example query as well as presenting the results.

Read the PlanetMySQL BlogPost:
 
http://www.clusterdb.com/mysql-cluster/trying-out-mysql-push-down-join-spj-p
review/


PlanetMySQL Blog: Simulating server-side cursors with MySQL Connector/Python Geert JM Vanderkelen

Last week, my colleague Massimo and I discussed how to handle big result sets coming from MySQL in Python. The problem is that MySQL doesn't support server-side cursors, so you need to select everything and then read it. You can do it either buffered or not. MySQL Connector/Python defaults to non-buffered, meaning that you need to fetch all rows after issuing a SELECT statement. You can also turn on the buffering, mimicking what MySQL for Python (MySQLdb) does.

Read the PlanetMySQL BlogPost:
 
http://geert.vanderkelen.org/2010/04/simulating-server-side-cursors-with.htm
l


PlanetMySQL Blog: The MySQL Community meets the Independent Oracle Users Group Giuseppe Maxia

Collaborate10 is the conference of the Oracle Users Groups. I had been asked to participate with a few talks on MySQL, and I was curious of meeting, for me, a new organization. I prepared three talks, one introduction to MySQL and two advanced ones, and thus equipped I ventured along the immense corridors of the Mandalay Bay convention center.

Read the PlanetMySQL BlogPost:
 
http://blogs.sun.com/datacharmer/entry/mysql_community_meets_the_independent


PlanetMySQL Blog: Reducing locks by narrowing primary key Shlomi Noach

In a period of two weeks, I had two cases with the exact same symptoms.
Database users were experiencing low responsiveness. DBAs were seeing locks occurring on seemingly normal tables. In particular, looking at Innotop, it seemed that INSERTs were causing the locks.

Read the PlanetMySQL BlogPost:
  http://code.openark.org/blog/mysql/reducing-locks-by-narrowing-primary-key


PlanetMySQL Blog: MySQL Performance: Improving Stability Dimitri Kravtchuk

Huge performance improvement has come with MySQL 5.5.4, and looking at the following picture it's very easy to see why.

Read the PlanetMySQL BlogPost:
 
http://dimitrik.free.fr/blog/archives/2010/05/mysql-performance-improving-st
ability.html


PlanetMySQL Blog: MySQL Random Data Selection Mahmud Ahsan

Some days ago I was working in a vocabulary game and dictionary. The dictionary contains 1,10,000 words and meanings. I developed a vocabulary game where I had to randomly choose 10 words out of 1,10,000 dataset. Here I'm describing the possible solutions for this problem and which solution I used.

Read the PlanetMySQL BlogPost:
  http://thinkdiff.net/mysql/mysql-random-data-selection/


PlanetMySQL Blog: A backup today saves you tomorrow Ben Mildren

Whether you're working with MySQL, MySQL Cluster, or any other RDBMS, every database with a requirement for persistent data should always have a backup.
As a Production DBA you're the insurance policy to safeguard the data. Bad things do happen. Backups are your safety net to ensure you always have a way to recover should the worst happen and the database becomes irreparable.

Read the PlanetMySQL BlogPost:
  http://www.productiondba.com/2010/04/a-backup-today-saves-you-tomorrow/


PlanetMySQL Blog: Choosing the right data type makes a big difference Venu Anuganti

Today evening one of my friend asked me in the IM to look into one of his production server where a query was taking about 11 seconds to run on 20 million row table, even though the query is using the right index and the plan as shown below.

Read the PlanetMySQL BlogPost:
 
http://venublog.com/2010/04/19/choosing-the-right-data-type-makes-a-big-diff
erence/

-------------------------------------------------------------------

Events

Live Webinar: Better Java Application Scalability and Reliability Using MySQL Connector/J Features Tuesday, May 25, 2010 - 9:00am PT

Join MySQL and Java experts, Mark Matthews and Todd Farmer, for an encore performance of their MySQL 2010 User Conference Session. In this technical presentation they will explain how to use the scalability and reliability features that are built into MySQL Connector/J to do

- Fault tolerant load balancing
- Replication-aware load balancing with slave fail-over
- Custom exception handling
- Sharding through some creative use of statement interceptors mixed with the built-in load balancer

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-537.html


Live Webinar: Getting started with MySQL Replication - Italian Tuesday, May 25, 2010 - 10:00 CET/8:00 UTC

MySQL Replication is widely used to deploy scalable and highly available database architecture. In this presentation we will demonstrate how to get started with configuring MySQL Replication. We will also cover how replication works, supported replication topologies and how to perform management and administration tasks.

Register for this Italian Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-540.html


Live Webinar: MySQL Performance Tuning Best Practices - French Wednesday, May 26, 2010 - 10:00 CET/8:00 UTC

You will get expert insight and learn best practices from the experts at MySQL to help you improve performance! We will discuss the main performance optimization opportunities, including schema optimization, server options tuning, storage engine selection, and more.

Register for this French Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-543.html


Live Webinar: MySQL Replication - Part 2 - German Thursday, May 27, 2010 - 15:00 CET/13:00 UTC

In this presentation we will look at more advanced MySQL Replication techniques. We will cover master-master configurations, semi-synchronous replication, fail-over and resynchronization.

Register for this German Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-539.html


On-Demand Webinar: Introducing MySQL Cluster 7.1

In blazing speed we will cover the most important features of MySQL Cluster
7.1: NDB$INFO; MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.

Watch the On-Demand Webinar:
 
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-527.html


On-Demand Webinar: Using the latest Java Persistence API 2.0 features with MySQL

The Java Persistence API is the Java API for the management of persistence for Java EE and Java SE applications. It provides an object/relational mapping facility for the Java application developer using a Java domain model to manage a relational database. The release 2.0 has been expanded to include several key new features.

This session will provide an introduction to the Java Persistence API and then a presentation of some of the new features available in Java Persistence 2.0. The talk will provide an overview of the object-relational mapping and modeling additions, the query language facilities, the new criteria API, pessimistic locking, and support for validation.

Watch this On-Demand Webinar:
 
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-504.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 webinars:
  http://dev.mysql.com/news-and-events/web-seminars/index.html

-------------------------------------------------------------------

Want to receive the latest MySQL updates and interact with the MySQL community?

Follow MySQL on Twitter:
  http://twitter.com/mysql

Follow MySQL Community on Twitter:
  http://twitter.com/mysql_community

-------------------------------------------------------------------

About the Newsletter

You can send us queries and give us feedback online.
  http://dev.mysql.com/contact/

Read more about the newsletter and view previous issues.
  http://dev.mysql.com/news-and-events/newsletter/

--
Copyright (c) 2010, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.

Adaptable Open Source

Posted by: nidhi.ost

nidhi.ost

Cost savings are still the primary driver for organizations choosing open-source software, according to Jay Lyman, an analyst at The 451 Group. However, that impression seems to change after adoption, when more users report that flexibility is the primary benefit they enjoy rather than cost savings, he says.

"With the downspin of the economy, how you spend your money is critically important," says Bassim Hamadeh, founder of University Readers, which uses SugarCRM software. "But beyond saving money, what we look for is better software." SugarCRM offers enough flexibility that when the IT team wants to add a feature to the Web site, it first considers creating it in SugarCRM.


Hooked on Open Office

Posted by: cybermama

cybermama

Several months ago, during a period of unemployment, my old laptop died necessitating that I buy a new computer.  The computer I selected came with a 60 day trial version of Microsoft Office.  Since I have used Office for over 20 years and needed a word processor and spreadsheet package, I almost bought the real version.  Because I am an IT professional who likes to develop applications in Access, I wanted the professional version of Office and that cost around $400.

Remember, I was unemployed.  That $400 was almost my entire gross take home from my unemployment payments!  I simply could not afford Office at that price and the Student Home Edition didn't give me what I wanted.  My son is a college student in another state and he loves Open Office so much that even when offered an inexpensive version of Office through his college bookstore, he shunned it in favor of Open Office.  Taking a cue my my son, I downloaded Open Office and got hooked!  No more was I chained to Microsoft!

 But I didn't have a good tool to manage my email.  That's when discovered Mozilla Thunderbird and its many extensions.  Why would I need Outlook? 

The greatest weakness in OO is Base.  Base isn't Access; it's not even close.  I have an extensive programming background and can get by some of the Base weaknesses by writing code but not everyone can do that.  I figure that if I should ever truly need Access, I can buy that product alone.

Ironically, I'm now working but I don't intend to return to Microsoft Office at its very expensive price.  I'm hooked on Open Office!


 

Zend framework is the latest buzz in the open source universe. There is a huge demand for Zend Framework developers.

Zend Framework is the framework of choice across the world today.This is for many reasons

  • It is industry backed. IBM, Zend etc. are involved in the development of this framework
  • It is flexible and powerful
  • Fully written in PHP5 and is completely object oriented.
  • It provides API support to Google, Yahoo, Flickr, Amazon etc.
  •  Modular and extensible
  • Minimum Configuration required,

Clearly Zend Framework is here to stay. It makes more sense to equip yourself with an emerging technology than learn a technology that has millions of people already.

To learn zend framework from people who use this technology in their day to day life, feel free to mail enquiry@zendframework-training.com .

You may visit http://www.zendframework-training.com


Search Engine Optimization is a great way to kick-off your Web marketing, increase your web presence, increase your visibility, double up your revenues and kill the competitors.
Today’s business has become reliant on the Internet as the easiest and most reliable way to access information quickly.
Information search on the web is becoming way of life, everything can be found online—including your services, it is a great way of marketing your product and services. The only tricky part is making your Web site visible to potential customers when they are looking for you. That’s where our SEO services come into picture.
We provide complete Web Promotion Expert Services including Search Engine Marketing (SEM) and SEO consulting Services. In synchronization with the latest trends, our unique methodology integrates following factors to render a complex matrix of SEO practices thereby helping you to promote your business globally.

What our SEO Experts Do for You?

  • Competitors’ analysis
  • Market research and analysis
  • Key phrase research and analysis
  • Meta tags and other HTML tags creation
  • Website architecture and navigation creation
  • Content Optimization
  • Quality Link Building with relevant sites
  • Search Engine Submissions
  • Manual Submission in Web Directories
  • Listing of your website in Business Yellow Pages
  • Creation of classified ads
  • Ezine / Articles and online PR publications
  • RSS feeds generation and optimization
  • Blog promotion
  • Social Media Optimization
  • for more

     http://www.php2ranjan.com


    SEO Training

    Posted by: seoruchi

    seoruchi

    What Kind of services we provide   

     Search Engine Optimization is a starting point for your Web marketing campaign that will increase your web presence, your visibility, double up your revenues and kill your competitors.

    In recent years internet become one of the most preferred and most reliable way to access information. Information search on the

    web is becoming way of life, everything can be found online—including your services, it is a great way of marketing your product and services.

    The only tricky part is to make your website available to your potential customers when they are looking for the services that you are offering. That’s where our SEO services come into picture.

    We provide complete Web Promotion Expert Services including Search Engine Marketing (SEM) and SEO consulting Services. In synchronization with the latest trends, our unique methodology integrates following factors to render a complex matrix of SEO practices thereby helping you to promote your business globally.

    SEO techniques are most simple and best way that helps you with all the work that is performed by a traditional media company. Search engine optimization strategy includes adjustment of keywords and keywords phrases visible on the website to visitors. SEO is also useful to analyze the web traffic details to know what factors contribute to ranking, because SEO drives organic traffics and push site position and ranking. SEO bringing more traffics to your website and increasing organic traffics rates regular, especially those types of traffics only who are interested in your services or products.

    Our Services

    On page and off pageoptimization

    Email Broadcasting

    Manual Search Engine Submission

    Manual Directory Submission Service

    SERP management Services

    Social Media Optimization

    Social Bookmarking Services

    Website Promotion Services

    SEO Training online and onsite

    SEO Link building

    Blog , Forum and Article submission

    Google,yahoo & bing Ranking management

    Pay Per Click (PPC) Management PPC

    Management Services India

    Our other Services

    SEO Training online and onsite

    PHP Website in Low cost

    Static website of 5 pages at $70

    Web Hosting with free one domain at $25

    SEO Training online and onsite

    PHP Training, PHP ready made site for Sale

     



    MySQL Newsletter: March 2010

    Posted by: nidhi.ost

    nidhi.ost
    MySQL Newsletter
    March 2010
    mysql-newsletter@sun.com

    Articles in this newsletter:

    Highlights

    - MySQL Conference and Expo: Register Now and Save $250 by March 15th
    - MySQL Conference and Expo: Technical Sessions
    - MySQL Conference and Expo: MySQL Expert Speakers
    - Live Webinar: Achieving Peak Application Performance with MySQL Embedded Server (Wednesday, March 17)
    - Live Webinar: Running MySQL Securely on Windows - EMEA (Thursday, March
    18)
    - Upcoming MySQL University Sessions

    New Product Releases

    - New Release of MySQL Server 5.5.2-m2 (Beta)
    - New Release of MySQL Workbench 5.2.16 (Beta)
    - New Release of MySQL Connector/Net 6.3.1 (Alpha)

    Hints & Tips

    - Documentation: MySQL Performance Schema
    - Article: Why Should I Check Out a MySQL-Based Column Database?
    - PlanetMySQL Blog Posts
      - PlanetMySQL Blog: The innodb_plugin - a pleasant surprise!
      - PlanetMySQL Blog: Linux MySQL distributions meeting in Brussels
      - PlanetMySQL Blog: How to get rank using MySQL query
      - PlanetMySQL Blog: The correct approach to rolling MySQL logs
      - PlanetMySQL Blog: Semi-sync Replication Testing
      - PlanetMySQL Blog: Ineffective concatenated indexes
      - PlanetMySQL Blog: Don't forget the COMMIT in MySQL
      - PlanetMySQL Blog: Why do we need InnoDB per table IO statistics?
      - PlanetMySQL Blog: How To Set Up MySQL Database Replication With SSL Encryption On Ubuntu 9.10

    Events

    - Live Webinar: Migrating from SQL Server to MySQL - EMEA (Thursday, March
    11)
    - Live Webinar: Windows and MySQL - Part 12: Advanced MySQL Replication on Windows (Tuesday, March 16)
    - Live Webinar: MySQL Cluster for Web & eCommerce Applications: Growing Revenue & Enhancing Loyalty (Wednesday, March 24)

    -------------------------------------------------------------------

    Highlights

    MySQL Conference and Expo: Register Now and Save $250 by March 15th

    The MySQL Conference and Expo is a deep technical conference designed to take your skills and know-how to the next level through expert-led sessions, in-depth tutorials, and face-to-face conversations with open source gurus and developers. You will also learn the current and future state of MySQL during the keynote from Edward Screven, Oracle's Chief Corporate Architect and leader of the MySQL business. Early registration discount has been extended through March 15th, so register now and save!

    Register Now:
      https://en.oreilly.com/mysql2010/public/register

    View Pricing:
      https://en.oreilly.com/mysql2010/public/register#pricing

    Learn More about Edward Screven's Keynote:
      http://en.oreilly.com/mysql2010/public/schedule/detail/12440


    MySQL Conference and Expo: Technical Sessions

    Take advantage of this rare opportunity to get hands-on knowledge from MySQL experts on numerous topics, including Security, Replication, Performance Tuning, High Availability, and Scalability. Here are some session
    highlights:

    - Performance Schema
    - Get Your Replication On: Advanced Techniques, Tips and Tricks
    - High-throughput MySQL
    - PHP Object-Relational Mapping Libraries In Action
    - Introduction to InnoDB Monitoring System and Resource & Performance Tuning
    - Scalability and Reliability Features of MySQL Connector/J

    View the current list of sessions:
      http://en.oreilly.com/mysql2010/public/schedule/grid


    MySQL Conference and Expo: MySQL Expert Speakers

    MySQL Conference Speakers include both the engineers who build MySQL and leading experts who are implementing MySQL in real-world environments. Come join the following MySQL Experts:

    - Mark Callaghan, Facebook
    - Jeremy Zawodny, craigslist.org
    - Giuseppe Maxia, Oracle
    - Sheeri Cabral, The Pythian Group
    - Ben Black, Garmin
    - Roland Bouman, Strukton Rail
    - Alex Esterkin, Nokia
    - Ronald Bradford, 42SQL

    View the current list of speakers:
      http://en.oreilly.com/mysql2010/public/schedule/speakers


    Live Webinar: Achieving Peak Application Performance with MySQL Embedded Server Wednesday, March 17, 2010 - 10:00am PDT

    MySQL expert and trainer, Sarah Sproehnle, will discuss the major MySQL design decisions that can affect the performance of your application and with it, your customers' experience and satisfaction. Sarah will show you how to achieve top performance with MySQL Embedded Server, including choosing the right storage engine(s), identifying critical performance-related server settings, and more.

    Register for this Webinar:
      http://dev.mysql.com/news-and-events/web-seminars/display-510.html


    Live Webinar: Running MySQL Securely on Windows - EMEA Thursday, March 18, 2010 - 15:00 CET

    In this presentation we will demonstrate how to install and configure MySQL to run securely on Windows. We will explain how MySQL's internal security model, authentication and privileges model works. We will also look at how to secure network access to MySQL and look how to thwart common attacks on MySQL.

    Register for this Webinar:
      http://dev.mysql.com/news-and-events/web-seminars/display-518.html


    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 Oracle 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.

    View Upcoming and Previous Sessions:
      http://forge.mysql.com/wiki/MySQL_University

    -------------------------------------------------------------------

    New Product Releases

    New Release of MySQL Server 5.5.2-m2 (Beta)

    MySQL Server 5.5.2-m2, a new version of the popular Open Source Database Management System, has been released. The "-m2" suffix tells this belongs to the second milestone according to our "milestone" release model. MySQL 5.5 includes several high-impact changes to address scalability and performance issues in MySQL Server. These changes exploit advances in hardware and CPU design and enable better utilization of existing hardware.

    View the complete list of changes:
      http://dev.mysql.com/doc/refman/5.5/en/news-5-5-2.html

    Download Now:
      http://dev.mysql.com/downloads/mysql/#downloads

    Read the Documentation:
      http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html


    New Release of MySQL Workbench 5.2.16 (Beta)

    We have published a new beta release of Version 5.2.16 Workbench Beta 6 build including fixes for 67 bugs.

    View the complete list of changes:
      http://dev.mysql.com/doc/workbench/en/wb-news-5-2-16.html

    Download Now:
      http://dev.mysql.com/downloads/workbench/5.2.html


    New Release of MySQL Connector/Net 6.3.1 (Alpha)

    MySQL Connector/Net 6.3.1, 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, including Visual Studio 2010 RC support and nested transaction scope support.

    View the complete list of changes:
      http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-6-3-1.html

    Download Now:
      http://dev.mysql.com/downloads/connector/net/6.3.html

    -------------------------------------------------------------------

    Hints & Tips

    Documentation: MySQL Performance Schema

    MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. This is a new feature available as of MySQL 5.5.3.
    Performance Schema is intended to provide access to useful information about server execution while having minimal impact on server performance.

    Read the Documentation:
      http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html


    Article: Why Should I Check Out a MySQL-Based Column Database?

    Recently, articles, blogs, analyst reports, and other media outlets have been noting the rise and usage of column-oriented databases in the areas of data warehousing, analytics, and other business intelligence/read-intensive situations. And on the MySQL front, there are a couple of column DB's that are now available for you to use.

    Read this Article:
     
    http://dev.mysql.com/tech-resources/articles/mysql-based-column-database.htm
    l


    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: The innodb_plugin - a pleasant surprise!
    Simon Mudd

    I've heard about the innodb_plugin but not had time to put it to the test.

    Read the PlanetMySQL BlogPost:
      http://blog.wl0.org/2010/03/the-innodb_plugin-a-pleasant-surprise/


    PlanetMySQL Blog: Linux MySQL distributions meeting in Brussels Giuseppe Maxia

    The MySQL team has organized a meeting with the Linux distributions with the intent of finding out which differences and problems they may have with each other, and to solve them by improving communication. The meeting was successful.

    Read the PlanetMySQL BlogPost:
     
    http://datacharmer.blogspot.com/2010/02/linux-mysql-distros-meeting-in-bruss
    els.html


    PlanetMySQL Blog: How to get rank using MySQL query Mahmud Ahsan

    Some days ago I was working in a quiz project, where user will play quiz and for each correct answer they will earn points. One of the task of this quiz application was to get rank of a particular user. Now I am showing how I could solve this problem using MySQL query.

    Read the PlanetMySQL BlogPost:
      http://thinkdiff.net/mysql/how-to-get-rank-using-mysql-query/


    PlanetMySQL Blog: The correct approach to rolling MySQL logs Ronald Bradford

    I say correct because there are several incorrect approaches to managing MySQL logs. In MySQL you have two important log files, the MySQL error log and the MySQL slow query log.

    Read the PlanetMySQL BlogPost:
     
    http://ronaldbradford.com/blog/the-correct-approach-to-rolling-mysql-logs-20
    10-02-22/


    PlanetMySQL Blog: Semi-sync Replication Testing Harrison Fisk

    I have recently been trying out semisynchronous replication. This is a new feature added in MySQL 5.5 based on the original google patch.

    Read the PlanetMySQL BlogPost:
     
    http://harrison-fisk.blogspot.com/2010/03/semi-sync-replication-testing.html


    PlanetMySQL Blog: Ineffective concatenated indexes Ronald Bradford

    In MySQL significant performance improvements can be achieved by the correct use of indexes. It is important to understand different MySQL index implementations and one key improvement on indexes defined on single columns is to use multiple column or more commonly known concatenated indexes.

    Read the PlanetMySQL BlogPost:
     
    http://ronaldbradford.com/blog/ineffective-concatenated-indexes-2010-02-24/


    PlanetMySQL Blog: Don't forget the COMMIT in MySQL Geert Vanderkelen

    Yes, MySQL has transactions if you use InnoDB or NDB Cluster for example.
    Using these transactional storage engines, you'll have to commit (or roll
    back) your inserts, deletes or updates.

    Read the PlanetMySQL BlogPost:
      http://geert.vanderkelen.org/2010/02/don-forget-commit-in-mysql.html


    PlanetMySQL Blog: Why do we need InnoDB per table IO statistics?
    Serge Frezefond

    InnoDB plugin offers an adaptive compression that is very interesting for performance. This compression works at a table level. Like most optimization techniques this is not black or white. You have to decide depending on IO patterns/CPU usage/Memory usage/disks constraints what tables are good candidates for compression.

    Read the PlanetMySQL BlogPost:
      http://serge.frezefond.free.fr/?p=335


    PlanetMySQL Blog: How To Set Up MySQL Database Replication With SSL Encryption On Ubuntu 9.10 Falko Timme

    This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred between the master and slave). MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync.

    Read the PlanetMySQL BlogPost:
     
    http://www.howtoforge.com/how-to-set-up-mysql-database-replication-with-ssl-
    encryption-on-ubuntu-9.10

    -------------------------------------------------------------------

    Events

    Live Webinar: Migrating from SQL Server to MySQL - EMEA Thursday, March 11, 2010 - 15:00 CET

    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.

    Register for this Webinar:
      http://dev.mysql.com/news-and-events/web-seminars/display-516.html


    Live Webinar: Windows and MySQL - Part 12: Advanced MySQL Replication on Windows Tuesday, March 16, 2010 - 10:00am PDT

    Join us for Part 12 of the Windows and MySQL webinar series with Jimmy Guerrero and Mike Frank of the MySQL group at Oracle. In this presentation we will build upon the previous presentation and look at more advanced MySQL Replication techniques. We will cover master-master configurations, semi-synchronous replication, fail-over and resynchronization.

    Register for this Webinar:
      http://dev.mysql.com/news-and-events/web-seminars/display-506.html


    Live Webinar: MySQL Cluster for Web & eCommerce Applications: Growing Revenue & Enhancing Loyalty Wednesday, March 24, 2010 - 10:00am PDT

    MySQL Cluster is already proven in powering some of the most demanding, mission-critical web and communications-based services. This session discusses how MySQL Cluster can enable you to cost-effectively deploy online applications to generate new revenue streams and build vibrant user communities with continuous database availability and high performance.

    Register for this Webinar:
      http://dev.mysql.com/news-and-events/web-seminars/display-513.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 webinars:
      http://dev.mysql.com/news-and-events/web-seminars/index.html

    -------------------------------------------------------------------

    Want to receive the latest MySQL updates and interact with the MySQL community?

    Follow MySQL on Twitter:
      http://twitter.com/mysql

    Follow MySQL Community on Twitter:
      http://twitter.com/mysql_community

    -------------------------------------------------------------------

    About the Newsletter

    You can send us queries and give us feedback online.
      http://dev.mysql.com/contact/

    Read more about the newsletter and view previous issues.
      http://dev.mysql.com/news-and-events/newsletter/

    --
    Copyright (c) 2010, Oracle Corporation and/or its affiliates.
    You are free to distribute this newsletter, as long as you don't make any changes.

    A few days ago, as mentioned, I initiated the process of moving TransProCalc onto google code, feeling that it was time to dust off the project and move forward with it. I had merely signed the project up at that time, so, last night, before my brain turned to complete jello after spending the day slogging through the translation of some pretty heavy Brazilian academic articles, I took some time to configure the google code pages for the project, make a couple of wiki pages, upload the current, stable release, and, upload the existing code for the project. Now, google code offers two version control systems, Subversion and Mercurial. I've never used either one before, but, at least I've heard of Subversion, so I chose to go with that one. It is, apparently, the default system, Mercurial offered as an option. I have used CVS before. So, I aptitude installed subversion (svn) on from the debian/lenny repos, and set about trying to import my code for the first time to the project. The instructions on the google Subversion FAQ for importing your code are rather succint.
    Just use the 'svn import' command.
    . Very thorough... So, the first thing I did was, logically, try to read the man page. Now, people frequently complain that man pages are written for the hopelessly, inhumanly geeky, and not very useful for the rest of us (ok, I do write code, but I am far from being a real hacker, yet), that they are written in some secret language, and that they are generally useless. Of course, those in the know say to read them, and find them rather useful. I confess, I have actually come to the point where I can make sense of some man pages. I'm not even ashamed to admit it. Some of them are insanely usefl (ncftp, for instance, has a very thorough man page). So, I called up "man svn". This is what I got:
    NAME svn - Subversion command line client tool SYNOPSIS svn command [options] [args]
    [sarcasm]That certainly cleared everything up for me...[/sarcasm] How about explaining the options? What args? Hello! I tried "svn help", and that gave me a list of commands, as least, but with no explanation of how to implement them, or what they did, what options or arguments could be passed to them... Folks, the Subversion project needs documentation writers. No doubt. So, I did the next natural then, and did some googling. In defense of subversion, I must say, they have an entire book/manual for Subversion, available to be purchased in print, or read online for free. Of course, the instructions I found in said book was that in order to import my code to my google code project, I was a bunch of garbbledy-gook, and said nothing of importing to a remote repository, only creating a repository on a local machine. I needed to import my code to a remote repository. I did some ranting on some forums, to no avail of course (ah, but the sweet release of venting...), and did some experimenting. I ended up resetting the repository a total of about 4 times, before I finally managed to figure out how to a) set up the svn repo at my end, b) import the code to google, and c) check in and check out. So the code is up there, now. Now, there do seem to be instructions available for checking out and checking in. That's not too bad. But considering the complete lack of instruction on how to actually import the code of the first time, I thought I'd share the culmination of my efforts.
    :~$ cd /path/to/project/files :~$ svn import https://projectname.googlecode.com/svn/trunk/ --username yourname
    There! Your code is imported to the svn repo... I know looks simple, but there was nowhere that I could find an explanation thereof. (okay, it might as well be martian to some of you, dear readers, but those who right code and participate in open source software projects will understand). Happy? I am. So, TransProCalc is now up on google code and ready to start a new life. I actually made a few minor changes to the code already, last night, before loading it up there, but not enough that I would call it a release or new version...just a little clean up, rewrote the install script, and, more than anything, a lot more commenting, since I'm hoping to have collaborators. Commenting your code makes it easier for others to find stuff and figure out what you're doing. And, happily, I have a collaborator already! Anindita Basu, who had previously written a manual for TransProCalc, has rejoined the project (it's been out of development for nearly 2 years, recall). ADDITIONALLY, TRANSPROCALC NEEDS TCL/TK DEVS! Want to sink your teeth into an open source translation project management project? Check out TransProCalc. I have big plans for TransProCalc, many new features to be implemented, including but not limited to incorporation of a providers and client db, more user configurability of project parameters, and a calendar/reminder system to annoy you when invoices are due (either to you, or to your providers). No time to work on any of that today, though...back to these articles...
    originall posted to tony baldwin | bloguiando

    Like our work? Support Us

    Feed Subscription

    Enter your email address:

    Delivered by FeedBurner

    CMS Demos


    Joomla Demo - looking for exploring Joomla? It’s the right place for you. Explore preset Joomla application of all versions or request your own exclusive demo for free for 90 days of any Joomla version.

    WordPress Demo - Do you love WordPress and/or want to see how it works? WordPress Demo is the best place for you to request your exclusive demo for 90 days without paying a penny. You can request for any WP version and can also explore preset demo sites of different versions.