(Luis Soares) The latest MySQL 8.0 release is out. That is MySQL 8.0.18. We have some new replication enhancements and some work done on replication internals in this release that we would like to highlight and celebrate with our users.
Tag: Open Source
Query Performance Optimization in MySQL
(Manoj Debnath) Experts know how to write performance efficient queries. Although experience ripens wisdom, there are certain things that one must understand at least to begin with.
AI-powered Search with spaCy — Part 3
In the previous articles of this series, you saw some examples of how you might use spaCy’s linguistic features to process user input, extracting the key word or key phrase from it to use then them for a search on the web. In. In the second part, you saw how to handle some complicated cases; for example, you looked at...
MySQL 8.0 Clone Plugin and its internal process.
(pon suresh pandian) MySQL 8 has recently released clone plugin which makes DBA’s task of rebuilding the DB servers more easy.
MySQL Cloud Backup and Restore Scenarios Using Microsoft Azure
(Paul Namuag) Backups are a very important part of your database operations, as your business must be secured when catastrophe strikes. When that time comes (and it will), your Recovery Point Objective (RPO) and Recovery Time Objective (RTO) should be predefined, as this is how fast you can recover
MySQL Parallel Index Range Scans: One is Sometimes Better Than Two
(Øystein Grøvlen) As presented at the Percona Live Conference in Austin in May, at Alibaba we are working on adding support for parallel query execution to POLARDB for MySQL.
Using MySQL Galera Cluster Replication to Create a Geo-Distributed Cluster: Part Two
(Krzysztof Ksiazek) In the previous blog in the series we discussed the pros and cons of using Galera Cluster to create geo-distributed cluster.
How to integrate ProxySQL in MySQL InnoDB Cluster
(Frederic Descamps) MySQL InnoDB Cluster is the most easy and integrated High Availability solution for MySQL.
MySQL InnoDB Cluster Network Reliability Parameters
(Ivan Ma) MySQL InnoDB Cluster is easy to configure and deploy. This article is written to provide 3 group replication parameter settings which may contribute to the stability and reliability of the Network in MySQL InnoDB Cluster.
Using MySQL Galera Cluster Replication to Create a Geo-Distributed Cluster: Part One
(Krzysztof Ksiazek) It is quite common to see databases distributed across multiple geographical locations. One scenario for doing this type of setup is for disaster recovery, where your standby data center is located in a separate location than your main datacenter.