The latest from the MySQL community

After spending four years working with ProxySQL in production, I’ve learned a few interesting lessons about interpreting and processing query rules. I hope to save you some time (and avoid wrong turns) with this summary of ProxySQL query rules.

ProxySQL query engine is very powerful and supports the building of complex rule sets. These can be used to route traffic to backend MySQL instances, rewrite queries, and for traffic mirroring, among other use cases.

When the rule set is short and simple, you can easily understand what the outcome for a certain query would be. However, for complex sets or combined scenarios, you need a deeper understanding of the engine logic.

Note 1: Rules are processed in rule_id order

It might seem like a trivial start, but during testing or implementation, …

Migrate from on premise MySQL to MySQL Database Service

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 …

 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?

 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?

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 →

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 …

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...

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 …

    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 …