Informix 11.50 Embeddability, Virtualization, and Cloud Computing © 2010 IBM Corporation

Informix 11.50
Embeddability, Virtualization, and Cloud Computing
Information Management Partner Technologies - Informix
© 2010 IBM Corporation
Agenda
• Informix Embeddability
•
•
•
•
•
•
What is Enterprise Class Embeddability?
Embeddability Overview
Types of Embedded Database Solutions
Deploying Embedded Informix Databases using the Deployment Utility
Automating Low-footprint Informix Deployments
Enabling Technology for Embeddability
• Informix Virtualization and Cloud Computing
•
•
•
•
•
•
Informix Virtualization Strategy
Informix Virtualization Overview
The Informix virtual appliance
Cloud Computing
Amazon Web Services EC2
Virtualization and Cloud Roadmap
• Appendix
2
© 2010 IBM Corporation
Agenda
• Informix Embeddability
•
•
•
•
•
•
What is Enterprise Class Embeddability?
Embeddability Overview
Types of Embedded Database Solutions
Deploying Embedded Informix Databases using the Deployment Utility
Automating Low-footprint Informix Deployments
Enabling Technology for Embeddability
• Informix Virtualization and Cloud Computing
•
•
•
•
•
•
Informix Virtualization Strategy
Informix Virtualization Overview
The Informix virtual appliance
Cloud Computing
Amazon Web Services EC2
Virtualization and Cloud Roadmap
• Appendix
3
© 2010 IBM Corporation
What is Enterprise Class Embeddability?
An enterprise class
embeddable database
server combines
embeddable
features such as low
footprint, zero
administration,
programmable and
autonomic capabilities
with enterprise class
database features such
as 99.999% availability,
flexible replication
features, standards
conformance, security,
extensibility, high
OLTP performance.
4
© 2010 IBM Corporation
Embeddability Overview – Traditional Embedded App
Application
Users
• Reacts to event alarms
• Monitors logs
• Queries system tables
• Calls command line
utilities
• Unforeseen failures
require application re-set
or manual intervention
5
© 2010 IBM Corporation
Embeddability Overview – Informix 11.50
• SQL Admin
API allows
application to
perform
DBA tasks
using SQL
• DB Scheduler
enables
scheduled
autonomous
administration
tasks
• New alarms
reduce the
application
monitoring
workload
Users
Remote
DBA(s)
Application
Application Code
SQL Admin
API
SQL
DB Scheduler
Monitoring
Agent
Alarms
Tasks
Sensors
System Tables
Logs
IDS
Application development effort is reduced
6
© 2010 IBM Corporation
Types of Embedded Database Solutions
• Invisible (or Deep) Embedding
• Integrated Administration
• Included
7
© 2010 IBM Corporation
Embedded Types - Invisible (or Deep) Embedding
• A database administrator cannot connect to the server
• Administration needs to be handled programmatically
• Needs the most API and scripting support
• An example would be a consumer electronics device which needs to operate on a standalone
basis, or is not accessible by a network
8
© 2010 IBM Corporation
Embedded Types - Integrated Administration
• Entails the tools and utilities to support the server are included
• An ISV integrating Informix will ensure that all the necessary
administration tools that the user needs for administration of the solution
are included:
• Monitoring tools, Backup tools, and Integrity checking
• An integrated solution includes middleware that uses Informix as the
backend. The IT staff is still expected to handle maintenance and
administration of the environment
9
© 2010 IBM Corporation
Embedded Types - Included
• The database server is bundled with the application
• Informix is typically administered by a DBA
• Simplest scenario as there are no extra steps on the Informix server end
• An example of an included solution is a CRM solution using Informix as
the backend
10
© 2010 IBM Corporation
Deploying Embedded Informix Instance - Pre-11.50.xC6
In a traditional
embedded database
deployment the
application will script a
silent installation of
Informix, call command
line utilities and run SQL
to setup the instance,
create databases and
populate with data
11
© 2010 IBM Corporation
Deploying Embedded Informix Instance - User Stories
• As an ISV, embedding Informix installation and deployment as part of
application deployment puts a significant load on our programmers. We
have to script silent installation, instance creation and setup, database
creation and data load. All of this, including chunk initialization and
system database creation takes time which has an impact on our
customers as well as our programmers.
• We want our customers to be able to install our application on multiple
platforms by simply specifying the install location, and automatically
have a ready to use Informix instance complete with data
• Our users do not have root permissions so we need to split Informix
installation into non-root and root components, so a system
administrator can run a single command to complete the deployment
• As a DBA I want to deploy pre-configured Informix instances to different
locations, making small configuration changes to each one
• As a DBA I wish to create new instances on the same machine with a
single command
• Answer : The New Informix Deployment Utility (DU) bundled with
Informix 11.50.xC6
12
© 2010 IBM Corporation
Deploying Pre-configured Instance – Informix 11.50.xC6
1. Install and set up
instance on a template
machine
2. Copy a snapshot of the
pre-configured instance
3. Application deploys
snapshot using
ifxdeploy
13
OR: Create solutions as pre-configured
virtual appliances and cloud images
© 2010 IBM Corporation
Example Solution - Lightweight Informix on Mobile Devices
App
ER
App
App
ER
ER
3G, WLAN,
Broadband..
14
• Example uses: Retail
POS/inventory, Transit
agents
• Informix instance stripped
down to minimum required
components and deployed
to mobile device using
Deployment Utility
© 2010 IBM Corporation
Deployment Utility (DU) – UNIX Usage
15
© 2010 IBM Corporation
Deployment Utility (DU) – Windows Usage
16
© 2010 IBM Corporation
Deployment Utility (DU) Configuration File
• All ifxdeploy command line arguments can be specified in a configuration file
and passed to the command line using the –config option instead
• E.g. ifxdeploy –config $INFORMIXDIR/etc/ifxdeploy.conf
• If the same options are in the config file and on the command line, command line
takes precedence
• If the same options are in the config file and the environment, config file takes
precedence
17
© 2010 IBM Corporation
DU Feature Details - Dynamic Chunk Relocation
Problem – Hard Coded Chunk Paths in Root dbspace
• You package an Informix instance, complete with data to deploy with your application
• At deployment time the files need to be deployed to a user-specified path on the machine
• The Root dbspace contains hard coded paths for all the chunks in the reserved pages and
extended reserved pages – if you move any chunks around they will get marked down when
Informix initializes
Solution – Dynamic Chunk Relocation
• The -relocate command line option, and RELOCATE config file option allow you to specify
new locations for chunk files
• As long as the new ROOTPATH location is known to ifxdeploy (e.g. specified on command
line or config file or the new location is correct in the ONCONFIG file) then the reserved
pages are updated at deployment time
• Make sure Informix is shut down cleanly (onmode –kuy) before copying chunks
• DU relocate option does not move the chunks for you, but you use it to point to the new
location
18
© 2010 IBM Corporation
Automating Low-Footprint Informix Deployments
• You can use Informix Deployment Toolkit to automate lowfootprint Informix Deployments
• A developerWorks tutorial describing how you can use the toolkit to:
• Install Informix on a computer
• Remove unwanted files from the installed product to create a very small
footprint
• Create a snapshot that is an archive of the reduced-footprint image
• Silently deploy the snapshot on one or more target computers by using the
Informix Deployment Utility
• Optionally relocate dbspaces
• Linux-UNIX-Toolkit: This folder contains the scripts and utilities that
run on Linux and UNIX platforms
• Windows-Toolkit: This folder contains the scripts and utilities that run
on Windows platforms
• Tutorial and the toolkit are available on developerWorks at
http://www.ibm.com/developerworks/data/tutorials/dm1003idsembeddabilitytoolkit/index.html
19
© 2010 IBM Corporation
Enabling Technology for Embeddability
Database Scheduler +
Alert System +
User Configurable Thresholds +
SQL Admin API
=
A flexible infrastructure for
automating DBA tasks
Other 11.x technology – E.g. dynamic onconfig parameters, auto Reprepare,
trigger enhancements, XML publishing, new SMI tables, ontape backup to
directories, built-in tasks and sensors..
20
© 2010 IBM Corporation
Embeddability Features – 11.50 Fix Packs
• 11.50.xC1
• Automated Update Statistics
• Evaluation task (creates necessary commands)
• Refresh task (executes the commands)
• API commands for cluster configuration
• New SMI tables for cluster status
•
•
•
•
•
sysproxyagents
sysproxydistributers
sysproxysessions
sysproxytxnops
sysproxytxns
• oninit –w
• Wait for Informix to initialize before returning to command prompt
• STORAGE_FULL_ALARMS onconfig parameter
• Dynamic SQL in Stored Procedure Language routines
• Extensible Stylesheet Language Transformation (XSLT)
21
© 2010 IBM Corporation
Embeddability Features – 11.50 Fix Packs (cont.)
• 11.50.xC2
• New ER SMI tables to enhance programmatic querying of ER status information
• LIMITSESSIONS onconfig parameter
• Limit max number of connected sessions, modify dynamically
• BACKUP_FILTER / RESTORE_FILTER
• 11.50.xC3
• Silent install on Mac OS with bundle.ini file
• SQL ADMIN API improvements:
• "SET ONCONFIG" commands to dynamically update onconfig parameters
• SQL Admin API commands to monitor and administer ER
• Better SQL tracing (per database, per user)
• Change Data Capture API, syscdc database, Change Data Capture API
Programmer's Guide
22
© 2010 IBM Corporation
Embeddability Features – 11.50 Fix Packs (cont.)
• 11.50.xC4
• SQL Admin API & SMI support for compression
• genconfig utility to create an onconfig file matching machine specification
• ER ATS/RIS collision files in XML format
• New Event Alarms for ER
• Schedule cdr check and sync with the --background option
• Datablade module registration with SQL
• 11.50.xC5
• Better ER handling of memory allocation failures
• ER stops and alarm 47 raised
• Deployment Utility (Windows)
• Onclean utility to force shutdown
• Silent upgrade on Windows
• Informix Developer Edition installer packages on Ubuntu Partner repository
23
© 2010 IBM Corporation
Embeddability Features – 11.50 Fix Packs (cont.)
• 11.50.xC6
• Deployment Utility config file support
• Deployment Utility on UNIX
• Deployment Utility dynamic chunk relocation
• Dynamically start, stop or restart Listen threads
• Dynamically start, stop, or restart an existing listen thread for a SOCTCP or
TLITCP network protocol without interrupting existing connections
• New onmode -P command & SQL admin API task/admin options
• Install Informix using RPM packages on Linux
• Better alarm documentation
24
© 2010 IBM Corporation
Informix Embeddability Resources
• Embedding Informix Redbook – Published March 2009
www.redbooks.ibm.com/abstracts/sg247666.html?
• Topics
•
•
•
•
•
•
Embeddability features
Installation methods
Planning and design
Embedded deployment
Post-deployment administration
Virtualization
• Informix Embeddability Resource Page
www.ibm.com/software/data/informix/embed
• Automate small footprint, embedded Informix
deployments
• developerWorks tutorial available at
http://www.ibm.com/developerworks/data/tutorials/d
m-1003idsembeddabilitytoolkit/index.html
25
© 2010 IBM Corporation
Agenda
• Informix Embeddability
•
•
•
•
•
•
What is Enterprise Class Embeddability?
Embeddability Overview
Types of Embedded Database Solutions
Deploying Embedded Informix Databases using the Deployment Utility
Automating Low-footprint Informix Deployments
Enabling Technology for Embeddability
• Informix Virtualization and Cloud Computing
•
•
•
•
•
•
Informix Virtualization Strategy
Informix Virtualization Overview
The Informix virtual appliance
Cloud Computing
Amazon Web Services EC2
Virtualization and Cloud Roadmap
• Appendix
26
© 2010 IBM Corporation
Informix Virtualization and Cloud Computing - Agenda
• Informix Virtualization Strategy
• Informix Virtualization Overview
• The Informix virtual appliance
• Cloud Computing
• Amazon Web Services EC2
• Virtualization and Cloud Roadmap
27
© 2010 IBM Corporation
What is Virtualization?
• The abstraction of operating systems and the applications
that run on them into virtual machines
• Benefits of Virtualization
• Server consolidation – Reduce power, storage and maintenance costs by
consolidating applications onto fewer machines
• Reduced development and test costs with platform emulation
• Lower deployment costs – deliver a solution without install-time configuration
• Simplified support models
• Provide a unified desktop to run on multiple platforms
• Reproduce customer problems in a common environments
• Simplified management - aggregating resources such as disks into virtual
disks, and IP routing to clones
• An education platform – students can take the classroom home with them
• Rapid scalability, startup cost savings, more efficient pricing models..
28
© 2010 IBM Corporation
Informix Virtualization Strategy
Ease of use, accessibility, ubiquity
Innovative solutions and deployment
•
Support a wide range of virtualization
platforms and solutions
methods
•
Licensing compatible with sub-capacity
and pay as you go virtualized
environments
•
Provide complete solution stacks
•
Virtualization on demand – automate
provisioning
•
Integration with cloud management solutions
•
Provide everything you need to get started
developing and deploying database
applications as standalone and cloud
based machine images
Leveraging Informix Strengths
•
Dynamic scaling and autonomic features
adapt to varying resource patterns of
virtualized environments
•
Low footprint and efficient use of resources
•
Extensive high availability and replication
features compliment and add structure,
manageability and peace of mind to flexible
scalable virtualized environments
•
Informix extensibility supports easy
adaptation to new and emerging
applications and data types
•
Autonomic and embeddable features which
integrate well with other standard software
enable virtual deployment by supporting
the creation of self-contained appliances
29
© 2010 IBM Corporation
Informix Virtualization Overview
• Free Informix 11.50 Developer
Edition virtual appliance images
for VMWare Workstation, Player,
Fusion (Mac OS X), and ESX
• Support for the major
virtualization solutions, e.g.
VMWare, Xen, HP VSE, vPars,
HPVM, AIX PowerVM, VIOS,
WPARs, Solaris Zones with
Informix 11
• 32 & 64-bit edition virtual
appliance and cloud images
• Sub-capacity Licensing options
designed for virtual environments
30
• Pay as you go licensing options
• Informix Developer, Express,
Workgroup Edition instances in
Amazon Web Services Elastic
Compute Cloud (EC2)
© 2010 IBM Corporation
The Informix 11.50.xC6 Virtual Appliance
• A SUSE Linux Enterprise Server 10 SP2 virtual machine image with Informix
11.50.xC6 installed and online
• Runs in VMWare Player, Workstation, Server and Fusion (MAC OS X), and
VMWare ESX
• 32 and 64-bit Editions
• Pre-configured and ready to run..
• Informix 11.50.xC6
• Informix Client SDK 3.50.xC6
• Informix Spatial DataBlade 8.21.xC3
• Informix Web DataBlade 4.13.xC4
• IBM Data Server Client Drivers v95fp5
Also Featuring
Programming Tutorials
The Informix Game
MACH11/HDR Demo scripts
• OpenAdmin Tool (OAT) 2.27
Documentation links
• Optim Data Studio 2.2
Firefox Browser with
Preconfigured links
• AGS Server Studio 6.5
• GNU C/C++ compiler and gdb debugger
• IBM JDK v1.5.0
31
© 2010 IBM Corporation
Where to get the Informix Virtual Appliance
• Direct Download link..
• https://www14.software.ibm.com/webapp/iwm/web/reg/download.do?source=swginformixfpd&S_PKG=dl
• Requires IBM Internet ID and Password
• VMware Virtual Appliance Marketplace
• http://www.vmware.com/appliances/directory/90643
• IBM Virtual Appliances Portal
• http://www.ibm.com/developerworks/wikis/display/im/IBM+Virtual+Appliances#IBMVirtualApplian
ces-ids
• This site includes the readme and installation instructions
32
© 2010 IBM Corporation
32
Starting the Virtual Appliance
• Install VMware Player (or Workstation/Server/Fusion)
• Download and Uncompress file (available as a .tgz or .exe)
• Double-click on the .vmx file
33
© 2010 IBM Corporation
Log in as root
34
© 2010 IBM Corporation
Accept all License Prompts..
35
© 2010 IBM Corporation
Login as developer
36
© 2010 IBM Corporation
The Informix Virtual Appliance is Ready to Use
37
© 2010 IBM Corporation
Informix SLES Virtual Appliance Desktop
Welcome page
Terminal
Tutorials
Firefox Browser
Informix Home
Page
Info Center
Dbaccess
Data Studio
Open Admin Tool
38
© 2010 IBM Corporation
Virtualization Support
• Informix 11 is fully supported in virtualized environments as
described in the virtualization support matrix
• http://www.ibm.com/developerworks/wikis/display/im/IDS+virtualiz
ation+support
• Other supported Informix versions can be
run in virtualized environments
• Problems are treated as regular problems in
physical environments
• No requirement to reproduce a problem on a
physical machine, unless..
• Support engineer determines that this is a necessary
diagnostic step in determining the problem cause
• No commitment to fix a problem that is specific
to virtualization in earlier editions
39
© 2010 IBM Corporation
Cloud Computing
A user experience and a business model
Cloud computing is an emerging style of IT delivery in which applications, data, and IT
resources are rapidly provisioned and provided as standardized offerings to users over
the web in a flexible pricing model
An infrastructure management and services delivery methodology
Cloud computing is a way of managing large numbers of highly virtualized resources such
that, from a management perspective, they resemble a single large resource
This can then be used to deliver services with elastic scaling
Service Consumers
Monitor & Manage
Services & Resources
Datacenter
Infrastructure
Access
Services
IT Cloud
Cloud
Administrator
40
Service Catalog,
Component
Library
Component Vendors/
Software Publishers
Publish & Update
Components,
Service Templates
© 2010 IBM Corporation
Amazon Web Services (AWS)
• Started in 2003 as an API to Amazon’s catalog service
• Data as a service
• Followed by infrastructure as a service
• Core services
Elastic Compute Cloud (EC2). Run time environment. Five configurations
starting at $0.10 per hour.
Simple Storage Service (S3). Storage on demand. Pricing starts at $0.15 per
GB/Month
• 540,000+ Developers using AWS today – growing > 10,000 each month
• AWS and its ecosystem is estimated to serve more than 80% of developers
using Cloud Computing Developer Services
• New Developments
General Availability including Premium Support and SLA (99.95% Availability)
Availability Zones (Improved performance in Europe)
Support for Windows (available on an hourly basis)
41
© 2010 IBM Corporation
The Amazon Elastic Compute Cloud (EC2)
• Resizable compute capacity in the
cloud
• Obtain and boot new server instances in
minutes
• Quickly scale capacity up or down using
a Web Services Interface
• Hosted virtualization
• Full root level access to the virtualized
server instance
• Based on Xen open source hypervisor
• High availability features
• Regions and availability zones
• Elastic IP addresses
• Persistent off-instance storage with
Elastic Block Store (EBS)
• Auto-scaling and load balancing
42
© 2010 IBM Corporation
Amazon Machine Image (AMI)
• An encrypted software package used to launch a virtual machine
within the EC2
• The basic unit of deployment for services delivered using EC2
• Includes the operating system and additional software necessary to deliver a service
• AMIs are stored in Amazon S3
• AMI’s are available as
• Public
• Available to public in EC2
• Downloadable from the Amazon Resource Center
• Can be used as a base to create custom private AMIs
• Private
• Owned and accessed by individuals
• Paid
• Order before use
• Come with service contracts from vendors
43
© 2010 IBM Corporation
AMI Instance Choices
44
© 2010 IBM Corporation
AWS Storage Compared
45
© 2010 IBM Corporation
Amazon Availability Zones
Availability zones represent distinct locations insulated from failures in other
availability zones
46
© 2010 IBM Corporation
Informix in the Amazon Cloud
• Partnership with Amazon Web Services
• Quickly get started using Informix
• Developer Edition cloud image available now
• Paid 32 & 64-bit editions available now
• Pay as you go licensing model to deploy Informix in the cloud
• Bring your own Informix license and install in the cloud
Service Consumers
Monitor & Manage
Services & Resources
Datacenter
Infrastructure
Access
Services
IT Cloud
Cloud
Administrator
47
Service Catalog,
Component
Library
Component Vendors/
Software Publishers
Publish & Update
Components,
Service Templates
© 2010 IBM Corporation
Example – Informix Cluster Across Availability Zones
A client application connects to Informix Connection Manager, which
maintains a continuous connection to Informix Servers in different
Amazon Availability Zones
AWS Zone: us-east-1a
Client applications on
Informix Connection Manager
virtual desktops
Informix Name: ids_east1a
Config: Primary
Group
Oltp=Primary
AWS Zone: us-east-1b
Payroll=HDR
Informix Name:
ids_east1b
Report=RSS
Config: HDR Secondary
AWS Zone: us-east-1c
Informix Name:
ids_east1c
Config: RSS node
48
© 2010 IBM Corporation
AMI Pricing for Informix Express and Workgroup
49
© 2010 IBM Corporation
Getting Started with Informix and Amazon EC2
• Read the Informix AMI Getting Started Guide
• http://download.boulder.ibm.com/ibmdl/pub/software/dw/cloud/ids/Get_Started
_IDS_AMI.pdf
• For Developer Edition - Subscribe to AMI
• https://awsportal.amazon.com/gp/aws/user/subscription/index.html?offeringCode=187103C5
• Sign up for AWS and log in
• Launch an instance from the AWS Management Console or with
the EC2 Command line tools
• Connect to the instance using SSH
• Select optional Elastic Block Storage (EBS) storage
• Choose passwords for root, informix, developer
• The instance is ready to use
50
© 2010 IBM Corporation
The AWS Management Console
51
© 2010 IBM Corporation
Launching an AMI Instance
52
© 2010 IBM Corporation
Launching an AMI Instance
53
© 2010 IBM Corporation
Managing AMI Instances
54
© 2010 IBM Corporation
Connecting to an AMI Instance with SSH
55
© 2010 IBM Corporation
Setting up an AMI Instance
56
© 2010 IBM Corporation
AMI Instance Setup
57
© 2010 IBM Corporation
Transferring Certificate and Private Key Files
58
© 2010 IBM Corporation
Using the New Instance
59
© 2010 IBM Corporation
Application Development - EC2 APIs
• Command line tools, Java libraries, SOAP or Query based APIs available
• The EC2 Developer Guide describes the APIs and command line tools
• http://docs.amazonwebservices.com/AWSEC2/latest/DeveloperGuide/
• EC2 command line tools are a set of scripts and Java libraries which interface with
the web service API
• The Amazon EC2 Library in Java provides a base library for working with the EC2
SOAP interface (or access the SOAP services with other languages which support
SOAP including C++, C#, Perl, Python and Ruby)
• Java client requires
• XFire (http://xfire.codehaus.org/)
• Log4j (http://logging.apache.org/log4j/)
• Xalan J2 (http://xml.apache.org/xalan-j/)
• The Query API supports HTTP or HTTPS GET and POST requests e.g.
https://ec2.amazonaws.com/ ?Action=AttachVolume &VolumeId=vol-4d826724 &InstanceId=i-6058a509
&Device=/dev/sdh &...auth parameters...
• Many companies offer AWS management services which simplify application
development and management of scalability and monitoring..
60
© 2010 IBM Corporation
Informix AWS Support
• Informix Developer Edition AMI is supported
through public forums
• Support for paid Informix AMI will be provided
by Amazon with the option to enter into
premium support contracts with IBM
• If you purchased Informix licenses for your
own AMI, support for Informix is business as
usual
• See http://aws.amazon.com/solutions/featured-partners/ibm/
61
© 2010 IBM Corporation
61
IBM Developer Cloud Space
• Landing site for ISVs and
developers interested in
cloud computing
www.ibm.com/developerworks/spaces/cloud
• Links to development
AMIs, demos and
supporting collateral
• Links to other IBM cloud
resources and IBM SaaS
Partner Program
62
© 2010 IBM Corporation
63
© 2010 IBM Corporation
Agenda
• Informix Embeddability
•
•
•
•
•
•
What is Enterprise Class Embeddability?
Embeddability Overview
Types of Embedded Database Solutions
Deploying Embedded Informix Databases using the Deployment Utility
Automating Low-footprint Informix Deployments
Enabling Technology for Embeddability
• Informix Virtualization and Cloud Computing
•
•
•
•
•
•
Informix Virtualization Strategy
Informix Virtualization Overview
The Informix virtual appliance
Cloud Computing
Amazon Web Services EC2
Virtualization and Cloud Roadmap
• Appendix
64
© 2010 IBM Corporation
Deployment Utility – Feature Summary
• Informix 11.50.xC5
• Deployment Utility available for Windows only – ifxdeploy.exe
• Can unzip a snapshot of INFORMIXDIR and set up an instance by
creating users, registry keys, batch files, Windows services etc.
• Can be used as an instance manager to create new instances from
existing ones or from onconfig.std
• Command line support for configuring values such as listening ports,
named pipes, SERVERNUM
• Can unzip/copy INFORMIXDIR files using 7-zip if installed, or by passing
a custom unzip command
• Can uninstall and Informix instance and files
• Only single instance install supported on Windows
• Values such as INFORMIXSERVER and INFORMIXDIR are read from
the environment
65
© 2010 IBM Corporation
Deployment Utility – Feature Summary
• Informix 11.50.xC6 – New Features
• Deployment Utility available on all platforms – ifxdeploy
• Can use a config file – ifxdeploy.conf as an alternative to command line arguments
and environment variables
• Additional support for DBSERVERALIASES and customizing ONCONFIG file
• Multiple instances can be installed to multiple locations on a machine (all platforms)
• Chunks can be dynamically relocated to a new path at deployment time
• Built in support for unzipping zipped tar files on UNIX (.tgz)
66
© 2010 IBM Corporation
Feature Details – DU Config File
• A sample config file is included here: $INFORMIXDIR/etc/ifxdeploy.conf
• Config file also supports a list of DBSERVERALIAS values – it will create onconfig AND
SQLHOSTS entries for them. Put them between BEGIN/END ALIAS clauses. E.g.
BEGIN ALIAS
SERVERNAME alias1
PROTOCOL drsoctcp
PORT 9091
OPTIONS b=32767
END ALIAS
• Individual ONCONFIG values can be customized in the DU Config file with BEGIN/END
ONCONFIG clauses. E.g.
BEGIN ONCONFIG
BUFFERPOOL
default,buffers=1000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.500000
BUFFERPOOL
size=4K,buffers=1000,lrus=8,lru_min_dirty=50.000000,lru_max_dirty=60.000000
END ONCONFIG
67
© 2010 IBM Corporation
DU - Dynamic Chunk Relocation Usage Examples
• Relocation of Chunks to Single Parent Directory
• ifxdeploy -rootpath D:\IFMX\ex1\rootdbs.001 -relocate D:\IFMX\ex2
• Relocation to Multiple Paths
• ifxdeploy -relocate C:\IFXDATA=D:\IFXDATA;C:\IFXLOGSPACE=E:\IFXLOGSPACE
• Relocation to Multiple Paths with New Offsets
• ifxdeploy -relocate C:\IFXDATA,0=D:\IFXDATA,4;C:\IFXDATAB,3=D:\IFXDATAB,5
• CONFIG file examples (same examples, but specified in ifxdeploy config file)
• RELOCATE D:\IFMX\ex2
• RELOCATE C:\IFXDATA=D:\IFXDATA;C:\IFXLOGSPACE=E:\IFXLOGSPACE
• RELOCATE C:\IFXDATA=D:\IFXDATA;C:\IFXLOGSPACE=E:\IFXLOGSPACE
68
© 2010 IBM Corporation
DU Feature Details – Support for Compressed Files
• On Windows a zip file of an INFORMIXDIR can be passed on the command line using the
–file argument or specified in the config file using SNAPSHOT
• The zip file will be expanded to the new INFORMIXDIR
• Requires 7-Zip to be installed on the deployment machine
• Note it is planned to move form 7-Zip to built-in compression/uncompression routines
• When creating the zip, do not zip up the full path, but just the files under INFORMIXDIR
• On UNIX use the –file argument (or SNAPSHOT) to specify a Gzipped tar file (.tgx)
• As with Windows, tar the files within INFORMIXDIR, e.g.
cd $INFORMIXDIR
tar cvzf ifxdir.tgz *
• Alternatively use the –extractcmd argument to specify a custom extract command. E.g.
•
ifxdeploy –extractcmd "tar -xf /tmp/my_instance.tar /opt/IBM/informix"
69
© 2010 IBM Corporation
DU Known Issue – Uninstall and the Discovery Files
Problem
• If the DU -uninstall option is used to remove all the Informix files associated with a
deployment, it will shutdown any instances it finds in the server discovery files in
$INFORMIXDIR/etc (*.conf.*)
• Suppose there were leftover server discovery files in the INFORMIXDIR you copied
to a new location, and these corresponded to instances elsewhere on the machine
that need to stay running?
• To avoid this possibility DU will remove all the server discovery files from
$INFORMIXDIR/etc when it creates a new instance
• But what if those files were valid? E.g. you were using DU to create a new instance
in-place and there were other valid instances using the same INFORMIXDIR. In this
case onstat -g dis will fail to accurately report all the online instances.
• If you know the server discover files in your INFORMIXDIR are valid, pass the keepdis option as a command line argument to ifxdeploy. This will prevent any
existing server discovery files from being deleted from $INFORMIXDIR/etc
70
© 2010 IBM Corporation
DU Troubleshooting and Other Notes
• Use the –verbose and –log command line options, or LOGFILE and LOGLEVEL
config file values to record as much information as possible
• ONCONFIG values specified in the DU config file, are added to the end of the
ONCONFIG file
• Similarly new DBSERVERALIAS values cause entries to be added to the end of
the SLHOSTS file
• If you specify a non-existent ONCONFIG file (via environment variable, command
line or config value) a new one will be generated from onconfig.std
• DU does not start the instance for you (currently)
• If you do not deploy chunks, an instance with an empty root chunk will be
created (ready for oninit –iy)
71
© 2010 IBM Corporation
Informix Embeddability Reference Material
• Informix InfoCenter
• Quick Beginnings for IBM Informix xxx Edition
•
Chapter 4 Embedding Dynamic Server xxxx
• IBM Informix Installation Guide for UNIX, Linux, and Mac OS X
•
Chapter 9 Deploying Dynamic Server with the Deployment Utility
• IBM Informix Installation Guide for Windows
•
72
Chapter 5. Deploying Informix with the Deployment Utility
© 2010 IBM Corporation
Cloud Computing - Evolution
Massive, Web-scale abstracted infrastructure
Dynamic allocation, scaling, movement of applications
Pay per use
No long-term commitments
No Hardware and Software to install
Cloud Computing
Software as a Service
Utility Computing
Grid Computing
• Solving large
problems with
parallel computing
73
• Offering computing
resources as a
metered service
• Network-based
subscriptions to
applications
• Anytime, anywhere
access to IT
resources delivered
dynamically as a
service.
© 2010 IBM Corporation
The Bell Micro Ubuntu Virtual Appliance
• Informix
Developer
Edition virtual
appliance
developed by
Bell Micro
• XUbuntu 8.10
(Ubuntu + xfce
desktop)
• Informix
11.50.UC4
• OAT 2.24
• CSDK + APIs
Check http://www.informixcity.com/ for details
74
© 2010 IBM Corporation
AWS Performance Considerations
• No official AWS IO throughput numbers published
• S3 IO Performance varies between instance sizes
• Small instance – “moderate”
• Large, Extra Large – High
• What does this mean?
• Small instances – EC2 – S3 measured at 10-12 MB/s*
• Large instances EC2 – S3 up to 50 MB/s*
• Elastic Block Store (EBS) performance estimated at up to 70 MB/s*
• 1 EC2 Compute Unit is equivalent to a 1.0-1.2GHZ 2007 Opteron or Xeon processor
• An extra large instance allows a maximum of 8 EC2 CPU’s at 15GB RAM, the High-CPU
Extra large instance allows 20 EC2-CPUs at 7 GB RAM
• Network performance between instances – Rightscale measured 75-100 MB/s*
• *all 3rd party measurements should be considered date dependant and subject to upgrade,
as well as dependant on the usage pattern measured
•
http://blog.rightscale.com/tag/performance/
•
http://blog.rightscale.com/2008/08/20/amazon-ebs-explained/
•
http://blog.rightscale.com/2007/10/28/network-performance-within-amazon-ec2-and-to-amazon-s3/
•
http://hostedftp.files.wordpress.com/2009/03/s3ec2_0209.pdf
75
© 2010 IBM Corporation
AWS Storage Reliability
Source: http://aws.amazon.com/s3-sla/
“AWS will use commercially reasonable efforts to make Amazon S3
available with a Monthly Uptime Percentage … of at least 99.9% during
any monthly billing cycle (the “Service Commitment”). In the event Amazon
S3 does not meet the Service Commitment, you will be eligible to receive a
Service Credit..”
• The Amazon EC2 SLA guarantees 99.95% availability of the service within a Region over a trailing 365 day
period
• Use Elastic Block Store (EBS) persistent block level storage for higher performance, reliability and persistence
between instances
• Use Informix High availability features (HDR, ER, RSS) for availability and load balancing – leverage free data
transfer between instances in the same region (e.g. US – US, Europe – Europe)
76
© 2010 IBM Corporation
VMWare Virtual Infrastructure Support
• VMWare ESX compatible virtual
machine images fit into the
VMWare Virtual Infrastructure
• VirtualCenter Management
Server allows different x86 based
operating systems to be
managed as a single virtual
platform
• Virtualized infrastructure centrally
managed by VirtualCenter
Management Server
• Virtual Infrastructure Client to
administer and connect to
individual ESX Server
installations
Source: http://www.vmware.com/solutions/consolidation/manage.html
See: http://www.vmware.com/pdf/vi_architecture_wp.pdf
77
© 2010 IBM Corporation
Informix 11.5
Embeddability, Virtualization, and Cloud Computing
Information Management Partner Technologies - Informix
© 2010 IBM Corporation