Tag Archives: MySQL

Cloud Platform as a Service Comparison- Cloud Foundry vs CloudBees vs CloudSwing

Cloud Platform as a Service Comparison- Cloud Foundry vs CloudBees vs CloudSwing

  Cloud Foundry CloudBeeS CloudSwing
Description Cloud Foundry is the open platform as a service project initiated by VMware. It can support multiple frameworks, multiple cloud providers, and multiple application services all on a cloud scale platform. The CloudBees platform is the first Platform as a Service that lets companies build, test and deploy Java web applications in the cloud. CloudSwing is a solution that allows you to deploy any application on any technology stack to any cloud, creating a fully flexible PaaS (Platform-as-a-Service).
Web-Site www.cloudfoundry.com http://www.cloudbees.com/ https://cloudswing.openlogic.com
Development Status Beta Production Production
Technology Java / Spring, Groovy/Grails, Ruby Rails & Sinatra, Node.js Java Java, Ruby, JavaScript, PHP and other languages.
Open Source Yes No No
Database MongoDB, MySQL and Redis Shared and dedicated MySQL databases, Reliable, distributed Database-as-a-Service, based on Apache CouchDB MySQL
Database as a Service No Yes No
API CLI REST API and CLI tools to automate tasks -
Pricing The pricing of commercial service is not being announced as of now. http://www.cloudbees.com/cloud-platform-pricing.cb http://www.openlogic.com/cloud/pricing.php
DevTest Environment No Yes, Manual and Selenium-driven cross-browser testing on the cloud No
Free Trail Free in beta CloudBees provides a FREE subscription for all of its core platform services – this allows you to get a taste of where next generation software development is heading to. Free Minutes/Month (m1.small only)**-300 There is a Free Plan for CloudSwing that enables you to set up an account with up to 3 members and deploy up to 5 concurrent applications through CloudSwing.
Real-time web monitoring and analytics Hyperic Brings Application Monitoring to Cloud Foundry New Relic CloudSwing Leverages New Relic to Monitor Application
Continuous Integration (CI) server Cloud Foundry Maven Plugin. Jenkins -
Eclipse Plugin Yes CloudBees Toolkit for Eclipse -

PHP 5 Power Programming (Download Free)

PHP 5 Power Programming

Click on the Image to Download

In this book, PHP 5‘s co-creator and two leading PHP developers show you how to make the most of PHP 5′s industrial-strength enhancements in any project–no matter how large or complex.

Their unique insights and realistic examples illuminate PHP 5′s new object model, powerful design patterns, improved XML Web services support, and much more. Whether you’re creating web applications, extensions, packages, or shell scripts–or migrating PHP 4 code–here are high-powered solutions you won’t find anywhere else.

Review PHP’s syntax and master its object-oriented capabilities–from properties and methods to polymorphism, interfaces, and reflection.

  • Master the four most important design patterns for PHP development
  • Write powerful web applications: handle input, cookies, session extension, and more
  • Integrate with MySQL, SQLite, and other database engines
  • Provide efficient error handling that’s transparent to your users
  • Leverage PHP 5′s improved XML support–including parsing, XSLT conversions, and more
  • Build XML-based web services with XML-RPC and SOAP
  • Make the most of PEAR: work with the repository, use key packages, and create your own
  • Upgrade PHP 4 code to PHP 5–compatibility issues, techniques, and practical workarounds
  • Improve script performance: tips and tools for PHP optimization
  • Use PHP extensions to handle files/streams, regular expressions, dates/times, and graphics
  • Create original extensions and shell scripts

If you’re a software developer new to PHP, you’ll leap quickly into PHP and its new object-oriented capabilities. If you’re an experienced PHP programmer, you already recognize PHP’s convenience and simplicity. Now, discover all of its extraordinary power!

By: Andi Gutmans, Stig Bakken & Derick Rethans. Published by Prentice Hall. Part of the Bruce Perens’ Open Source series.

Offered Free by: informIT

Download

 

How to install Magento in Ubuntu

To install Magento in Ubuntu - Now it’s turn to install another eCommerceMagento‘ which is feature-rich eCommerce platform built on open-source technology. Magento is available in two editions: Community and Enterprise.

Installing and Configuring Apache

$ sudo apt-get install apache2

You may see following message during installation:

apache2: Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName

To fix that problem, you need to edit the httpd.conf file. Open the terminal and type

$ sudo gedit /etc/apache2/httpd.conf

By default httpd.conf file will be blank. Now, simply add the following line to the file.

ServerName localhost

Save the file and exit from gEdit.

Finally restart the server.
$ sudo /etc/init.d/apache2 restart

* Restarting web server apache2
…. waiting             [ OK ]

sudo a2enmod rewrite

Installing PHP

sudo apt-get install php5 php5-curl php5-gd php5-mcrypt php5-mysql

Installing MySQL

sudo apt-get install mysql-server

To know more system requirements click on following link :

http://www.magentocommerce.com/system-requirements

Now create directory for magento

mkdir /home/magento
chgrp www-data /home/magento
mkdir -p /home/magento/{public,log}

Configuring Apache Virtual Host

Now we are going to create simple virtual host configuration file that will help Apache to display the data of directory /home/ubuntu/magento for any HTTP request to localhost.magento.com

Create “magento.com” file in this location “/etc/apache2/sites-available/” with following content.

ServerName localhost.magento.com
ServerAlias www.localhost.magento.com

DocumentRoot /home/ubuntu/magento/public

LogLevel warn
ErrorLog /home/ubuntu/magento/log/error.log
CustomLog /home/ubuntu/magento/log/access.log combined

Use a2ensite command and restart Apache to load the new configuration file.

sudo a2ensite magento.com
sudo service apache2 restart

To ensure that the domain localhost.magento.com resolves locally to the computer require entries to /etc/hosts file.

# For magento

127.0.0.1 localhost.magento.com
127.0.0.1 www.localhost.magento.com

Now hit localhost.magento.com in your browser to check working status after completion of above entries.

Now we will execute installation steps of main topic.

Type following command on prompt. It will ask for root user password.

mysql -u root -p

Now lets create database for Magento.

CREATE DATABASE magento;
INSERT INTO mysql.user (User,Host,Password) VALUES(‘magento’,'localhost’,PASSWORD(‘magento’));
GRANT ALL PRIVILEGES ON magento.* TO magento@localhost;

Now download latest stable Magento from
http://www.magentocommerce.com/download
and put zip file into /home/ubuntu/magento/public

For testing Magento, you can download it from
http://www.magentocommerce.com/downloads/assets/1.6.1.0/magento-sample-data-1.6.1.0.tar.gz

mv magento-sample-data-1.6.1.0/media/* media/
mv magento-sample-data-1.6.1.0/magento_sample_data_for_1.6.1.0.sql sample_data.sql

Now we have to insert sample data into database that we earlier created for Magento.

mysql -u magento -p
USE magento;
SOURCE sample_data.sql;

Now everything is setup so open your browser and type localhost.magento.com and follow installation steps. You will find following screen.

Here is your Magento is working.

Cost Modeling – Plan for Cloud

Cost Modeling – Plan for Cloud: Cost Modeling of Cloud Deployments on Public Cloud such as AWS, Google, Microsoft Azure and Rackspace with RightScale-PlanForCloud

PlanForCloud allows innovative modeling of the elements of cloud deployments, such as servers, storage, databases and data transfers, as well as usage scenarios that incorporate growth, seasonality and other variability in the consumption of cloud resources. Deployments are run through a simulation to create a detailed 3-year cost report that enables you to accurately forecast costs for new deployments or budget for future usage. You do not need to be on the cloud and we do not require any cloud credentials.

Reports: each deployment has its own cost report that shows the estimated cost of that deployment over three years from the date of report generation.

It uses Google Money- http://www.google.com/finance/converter to get live exchange rates at the time of report creation in order for your cost reports to be shown in your chosen currency.

Click on http://www.planforcloud.com/

RightScale-PlanForCloud Home Page

RightScale-PlanForCloud Home Page

Sign up for New User or Login as a Guest

RightScale-PlanForCloud: Sign Up

RightScale-PlanForCloud: Sign Up

Log in

RightScale-PlanForCloud: Log in

RightScale-PlanForCloud: Log in

Dashboard

RightScale-PlanForCloud: Dashboard

RightScale-PlanForCloud: Dashboard

Sample Report- 3 year Cost Report

RightScale-PlanForCloud: Sample 3-Year Cost Report

RightScale-PlanForCloud: Sample 3-Year Cost Report

Create New Deployment

deployment represents groups of servers, storage and databases. Each deployment has its own cost report.

RightScale-PlanForCloud: Create New Deployment

RightScale-PlanForCloud: Create New Deployment

Give Resource Name such as Web Servers, Application Servers, Load Balancers;

Select Cloud Type from AWS, Google, Microsoft Azure and Rackspace.

RightScale-PlanForCloud: Cloud Type

RightScale-PlanForCloud: Cloud Type

Select Server Type from the available configurations for selected Cloud; We have selected AWS for our Sample Deployment.

Select Usage parameter

RightScale-PlanForCloud: Server Usage

RightScale-PlanForCloud: Server Usage

Select Quantity and then Select Pattern.

Patterns provide users the facility to scale up and scale down the resources as per their application need; for example in festival season traffic to the application is more than normal scenario; User can provide scale up configuration for that specific period.

Note: Patterns are not available for Reserved Instances as of now.

RightScale-PlanForCloud: Patterns for Scale up and Scale Down

RightScale-PlanForCloud: Patterns for Scale up and Scale Down

Final Server Configuration is

RightScale-PlanForCloud: Server Configuration

RightScale-PlanForCloud: Server Configuration

Storage Deployment

Select Storage for WebServer and Backup; Select Specific Cloud Type and Storage Type as well. User can select Patterns also.

RightScale-PlanForCloud: StorageConfiguration

RightScale-PlanForCloud: StorageConfiguration

Database Configurations

For AWS, MYSQL and Oracle are available as a Database and that also in different flavors.

RightScale-PlanForCloud: AWS Database Selection

RightScale-PlanForCloud: AWS Database Selection

Database Configuration for HPCDemo is

RightScale-PlanForCloud: Database Configuration

RightScale-PlanForCloud: Database Configuration

Data Transfer Configurations

RightScale-PlanForCloud:  Data Transfer Configuration

RightScale-PlanForCloud: Data Transfer Configuration

3 Year cost report for HPCDemo

RightScale-PlanForCloud: 3-Year Cost Report

RightScale-PlanForCloud: 3-Year Cost Report

Detail Report, Year wise

RightScale-PlanForCloud: 3-Year Detail Cost Report

RightScale-PlanForCloud: 3-Year Detail Cost Report

All Deployments

RightScale-PlanForCloud: All Deployments

RightScale-PlanForCloud: All Deployments

I believe PlanForCloud will soon add Cloud Management Cost as well since it has been taken over by RightScale and I guess they were giving same facility before.

Incremental Backup in MySQL

Incremental Backup

To get a consistent backup, do a LOCK TABLES on the relevant tables, followed by FLUSH TABLES for the tables.

You need only a read lock; this allows other clients to continue to query the tables while you are making a copy of the files in the database directory.

The FLUSH TABLES statement is needed to ensure that the all active index pages are written to disk before you start the backup.

mysqldump is more general because it can back up all kinds of tables.
LOCK TABLES and UNLOCK TABLES Syntax
MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating with other sessions for access to tables, or to prevent other sessions from modifying tables during periods when a session requires exclusive access to them.

A session can acquire or release locks only for itself. One session cannot acquire locks for another session or release locks held by another session.

LOCK TABLES explicitly acquires non-transactional or transactional table locks for the current client session. Table locks can be acquired for base tables or views. You must have the LOCK TABLES privilege, and the SELECT privilege for each object to be locked.

UNLOCK TABLES explicitly releases non-transactional table locks held by the current session. Transactional table locks are released by ending the current transaction.

A table lock protects only against inappropriate reads or writes by other sessions. The session holding t

Bugzilla-Issue Tracking System

 

Introduction
Bugzilla is a Web-based general-purpose bugtracker and testing tool originally developed and used by the Mozilla project, and licensed under the Mozilla Public License. Bugzilla is the most popular bug tracking system available today. Bugzilla’s popularity is due to its highly customizable interface, easy configuration, and a large community of very active users. With Bugzilla, you can begin configuring your products, users, and bugs within minutes of starting up the system. Bugzilla provides you with many features, including:

ü  LDAP integration

ü  Internationalized

ü  User authentication, group security, and SSL support

ü  Voting system

ü  Shortcut flags

ü  Custom fields

ü  Keyword tagging

ü  Saved searches

ü  Voting module

ü  Multiple report types
System Requirements
Bugzilla’s system requirements include:

ü  A compatible database management system

  •     MySQL: All Bugzilla versions support MySQL.
  •     PostgreSQL: Bugzilla 2.22 and above contain complete, stable support for PostgreSQL.
  •     Oracle: Bugzilla 3.2 and above have experimental support for Oracle.
  •     MS-SQL: MS-SQL support is currently underway for Bugzilla 3.8.

ü  A suitable release of Perl 5

ü  An assortment of Perl modules

ü  A compatible web server

ü  A suitable mail transfer agent, or any SMTP server

Currently supported database systems are. Bugzilla is usually installed on Linux and runs using the Apache HTTP Server, but Microsoft Internet Information Services or any web server that supports CGI such as Lighttpd, Hiawatha, Cherokee can be used. Bugzilla’s installation process is command line driven and runs through a series of stages where system requirements and software capabilities are checked.

Features

  • Optimized database structure for increased performance and scalability
  • Excellent security to protect confidentiality
  • Advanced query tool that can remember your searches
  • Integrated email capabilities
  • Editable user profiles and comprehensive email preferences
  • Comprehensive permissions system
  • Proven under fire as Mozilla’s bug tracking system

For Users

ü  Advanced Search Capabilities

ü  Email Notifications Controlled By User Preferences

ü  Bug Lists in Multiple Formats (Atom, iCal, etc.)

ü  Scheduled Reports (Daily, Weekly, Hourly, etc.) by Email

ü  Reports and Charts

ü  Automatic Duplicate Bug Detection

ü  File/Modify Bugs By Email

ü  Time Tracking

ü  Request System

ü  Private Attachments and Comments

ü  Automatic Username Completion or Drop-Down User Lists

ü  Patch Viewer

ü  “Watch” Other Users

ü  Move Bugs Between Installs

ü  Save and Share Searches

For Administrators

ü  Excellent Security

ü  Extension Mechanism for Highly Customizable Installations

ü  Custom Fields

ü  Custom Workflow

ü  Full Unicode Support

ü  Localization

ü  mod_perl Support for Excellent Performance

ü  Webservices (XML-RPC) Interface

ü  Control Bug Visibility/Editing with Groups

ü  Impersonate Users

ü  Multiple Authentication Methods

ü  Support for Multiple Database Engines

Bugzilla 3.0 Life Cycle

Bugzilla 3.0 Life Cycle

ü  Sanity Check
Life Cycle

Benefits

  • Improve communication
  • Increase product quality
  • Improve customer satisfaction
  • Ensure accountability
  • Increase productivity
  • Bugzilla can adapt to multiple situations

Comparison of issue-tracking systems

General

System

Creator

License

Implementation language(s)

Back end

Launch Date

Assembla Tickets Assembla Proprietary, hosted. Available for free for open source projects Ruby MySQL 2008
Bontq Bontq LLC Proprietary, hosted. Available for free for open source projects PHP, Java PostgreSQL 2010
BugTracker.NET Corey Trager GPL ASP.NET, C# on Windows SQL Server, SQL Server Express 2002
Bugzilla Mozilla Foundation MPL Perl MySQL, Oracle, PostgreSQL 1998-09-19
Cerebro CineSoft Proprietary C++, Qt PostgreSQL 2009
codeBeamer Intland Software Proprietary, free version Java MySQL, Oracle, Apache Derby or Postgres 2002
Debbugs Debian GPL Perl Flatfile, Berkeley DB indexes 1994
FIT Issue Management Alcea Technologies Proprietary Java flat-file, optional extension for SQL Server, MySQL, Oracle (via JDBC) 2004
Flyspray flyspray.org LGPL PHP Mysql, PostgreSQL 2003
FogBugz Fog Creek Software Proprietary ASP.NET on Windows, Mono on Mac, FreeBSD, and Linux SQL Server, MySQL 2000
Fossil D. Richard Hipp BSD C SQLite 2006
Gemini Countersoft Proprietary, free for non profit / open source ASP.NET, C# Microsoft SQL Server 2003
GNATS Free Software Foundation GPL C MySQL 1992
GLPI INDEPNET GPL PHP MySQL 2003-11-17
Google Code Hosting Google Code Proprietary, hosted; available for open source projects Python BigTable 2004
HP Quality Center Hewlett-Packard, formerly Mercury Interactive Proprietary C++ (Visual Studio.NET 2005) (client), Java (server) SQL Server, Oracle 1995
IBM Rational ClearQuest Rational Software Proprietary kernel: executables for several platforms; hooks: Perl and Visual Basic IBM DB2, Oracle, SQL Server, Access, Sybase ASA 1998
IBM Rational Team Concert Rational Software Proprietary kernel: Java; API: Java IBM DB2, Oracle, SQL Server, Apache Derby

Unknown

ikiwiki Joey Hess mostly GPLv2 (mixed) Perl git, darcs, bzr, svn, monotone, mercurial, tla

Unknown

IssueNet Elsinore Technologies Inc. Proprietary ASP.NET, C#, C++ SQL Server

Unknown

IssueTrak IssueTrak Inc. Proprietary, Hosted and On-Premises ASP, JavaScript Microsoft SQL Server 2000
iSupport iSupport Software Proprietary, Commercial, Source Code License available ASP.NET, XHTML, C# Microsoft SQL Server 1994
JIRA Atlassian Proprietary, Free for non-commercial use Java MySQL, PostgreSQL, Oracle, SQL Server 2003
Launchpad Canonical Ltd. AGPL, hosted. Available for free for open source projects Python, JavaScript PostgreSQL 2004
Liberum Help Desk Doug Luxem GPL ASP SQL Server, Access 2000
Kayako SupportSuite Kayako Proprietary, some parts GPL PHP MySQL 2001
LibreSource Artenum GPLv2 HTML, Java on all platforms PostgreSQL

Unknown

ManageEngine ServiceDesk Plus ZOHO Corporation Proprietary Java MySQL, SQL Server

Unknown

MantisBT Various (open source contributors) GPLv2 PHP ADOdb (MySQL, PostgreSQL, SQL Server, etc.) 2000
Microsoft Dynamics CRM Microsoft Proprietary, Commercial .NET Microsoft SQL Server 2003
Mojo Helpdesk Metadot online / hosted only Ruby on Rails

Unknown

Unknown

OnTime Axosoft Proprietary, Saas C#, .NET SQL Server 2002
org-mode Carsten Dominik GPLv3 Emacs Lisp text file(s)

Unknown

OTRS otrs.org AGPL Perl MySQL, PostgreSQL, Oracle, SQL Server 2002
Planbox Planbox Proprietary, free version PHPJava MySQL 2009
Pivotal Tracker Pivotal Labs Proprietary, free version Ruby on Rails Ruby on Rails, MySQL, Memcached 2008
Plain Ticket Turbine interactive Proprietary, online, hosted. Java MySQL 2011
Projistics Nagarro Proprietary C#, .NET, Com+ SQL Server

Unknown

Redmine Jean-Philippe Lang GPLv2 Ruby on Rails MySQL, PostgreSQL, SQLite 2006
Remedy Action Request System BMC Software Proprietary C Oracle, SQL Server, DB2, Informix, Sybase ASA 1992
Request Tracker Best Practical Solutions, LLC GPL Perl MySQL, PostgreSQL, Oracle, SQLite 1999-10-13
Roundup Ka-Ping Yee, Richard Jones MIT license (ZPL v 2.0 for the template system) Python SQLite, MySQL, PostgreSQL, Berkeley DB 2001
StarTeam originally Starbase Corporation, currently Borland Proprietary Java, C++, others SQL Server recommended, Oracle, DB2 supported

Unknown

Supportworks Hornbill Systems Proprietary Visual C++ and PHP SQL Server, MySQL, Oracle, Sybase 1994
Team Foundation Server Microsoft Proprietary, Commercial .NET MS SQL Server 2005 & 2008 2005
Teamwork Open Lab Proprietary, some parts LGPL Java all relational (uses Hibernate) 2003
Trac Edgewall Software New BSD Python SQLite, PostgreSQL, MySQL 2006-10-01
Unawave Unawave LLC Proprietary

Unknown

Unknown

2010
Web Help Desk MacsDesign Studio, LLC Proprietary Java OpenBase, FrontBase, MySQL, SQL Server, PostgreSQL, Oracle 1999
Wrike Wrike, Inc. Proprietary, hosted Java PostgreSQL 2006
YouTrack JetBrains s.r.o. Proprietary, stand-alone and hosted, free version, free for open source projects Java, MPS-based DSLs JetBrains DB 2009
Zentrack Wrike, Inc. GPL PHP MySQL

Unknown

Zoho BugTracker Zoho Corp. Proprietary Java MySQL 2011

Features

System

Dynamic documentation integration/generation

Test planning integration

Customizable workflow

Unicode support

Custom Fields

SLA

Plugin API

Multiple Projects

Assembla Wiki syntax, email notification, linking to Subversion commits, document manager, charts, reports, notifications

Yes

Yes

Yes

Yes

No

Yes

Yes

BugTracker.NET integrated charts and reports

No

Yes

Yes

Yes

No

No

Yes

Bugzilla reporting: integrated reports and charts, scheduled reports by mail

Yes[3]

Yes

Yes

Yes

No

Yes

Yes

codeBeamer Yes, Integrated document manager, Scrum, Kanban, waterfall project mgm, Wiki, custom dashboard, multiproject report, baselineing, release mgm, API, RSS, ActivityStream, notifications

Yes

Yes

Yes

Yes

Yes

Yes

Unknown

Debbugs No

No

No

Yes

No

No

No

Unknown

Flyspray Yes, Roadmaps, overviews of projects, dependencies diagrams

Yes

Yes

Yes

No

No

Yes[9]

Yes

FogBugz Integrated wiki

No

Yes

Yes

Yes

No

Yes[10]

Yes

Fossil Yes, Integrated Wiki in addition to integrated versioned project documentation via web ui.

No

No

No

Yes

No

No

Yes[14]

Gemini Yes, Integrated document manager, RSS, charts, reporting engine, remote API, notifications, custom fields/values for issues

Yes[16]

Yes

Yes

Yes

No

Yes

Yes

GNATS No

No

No

No

No

No

No

Unknown

Google Code Hosting Wiki syntax, email notification, linking to Subversion commits, custom fields/values for issues

No

Yes

Yes

Yes

No

No

Yes

HP Quality Center Yes

Yes

Yes

No

Yes

No

Yes

Yes

IBM Rational ClearQuest reporting: integrated charts and interface to Crystal Reports

Yes

Yes

Yes

Yes

No

No

Yes

IBM Rational Team Concert Yes

Yes

Yes

Yes

Yes

No

Yes

Yes

ikiwiki No

No

No

Yes

Yes

No

No

Unknown

IssueNet Advanced reporting, configurable dashboards, Microsoft Project integration

No

Yes

Yes

Yes

No

Yes

Unknown

IssueTrak Task management, Workflow, Custom reporting, Knowledge Base, dashboard, service level agreement, automatic assignment, file attachments, inbound and outbound email, active directory integration, Asset Management, escalation rules, surveys, global issues, projects

No

Yes

No

Yes

Yes

Yes

Yes

iSupport Extensive workflow, automated or manual routing, service level agreements, ITIL, automatic assignment, statistical reports, Knowledge Base, advanced search, file attachments, inbound emails to issues, notifications, configurable dashboard, report writer, WMI based asset management, escalation rules, surveys, related issues, call scripts

No

Yes

Yes

Yes

No

No

Unknown

JIRA Workflow with triggers, timers, and conditions, dashboard with reporting widgets (Open Social), Customizable fields for each project, HTML, XML, RSS, PDF, Excel, Word, customizable charts, Confluence (Enterprise wiki)

Yes[18]

Yes

Yes

Yes

Yes

Yes[19]

Yes

Liberum Help Desk No

No

No

No

No

No

No

Unknown

LibreSource No

No

No

Yes

No

No

No

Unknown

Kayako SupportSuite Knowledgebase builder, reports, integrated download manager, step-by-step troubleshooter builder

No

No

Yes

Yes

Yes

Yes

Unknown

MantisBT Yes, Integration of MediaWiki, DokuWiki, XWiki

No

Yes

Yes

Yes

No

Yes

Yes

Microsoft Dynamics CRM reporting: integrated charts and reports, export to Excel, Mail Merge

No

Yes

Yes

Yes

No

Yes

Unknown

Mojo Helpdesk Yes

Yes

Yes

Yes

Yes

Yes

No

Unknown

OnTime Wiki, SVN, VSS, Vault, Email Notification, Subversion

No

Yes

Yes

Yes

Yes

Yes

Yes

org-mode No

No

Yes

Yes

Yes

No

No

Unknown

OTRS Advanced reporting, configurable dashboards

No

Yes

Yes

Yes

Yes

Yes

Unknown

Planbox Yes, thru File sharing, RSS, User story backlog, charts, reporting engine, Open API, email notifications, custom fields for issues, time tracking, searchable labels.

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Pivotal Tracker Yes, real time collaborative story backlog, integrated reports, email notification

Yes

No

Yes

No

No

Yes

Yes

Plain Ticket Yes

Yes

Yes

Yes

Yes

Yes

No

Yes

Projistics Yes

No

Yes

Yes

No

No

No

Unknown

Redmine Yes, integrated wiki, discussion forums, news blogs, email integration, calendars, Gantt Charts, export to PDF, export to Excel/CSV

Yes[25]

Yes

Yes

Yes

No

Yes

Yes

Remedy Action Request System With RKM, the Remedy Knowledge Base product from BMC

No

Yes[28]

Yes

Yes

Yes

Yes

Unknown

Request Tracker Yes, MediaWiki[30]

No

Yes

Yes

Yes

Yes[31]

Yes[32]

Yes

Roundup wiki can be integrated or linked

No

Yes

Yes

Yes

No

No

Yes

StarTeam No

Yes[36]

No

No

No

No

No

Unknown

Supportworks Yes – Integrated reporting wizard, customizable PHP reporting tool, dashboard, optional interface with Crystal Reports, export to Microsoft Excel/CSV, knowledge base, optional asset management tool

No

Yes

No

Yes

Yes

Yes[37]

Unknown

Team Foundation Server Yes – workflow definitions, process documentation

Yes

Yes

Yes

Yes

No

Yes

Yes

Teamwork Yes

Yes

Yes

Yes

Yes

Yes

No

Yes

Trac Yes, integrated wiki

Yes

Yes

Yes

Yes

No

Yes[39]

No

Unawave Yes, works within Google Wave

No

No

Unknown

No

No

No

Unknown

Web Help Desk Dynamic request forms based on category choice, Dynamic auto-routing of request tickets, Auto FAQ generation, Integrated charts and reports, context sensitive help

No

Yes

Yes

Yes

No

No

Unknown

Wrike real-time customized reports, export to Excel, scheduled reports by mail, alerts, discussions, Gantt charts,

No

Yes

Yes

No

No

No

Unknown

YouTrack Yes: Wiki syntax, custom workflow, custom issue attributes, notifications (email, jabber, RSS, etc.), email integration, reports, export to HTML and CSV, integration with VCSs.

Yes[43]

Yes

Yes

Yes

No

No[44]

Yes

Zentrack No

No

Yes

Yes

Yes

No

Yes

Unknown

Zoho BugTracker Yes

No

Yes

Yes

Yes

No

No

Yes

Installation List
A large number of companies, organizations, and projects use Bugzilla. This page showcases a few particularly high-profile or otherwise interesting installations, and also contains a complete list of known Bugzillas.

Free Software Projects

Linux Distributions

Companies

References
http://www.bugzilla.org/

http://www.bugzilla.org/features/

http://www.bugzilla.org/installation-list/

http://www.click2try.com/tutorial/bugzilla30/click2try_bugzilla30_Tutorial.pdf

http://en.wikipedia.org/wiki/Comparison_of_issue_tracking_systems