Showing entries 1 to 10 of 67
10 Older Entries »
Displaying posts with tag: howto (reset)
Discovering MySQL Database Service – Episode 7 – Use a Bastion SSH port forwarding session

MySQL, the world’s most popular open source database, is available as a managed cloud service in Oracle Cloud Infrastructure (OCI) under the name of MySQL Database Service (MDS).

This is the seventh episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services.

In this episode, we’ll discover and use the OCI Bastion service to provide a restricted and time-limited access to administer our MySQL instance.

The post Discovering MySQL Database Service – Episode 7 – Use a Bastion SSH port forwarding session first appeared on dasini.net - Diary of a MySQL experts.

Discovering MySQL Database Service – Episode 6 – Update the Private Subnet Security List

MySQL, the world’s most popular open source database, is available as a managed cloud service in Oracle Cloud Infrastructure (OCI) under the name of MySQL Database Service (MDS).

This is the sixth episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services.

In this episode, we’ll introduce the concept of Security Lists a virtual firewall to control traffic at the network packet level.

The post Discovering MySQL Database Service – Episode 6 – Update the Private Subnet Security List first appeared on dasini.net - Diary of a MySQL experts.

Discovering MySQL Database Service – Episode 5 – Create a MySQL DB system from a MySQL Shell dump

MySQL, the world’s most popular open source database, is available as a managed cloud service in Oracle Cloud Infrastructure (OCI) under the name of MySQL Database Service (MDS).

This is the fifth episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services.

In this episode, we’ll see how these data can now easily be imported into a MySQL Database Service instance.

The post Discovering MySQL Database Service – Episode 5 – Create a MySQL DB system from a MySQL Shell dump first appeared on dasini.net - Diary of a MySQL experts.

Discovering MySQL Database Service – Episode 4 – Dump your MySQL data into an Object Storage bucket

This is the fourth episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services.

In the previous episode we’ve created our Virtual Cloud Network, that provides you with complete control over your cloud networking environment that we will create in this Discovering MySQL Database Service journey.

In this episode, we’ll see what is OCI Object Storage and how to export data to it from a MySQL instance using MySQL Shell.
In fact, in the process of creating a MySQL DB system, this step is optional. But it is especially useful if you want to create a MDS instance with data from a MySQL server on premise or in any public/private cloud.

The post …

[Read more]
Discovering MySQL Database Service – Episode 3 – Create a Virtual Cloud Network

This is the third episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services.

In the previous episode we’ve created our compartment, the foundation stone, of the architecture that we will build during this Discovering MySQL Database Service journey.

In this episode, we’ll see what is a Virtual Cloud Network (VCN) and how to create one and use it.

The post Discovering MySQL Database Service – Episode 3 – Create a Virtual Cloud Network first appeared on dasini.net - Diary of a MySQL experts.

Discovering MySQL Database Service – Episode 2 – Create a compartment

This is the second episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services.

In the previous episode we've introduced the different components that we will use during this Discovering MySQL Database Service journey.

In this episode, we'll see what is a compartment and how to create one and use it in order to create a MySQL DB system.

The post Discovering MySQL Database Service – Episode 2 – Create a compartment first appeared on dasini.net - Diary of a MySQL experts.

Discovering MySQL Database Service – Episode 1 – Introduction

This is the first episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services.

Like any series, in this episode I’m going to give you some context and set up the characters.

The post Discovering MySQL Database Service – Episode 1 – Introduction first appeared on dasini.net - Diary of a MySQL experts.

Group profiles in MySQL Enterprise Firewall

MySQL Firewall is an enterprise security solution providing ease of mind while protecting your database from rogue queries. Sometimes granting wide-style access privileges may feel a bit too generous, and leaves you wondering whether you could do something more. Join us as we explore Firewall, and (in particular) using Group profiles.…

Facebook Twitter LinkedIn

Setting MySQL Configuration Variables – MySQL 5.7 vs MySQL 8.0

MySQL configuration variables are a set of server system variables used to configure the operation and behavior of the server. In this blog post, we will explain the differences in managing the configuration variables between MySQL 5.7 and MySQL 8.0. We will explain three different ways for setting the configuration variables based on your use-case. […]

How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

Monitoring your MySQL database performance in real-time helps you immediately identify problems and other factors that could be causing issues now or in the future. It’s also a good way to determine which components of the database can be enhanced or optimized to increase your efficiency and performance. This is usually done through monitoring software and tools either built-in to the database management software or installed from third-party providers.

Prometheus is an open-source software application used for event monitoring and alerting. It can be used along with a visualization tool like Grafana to easily create and edit dashboards, query, visualize, alert on, and understand your metrics. ScaleGrid provides full admin access to your MySQL deployments – this makes it …

[Read more]
Showing entries 1 to 10 of 67
10 Older Entries »