Category: Router
How to deploy a MySQL Database Service Instance with PHPMyAdmin
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 … Read More
Testing MySQL Database Service without VPN
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:
From MySQL Group Replication to MySQL InnoDB Cluster
I wanted to be brave and I installed MySQL Group Replication manually…. it was painful ! Then I realized that managing those servers and especially deal with MySQL Routers was even more painful ! What are my options now ? Is there a solution or do I need to restart from scratch ? Asking the answer is already answering it… … Read More
MySQL 8.0 InnoDB Cluster with WordPress in OCI – part III
With this post we are reaching the end of our journey to HA for WordPress & MySQL 8.0 on OCI. If you have not read the two previous articles, this is just the right time. MySQL 8.0 InnoDB ReplicaSet with WordPress in OCI MySQL 8.0 InnoDB ReplicaSet with WordPress in OCI – part II We started this trip using the … Read More
MySQL 8.0 InnoDB ReplicaSet with WordPress in OCI – part II
This article is the second part of our journey to WordPress and MySQL 8.0 High Availability on OCI. The first part can be read here. We ended part I with one webserver hosting WordPress. This WordPress was connecting locally to MySQL Router using HyperDB add-on. This add-on allows to split the reads & writes on MySQL Servers using replication. And … Read More
comments