(Dave Stokes) JSON_TABLE is one of the more complex functions that arrived in MySQL 8. It takes schemaless JSON data and turns it into a relational table. So your NoSQL data becomes SQL data and you can use good ol’ SQL where clauses on that temporary relational table!
Tag: Open Source
Exploring Oracle’s MySQL Cloud Service
(Rob Gravelle) As the maker of the world’s most popular open source database, Oracle is ideally positioned to deliver a MySQL Cloud Service.
30 mins with MySQL JSON functions
(Olivier DASINI) JSON (JavaScript Object Notation) is a popular way for moving data between various systems, including databases.
MySQL InnoDB Cluster: is the router a single point of failure ?
(Frederic Descamps) As you know, MySQL InnoDB Cluster is composed of 3 elements:
De-Normalization of Your Database with JSON
(Dave Stokes) One of the humbling things about working at Oracle with the various MySQL personnel is that you are often blown away by something one of them says or does. And that is on a regular basis.
InnoDB Cluster in a Nutshell Part 3: MySQL Shell
(Francisco Bordenave) Welcome to the third part of this series. I’m glad you’re still reading, as hopefully this means you find this subject interesting at least.
Controlling Replication Failover for MySQL and MariaDB with Pre- or Post-Failover Scripts
(Krzysztof Ksiazek) In a previous post, we discussed how you can take control of the failover process in ClusterControl by utilizing whitelists and blacklists. In this post, we are going to discuss a similar concept.
Cool new features in FromDual Backup and Recovery Manager 2.0.0
(Shinguz) A while ago we released our FromDual Backup and Recovery Manager (brman) 2.0.0 for MariaDB and MySQL. So what are the new cool features of this new release?
A small dive into the MySQL 8.0 X-DevAPI
(Gabriela D’Ávila Ferrara) What is the X-DevApi? From insidemysql.com there is a definition of the X-DevAPI and its features in the following paragraphs:
Protecting your data – Part II: Preventing unwanted data changes on Group Replication members by asynchronous replication channels
(Hemant Dangi) Further to our earlier blog post about Fail-safe enhancements to Group Replication, where we discussed enhancements against data modification in members which are not ONLINE, we now present here additional changes to protect data from being accidentally modified by asynchronous replic