At my FOSDEM talk earlier this year, I gave a trick for fixing a crashed GTID replica. I never blogged about this, so now is a good time. What is pushing me to write on this today is my talk at MinervaDB Athena 2020 this Friday. At this conference, I will present more details about MySQL replication crash safety. So you know what to do if you want to learn more about
Dec
06
2020
Dec
03
2020
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]
Dec
03
2020
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]
Dec
01
2020
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]
Dec
01
2020
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]
Nov
30
2020
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 …
Nov
30
2020
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 …
Nov
30
2020
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.
Nov
24
2020
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]
Nov
23
2020
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]