Transcript 3244 Multiple Instance of InterBase

3244
Multiple Instance of InterBase
Shaunak Mistry
Staff Engineer
Borland
Objective
• Understand the benefits of multi-instances - so
that you can leverage this new feature.
Peaceful Co-existence
Agenda
Explanation of terms.
Uses of multiple instances
How do you use multiple instances.
Demos
Questions
Agenda
Explanation of terms.
Uses of multiple instances
How do you use multiple instances.
Demos.
Questions
What does multiple
instances mean?
Multi-instance refers to the 7.5 feature which allows
multiple versions of InterBase to run
simultaneously on the same machine.
– Before this feature you could not install a new
versions of InterBase without uninstalling the
previous one.
What does multiple
instances also mean?
Multi-instance also refers to the 7.5 feature which
allows multiple instances of InterBase 7.5 to run
simultaneously on the same machine.
– Before this feature you could not install or run
2 (or more) instances of InterBase without
uninstalling the previous one.
What Multiple instances
allows
So with this feature you will be able to install and
run one instance of “old” IB (pre-7.5) with any
number of “new” IB (7.5 and above).
The diagram below illustrates this
7.1 and below
1 instance
7.5 and above
n instances
Multiple instances imply ...
Multiple partitions which can be used for
Security HR database, purchase database
Upgrading of your application from one version to
another
Old version of app with IB 7.1, newer version IB 7.5
Partiton 1
Partition 2
Agenda
Explanation of terms.
Uses of multiple instances
How do you use multiple instances.
Demos.
Questions
Uses of Multiple instances
• Embedded database applications - We feel that
this feature now make InterBase a true
embedded database
• Allows for load distribution and partitioning for
end point database users
• Allows development, testing and support of
different versions of InterBase on one machine no need to have a separate machine for every
version.
Uses of Multiple instances
• Database re-routing allows you to scale on the
server side with out any client side changes.
Agenda
Explanation of terms.
Uses of multiple instances
How do you use multiple instances.
Demos.
Questions
Multiple version - Server
The server and the guardian both take 2
new switches
• -i <interbase install location>
• -p <service_name>
Use these switches when starting ibserver
or ibguardian.
Multiple version - Remote
To inform the InterBase client library of the
server you want to select set the TCP/IP
service name in the connection string
e.g. “agni/gds_db2:c:\employee.gdb” for
attaching to the gds_db2 server.
Multiple version - Local
Set the INTERBASE environment variable
to match the Install directory of the IB
server you want
• Your client can set the INTERBASE
environment variable with in the
application using the _putenv() function
• Set the INTERBASE environment
variable in the shell or command window.
Multiple version - Local
Applications can also pass in the
information regarding the InterBase
server they want to attach to as part of
the InterBase database parameter block
(isc_dpb parameter). Set the
isc_dpb_client_interbase_var.
Multiple version - Local
Your client can also take in a command line
argument which helps set the InterBase
environment variable. This is how
InterBase tools have been designed.
Multiple version - Local
Limitations
• Windows Only
• Case insensitive
• Only one local server can be connected
by a client application at a time.
Automatic re-routing
Allows you to select which instance and
version of InterBase server to choose on
the server side, without making any
changes to the client.
Allows the DB Admin to setup the
databases for deploy time performance
and scalability.
Automatic re-routing - 2
IB client
Gds_db1
Gds_db
IB server
Automatic re-routing
Limitations
• For remote connections only.
Licensing
A single InterBase server or desktop
license is for one instance and one
version only.
What this means is you need a new license
for every instance of InterBase.
So if you have 1 IB 6.5 and 2 IB 7.5
running on a machine you need to have
3 different licenses.
Important security practice
Use the embedded User authentication
feature in 7.5
Agenda
Explanation of terms.
Uses of multiple instances
How do you use multiple instances.
Demos.
Questions
Demos
Multiple InterBase server Installation
Accessing InterBase through local clients
Accessing InterBase through remote clients
• through JBuilder
• through ISQL.
Database re-routing for remote
connections
Objective
• Understand the benefits of multi-instances - so
that you can leverage this new feature.
Questions?
Thank You
3244
Multiple instances of InterBase
Please fill out the speaker evaluation
You can contact me further at …
[email protected]