Percona Live - Tomas Ulin of Oracle - KEYNOTE: DRIVING MYSQL INNOVATION
https://www.percona.com/live/mysql-co...
Join Tomas Ulin, Oracle's Vice President of MySQL Engineering, as he talks about the focus, strategy, investments and innovations evolving MySQL to power next generation Web, mobile, Cloud and embedded applications. Tomas will also discuss the latest and the most significant MySQL database release ever in its history, MySQL 5.6.
More on Percona...
* Upcoming Percona Live conferences: http://www.percona.com/live/conferences
* Visit the MySQL Performance Blog: http://www.mysqlperformanceblog.com
* Download Percona open source software (always free!): http://www.percona.com/software
* Interact with your peers and Percona experts on the Percona MySQL forums: http://www.percona.com/forums/
Closed Caption:
so I am very pleased to see into our
to announce this year that Oracle's
participating in the conference so
introduce our keynote speaker in a
moment but you also find that they spit
sent to
3 technologists who will lead to a
hookah breakout session talks
this week and they'll also be leading a
birds of a feather session tonight
bicycle 5.6
so up you know we're very pleased to
have them here
obviously it's better for you if you get
the information directly from the source
so with that I am happy to up
school welcome or a final keynote
speaker for this morning
and that is a Thomas all who is the vice
president for the bicycle engineering
team at Oracle
he's been working with the bicycle
database team since 2003
and is based in Sweden is responsible
for the development and maintenance of
my sick or related
suffer price within Oracle such as the
bicycle server
bicycle cluster bicycle connectors
bicycle workbench
in price back up in Enterprise monitor
prior to working with MySQL
he has a background in the telecom
industry working for the Swedish telecom
operator
to Leah in telecom vendor Ericsson he
has a master's degree in computer
science applied physics from Case
Western Reserve University
a PhD in Computer Science from the Royal
Institute of Technology
please join me in welcoming promised
stage
so um really happy to be back
and it was a bomber if I had missed last
year I want to be able to raise my hand
and I've been here for
all the ten years but pay at least I'm
here for the 10-year anniversary I'm
happy about that saw
and got to see so many people here and a
before I start of my presentation am
like
just look back at two years from now
because I was standing not at this
podium I think it was
another room but I was talking about my
ass cum 55
and I was very proud to be able to
prevent 55
it represented a fresh start from my
scrubs and we
year yeah started on a a a different
pot of where we changed our engineering
processes
we Android a lot more Q a resource is
that we've done in the history
and before that and and new
Stewart Oracle for for the database
and I think my skin 55 was a a a great
success
it had excellent quality had great new
features
saw I'm I'll be talking about 5-6 and
how we've
Sourav move forward with the same path
about I'll come later in the
presentation so am
today I'll be focusing on three things:
Oracle's investment in moscow and
our also hope to get across to you
and excitement but I feel about 5-6
so y'all be working on 56 from Anna
guess eleven o'clock when I finish of
this keynote
and I think it's a great release and I i
want everybody to get excited about that
and just start working on it
and also would be looking a little bit
into the future what
we at Oracle and MySQL will be focusing
on with respect to
to my ass girl moving forward and
gonna start off with a big thank you and
to all of you in this room
and I think probably I don't know how
many have you in this room have
reported a bygone 56 of I thought we'd
be more
at least that 20 people at least oh
that's great thank you very much
and the kinda feedback that we get from
from
from our community in terms of love
and feedback on the features we do by
reports that is really invaluable
it really helps and in making sure that
the release is that we get out
or RR an hour as good as possible sop
am and also once we
release the 56 GA all the excitement
that you share
with of sand with the community really
helps to drive the adoption saw
thank you very much a.m.
I started off with saying and talking
about the fresh start that we did for
455 we put out a new engineering process
and I'm gonna show you
how this works when we did the same
thing with 56
and leading up to the GA release and
February so what we did was instead of
in the like in the past just crime
prevention new features
and into an alpha release and then do
another alpha release with
yet another bunch of features and
semi-finished and then
sort of complete them on the way
creating a lot of uncertainty over one
would complete the
release and so on we said okay we're not
going to do that anymore
we're gonna do a step-by-step a trip to
and Joe type of development where we
divide the work in two milestones
we divide them equal in time
approximately say every
four to six months we come out with a
new milestone and
we decide to do for each milestone we
decide to do a small set of features
Anna when only not only decide to do a
small set of features
we decide to complete them we decide
them they should be feature complete
should be fully Q&A
one day when they hit the street and
this is very important because we don't
want to build up
development dept and great uncertainty
for the future
we could principal take any of these
their development milestones releases
and release to mister yep but
you as well as I understand that that
wouldn't be possible from a sober
I maintenance standpoint have like are
no three or 4G releases every year so
we said okay let's do a new G release
every 24 months or so
that make sense from sort of an
operational perspective that's how often
you can consider bringing in the new
year
release onto the market so you can see
the different drug development milestone
release as we did
air with 56 sets a features
an apt optimizer features in a DB
features replication features
and pair and performance schema features
and
partitioning and a whole bunch of things
and
am I'm really happy to be able to stand
here today and and and and and
talked about this and and tell you that
that we managed to get this
release out in time and I think it was
because we did it this way and along the
way that we decided to not bring in some
features because
we didn't their wouldn't think we'll be
able to complete the meantime
during this course we decided over the
spring and some other features that we
weren't thinking about when this whole
thing started because
those turn out to be many important
something that people want it so
very i John asswipe
and just I guess most the view were
around
in the 50 151 days rights said anybody
who's not familiar with 500
okay so these are all familiar things to
you right
we really failed with 500
and a.m. some quotes here from Germany
call for example I think he's in the
room
my skull 500 remarkably painful we
created a lot of death
there and we had to work many years to
sort of catch up and and ensure that we
we were back in the game again
at even 51 and still we weren't
fully back on track when we release that
one
and we put a lot of work into 51 and
then also subsequently
fixing old legacy bikes but I think we
are on track
out today starting with 55 we said we
did this fresh start but I talk about
and I'm and we're just discover
excellent reviews
people really happy about the features
that people really happy about the
quality
and the really happy about the timeline
ass in which 55 was released
same thing with 56 came I think care
twenty six months after 55 so miss
thereby couple months but still
and I'm and didn't drag on for years
and for what I have here
feedback it has great quality a great
feature set
and already said and in a very timely
manner and see some quotes here
from different and community members and
I think
on with Shari is here
and senior okay
am your air but a bunch of people are
here
and
representing different companies and at
that's one thing coming back here with
his
its it's fun to see so many familiar
faces and
and see how they switch around them
somebody or used to work a Twitter and
now I use that link the I work at link
then
somebody move from Twitter to Google
somebody work from will move from Google
to Facebook and its like
ever evolving and that is so much my ass
girl
more child they are circulating in the
cycle systems on really happy too
to meet so many familiar faces am
for recapping on what I've said already
we made a fresh start with 55
am we moved on with 56 and I think
the promise of over future is is great
and will continue in the same PAF and
working in the same
mode and moving forward with that with
the
with a subsequent releases and I think
important here is that we are adding a
lot of new features
lot of innovation to my school we we we
keep the quality
very high and we release in a timely
manner
so coming back to Oracle's
investment in moscow and I think Oracle
is a unique position to
to deliver a combination of things in
for the the
the number of resources that we can put
into this we have a solid business
around my ass girl and we are and
profitable
and which may which ensures that we can
invest a lot of resources development
review resources
to to make sure that the next release
from the next release after that
and I can come out with with with a lot
of new features I think that
keep that in back in back to your head
when you think about
and how how this whole works how can you
invest so much money in this it's really
important that you keep
a solid business around what you doing
around moscow
and I think we have the innovation we
have a great road map
and we have a very very professional and
engineering
workforce there what I've as year so far
engineering expertise in there
on new people coming in as well learning
quickly
there the them to my ass cum source code
being able to contribute
very quickly and fixing bugs
and making new features and doing Q&A
release engineering all the things that
are important in order to give you
a product that is is ready to to
where really yeah
battle tested and and and ready to go
and
stay online for you day and night
at today air you my skull
a development has 100 solve air and
MySQL engineers
we have a a bigger in a DB team than
ever we have a bigger optimize for Team
than ever we have a bigger replication
team than ever
we have tripled the number of Q-eight
resources and we have since
the pre-acquisition day so all Volvo
over my school we have
double the engineering workforce and
we're growing the team by today
hiring I will grow the team even more
and the coming year
and we have the by far the largest
development an engineering team
in in in moscow's history and looking a
little bit of
what what we so loving in numbers what
we've done
in in in the past couple years and we've
done
a 191 work logs if you know what the
workload
anybody not familiar with the work long
okay it's
whatever we we call and to the
self-development
feature if you call it but many features
can be of course
and broken up into it
to several were clubs but it's it's
individual pieces solve
over and handsome and so it goes into
the
to the server I suppose to to box they
don't typically have worked on
we have fixed a thats 1,667
bogus in 56 and we fixed
2,909 dogs in total since my skull 55
GA we've added 911
and MTR high school test run tests
in my skin 5'6 and authority mentioned
we have tripled the Q eighteen
we've 400 we now have like around four
hundred-man years a database cue
expertise on that team and I think
that's that's really important for you
and when you when you take 55 or 56 into
production that you have a
a solid database to work with
am
another view and looking into the south
from Stewart's
both recently at the number outlines the
code that have been added
and quote from him is basically and
we've not seen anything like this in
terms of number of lines of code since
the 41 days when we added
at the cluster stuff which by the way
was
me and my team joining the yeah the gym
mice got back then there was a lot of
lines of code
coming in back from so really a big step
in terms of number lines the code course
number going to code is not always good
but its Lisa a testament solve over the
amount of work
that has gone into to to my ass cum 56
you
i 10 this is the picture that I use
before and and and we have it here
because the question comes up saw
why why are you doing this by
reinvesting in my ass girl
and I think it's really important that
you understand at that
my ass got fits perfectly into Oracle
strategy
an Oracle has a strategy which is to be
able to provide
a a full stock aP's
Anna to wear or rather aP's to desk
the whole way and also not only
the whole stock but also the the breadth
of the stock
in each layer and we we have a and open
a.m. open stance with philosophy around
this
you should be able to buy the whole
stock from of you fat
that's what you want but you should or
will also be able to pick
individual components in there if thats
your choice
and we do think that and lower cases its
its a cost-efficient to buy the whole
stock you can save a lot of work on on
integration work and so on but
again it's it's your choice if you just
wanna pick the database
and the number one database on the web
if
MySQL we provide that
and that's that's that's how it fits
enright an Oracle wants to be number one
on the web
and number one on on on on ERP
and on you take a nap there even more
choice issue will be number one in
transport the number one then
in in retail and and so on and and
there's no questions asked
we've seen it several times in the sand
and he notes in the morning that
that my skull is number one on the web
it powers today nine out of ten of the
pope and most traffic could
web sites in the world
and I think you can guess the one that's
that's not been there anybody
SMS am right there and running single
server for for reason I guess
yes all just to summarize my skype does
make sense
the salon it makes a lot of sense for
Oracle in for example the web
the mall bother and the about its base
and both
on-premise and in the cloud that you've
heard both
and Peter and some owner talked about
already
and Oracle database and the mice good a
bit database are very complementary
and we have air yeah Sood said they've
together they serve a a a broader and
center customers
and it so it's very well suited for four
more web-based
am or what up some also customer a
custom Departamento ops
and an embedded aP's and there's a lot
of customers out there that
that benefits from from running both
MySQL and Oracle together
I think Oracle has some 400,000
customers
and it's believed that some seventy
percent
over those customers Ron Oracle products
side by side with my skype
I talked about and what we've done in
the last couple years around
at the MySQL server and MySQL servers by
for
the only thing and that we do in the My
School engineering team
there's tundra products out there and
here is set since 2010
a just lists of all the different
releases GA releases that we've down
during the past yeah I'd say actually
two-and-a-half years almost now and
never in my skills history have we seen
so many new products come out
in and every year and in
in in a period of time like this we have
and things like my score cluster and the
mice got database of course
our flagship products and by then
all the products that come around there
we have the enterprise backup
we have my score workbench we have my
skin utilities which is a new open
source toolkit that we have
released we have my skull migration
wizard that helps you move from
ass equal server to to
my ass girl had to move from Sybase to
my school
on and so on and we have enterprise
audits
there we have the Cluster Manager
and am several them have been released
in several versions
during this year and also you might have
seen my ass collapse where we release
early some other features that we wanna
yeah get out and I think
looking at this list I think it's fairly
impressive
a.m. so many people have said so many
good things
and around 560 I feel like I'm repeating
myself from a bit here but I I will go
into a little bit more detail on 56
and as as i said i do want to get you
excited about 5-6
Affleck's excited as I am around 5-6 and
I think
it is really a big leap forward
and we have so many different
features in so many different areas
around the service
server and and I feel confident in
saying that that 56 is the best
really savour ever in terms of love
feature set
and and quality and we have improved
performance and scalability we've
been able to show where scalability up
to 48 CPU threads and an app scale
we can have like three times the
performance gain over 55
we've improved in the DB in a number of
different areas
we're better transactional throughput
and throughput and availability
we've improved optimize server faster
query execution for a lot of different
queries
and improve replication and improve
performance keen of performance given
was first released in 55
and a lot of excitement back fan and
we've got a lot of improvements on
on performance schema and 56 and also
with the
with them 56 and I think
both Peter and Simone already mentioned
the North's equal access
and what that means came came out now
and its first version and 56
and this isthe same side I guess Peter
used
air and we're able to show where linear
scalability
as you and increase the
there the number six you threats and
that the
and Moscow servers really able to
utilize
and new hardware if you decide to to to
to buy a bigger and faster machine
and were able to give I get
much more throughput Anna and also scale
across
the number connections
that you add to the database there this
is
over three times the performance so
very very good numbers this is not every
day you see this kind of performance
improvements from one
1 release to another on into the bsa
said
a lot of things there I am I think
and there's the session by Sonny who
will be talking more in depth
on this all just skim through them and I
encourage you to go to
ass on the session and and
today am and and and get more in-depth
fun on what has happened there
be so it things around better resource
utilization
removing alone bottlenecks to be able to
scale and some SS the optimized stations
we've done some really nice ok my
sessions for read-only workloads
and better availability on faster
scaling
and online DDL operation sign personally
very excited about but something that we
had in
custer for many years since I have a
clustering background and sloth
sort of pop features there to be able to
to
to do the daily operations without
taking down or making
making table read-only
now now we have it as well in anonymity
be some really excited about that
and we know a full text search how's the
recent blog Michael former opened and we
did a switch
an hour with the with the with my cell
database
to to actually use the they know the
full text search now instead of my
awesome
full-text search and of course the no
sequel
access I'll come back to
right here am so why do we do this
and so we first of all we believe that
that that that
users are gonna wanna combination all
advanced query language you want to do
complex queries you want to do
your your data mining and sort figuring
out
without having to write pages and pages
of code
to to perform like we are you can right
that in a very compact and and quick
fast manner with with sequel at the same
time we understand that people one
really really fast access if you just
have to keep ValueType lookups
but being able to do that and and and
have the same dataset underneath in this
case here they know the beast origin
I think that adds great value to to
to US us us users of of the database
am and I one of sacrificing on the the
the flexibility that the sequel
interface gives you
you can for parts ago application or or
certain applications you can
optimize then the the access pattern two
words in a DB and gets
up to nine times the performance by
basically bypassing
some other layers and the MySQL server
and going directly to
to to memcached and and Peter mentioned
a.m. his keynote that we had a a new
sequel
type access
and method am to what's cluster and that
has been
success factor for cluster and I why
it's been so adopted in many places
especially in the pool
telecom area and up
how to work with our product for many
years II I i encounter many customers
that really appreciate that this ability
to both
work have through typically there
consoles where they do much more
maintenance type operations they wanted
or
sequel but for their 44 there so love
transection intensive
an application where they wanna save
money on hardware because they're
shipping in in in thousands of copies
and it's really important for them to
get the the most most power out to all
the boxes boxes in time so
in terms of throughput saw seen many
many examples as I said above
with success of this and impostor and
I'm hoping we're gonna see similar
success with
with 56 and and and and and all sequel
sequel
combination that but we're providing
here and the optimizer
a.m. a long list of things here air
and I think this becomes
highly context-dependent whether you
care about some queries or if you don't
care about softwares
and whether you have the particular
queries in your application
which which a and if you can gain
from this and I think
things like explains for INSERT UPDATE
DELETE
people have been asking for this for
many many many years and this is
something that everybody can benefit
from
and the other ones you have to go in and
see if you want to use
by Scott now in a new use case when you
can see that all I can get good
performance also and in this case
I think the structure explain for
example can also be very very helpful
for almost everybody
when you wanna try to figure out what's
what's going on
at and with your query and and and
optimize something more change something
and the optimizer traces as well so this
is so this is the reading exercise for
you basically to see
whether weather and I love the optimizer
features this is something that but you
can benefit from and but
in terms of performance gains that's
anything from
4x2 200 X depending on
on on what kinda we're looking at am
replication as few all probably know is
one over
hope features asked for my skull whites
become so popular over the years it's so
easy to scale out
and the the MySQL server out a new slave
and so on yet there are and many things
that can be improved
and we continue to prove replication
and I'm and these are some of the so the
features that we had in 56
so on the performance I'd and being able
to skate know now in at the Beacon scale
rights
with with threats and of course we need
replication to be able to scale is about
right
because otherwise you can't really
utilize the
their them the performance gain that
you're getting so
multi-threading slaves the binary Law
Group commit and some optimize throw
based replication helps you
so that you can benefit from that in the
DB performance enhancements all the way
through
the chain to that to the slave an app
better failover recovery
especially global transaction
identifiers is a great addition
makes it much easier to build your
tooling around
and failover capabilities that too
21 have in your in in your system am
and then some some nice things around
time-delayed replication
remote been log backup both again
depends a little bit on on whether it's
useful for you or not think the other
ones are things that you can
pretty much and benefit from right away
and performance schema
and it was very well received when it
came
unfortunately and there was some
performance overhead which
there and made its and less useful in
some cases
and we now have worked very hard to
bring down the performance overhead
and our design goal is that there should
not be
more than 5 percent over had to have
your performance schema
am and on and I think we've succeeded in
most cases some before mark Alan
races hand the and says otherwise I do
acknowledge that there are some use
cases that
we still have to work on and will
continue to work on those
am but there's a lot of new information
and instrumentation there
and
and and so much information and I think
one thing that we will work on as well
is to make it easier for
and for most people to access it because
it's it needs a book by itself today
because it's so flexible
at maybe sometimes you don't see either
the
the the fourth for all the trees so all
will continue to work on that to make it
so that you can have sort of the saw the
the tools are you
most likely want to do some have them
pre-packaged some somehow
but it's a really useful tools and we
have had a a great feedback around this
so
I'm really happy about this and an
animal
if we continue to work on this and
intuitively
and continue to improve this am
we were working with the community and
reaching out
and trying to were am get even more
feedback
get our messaging out and and getting
you involved
and we've grown the community team which
sponsored forty-a vans with delivered
seventy talks at different conferences
and with dozens the tech to earth
we've had air and virtual developer days
and so on a very well-attended so very
happy about that we have at my scar
tracks at scale and self conferences ano
water blogs and social media and of
course mysqlconnect that I'll come back
to another but in the end
so that concludes the second part
getting excited about 5-6
and maybe I overdid it because probably
you were excited about 5-6 already
but for the fewer view that that weren't
I hope you announce a good fight it
at least as well so I have everybody
with me on the 56
train looking a little bit had a movie I
i
and
what's going to happen in the future and
what we're focusing on down just looking
at what we think are
an important trends that we need to sort
of navigates
and
along and I think this has been said
already by
by by Peter asobi some repetition
am the whole web
internet thing is continuing to boom and
mo body internet this just making it
boom
even even more right so this is old news
to everybody
and mice got is already number one out
there that
that I've I've already stressed but we
need to work hard to actually make sure
it stays number one
their new technologies coming up all the
time and Peter
listed a bunch of different things eat
different products out there trying to
address different challenges
in the in in the market and an of course
will continue to make my ass girl
and and better and better and better to
be able to meet those
challenges so our goal this term a
number one
and that means that we either a bunch of
things that we need to work on
to to ensure that happens the other one
is the cloud and we had some owner
of course and going into this in depth
but also Peter talked a lot about this
at my skull today if ubiquitous and the
cloud
and I think almost every cloud vendor
out there
pass my skull as an option you thought
than a job in the ass there's an rocks
basis and
every every every you can get the the
the sort of the the database of the
service
down type thing which is my school as a
choice they're
and but also all the ops that you can
get in the cloud
and many many many of them i know if im
a vast majority are are powered by by by
moscow
and this doesn't mean that that we can
sit down and just wait and and and
that things move on i mean they're
they're challenge us right we need to
work on our scale out story we need to
work on
no no not my I'm and stability story
and and and so on there are many things
that we need to do and to make sure that
we stay number one there
as well and a as were challenged by
my by by bout by many other products to
try to
to to address challenges and
in this and this place and the third one
and a bit a repetition here again from
the
the trends that that Peter brought up
from big data big data is
that important for my ass girl and their
and its there's a lot of growth there
and then I think the number on the on
the top right there
in ninety percent of the Fortune 500
companies with
already pilot projects and by the end of
2012
and and its like everybody's talking
about big big data
and and I think the important thing here
is
it gets almost Anna a boring for me to
say there but but
in the open-source arena around Big Data
eighty percent all the user's and
working with a a leading Hadoop
vendor not mentioning any names
integrate all ready now
with my skull sold you could claim that
we're number one there as well
but coming back to the same arguments
there i mean
their challenges we need to make sure
that we stay number one
and and and stay relevant in that market
saw
03 at the Internet keeps just keeps
growing
we need to keep and and growing with it
and housing our product and the v
%um cloud we need to just continue to
make sure that we stay relevant there
and and meet the the
the requirements of the the the vendors
there
and on the big that the side on the big
that the side we haven't done so much
ourselves and other than just being a
database right
am okay I'll skip this one am
in the Big Data life cycle and
their different sort of stages in there
and there's a decision states's acquire
staged organize analyze and so on and i
do better or
the the mice got that the bases Houston
indifferent and
in different places here and there's
been a a
a.m. popular connector which has been
used to connect my skull with Hadoop
here and we thought it would be good to
make something and exciting around that
so that's why we built the Hadoop apply
and I think I was announced
yesterday so what that basically does is
sit
it brings the and instead of having like
a a batch job from
from the semi-skilled server into her
dupe and then doing some processing with
sort of stale all the data we'll have a
live feed of the day
but into Hadoop so that you can do
basically and speed of thought analytics
on your day up so out on lobster day you
can download and and try it on our teeth
on a number or
and posts and and people are you already
getting so excited about this
and but if you're looking at bay date on
on top
probably eighty percent of your and for
some some reason
and then and then and I think you should
take a look at this at the hookah plier
available on laps book my scrapbook.com
and and try it out basically and if
takes
the binary log and
and parts the snot out through the been
like a PI at the
Hadoop liar pushes the same to the ACFs
at that the file and you're able to work
on it
with higher for and
to any any tool around the Hadoop
eco-system saw
read up and i own apt and and and give
us feedback
that's what lab for 44 right this is
something that we want to try out
we think it's a good idea and but we
want to have your feedback to make sure
we we would build it in the right way
such that makes it
very useful for you the other thing that
i wanna talk about
and to have an ounce or or stress
today is that we just released and this
morning actually
our our first 57
milestone and it's out there and so
anybody doubting that 57 will be
open source this is now proof to the
contrary we will continue with the pass
without doubt there's
is no reason why we would do anything
out my ass girl issue back to this and
the web
we 10 keep it ubiquitous and the Y on
the web
and web is open source on
there is no other choice if you wanna
stay the number one
and database out there for the web and
just quickly on some other features and
that you'll see in the first milestone
of course this is
as I said just the first one solo be a
lot of other ones coming in subsequent
milestones and some features that people
have been asking for around
and non-blocking show slave status and
there's some other
and additions to two replications I'd
important mode
and and some additional
an options for
for the mice got been logged and now
there's some we continue it on
on the and just on the online stuff
and I think this is a really critical
component in the whole
and when it when it comes to meeting
future requirements right
it's not no longer good enough to have
to sort of take your table
offline to your altering table and so on
people demand more than that
today you have to be online so the whole
online thing that we
we did with 56 will continue within 5-7
seven and make
even more operations and
able to to perform online so here's your
name index
and and large watch our size
and I am some improvements on into the
be temperate a bowls
to getting par with with with my I some
and
am the other once if you're interested
you can read it yourself there
it's available now download it test it
and give us your feedback its really
important for us
am my school server is one or flagship
a.m. and
products was a cluster is another one I
we've had
I'm tremendous traction with my skirt of
her over over the years
going for virtually nothing in 2004
to a very very sizable business and
with cluster 73 this is our second
development milestone relief
and amp and one of the main features
with 73 is foreign key support
I was actually one of the first feature
that people asked for when we came out
and we decided to prioritize some other
features about the
I think foreign key support is a very
very well come
addition to to cluster 73 so I'm I'm
looking forward to having that
GA soon it would be based on may I am i
scum 56
which is another big thing will be able
to and take advantage over of many of
the
the the great improvements that we've
done and and in 56
and it has a very nice open staller
feature
it also has an ad additional no sequel
type access and node.js
JavaScript APIs well so if you haven't
got the cluster yet
please do on it's it's it's a really
neat product
as I said in the beginning it
and the having a a the ability
to sell and
my ass girl and make a profitable
business is what keep those growing
and for that purpose we have this at
pilot all add-ons to the MySQL server
and which is the value out that we
provide to our commercial customers
many have you can live without them
that's fine
I mean we're very happy to have the 50
million users or so out there
and continue to work on the on the and
community version on my Scotland and
that's that's great
and I but I know that someone you are
working
with the commercial version I hope that
more will see the value that we provide
it with the commercial version and
eventually
become and a paying customer it's what
keeps growing
as I said and I think there is a lot of
value out there
and we have some additional things
around high availability
and there's additional things on
scalability
if you are and some kind of business
around
money you're probably interested in
auditing
and if you have some governmental
requirements or anything like that
there's additional things around
security especially if you want to
integrate with
with the other systems for
authentication
like pat on more or or or
Windows authentication so you have to
so to manage your users and multiple
system course you get the support
from from from Oracle
and and is also a few and I want to use
Oracle together with our use my skills
together with some other Oracle products
like
for example use Oracle GoldenGate to
connect
live data from and Oracle Database
into my ass girl or vice versa oversaw
then
and you need to have an enterprise am
subscription from us an issue 10 where
use Oracle Secure Backup for example to
secure backup for Ghana on sort of your
you're you're my school systems and your
Oracle database systems and other
systems you also need to go to the
Enterprise Edition
and if you were up and if you want to
use Oracle Audit Vault for auditing
purposes
found at the group without so there's a
bunch of soda integration points we have
Oracle products where you can benefits
from from from the
yeah and from the from using the
Enterprise version so
I'm running out of time here enterprise
backup great product
and of course map the Enterprise monitor
if you haven't tried that yet you should
really try it its
free to download test and try out and
assist
30 day trial period there saw please try
them out if you haven't already
and there's no having to buy and I'm not
giving out two hundred fifty dollars
here on
you continue to pay after their I mean
you just stop using it down
on no not no strings attached am so the
concluding thoughts here and
I think I hope I made it clear to you
that that
that we're going fast in my Oscar like
never before
where we are serious about MySQL were
serious about keeping us go
open source we're growing the team
adding new features
where and driving my skull in the vision
and and and
we really want to make sure that that
Oracle and/or Oracle MySQL is
is the best database choice for your
next generation Web your cloud
and your big data applications and we're
going to try to make that happen
and so the sessions that you can
and a and join today and I'm
coming from from Oracle and what's new
in the DB from sunny
today at 4:50 at the meter will talk
about performance tomorrow at 2
and then do I Luiz will talk about
replication
and 11 on Thursday and their support
session tonight
and where I will be and their son who
will be there to meet you will be there
Lewis will be there at 6 p.m. in
in borrowing H am and all just talk
Moscow 56 what you think what we should
change what we should add incoming
releases for
discuss if you wanna know in duct fan
and some other areas
what come to to join us there and and
and just talk
a.m. final slide
I think and we have now X and extended
the mysqlconnect
their event at Oracle OpenWorld and for
another day so now it's three days
and one day tutorial and two day
and sections and it was a a very
successful event last year a lot of
people came there
and we want to try to get even more
people there and therefore we have a
special offer for everybody year
and at the park on a conference if you
register before the third on May
you can save say say seven hundred
dollars using that code
and right down there and just gonna be a
lot of exciting stuff there if you
decide to stay for the whole
Oracle OpenWorld there'll be even more
exciting stuff for
and around there but you can decide to
go just for the three days
it's a Saturday to Monday event and them
amp thank you very much for listening
Video Length: 46:24
Uploaded By: Percona Database Performance
View Count: 3,694