Migrate from on premise MySQL to MySQL Database Service
Sep
02
2020
Sep
02
2020
Over the last few months, I have written numerous blog posts on different features of the MySQL Shell ranging from basic CRUD to aggregate functions and DDL. As a part of the MySQL version 8 release, MySQL Shell is a powerful and alternative environment that you can manage and work with your data in using a choice of 3 languages: Python, Javascript, or SQL. So this blog post is a simple compilation of all the Python mode related posts, in one easy-to-access location…
Photo by Tamara Gore on Unsplash
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit …
[Read more]
Sep
01
2020
How to do selective schema Restore Using “Load Dump” Features Introduced in MySQL 8.0.21 ?
In this Blog I will cover below topic:-
1. What is Dump Load features all about.
2. How to take Restore particular database from Complete Backup?
3. Conclusion.
What is Dump Load features all about?
|
Dump Load Utility introduced in 8.0.21 version of MySQL Shell , which will do Import of backup files to MySQL Instance. Make sure back up files should be created with utility called Instance Dump/Schema Dump Utility. More Info :- … |
Sep
01
2020
Using Instance Dump and Schema Dump features introduced in MySQL 8.0.21 Version.
In this Blog I will cover below topic:-
1. What is Instance Dump/Schema Dump features all about?
2. What are advantage?
3. What is Disadvantage of using Instance Dump?
4. Performance Benchmarks?
5. Conclusion
What is Instance Dump/Schema Dump features all about?
|
MySQL Instance Dump is another logical back up option where backup can be processed in multi-threaded with file compress which will help users to improve performance of overall backup process and also save disk space. This features is introduced in MySQL 8.0.21, … |
Sep
01
2020
So you need to build a new set of databases, perhaps in a new location or geographical zone. Management wants it done yesterday cause the newly updated service hit the front page of reddit and your website and its back-end … Continue reading →
Sep
01
2020
We have scheduled a series of several live webinars about MySQL Database Service, the only service 100% developed, managed and supported by the MySQL Team.
Our webinars will cover a full introduction to the new service. We will discuss the business benefits of using the MySQL Database Service compared to on-premises and vs services of “forked” cloud versions of MySQL. We will show you how to migrate your existing database from on-premises directly into the new service. We will demonstrate how to migrate data from RDS to the MySQL Database Service. And if you happen to use WordPress, we will also show you how to run WordPress with the MySQL Database Service.
__________________________________________________________________________
Date: 9/9/2020 @9AM PST
Title: Introduction to MySQL …
Sep
01
2020
We have scheduled a series of several live webinars about MySQL Database Service, the only service 100% developed, managed and supported by the MySQL Team. Our webinars will cover a full introduction to the new service. We will discuss the business benefits of using the MySQL Database Service compar...
Sep
01
2020
The MySQL team is thrilled to introduce the MySQL Database Service in the Oracle Cloud Infrastructure (OCI), the only service 100% developed, managed, and supported by the MySQL Team.
For those not familiar with MySQL Database Service, it is the same MySQL you know and use, now available in the cloud as a fully-managed service running on Oracle Generation 2 Cloud Infrastructure. It automates time-consuming tasks such as MySQL instances provisioning, patches and upgrades, and backups and restores. Users can easily scale MySQL, monitor cloud resources, and implement security best practices to meet regulatory requirements. Customer applications simply access the MySQL databases via standard MySQL protocols. The typical administrative tasks are automated, integrated, and accessible via the OCI web console, REST API, CLI, or DevOps tools.
The MySQL Database Service is available in multiple OCI Regions and quickly expanding to meet your …
[Read more]
Aug
31
2020
One of the problems with Structured Query Language as opposed to languages like C++, Java, Python, or PHP is that it is hard to tell if a query is good or bad just by looking at it. A programmer with a few months of coding experience can be shown a snippet of code from a project and have a pretty good chance of telling if that code is good or not. Some call this a 'code smell'.
A programmer can tell if the code is legible,
understandable, and many times if it performs well often times at
just a glance. Want to do an experiment on this? Go
out to Github and check out a handful of random
projects. Good code often just looks good.
But SQL is different. It is mostly a declarative language, telling the computer what it wants rather than how to make what it wants. You can random pull SQL queries off Gitthub or Stackoverflow or Reddit …
[Read more]
Aug
31
2020
Migrating On-premises MySQL Enterprise Database to OCI Compute Instance MySQL Enterprise Database ?
In this post , we will walk through steps needed to migrate particular database(example - Sales database) from local Instance(On-premises) to Oracle Cloud Infrastructure Compute Instance.
We will use two new features introduced with latest release of MySQL 8.0.21.
1. Dump Schema Utility
a. This will help us to take the backup from On-promises database and export to Oracle Cloud Object Storage.
2. Load Dump Utility
a. This is help us to Import the schema from Object Storage to local compute Instance.
More info:- …
[Read more]