aster.cloud aster.cloud
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
    • Learning
  • Tools
  • About
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
    • Learning
  • Tools
  • About
aster.cloud aster.cloud
  • /
  • Platforms
    • Public Cloud
    • On-Premise
    • Hybrid Cloud
    • Data
  • Architecture
    • Design
    • Solutions
    • Enterprise
  • Engineering
    • Automation
    • Software Engineering
    • Project Management
    • DevOps
  • Programming
    • Learning
  • Tools
  • About
  • Data
  • Engineering
  • Tech

Up For An Update? Cloud SQL Launches Support For In-Place Upgrades

  • aster_cloud
  • April 26, 2022
  • 3 minute read

If you adore databases like we do, the launch of a new major version is an event you celebrate. With each new major version comes cutting-edge database features, performance boosts, and other goodies for database lovers like you. You can hardly wait to spin up a Cloud SQL instance to test out the freshest release for your new services! But how about those existing databases of yours–is there a way to get them upgraded?

Cloud SQL now supports in-place upgrades for PostgreSQL and SQL Server in preview. With in-place upgrades, you can upgrade your databases in just a few minutes with a single command. When you perform an in-place upgrade, Cloud SQL keeps things simple for you and maintains your database’s IP address, user data, and settings, so that you don’t have more work to do after the upgrade completes. Cloud SQL even takes care of the mundane steps, such as running compatibility checks and backing up your data. If an issue does arise during an upgrade, Cloud SQL automatically rolls your database back to the previous version, getting you back up and running right away. When compared with migration-based upgrades, in-place upgrades are faster, easier, and more reliable.


Partner with aster.cloud
for your next big idea.
Let us know here.



From our partners:

CITI.IO :: Business. Institutions. Society. Global Political Economy.
CYBERPOGO.COM :: For the Arts, Sciences, and Technology.
DADAHACKS.COM :: Parenting For The Rest Of Us.
ZEDISTA.COM :: Entertainment. Sports. Culture. Escape.
TAKUMAKU.COM :: For The Hearth And Home.
ASTER.CLOUD :: From The Cloud And Beyond.
LIWAIWAI.COM :: Intelligence, Inside and Outside.
GLOBALCLOUDPLATFORMS.COM :: For The World's Computing Needs.
FIREGULAMAN.COM :: For The Fire In The Belly Of The Coder.
ASTERCASTER.COM :: Supra Astra. Beyond The Stars.
BARTDAY.COM :: Prosperity For Everyone.

If you use SQL Server, you may also use in-place upgrades to upgrade your edition and take advantage of features in a more premium SQL Server offering, such as SQL Server Enterprise.

In-place upgrades can be performed with a few clicks from the Cloud Console, or through gcloud or the API. MySQL support is coming soon.

How to upgrade your database

Pretend you’re a database administrator at BuyLots, where you manage a fleet of Cloud SQL for PostgreSQL and SQL Server databases. The BuyLots fleet is on PostgreSQL 9.6 and SQL Server 2017–while that was state-of-the-art when you set up these databases four years ago, the software is now antiquated and you acknowledge it’s time for an update.

Read More  InfluxData Announces Availability Of The Leading Time Series Platform On Google Cloud

You do your homework and you decide to go straight to the latest and greatest with PostgreSQL 14 and SQL Server 2019. You see that PostgreSQL 14 offers major performance improvements for BuyLots’ connection-heavy workload and you can’t wait to try out SQL Server 2019’s accelerated database recovery feature. You check out the PostgreSQL and SQL Server documentation and find out that, fortunately, none of the incompatible changes introduced in the later versions are ones that you need to worry about. You know that upgrading incurs some downtime, so you check the calendar and decide that next month’s Saturday evening service update window–when BuyLots’ database activity is at its lowest–is the right moment to conduct the upgrade event.

In preparation for the upgrade event, you decide to do a dry run of your upgrade and kick the tires on PostgreSQL 14. You also want to get a sense for how long upgrading will take. You first clone one of your PostgreSQL 9.6 databases called inventory-db. After inventory-db-clone is created, you view the cloned instance’s Overview page from the Console and you click the Edit button. You spot the Upgrade button underneath the database version and you click it.

 

When you’re prompted to choose a major version to upgrade to, you click the drop down menu and select PostgreSQL 14.

 

On the next screen, you type in the cloned instance’s name to confirm that you are ready to start the upgrade.

 

Cloud SQL takes you back to the Overview page and you see the upgrade progress in real-time. You hold your breath for a moment–is it really this easy?

Read More  Kubernetes Tooling For TechOps And Support (Local Kubernetes Clusters)

 

You leave for a brief moment to crush the daily Wordle (3 guesses!). When you click back a few minutes later: presto change-O! Your database is now on PostgreSQL 14!

 

You perform a few acceptance tests on the upgraded instance and things are running smoothly. You’re really impressed by how much faster things are running in PostgreSQL 14. You test out the upgrade procedure a few more times with other PostgreSQL and SQL Server instances in the fleet and everything looks good. You’re feeling ready as ever for the big upgrade event next month!

Learn more

With in-place upgrades, you can now upgrade your database major version and benefit from the latest database features, performance advances, and other improvements. To learn more about in-place upgrades, see our documentation.

 

 

By: Akhil Jariwala (Product Manager, Cloud SQL)
Source: Google Cloud Blog


For enquiries, product placements, sponsorships, and collaborations, connect with us at [email protected]. We'd love to hear from you!

Our humans need coffee too! Your support is highly appreciated, thank you!

aster_cloud

Related Topics
  • Cloud SQL
  • Databases
  • Google Cloud
  • Tutorial
You May Also Like
View Post
  • Data
  • Engineering
  • Platforms
  • Solutions

How ‘Anything Is Possible’ Automated Data Pipelines With BigQuery And Windsor.ai

  • September 27, 2023
Penguin
View Post
  • Engineering

How To Find And Fix Broken Packages On Linux

  • September 19, 2023
View Post
  • Data
  • Multi-Cloud
  • Platforms

Microsoft And Oracle Expand Partnership To Deliver Oracle Database Services On Oracle Cloud Infrastructure In Microsoft Azure

  • September 14, 2023
View Post
  • Gears
  • Tech

Apple introduces the advanced new Apple Watch Series 9

  • September 12, 2023
View Post
  • Design
  • Engineering

4 Ways To Improve Long Term Kubernetes Capacity And Cloud Costs In Kubernetes

  • September 9, 2023
View Post
  • Data
  • Learning

Resources to Take Your Charts From Bland to Beautiful

  • September 6, 2023
View Post
  • Engineering
  • Platforms
  • Research
  • Technology

Fast-Tracking Fusion Energy’s Arrival With AI And Accessibility

  • September 6, 2023
View Post
  • Cloud-Native
  • Computing
  • Engineering
  • Platforms

Farewell EC2-Classic, It’s Been Swell

  • September 4, 2023

Stay Connected!
LATEST
  • 1
    How ‘Anything Is Possible’ Automated Data Pipelines With BigQuery And Windsor.ai
    • September 27, 2023
  • 2
    Oracle CloudWorld 2023: 6 Key Takeaways From The Big Annual Event
    • September 25, 2023
  • 3
    Nvidia H100 Tensor Core GPUs Come To Oracle Cloud
    • September 24, 2023
  • 4
    Combining AI With A Trusted Data Approach On IBM Power To Fuel Business Outcomes
    • September 21, 2023
  • 5
    Start Your Ubuntu Confidential VM With Intel® TDX On Google Cloud
    • September 20, 2023
  • Microsoft and Adobe 6
    Microsoft And Adobe Partner To Deliver Cost Savings And Business Benefits
    • September 20, 2023
  • Coffee | Laptop | Notebook | Work 7
    First HP Work Relationship Index Shows Majority of People Worldwide Have an Unhealthy Relationship with Work
    • September 20, 2023
  • 8
    Oracle Expands Distributed Cloud Offerings to Help Organizations Innovate Anywhere
    • September 20, 2023
  • 9
    Huawei Connect 2023: Accelerating Intelligence For Shared Success
    • September 20, 2023
  • 10
    Huawei Releases Data Center 2030, Leading Innovation and Development of New Data Centers
    • September 20, 2023
about
Hello World!

We are aster.cloud. We’re created by programmers for programmers.

Our site aims to provide guides, programming tips, reviews, and interesting materials for tech people and those who want to learn in general.

We would like to hear from you.

If you have any feedback, enquiries, or sponsorship request, kindly reach out to us at:

[email protected]
Most Popular
  • Penguin 1
    How To Find And Fix Broken Packages On Linux
    • September 19, 2023
  • Volkswagen 2
    Volkswagen Races Toward Next-Gen Automotive Manufacturing Leadership With Google Cloud And T-Systems
    • September 19, 2023
  • 3
    VMware Scales Multi-Cloud Security With Workforce Identity Federation
    • September 18, 2023
  • Intel Innovation 4
    Intel Innovation 2023
    • September 15, 2023
  • 5
    Microsoft And Oracle Expand Partnership To Deliver Oracle Database Services On Oracle Cloud Infrastructure In Microsoft Azure
    • September 14, 2023
  • /
  • Technology
  • Tools
  • About
  • Contact Us

Input your search keywords and press Enter.