Moving Data in Real-Time between Oracle and MySQL

Moving data between legacy Oracle databases and cheap, flexible MySQL-based applications is an increasingly important problem for open source-based businesses. Do you need to move sales requests from MySQL-based web applications to an Oracle-based procurement system? How about from your Oracle ERP applications back to MySQL? Tungsten Replicator leverages open source to move data in real-time at a fraction of the cost of solutions from expensive enterprise vendors.




In this webinar we show you how to use Tungsten to replicate transactions from Oracle to MySQL as well as MySQL to Oracle. We describe the setup on each side of the fence and show demos of data movement in both directions. Finally, we introduce a few of the other replication combinations Tungsten Replicator handles, including MongoDB, Vertica, and PostgreSQL.

Tungsten Replicator makes MySQL data plug-and-play with Oracle without application changes or complex configuration -- think Oracle GoldenGate without the price tag! And Continuent offers the support you need to get replication projects deployed quickly and efficiently. Learn how our heterogenous replication solutions can help you today!

---

Closed Caption:

my name's Robert Hodges some CEO's
continue and and I will be your host and
presenter today
at our webinar on moving data in real
time between
Oracle and Mike sequel it's my pleasure
this morning to help with me today
leave a surplus senior engineer I
works with me at continuing to and has
done a lot of the work
to make this heterogeneous replication
possible before we get into the
presentation like just
I'd like to bring a few things to your
attention we're using go to
eating come to run this webinar and
their is a question box
that you can use to type in questions as
the presentation
is unfolding will answer those questions
either directly by typing in answers
or at the end to the web a NAR which
will have time
at the into the weapon are you can also
request copies are slights
by sending email to sales act continue
into com
will post that information at the and
as well so that you have the contacts in
case you want to talk with us further
with that let's go ahead and dive into
the presentation
so
in a webinar today will be doing some
quick introductions
and for small continued and then to the
tungsten replicator itself that's the
main technology that will be
covering stalk will then move to the
topic specifically
replication between or call and my
sequel once we've given you the
background on
topologies how things are set up I'll
shift things over to my colleague
we know staples who will give you
demonstration how easy it is to set up
replication in both directions
I'm after the demo will have a short
discussion
other types of heterogeneous replication
be on those
shown you and that will conclude with
wrap up in Q&A
this presentation doesn't go for the
full hour so we do have time at the end
to cover any questions you have on this
topic
leader said I both replication
specialist
this is one of our favorite service talk
about so any question that you have on
this subject we will
train answer for you
let's talk a little bit about continue
it you're probably familiar with us
after all you signed up for this webinar
I'm we are the leading provider
clustering replication for open source
databases
we have a couple products that we sell
the first
tungsten enterprise which provides
commercial
I data management using replication for
both my sick one post press
it's a complete solution that I'll works
by
taking a setup copy databases maintain
real time and making them appear at your
applications
as a single virtual database the salsa
number
problems not least of all availability
scaling yet simplified
management that allows you to use is
effectively to
run very very large businesses on open
source database
today in iraq dinar presentation today
will be focused
on our other product which is the terms
replicator which provides
flexible high-performance replication
for my sequel
and as you'll see a course this
presentation other database
as well
I'd like to just give you a couple
interesting tungsten fax along the way
the purchased from stand-up price
installation processes
close to $500 billion transactions each
day there sixteen tons
impostors each averaging around 30
million
transactions daily height the amount of
data under
management is around 235 terabytes this
is all of my sequel so this is a very
very large installation
and has been using tungsten after years
the tungsten replicator was application
year last year's my sick circumference
receipt
work and tungsten prices replicator
are in production use it at are
countless great companies
the numbers actually have customers that
we have on support and
licensed is over 70 at this time growing
every week
I'd now like to turn
around and do short introduction to the
tanks
replicator so it's first start out
by describing what the tungsten
replicator is
very briefly tungsten replicator
is a fast open source database
replication engine
and we built it as a replacement
for my sickle replication in order to
enable us to build
I high speed high available I feel
guilty Koster's
so the Colts for the core the replicator
is gplv2 same license as my sick with
self
I with commercial extensions for
replication replicators design first
even
flexibility and in fact it has
many of the features that your custom to
in commercial replicators
such ask Wes or Golden Gate and we
sometimes use
describe it has Oracle GoldenGate
without the price tag
let's just look I'm quickly it how the
replicator works
so when you use tungsten replicator it
typically runs
as a couple prostheses in the picture
that we have here
we see tungsten replicator acting as a
replacement
or my sequel so the you run out
for example a master replicator process
and the way that this works
yes it will laughin to my sequel
using the port 3306 just like
my sick or slave replicator arsov slave
database
and or we can actually read been locked
as a written desk
either way the master replicate it grabs
the been more records
as they appear and then stores them in
what we call the transaction history
lock on the transaction history log
split things up into database trends a
actions and at
meditated arm the most important meta
data that we add is
something called Global Transaction ID
so every single transaction
as we read it and store it gets a
number on it that starts at zero and
increases 1234
so on as we get more transactions this
is actually a critical feature
out the tanks replicator because it
enables us to do
failover I in master space situations
so unlike by sequel which depends on
a file name: enough and an offset I'll
to lock
to replicator for the next transaction
I D and no matter where the master is
I'm
within a network replicators if which
transaction the slave
wants so as the
slaves pick up the transactions they
store them in their own transaction
history or
and then they apply them to the database
using
JPC which is a standard at other case
for talked database tungsten is in fact
arm written almost exclusively job we
use
ready for installation we do this
because job is very fast
and it works very well across multiple
platforms including both
operating systems as well as database
as a user you don't have to be aware
we're using Java
them the fact that you need to have a
job p.m. ill
on she on stocks
let's talk a little bit into how the
replicators is put together
I mention that right the terms
replicators is fast and flexible
in fact it's designed along the a.m.
principles a message bus so if you're
familiar with
I message bus architectures they
typically have
a a set-ups
processing steps we call this that a
pipeline
and each step is known as stage and
within a stage
the tungsten replicator has a little
blue it runs
to do extract filter pie so for example
here's
this particular pipeline reach from a
master database log
applies it into our transaction history
after adding medea
pulls it back out again of president in
memory cue
and applies it to a replica
this on I
the stages each yr each atom will
operate independently
they have one more threat and they're
extremely fast I'm
one we test this for example even on
small machine like a laptop
the cycle time stages several week
several hundred thousand transactions
per second
reached age so it's very very fast
processing
now you can have one interesting
features about the times
replicator is the you have these type
lights which are built like Legos
you can also have multiple pipelines
within a single replicate
so for example this picture that we're
looking at right now
shows us a
a replicator configuration that supports
something that week off
fannie where we have multiple masters
writing from New York City and Frankfort
databases
aggregating transactions together under
so we run
a pipeline for the NYC database
in New York a pipeline for replicator
for the arm
for the arm for the Frankfort a.m.
database in Frankfort and then they both
talk to
another replicator in London which has
service for each of those masters
and those two services just run with it
same replicator process
so this on gives us the the pipelines
give us the ability to
do many different types replication
processing and the fact that we can run
multiple pipelines within a single
replicator process
is the the secret ingredient the last
sport white
just apologies such as and some other
two parties I'll show you shortly
another interesting feature the pipeline
architecture
is it supports something that we call
parallel apply
so if you're my sequel a particular
issue or to be with my sick or
replication
your where the fact that one of the big
reasons why my sick
replication tend to be kinda slow is
that the Apply
stage on on a bicycle slave
single-threaded and if there's any
delayed due to I O or anything else for
that matter
I this can cause repetition to lack very
very badly up slave of
our street days hi so with tungsten
on there is we have a this
parallel apply feature in the way it
works as follows:
when we extract the the transactions out
the database
one of the other things we do besides
adding a
I'm Global Transaction ID it we have
Chardy
in case a bicycle in work or for that
matter
short ID is the name a the schema
into which the track jacket to which the
transaction applies:
that's arm thats signed
before we put it into the transaction
history locked begin
and then when we reach the Apply the
point where we're going to apply
we have what's known as a parallel cue
where we basically split
the transactions out by their short I D
and then can have separate
on threats we called channels applying
into the independently into the slave
database
this speaker can speed up the
transaction
applied a pirate remarkably we get
pretty standard
in benchmarks as well as on real
customer such
scenarios we gets beat up some water for
five times
native bicycle replication
there's from one final kinda by
interesting aspect apply
in tungsten replicator and that's what
we call Pat reply
were data warehouses and if you've
worked with data warehouses
you you may be aware that I'll
they don't load ordinary sequel
particularly well so for example
if you're if you have a bicycle database
or set of data bases that are generating
margin
data you wanna put them into a data
warehouse like burdick up
if you simply take the sequel that
executed on the bicycle
arm our master or masters
and just apply those statements one by
one as they come
to Vertica that's about 50 or 100 times
slower than the speed that you would get
a few loaded
I in Polk so the batch apply
has this arms special
process that we can use where's where
instead of just applying the sequel
as it as it arrives we keep the
we basically dump the sequel statements
are the changes
outages into CSV files
and unload them either using a loaded in
false statement or copy
are so what you can do is effectively
batch say and 23,000
transactions and then upload them to the
data warehouse
all once and this can result in a as I
mentioned to speed up
something like 50 times overload Street
sequel
so as a result of these different
on I features that I've been describing
pipelines multiple services barrel apply
I'm we have the ability with the
tungsten replicator
create very flexible apologies so we can
do they
the ordinary fan out master/slave I
we can do it called direct replication
we go straight from one database to
another
winter peak steps on we could do some
very interesting
multi master topologies all masters up
spoke
the search um these topologies are very
useful particularly few trance
transfer idea between multiple sites
that need to be simultaneously updated
or simultaneous available rights I'm
these are all apologies their support by
tanks that
and they're being implemented either in
production or
be implemented now with our customers
however
what we'd like to do now is focus on
heterogeneous replication
and particularly the cases replicating
from bicycle
or call or from or call to my sequel
so what we're going to do now is going
ops excuse me I have
I'll one thing I want to talk about the
installation model
so are replication is you're probably
aware
is sometimes a bit complicated setup
so touched it has a very simple up
models for the insulation week I spent
quite a bit of work
not and out what happens when you when
you install tungsten
is you have a tar.gz file which I
you get from Oscar example from our
work download servers and you go ahead
I bring it down on target and put it on
stage in sir
and arm then what you do is you just
by CD into the the antarctic files
and as a program called tungsten
installer you can Ron
which will are go ahead and
copy the code out to its final deploy
location
and the interesting thing about this is
for basic master/slave
are topologies
you can do this is a single command
so for example if you have harpo station
master host the issue slave
you can run a single command and the
terms installer will STP the file
out to the target locations the next
thing that will do
it will go ahead validate to make sure
that all the up
prerequisites for installing so
things like being access log files I
be able to access ports being able to
get into the bicycle
server confirm that correctly configured
make sure that all those for
prerequisites or fulfilled and that only
10
do we go ahead complete the installation
so the result is for particularly for
simple
apologies there's a a relatively short
command
that sets up the master-slave topology
and has your replicate very quickly
so this light up showing right here
shows
the commands to do basic master/slave
installation
on target file CD into it and then go
ahead
on text star
so with that background we are finally
ready to talk about replication
between orkut equal
so there's a number of issues that
you have to handle when you're
I replicating between these two database
types
and we'll show you a.m. either
directly or in passing a little bit
about each
so for example you have to set up
replication
in the case of work one of the things
that is is a little bit tricky
setup Oracle Change Data Capture as a
scene a couple minutes
that's the way that we extract the
transactions from
or call to make them available
replication
this provisioning updater and the number
of
I'll little interesting I'll
issues that come up as long as you could
move if you could move data between
of course the biggest problem is just to
move data from orkut my seek
first place but what you can do that
there's a number issues like
incompatible sick Walkman such for
example
arm most ppl on translates poorly or not
at all
our tix a character set translations t
want column name
case mappings as you're probably aware
Oracle likes uppercase
whereas my sequel text like a lower case
this mapping datatypes as well yes
default schema names these are all
things that
that have to be handled and are taken
care of by tanks that in order to set up
efficient replication
soap.com let's look at a couple examples
starting first with replicating from
Oracle into my sequel so here's an
example application in fact one that
we're implementing right
right now in your bomb where
we have TV content descriptions which
are being stored
and a system that runs on or call and
the idea is
that these TV content descriptions on
this this is in fact
meditative or a website that allows
users to
try to find out what's currently running
up to your actually on get access
to online her into these programs
whenever these content descriptions are
updated what we want happen
is once those are committed to Oracle
Database
they should appear within a minute or
less on the web based can walk
which front sequel so
tungsten is able to do this and would
like to show you is
how we do it so
we first we start first with Oracle 10
or 11
we can use either standard addition or
Enterprise Edition
and we can figure or call CDC so
on Oracle CDC's a CD
he stands for Change Data Capture it is
a standard feature
a both SE is well Enterprise Edition
I'm the nice thing about it is the you
typically don't have to
change ok a license is just there
already or license
Oracle you have a version of it what
the way that CDC works is that if you
have
a schema for example damask you can
configure
CDC to capture the changes
and put them in another schema in
staging tables that are then available
for applications to read out
and moved to other locations so in this
particular case
we got the demo schema we publish into a
scheme call
published the changed the changes into
the demo part skim
I'm or call CDC comes in a couple
different flavors there's
what cost synchronous CDC which is
triggered based
I'm that's what people typically use for
Oracle SE
come the lower lower-cost version if you
better after the transaction commits
either way
the transactions appear in this devil
it's been transferred over to the times
way for AppleCare
were supplied my sequel or on the time
since late we have some special
filtering
up that goes on as I mentioned when I
first discussed the pipelines
we have these loops the two extract
filter I'm
apply the filters I'm can basically look
at or modify transactions as they pass
by
and some other filtering that we do with
in New York a bicycle cases pic or extra
tables
so for example heterogeneous replication
is very common to
to ignore some data and not apply
everything to my sequel
arm another thing that we do is we now
names to lower case we're going from or
call with
uppercase table column names map
down to lower case for mexico and then
finally I'm
we have with cohurt table are pregaming
I
constant supports a feature called
heartbeats a large
test likeness the transaction system and
those heartbeats go into a special table
we recognize
I'm we need to change the
schema and the table to make sure that
it goes to the
the correct location bicycle this is all
stuff that just happens automatically
so the result is when this pipeline
setup you
have real-time replication from I'll
Oracle to my sequel we basically get the
transactions about as fast as
as a I'm as Change Data Capture could
pull them out
and you can move up you can move
transactions over between
between these two systems at on up to
several past transactions per second
if your application gust on let's have a
look now
going the other way I am and
it's very common to this effect this a.m
this particular scenario is again
something that
in production with whatever customers
right now from
they have web-based sale so they have a
bunch my sequel applications
taking sales on the web I
processing something like a million
transactions per day
there then replicated real time to
purchase or
ordering which is Oracle Application
that manages order fulfillment
on a warehouse that on a Sat warehouses
that have up to three million order
items
and in fact this I scenario looking at
is
I'm exactly how things are processed if
you've ever bought
anything from Zappos Starcom I'm
very large web retailers United States
if you bought from them you actually are
just software
because this is exactly how to do it so
let's have a look at how that's set up
in tungsten
so are we start with my sequel
one of the key things that we do with my
sequels we have to in marketing able
we also turn out well replication so for
heterogeneous replication really don't
wanna
replicates sequel state statement based
ish
because they don't translate Lee to
other sequel dialects you turn on rose
or manic which
row up up
replication in the solid in the pin lock
we just see the
Sequatchie via the actual changes to the
Rose those are read out
with the standard bicycle extractor we
do have some still turn on the bicycle
signed
I'm to transform the enough data type
to string that's one bicycle data type
that does not exist
in in orkut so we just turn it into a
string
trend I'll forward the transactions over
to this label applicator
Oracle side and again up a syriza
filters for example morning extra tables
are this is actually pretty standard for
my sick one particular because you asked
when your table the actual quite or
are map the names from lower case after
case
and then there's a common optimization
you for the Oracle side
to remove unchanged call update this
just gets better performance
as reply or so
what we're seeing here is how we can set
up
my sequel she or call to bicycle
replication
in the first case and then going the
other way
I'll from my sequel to or call what I'd
like to do now
is turn things over million surplus who
is going to do
demo that shows how the stuff actually
works in practice
solely s I'm gonna go ahead and change
presenter
I last and
you should have control so that we can
see this stuff running in real
for real thank you Robert
and travel everyone I'll I will show you
too
Devils when going from Oracle
to my sequel this will be the first one
and later
going from my sequel to Oracle
and to in the first time I was also show
you
installation so let's take a look
are in my screen you can see it Oracle
day today it's and a half he
databaseName demo and
in the state at this have two tables one
program and schedule
so you can take a look at the
specification of stable it has three
columns
and ücretsiz no data available
so what we'll do it now we will setup
tungsten on both master where Oracle
is installed and slave servers my
secrets
stopped in my screen can see
Oracle server and have downloaded
the two stints release
here which will use for stylish
are first of all insulation consist of
two steps on Oracle we need to prepare
s Robert mentioned the its to see Change
Data Capture
on tables so
to make this process you see we have the
script
so ago and scripts folder
have a script called set-ups to see haha
deferring its we will need to conflict
for that we have some tips to see
configuration file
which contains a few authorization
requests
so first need to tell the script
which database want to replicate out
in this case the Desi damn date
also we need to tell on
the database name for the publishers
keep
so as you already know when Oracle
changes
happen the and up in the publisher our
database
to this is the name for the date its in
our case it will be Dhamaal
underscore Bob and
tell the passwords and also we need
the user to producer for Johnston which
school
reads out this publishers
finally which sell this to see tight
so in this case will use CDC
which is based triggers but if you have
for 11g Oracle
you can use the hard-luck sleep
replication
tests as that is done we can
run the script
the script Sanchez and
now we can go back to Oracle
and take a look at the dental public
shirt database
thats connect to the database
Oracle takes a little bit of time
and under the tables we can see that we
have
to you tables change table for program
and change table for scheduled
so grim it isn't. but
will not set up tents replicator ants
can see how it looks like afterwards
so to see set up and the second step is
to actually install
the replicator for thats
have prepared is scripts called
deploy Oracle master double
and in the strip to consider from there
install a comment smudge Robert to the
one that Robert short
and search analytics parameters
like hostname haha type of data source
that snorkel where to install its
and to of course the credentials so we
provide
the democrat blusher username and
password to the sky
this to see preparations just created
at on thanks anon user works at setter
so with the setup we can
Transtar text
its
I'll I'm going cited extracted thanks
replicate to release
and executing the script
replicator is stop and it is online
so now if I go back to the
Oracle database
and into the publisher database
I can see a few more tables created here
maker
heartbeats and change table for
heartbeat this table are
internal thanks tables and they help us
the help
replicators communicate and no on which
transactions
to start with replicators restart
for example with thats
we can go to the sleeve sir on the
sleeve sir
it is high school so we only need tool
hop install the replicator no need for
this disproportion script
and for that a half no
script prepared and
the scintillation call also house
credentials for
My School Host username/password are
aunt a few more lines which are
static for Oracle but are needed to tell
the Oracle like com which by plan to use
setter so
when with who up the correct for some
credentials
we can install this leaf
and the sleeve is up so
we now have a link we have master and
slave connect its
ants in order to check the license
replication I will issue the heartbeat
so I'll go back to the
master server and
go back to my
to the folder were I have two years
replicates were deployed
and their
I have comments like to rip city O which
is a management console forty
replicator and I can do
heartbeat after heartbeat
I can go back to the slave and check
whether the sleeves is
has received its heartbeat
I'm writing to rip still serves
this and I can see that the last flight
sequence number
was previously fifties 6 and now it
increased to 50 Sep which means that
replication
is working general so
with that we can try to replicate and
some real data difficult to the MySQL
consul half two tables
same tables program schedule already
prepared but
they are
and so let's go back to Oracle
absence at some date
K style
funerals in a single transaction to make
it more interesting
and to
until I commit them they do not
her acute in CDC tables
and hence the not too pure in the
application
stream but assay commit
should see them replicate
so I have executed a number
to upskill services commands India last
flight sequence number increased
and there's another handy tool called
stage show
with which I can actually drill down to
any transaction I need want
and see the house looks like
and I was like to show you this gusts
very powerful
and interest so I have
on listed the last transaction and
you can see that Rep Texas replicating
data
in structures Martin some sequel
way to see defined structure you can see
that
action is inserts can see the schema
which on which it works
tablename and the column ballots
and to this particular transaction
contains those two roles so if we go
back to the bicycle consul
and try to check table the column
the rules half replicate let's try
doing an update which is quite that
different K
and let's see what first
reached Moscow and to do it and
finally week we can do Italy that
sleater
so these are
the three most her important operations
that I wanted to demonstrate to you
and they're also got if we
take a look at the teacher I'll ants
specifically Rd update
transaction we can see that
the transaction are structure contains
both the year
all calling the others the new condos
and the key doubt you to know which call
to update answer which'll to update with
that
the first part the dumbest on and we can
out
switch to my sequel to Oracle
Application
I have
replication already set up here it is
more simple tool
prepare them Oracle to my sequel soul
let's just check whether it is working
half
slave server ants course the master
on which am and grant commissioning
a status call and I see that the
state-of-the-art
replicates is online so master
is up to go to the slave I cannot also
should status call and see that it is
also online
so offense setup
are for it is the whole I will show you
how you can use to
heterogeneous applications to are
maker some powerful
statements sickle statements which you
cannot execute for example on one
data this but you can on the other so
let's try creating a table which
contains
here article data and then Hughes
on on the article cites used to connect
by cry or
SecureWorks which its very
powerful and school which allows us to
select and to manipulate skyrocket
hierarchical type of tables so
that's true to table first on the Oracle
are the table granted does not exist
so
I will use DDL
so it to us some video won't work
but the studio is capital
of replicating so we're creating a table
and snout chipped pure on the Oracle
site
and the table is there and empty
lessons have some data
and inserting 5 roast which
described animals in the suit and said
the heritage
moralistic wit on half
aunt
the rules for preclusion already to
Oracle its
in real time and let's try the
hierarchical query
to mention to you you can see
this query on for months the year
the table the rules in now
and indented fashion so weekend
visually see the here cue that these
animals correspond to so
let's try inserting some morals and see
how
the skits date
and so the
process replicate ants now I want
I see the time it and stay that the
sioux
said the same level ski elephant I would
like to
makes the sioux the master of the other
Allison and
the SIS simple updates which
which are used with Connect by prior
will make this
happen so for that I will just
dates on the My School site this
sOooo entry and I will tell that's
sir
the other front entry and I'll tell
that's its master is
and if I go back to the Oracle
the hair kits updated finally
I can drop the table
efforts to Oracle site and thus
concludes
Adam okay great
thank you very much leaner so I'm going
to go here they can transfer control
back
lichen fine the control panel here
and we'll talk about a few war I'll
variations on replication
okay screen should
showing here leaders can you confirm
that my screen is visible
justice okay thank you very much alright
up let's talk about some more
replication trick so where you can go
with this
so arm the first thing that we won't
talk about
is if the data are valuable enough to
move them between from my sequel to
to Oracle it's probably a pretty good
chance that we want the cluster
so wanna be interesting variations on
this heterogeneous replication
years other Oracle site to be running
for example 11g
rack so that you have high availability
as well as performances for comment or
large enterprises and then on the mic
sequel site
you can achieve the same type of
clustering using
the continuing tungsten enterprise
product as I mentioned before
i touch the enterprise works by using
master-slave replication as you can see
we we have this very powerful
replication technology
we have the master we have one or more
slaves
and then using a combination of
connectivity and management we make
those appears a single database to your
applications
are you don't have to migrate you dare
you don't have to change the app's
they can't tell that they're being
switch between databases but this kit
you clustering and you could then
replicate between these two clusters I'm
so this is an integration we I'm spent
quite a bit I'm on
and as a result if you for example
have a master failure over on the
bicycle side we can easily switch you
over to continue receiving transactions
from a promoted way so this is
this variation is is quite important as
you begin to connect
high-availability systems are
another interesting variation is are
to think about analytics and reporting
so
the examples that leaders gave you was
actually wanna
the using connect right actually the
beginning at just
a very strong motivation for moving data
out of arm
out my sequel and into or call we can do
data warehouse operations so
in this slide show you how you have of
for example large number
my sequel databases using chard deter
are which so for example you might have
marketing
market automation data spread out in a
bunch scheme as across a bunch
a master host those can get aggregated
into
single my sequel arm server
using arstan replication and from there
replicated up to a data warehouse on
Oracle
and in addition to K I connect by course
or perhaps a very powerful features
if you want to create star schema soap
back table
dimension tables is good support for
that its walls
things like materialized views inside
Oracle
at this is a this is an approach to
Prost
data it now becomes possible with the
bicycle
both the fan in for education as well
bicycle or call
a heterogeneous replication
arm one final example
arm obviously if we can replicate from
bicycle
or call from orkut bicycle the question
is
what else can replicate to so here's
just some other combinations that we
support it
I'll starting with bicycle databases we
can
replicate for example to order with a
project that we've been working on for a
while
who are a to do the batch loading into
particular sexual big motivations for
developing
feature another very interesting
combination is my stick
into manga EP so into no sequel
databases
and then finally to other arm I a
database types
an example that but please lifeboat
is replication in to post crest are
if you're interested in these I give us
a call and we could discuss
further so
speaking of calling us I'd like to
discover a few commercial details
arm about how you get started with the
software's so
a question that comes up pretty commonly
is how do you
how much does touched cost it's pretty
simple
if we look at the bicycle or on or call
to
arm bicycle replication in the case were
you coming out of
or call arm that is a the CDC
replication sure you is a commercial
extension
to the Oracle are to the tungsten
replicator so that's licensed
are coming out the bicycle side 'em
we're open source
I under gplv2 but in both cases if you
want support
licensing it's going to be 5k upper
database per year you should arm also
count on a minimalist
attend this consultant set up
and the issues the reason for this is
tungsten as you saw
is arm fairly simple to set up even in
relatively complex are replication cases
however getting your applications talk
heterogeneously
you haven't done it or it a little more
complicated so we work with you to
arm to deal with any
on issues datatype translations arm
make sure that I you have appropriate
monitoring make sure that you
arm her able to bring that
initial bomb loaded data across all
those things that are necessary
to get you up and running really data
effectively
and of course if you're on support I'm
the only support that
continued offers 24 by seven if it's
important enough to do
you probably want answered matter when
you run into a problem
so those are your basic cost I'm just in
terms of the consulting
and implementation services so those are
delivered by Australian replication
experts on
that is say us so if you do want these
projects is a good chance that your
up be talking to somebody on the
engineer
K likely yes or me I tend to be more the
panel replication
latest as a lot of the heterogeneous we
have up all team behind us
but also helping these and arm as I said
the heterogeneous
implementation task tend to be set up
things like the table filtering
mapping renaming monitoring and then
some future development so
as we go into these if you it it's not
uncommon or I for us to see that
there may be some feature some addition
to the replication
can make home this whole thing work
better in course we're happy to put
yeah the standard rate for that is two
thousand dollars per day
arm in both cases I volumes site
multi-year discounts apply
so arm when you doing yes i'm happy to
show you don't just
have to work with contentment I am we
also have some great partners I just
like to introduce
here these are our European zone our
partners including for Linux
a cover UK and Ireland sky SQL arm
their pan-european and then PNC who
covers the
arm the Germany Austria and are
Switzerland
a darkish of area out
up your so you can get a full list of
our partners
on on our website if you
like to find additional names and or or
cover additional reach
so ok with that I just like to leave you
with some final contact information
I am we r have a number so
here's our address as I said at the
beginning at this if you are interested
in
up getting a copy of the slides or
talking with us further
police and arm email sales continued to
call
I'd also like to point out that on to
get additional information on the
technology
please have a look at bosses are our
website but also blocked
I'll we right very actively my blog
scale-up block
are top of the list
partly to spark of light clusters I'm
I think that a playmaker on flying
coaster stop blog spot
dot com I'm we also have the data
charmer block
that's written by deceptive mejia
another one to call
and other finally the continued tungsten
block
which I post information about products
arm obviously our website and then of
course if you want to look directly at
tungsten replicator technology please
visit us at Kodak Google Doc call
where the coaches his out there to look
at and there's all kinds of
are resources you could use so
on with their our webinar is concluded
'em I just wanna check to see if
by we have
let's see I where we can go ahead and
take I
questions here I noticed a couple have
come up they've already been answered
arm one interesting question that
that has come up in the past is up
can we r replicate not only from our own
clusters but from other cost her tights
and an example would be
out my by sequel hoster and the answer
is yes we actually have done that
replication in the past
we haven't certified it at least not
recently because we have had a lot of
calls
or but there's a lot of flexibility in
this technology
and and were able to up arm
you know that's something that we're
also able to do
so with that I believe we're at it the
end of our webinar
ugliness and I will hold on for another
minute or two
if there's additional are questions
please feel free to talk them into the
up into the question answer box and will
our cover this for you I'm otherwise
I'll we hope that this webinar has been
helpful to you
and very much look forward to talking to
you futures so
thanks again for attending that's been
our pleasure and
we hope to talk