Category Archives: Uncategorized

Improving Security and Compliance with MySQL Enterprise Edition online event

IT Security has a lot to do with reducing the exposure of the system, controlling the risk and minimizing the attackers options.

Assess, Prevent, Detect and Recover: MySQL Enterprise Security can help you fulfill all of your security needs. Whether it’s meeting with Compliancy and the applicable Regulations, attending specifics like Data Encryption or SQL Injection or quite simply securing your data, there are many options. Continue reading

Posted in Uncategorized | Leave a comment

MySQL InnoDB Cluster Disaster Recovery contingency via a Group Replication Replica

Just recently, I have been asked to look into what a Disaster Recovery site for InnoDB Cluster would look like.
If you’re reading this, then I assume you’re familiar with what MySQL InnoDB Cluster is, and how it is configured, components, etc. Continue reading

Posted in clone, InnoDB, innodb cluster, MySQL, MySQL 8, MySQL Enterprise Edition, MySQL Enterprise Monitor, Oracle, Replication, Uncategorized | Tagged , , , , , , , , | Leave a comment

MySQL Webcasts On Demand en Español & English

Por si no se hubiera visto o promocionado lo suficiente, quería compartir la lista de webcasts en Español que ya hay disponible en On Demand webinars en el apartado de News & Events en mysql.com: https://www.mysql.com/news-and-events/on-demand-webinars/#es-20-0 Sobre 1 hora de … Continue reading

Posted in Uncategorized | Tagged , , , , , , , | Leave a comment

InnoDB Cluster: Recovering an instance with MySQL Enterprise Backup.

Ok, so if you’re reading this, then I can guess you’ve got a MySQL InnoDB Cluster in an awkard shape, i.e. you need to restore a backup and add the instance back into the cluster, so we have all our instances again. Continue reading

Posted in Backup, innodb cluster, MEB, MySQL 8, MySQL Enterprise Backup, MySQL Enterprise Edition, Oracle Linux, Recovery, Replication, Uncategorized | Tagged , , , , , , , , , | Leave a comment

MySQL TDE: Online key store migration

So, if we’re applying GDPR to our system, and we’re already making use of MySQL Transparent Data Encryption / keyring, then here’s an example on how to migrate from filed-based keyring to the encrypted keyring. Online. Continue reading

Posted in Backup, GDPR, MEB, MySQL, MySQL 8, MySQL Enterprise Backup, MySQL Enterprise Edition, Oracle, TDE, Uncategorized | Tagged , , , , , , | Leave a comment

Upgrading MySQL to 8.0.12 with Audit plugin.

As a spin-off from the previous post, https://mysqlmed.wordpress.com/2018/08/23/get-the-auditors-in/, I thought that it would be good to see how well the Audit plugin upgrades to MySQL 8. The big change in auditing is that the tables change from MyISAM to InnoDB, … Continue reading

Posted in audit, InnoDB, MySQL, MySQL Enterprise Edition, Oracle, Uncategorized, upgrade | Tagged , , , , , , | 1 Comment

Get the Auditors in: MySQL Enterprise Audit.

Here I have been looking into using the MySQL Enterprise Edition Audit Log plugin for 5.7. We have many options to audit (filters, encryption, compression, Workbench, rotation & purging, viewing the log, etc.)…. Continue reading

Posted in InnoDB, MySQL, MySQL Enterprise Edition, Oracle, Uncategorized, upgrade | Tagged , , , , , , | 4 Comments

Going to Oracle MySQL Cloud via Enterprise Backup.

First of all, if you want a guide on how to deploy MySQL in Oracle Cloud, then the best place to start is here. So, what are we going to do here? Create an Oracle Storage container to keep our … Continue reading

Posted in Uncategorized | 2 Comments

MySQL Cluster in Docker: quick step by step

I just wanted to share the ‘how to’ in getting to know MySQL Cluster a bit more, via Docker, as mentioned in the docker store install guide: https://store.docker.com/community/images/mysql/mysql-cluster. all I’m doing here is replicating what’s mentioned there. Hopefully someone might … Continue reading

Posted in Uncategorized | Leave a comment

Taming a ‘wild’ NDB 7.3 with Cluster Manager 1.4.3 & direct upgrade to 7.5.

Well, since working with outdated clusters and upgrade paths that quickly become obsolete, as in my last post, Migrating/importing NDB to Cluster Manager w/ version upgrade. , I wanted to share that we can also use Cluster Manager… Continue reading

Posted in CGE, Cluster 7.3, Cluster Manager, libnuma.so.1, MySQL, MySQL Cluster, numactl, Oracle, Uncategorized, upgrade | Tagged , , , , , , , , | Leave a comment