MySQL will be used for our online sections because the VMware instance and Docker configurations where too large to effectively download this term.

MySQL 8.0.21 Installation Steps

After you download the MySQL 8 MSI file, you will perform the following 24 steps to install MySQL on Windows 10. If you want a full developer install you must install Microsoft Excel and Visual Studio first.

1. The first thing you need to do is grant privileges to allow the MySQL Installer application to work in Windows 10. Click the Yes button to authorize the MySQL Installer to run.

1. The next thing you need to do is grant privileges to allow …

This post was first published on Oracle MySQL Blog.

If you are running MySQL on premise, it’s maybe the right time to think about migrating your lovely MySQL database somewhere where the MySQL Team prepared a comfortable place for it to stay running and safe.

This awesome place is MySQL Database Service in OCI. For more information about what MDS is and what it provides, please check this blog from my colleague Airton Lastori.

One important word that should come to your mind when we talk about MDS is SECURITY !

Therefore, MDS endpoint can only be a private IP in OCI. This means you won’t be able to expose your MySQL …

Completing the data lifecycle is often harder than originally expected: Deleting data can cost sometimes way more than inserting it in the first place. MySQL Partitions can offer a way out. We have an earlier post on the subject.

A sample table, and a problem statement

Let’s define a kind of log table, to which data is added with an auto_increment id value and some data.

#! /usr/bin/env python3

from time import sleep
from random import randint
from multiprocessing import Process

import click
import MySQLdb
import MySQLdb.cursors


db_config = dict(
    host="localhost",
    user="kris",
    passwd="geheim",
    db="kris",
    cursorclass=MySQLdb.cursors.DictCursor,
)

@click.group(help="Load and delete data using partitions")
def sql():
    pass

@sql.command()
def setup_tables():
    sql_setup = [
        "drop table …

Our pleasure to announce the MySQL Day which will be hold on September 26, 2020. Please find more details below and at the Oracle India User Group website.

• Name: MySQL Day
• Date: September 26, 2020
• Agenda: 
  • 11:00 to 11:20 - Welcome: MySQL Day Agenda by Sanjay Manwani, the MySQL India Dev. Sr. Director, Oracle. 
  • 11:30 to 12:00 - Keynote: State of MySQL by Tomas Ulin, the Vice President, Oracle
  • 12:15 to 13:15 - Hands-On: Introduction to MySQL Database Service (MDS) by Jothir Ganesan, the Software Development Manager, Oracle  
  • 13:15 to 14:15 - Lunch Break    
  • 14:15 to 15:00 - Hands-on: Backup and restore of MDS  by Gagan Goel, the Senior Development Manager, …

Our pleasure to announce the MySQL Day which will be hold on September 26, 2020. Please find more details below and at the Oracle India User Group website. Name: MySQL Day Date: September 26, 2020 Agenda: 11:00 to 11:20 - Welcome: MySQL Day Agenda by Sanjay Manwani, the MySQL India Dev. Sr. Director...

Watch this on-demand webinar tutorial to learn all about our new Tungsten Cluster (AMI) for MySQL HA, DR & geo-clustering, including a demonstration on how to use it. Learn about clustering architecture, and the different possible topologies.

Tags:  MySQL High Availability Disaster Recovery Geo-Distributed Webinar tutorial tungsten cluster …

The MySQL team is thrilled to invite customers to use the new MySQL Database Service also in OCI Japan East (Tokyo) Region. This is an addition to the Regions where the Service is already available: US East (Ashburn), United Kingdom (London), Germany (Frankfurt), Brazil (Sao Paulo), and the US West (Phoenix).

If you want to test for free, 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, Frankfurt, London, Phoenix, and Tokyo Regions. Check the documentation for the quick steps to create your MySQL databases.

We continue our expansion journey and more Regions are coming soon!

You are also welcome to register for the live MySQL Database Service webinar …

The MySQL team is thrilled to invite customers to use the new MySQL Database Service also in OCI Japan East (Tokyo) Region. This is an addition to the Regions where the Service is already available: US East (Ashburn), United Kingdom (London), Germany (Frankfurt), Brazil (Sao Paulo), and the US West ...

A blog series about ProxySQL and Galera…

This post is the first of a series of blogposts on how to easily use ProxySQL to scale-out your application’s database workload on a Galera cluster. This series will explore the main concepts in configuring ProxySQL for Galera across three articles as follows:

– A first introductory post describing the minimal configuration needed for ProxySQL to monitor and manage a Galera Cluster.
– A second post describing how to setup a read/write split configuration for our Galera Cluster, using ProxySQL query rules.
– A third and final post with examples on specific cluster configuration options and more detailed explanations on why and how ProxySQL changes the nodes states based on configuration changes and monitored variables. Requirements

To illustrate how to configure ProxySQL for a Galera Cluster we will use a sample Galera Cluster …

MySQL uses connection and config parameters from a number of possible sources. The easiest way to find out where it is looking for config files is to run

$ mysql --help | grep cnf
                      order of preference, my.cnf, $MYSQL_TCP_PORT,
/etc/my.cnf /etc/mysql/my.cnf /Users/kkoehntopp/homebrew/etc/my.cnf ~/.my.cnf

As can be seen, my version of the MySQL client checks in this order

• /etc/my.cnf
• /etc/mysql/my.cnf
• /Users/kkoehntopp/homebrew/etc/my/cnf
• ~/.my.cnf

The cnf file is a file in dot-ini syntax, so you have [groups] and each group contains lines with key = value pairs. Which groups are read?

$ mysql --help | grep "groups are"
The following groups are read: mysql client

So in my case, I would create a /Users/kkoehntopp/.my.cnf looking like this:

[client] …