Recently (earlier today), I blogged about how to use PHPMyAdmin with a MDS instance. I also showed at the end of the video that it’s possible to open MySQL Router on the compute instance to connect from anywhere. However this has security risks of course. Therefor, it’s not recommended.
If you want to connect from on-premise to your MDS instance you should use a VPN or a SSH tunnel. Take a look at these previous post:
[Read more]I recently received several messages from developers not being comfortable with command line when they need to create schemas, tables, … They were asking me for an easy alternative when testing MDS.
There is a very popular tool in the developer community to manage their databases in MySQL: PHPMyAdmin.
So if you are trying MDS (MySQL Database Service in Oracle Cloud Infrastructure), it’s possible to deploy such instance with a compute instance hosting PHPMyAdmin very easily using OCI’s Resource Manager and a stack (zip file) that you can find here: https://github.com/lefred/oci-phpmyadmin-mds/releases/tag/1.1.0
If you want to try MDS in OCI, you can get free credits using this url: …
[Read more]
I am pretty new on the Oracle Cloud Infrastructure technology, so
maybe I am talking about something you already know. But anyway I
prefer to share this case: it can help if you encounter the same
problem as me. Let’s take the risk to have too much information
rather than nothing!
The problem
I was doing some tests on the new MySQL Database
Service and during the setup I decided to generate my ssh
keys via the OCI console:
When I tried to connect via PuTTY or MobaXterm to my compute instance using the opc account and my private key (generated previously), I got the following …
[Read more]
I am pretty new on the Oracle Cloud Infrastructure technology, so
maybe I am talking about something you already know. But anyway I
prefer to share this case: it can help if you encounter the same
problem as me. Let’s take the risk to have too much information
rather than nothing!
The problem
I was doing some tests on the new MySQL Database
Service and during the setup I decided to generate my ssh
keys via the OCI console:
When I tried to connect via PuTTY or MobaXterm to my compute instance using the opc account and my private key (generated previously), I got the …
[Read more]
On a previous blog post, we saw how to create an account on
the Oracle
OCI using the Oracle Cloud Free Tier offer and then how to
instal MySQL Server on the Compute instance.
Some weeks later, the new MySQL Database Service (MDS) was out and I can
show you now how to install and configure it.
We are talking about the MySQL 8.0 Enterprise Edition on the on Oracle
Generation 2 Cloud Infrastructure. For the moment it’s only
available on some of the data regions (Frankfurt and London for
the EMEA zone), but normally others will be activated …
On a previous blog post, we saw how to create an account on
the Oracle
OCI using the Oracle Cloud Free Tier offer and then how to
instal MySQL Server on the Compute instance.
Some weeks later, the new MySQL Database Service (MDS) was out and I can
show you now how to install and configure it.
We are talking about the MySQL 8.0 Enterprise Edition on the on Oracle
Generation 2 Cloud Infrastructure. For the moment it’s only
available on some of the data regions (Frankfurt and London for
the EMEA zone), but normally others will be …
Django is a popular framework for Python application developers. It includes packages which make tasks like authorization and content administration easier. Django supports a number of databases including MySQL which makes it possible to run a Django application over Vitess without having to change the application code. Let’s take a look at how to combine the strengths of these two open source frameworks. We built this example using Vitess operator. You can see the details of the implementation in the blog post Vitess Operator for Kubernetes.
Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular post from the past. Today’s post was originally published on November 26, 2019.
It’s not uncommon these days for us to use a high availability stack for MySQL consisting of Orchestrator, Consul and ProxySQL. You can read more details about this stack by reading Matthias Crauwels’ blog post How to Autoscale ProxySQL in the Cloud as well as Ivan Groenwold’s post on MySQL High Availability With ProxySQL, Consul and Orchestrator. The high-level concept is simply that Orchestrator will monitor the state of the MySQL replication topology and report changes to Consul which in turn can update ProxySQL hosts using …
[Read more]Kubernetes operators are meant to simplify the deployment and management of applications. Our Percona Kubernetes Operator for Percona XtraDB Cluster serves the purpose, but also provides users the flexibility to fine-tune their MySQL and proxy services configuration.
The document Changing MySQL Options describes how to provide custom
my.cnf
configuration to the operator. But what would happen if you made a mistake and specified the wrong parameter in the configuration?
Apply Configuration
I already deployed my Percona XtraDB Cluster and deliberately submitted the wrong
my.cnf
configuration in
cr.yaml
:
spec:
...
pxc:
configuration: | …[Read more]
Kubernetes has been a big trend for a while now, particularly well-suited for microservices. Running your main databases on Kubernetes is probably NOT what you are looking for. However, there’s a niche market for them. My colleague Stephen Thorn did a great job explaining this in The Criticality of a Kubernetes Operator for Databases. If you are considering running your database on Kubernetes, have a look at it first. And, if after reading it you start wondering how the Operator works, Stephen also wrote an Introduction to Percona Kubernetes Operator for Percona XtraDB Cluster (PXC), which presents the Kubernetes architecture and how the Percona Operator simplifies the deployment of a …
[Read more]