Duration 21:08
16+
Play
Video

What’s new with Cloud SQL

Brett Hesterberg
Product Manager, Payments at Google
  • Video
  • Table of contents
  • Video
Google Cloud Next 2020
July 14, 2020, Online, San Francisco, CA, USA
Google Cloud Next 2020
Request Q&A
Video
What’s new with Cloud SQL
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Add to favorites
1.82 K
I like 0
I dislike 0
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
  • Description
  • Transcript
  • Discussion

About speaker

Brett Hesterberg
Product Manager, Payments at Google

As a product manager, I figure out what users need and why they need it, build it as quickly as possible, ship it smoothly, measure impact, and repeat.

View the profile

About the talk

Cloud SQL is managed database service that makes it easy to set up and maintain your MySQL, PostgreSQL, and SQL Server databases in the cloud. See new features and enhancements that improve security, protect against disaster, and more.

Speaker: Brett Hesterberg

Watch more:

Google Cloud Next ’20: OnAir → https://goo.gle/next2020

Subscribe to the GCP Channel → https://goo.gle/GCP

#GoogleCloudNext

DBS102

product: Cloud SQL; fullname: Brett Hesterberg;

event: Google Cloud Next 2020; re_ty: Publish;

Share

Welcome to Google Cloud. Next on are in this session. All cover, what's new with God's people? My name is broadcaster for product managers month of people that we can learn a little bit about each other. Using your question, paint your commenting on your screen, you feel comfortable please. Comment in your job title. Are you a database administrator a reluctant database administrator? Your preferred or the Oracle site or something else? Expert sessions, I'm available to meet one-on-one and talk more about cups equal

to reach out. What about for me hear he's one is how you find more flexibility in your database environment, how we can protect against, the unexpected automatic transfer, without the risk before it offers Mike sequel server and postgresql. This means that if you have an application, that uses my steel sequel server, SQL, it will work with people focus on managing mundane Administration. Aspects of these databases equal is compatible with your favorite database Administration tool

guy here. just can use their favorite Administration operating in those links if you're interested in learning more, When I think about running a database, this tends to be the technology staff, General. This means to Romanian rap power HVAC networking for you. In the cloud wear with cows equal when we offered instance, and you can figure the number of a CPU cores. Ram, we make sure that you get a consistent experience that number for wasn't even moving. One, come to the right, we look at the operating system, installation, and passing keeping

the Auburn system where he can meet up today with some sort of hatches or things like, Usually include automatic fail over using mosquito out. Reeds to wrap up. This whole technology staff is a problem. We're able to quickly find a room cost in a t. I c l, i knew I submit for your application teams in your environment or your developers. They can easily start up and create a Dever test database, but just as easily create a production, Brave database, which means it includes availability, which relies on synchronous replication and

automatic fill over. Includes a back-up plan for data protection and even properties and replication for Disaster Recovery. Again, all of the day, I see a liar. You, I mean in just a few minutes to get this setup. Him some physic well in Templeton with a customer at Duke heart lab. He says the products that provide value to his customers, they're going to spend less time on certain aspects of database Administration so they can focus their time elsewhere

and wanting to know here is that the diagram I showed up and was also back in Sims 4 is a dedicated as a site reliability. Engineering group of people is on call 24/7, decent folks who write the Automation and make sure our service is healthy and run. Well and when automation fails their hands on keyboard to get a database backup and run Have you taken a look at Cloud? SQL will start to introduce. What's new? What we've been up to in the past few months. And I think what you'll find as we have

great momentum in terms of Enterprise features were building on an Enterprise features. A number of these new features of today, 1st and flexibility in your database will start with the classical Federation enhancement, a way to quickly reduce the value for business Insight. Perhaps they wanted was for some days off without saying that the pipeline first, or perhaps they have a quick question. They need to answer and that they'd be spread across multiple come sequences with big Creative Cloud. SQL Federation, the analyst

sequences that already reside in big berry or perhaps resides in one of the other external data sources supported by Vic. What do you see in this light is a depiction of a very simple query analysis. Running in big Prairie where they're using the Sternal query function, which is what we use to ask her to go running around the advocates, for example. So we're not sending back YMCA, large keyboard. Beta, the dataset back from cloud, SQL table format, from

another external Source, supported by Big Bird. All of this can be done without setting up a pipeline and assure that the inside screen provider useful from there beside my clients or regular reporting schedule. Next to look at committed, use discounts and we don't often think of pricing and flexibility in the same size. Hopefully you'll find a committed use discount is ideal for a workload. With predictable resources, this is a way of saying that they're great for environment where you're running. A

number of consequence is 24 x 7. You know, that each month, you're going to spend a certain amount of people when you commit to a one-year or three-year term, was it committed use discount. You receive either 25% or 52% discount one year. And three year, the flexibility comes in with a permitted use discount in that easily and fully transferable between the database engine support, if I have people might as well as rescue well as well as people server the cancer CDs.

And RAM associated with each of your house. And here, if you need me to stay changes in sequel, server to Pro stress over time, is no problem. Your CDs will continue to apply. Need to reach out to us fully transferable but you don't need to take any specific action. You purchase a committed. Use discount in a currency denomination breathable dollars and we charge for instance race against that commitment each month. These are also growing fully transferable between machine sizes so you don't need to forecast machine size or how many CPUs for machine.

You'll be needing the future you simply UCP use as you see fit and change over say a three-year period of time without any problem of flying two middies discounts we hope this will make your planning for communities discounts much easier with a lot less for casting. The whole process to be and be flexible. Looking now at how to protect the against the unexpected. We'll start with Disaster Recovery in Google. Cloud terms. We often categorized disasters as a region

region. Google cloud is comprised of three or more zones, where is zone is a separate failure to me that if we have a problem presents itself against the recent mileage but if she were more of the zones in a reason or down, we have introduced a replica enhancement for coffee during replication enhancement. It allows you to guard against this sort of any region around the world other than your primary reason, we're using Google's Global Network as well as Google Google Cloud to be PCS with your Global in

nature. All Races in the world to ensure that this experience is easy to set up your own private, you see, in this light in the screenshot that I'm selecting a region. Something other than where I have my primary in with my primary is Izzy in, for example, us Central one. Last one as my reason for the replica that's really about. All I have to do this will not take advantage of my private BBC Network. So I know I'm transferring data or copy data rather than your real time to my replica. The replica is now available in another reason

than my primary. This mean, in the event that I have a outage in my primary reason you have Central one piece of that disaster of Nokia, is that this replica is also. If you have users in another region of low, latency reads to a replica, Or you want to run report a freaking phone replica. You can certainly do. So knowing that the replica is still available. We talked a lot about disasters and widespread outages you all have done. A lot of disaster planning as part of your careers in it what we tend to realize, though is often the most common event is

a user, are we are sort of the disaster if you will. I might drop a table or should you rotate it by mistake. I want an undo button to get back in time before. I think that they do get back to where I was long, have points on recovery or are my sequel product of people are now a proud to introduce it for who stressed, you out as well put rescue album. We store transaction logs or wall for the past 7 days which allow you as a user to select a millisecond at any point in the last 7 days. So I made a mistake on a Friday afternoon. For example, I don't realize until Monday morning

easy for me to get back to the millisecond for the second before I made that mistake on Friday and recover. That gives me an undo button as I mentioned and helps against the more common issue, which is user are These features Enterprise ready to list for data protection and disaster recovery. And I think it's worth summarizing, how to build a production production with people, you start by nibbling automatically backup or taking more frequent on-demand backups,

especially when you're making a major change. You might be making a schema change. The great, I'm taking Autumn and back up. Just before you make that change, anything goes wrong that you can get it back. We also have an export magnetism a crowd of people that allows you to ask for your data, in a portable format to Google. Cloud Storage GPS is to be in a single reason, bucket or otherwise use multi-region pockets in insurance said, in a recent outage, your data is automatically replicated

on premises are in another cloud provider. Allows a very portable format so that you can take it where you want. In region. Ensure that you enable High availability availability tells Cosby photo which means we automatically fell over on your behalf even after a major fall. This is necessary for the general availability for any production system. Last week as I mentioned to protect against a region, outage consider using our cross-region replication or cross-region replica. Again, you'll have a near real-time copy JCPenney application, which means you'll have

data available to you in another region. Should your primary reason to have an outage? You can make that data accessible very quickly to get back online. Working now how to get automatic transparency and trusted. Security control will start with access grandparents administrator, accesses your contact. How do I get lost? Already provide visibility into the actions of your own administrators support administrator is this betrayal typically or previously stopped once

your provider support? When you open it with our support team with the x-axis transparency, you'll see their actions in your audit log as well for our manual and targeted asses again your database back online. Take us further with access approval and viewing the access you can use the access approval feature to increase your level of control by requiring explicit approval before Google support, registering can access your data or configurations on Google Play. I recommend taking a look at both access conspiracy and access approval to see how they fit with

your environment. Next up was looking at encryption in specifically customer managed encryption keys, keys are intended for organizations that have sensitive or regulated data. That requires them to manage their own feces are stored in a system that you managed were using keys and House people that you manage and we access them. As part of our operation, should you remove access from that team, then when possible performs a major operation next? It won't be able to get the keys and access to the system is shut down. Again allows you to use

to control your data at rest, the day to restore. I mentioned earlier, Google clouds will be PCS. We've introduced in cups, equal support for BBC service controls, these generally ngcp allow you to Define refined grains perimeter control across numerous Google cloud services, including possible very well with feces or private IP addresses with the combination of private IP addresses and BBC service control. Your now able to make private your consequences, both from a perspective as well as the private. I can hear BBC allows you to protect the data pass, the

things that your clients BBC, service controls 4 cups, equal, protect the administrative API, who can create consequences, Administration API, totally private, as well as ensuring that you can control where your your teams to access consequences. What's found out what kind of stay up-to-date without the risk? As a reminder, sequel, has long offered maintenance Windows, which are 1 hour per week time, when you define the Google can perform maintenance on your AC. In general, people typically performed maintenance

your maintenance. When do you see in this diagram 1? Thinking about meetings Windows is that we offer certain timing is in a given project. You have Devin test database as well as production. A to me, you might put the Devon test databases on the earlier time and you might put the production databases on the later time that the news on the earlier. Timing get me in to receive maintenance about a week in advance of your production. That way, give you a chance to test the

updates with your application. We recently added maintenance notification and reschedule. When you often willing will email you a week in advance of Maintenance, letting you know that we're planning to perform at you in your next meet is, when do you get a few options as part of this notification, including the ability to reschedule to a fall in with window when week later or the ability to apply maintenance, any time you click the apply now, but I'm in the next few weeks, if you're not happy, just gives

you much more control as to when maintenance is applied. Especially on your production, is considered amateur teams know. Well, in advance of Maintenance will be performed. The wrap-up. Hopefully, these features help you find a bit more flexibility in your environment with things like big furry Federation, and middies discounts help me protect against the unexpected. Be that user error with point in time recovery, or a regional Abbott with crossbreeds or application at disaster recovery. Automatic transparency in pricing things like private IP. And now the addition of

EDC security controls for example, as well as well as grounded out with our new maintenance notifications and reschedule. As you can see, you drop your next steps. I encourage you to take a look at two other sections. The first a date of modernization story, where McKesson talks about their journey. And please take a look at the bare metal solution which will help you bring your Enterprise workloads, GDP want to see cups, equal an action, take a look at our showcase them, which is a Wacom old style high-availability. I mention hi Beverly, briefly in this demonstration. As a man

in Wacom old style. You'll get to see how many cups equals ounces. Can you make bail and how many recovered in the amount of time you're giving him again? Lastly guess hands on people and try it out with her. Qwiklabs quest in the quest, you'll be reduced because he poo from beginner, not all the way through advanced touching on a lot of the features that I talked about today by the end. I think you'll feel very comfortable using Cloud SQL, be taking advantage of that we brought up this year. Thank you all for spending this time with me and watching the session. As I mentioned, I'll

be available as part of our Google Cloud. Next session. If you want to meet one of them wanted to talk a little more. Thank you again.

Cackle comments for the website

Buy this talk

Access to the talk “What’s new with Cloud SQL”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Ticket

Get access to all videos “Google Cloud Next 2020”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Ticket

Similar talks

Gurmeet (GG) Goindi
Product Management at Google
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Lokesh Kris
Principal Architect | West Region | Google cloud at Google
+ 1 speaker
Anshul Kumar
Strategy and Analytics Leader at Deloitte Consulting
+ 1 speaker
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free
Marsh Gardiner
Product Manager at Google
+ 1 speaker
Evan Scheessele
Sr. Manager, Cloud, API, & Developer Experience at HP
+ 1 speaker
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Buy this video

Video

Access to the talk “What’s new with Cloud SQL”
Available
In cart
Free
Free
Free
Free
Free
Free
Free
Free

Conference Cast

With ConferenceCast.tv, you get access to our library of the world's best conference talks.

Conference Cast
635 conferences
26170 speakers
9693 hours of content