pre { background: lightgrey; font-size: 14px; border: 2px solid grey; padding: 14px; }

Oracle Cloud Infrastructure (OCI) is the Oracle Cloud Platform where the tutorial leverages 3 services – namely the MySQL Database Service (MDS), Kubernetes Container (K8s) under Developer Services and Compute VM services.

This article is written to provide the steps to provision MDS, K8s and Compute VM services.   It also provides the steps to create a docker image from Image:java:latest as tar for local node image repository import (loading).  

2 Java Client sources are used with the tutorial.

• Helloworld.java – it is a simple hello world output java source
• HelloDB.java – it is multi-threaded java application with Runnable Thread to pump Data into MySQL Database Service.   It uses the Connect/J (MySQL JDBC Driver) to connect to MySQL MDS.

MySQL Shell is …

Building Java with K8S using MySQL MDS

Please note that this is not recommended for any production purpose, don’t expose MySQL traffic to the Internet !

MySQL Database Service is now available, take a look at this nice introduction video:

It is usually a very bad idea to expose a database on a public IP (MySQL or any other database ). MDS doesn’t allow you to implement such bad security practice.

The best way to use your MySQL instance is to use a VPN as I explained in this article.

However, this can be restrictive for a simple test. In this post I will illustrate how you can setup a MDS instance and test it without having to setup any kind of VPN. Of course I recommend you to use such practice only for testing …

I have made changes to the RSS Feed of this blog:

1. Each <item/> does now contain a container <tags/>, inside a sequence of <tag/> containers, with each posts tags.
2. There is now a second RSS feed for posts tagged #mysql, because of demand. You can find it at https://blog.koehntopp.info/feed_mysql.xml.

Example for the tags:

<channel>
        <title>Die wunderbare Welt von Isotopp</title>
        ...
        <item>
                <title>A post title</title>
                <link>https://blog.koehntopp.info/2020/09/...</link>
                <guid isPermalink="false">/2020/09/...</guid> …

     If you are running MySQL 5.6 please note that it will hit support End of Life status in February 2021!  MySQL 5.7 has been Generally Available for almost five years and MySQL 8.0 has been out for over two  years.   You need to upgrade as soon as possible.  

    Upgrading to 5.7 is pretty easy. And I heartily suggest that after upgrading to 5.7 that you also upgrade to 8.0  using the upgrade checker …

MySQL Database Service is expanding to more Oracle Cloud Infrastructure Regions. In addition to the US East (Ashburn), we are rolling out the Service to the United Kingdom (London), Germany (Frankfurt), Brazil (Sao Paulo), and the US West (Phoenix).

Go to oracle.com/cloud/free and get access to a wide range of Oracle Cloud services for 30 days, including MySQL Database Service in Ashburn and Frankfurt Regions. Check the documentation for the quick steps to create your MySQL databases.

We will be rolling out even more Regions soon. Stay tuned!

Don’t forget to register for the live MySQL Database Service webinar series: www.mysql.com/news-and-events/web-seminars …

MySQL Database Service is expanding to more Oracle Cloud Infrastructure Regions. In addition to the US East (Ashburn), we are rolling out the Service to the United Kingdom (London), Germany (Frankfurt), Brazil (Sao Paulo), and the US West (Phoenix). Go to oracle.com/cloud/free and get access to a wi...

The MySQL DROP statement is one of many powerful DDL commands. Be it ALTER TABLE some_table DROP some_column or DROP some_table, this type of command can drastically change your data landscape because in executing MySQL DROP, you are completely removing objects from the database! If you are using the phpMyAdmin web interface, you can execute the MySQL DROP statement with just a few mouse clicks. Continue reading to see how…

Drops of water.

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 from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!

Note: The …

MySQL for RDS and DBaaS, in general, are very controlled environments by the vendors, meaning that there are missing things like a SUPER grant for the root user (and any user in general). This has some implications on operations, one of them being the impossibility of running pt-table-checksum to verify data consistency between a primary and its replicas.

However, there’s a workaround that might overcome this situation and involves three things:

• The pt-table-checksum itself
• A way to collect executed queries
• And the last one, which can be controversial, is to remove the read-only from the replica and use a maintenance window to stop traffic to the database while pt-table-checksum runs.

The problem with RDS is that you cannot change binlog_format to STATEMENT, which is one of the requirements for pt-table-checksum to run.

The workaround consists of capturing the executed …

ProxySQL is proud to announce the release of the latest stable version of ProxySQL 2.0.14 on the 8th of September 2020

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded here or alternatively from the ProxySQL Repository, and freely usable and accessible according to the GNU GPL v3.0 license.

Release Overview Highlights

Before discussing the features and fixes in this release we’d like to mention that we are aware of the delays in new releases. Ideally we would like to release ProxySQL more rapidly however we have recently been focusing our development efforts on ProxySQL 2.1.

The next edition of ProxySQL brings improved performance as well as many new and exciting …