Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Howto connect to MySQL using a client certificate
More and more people are requesting how they could connect to MySQL without using a password but using a SSL certificate. Known as X509. CA Certificate A CA certificate is a digital certificate issued by a certificate authority (CA). It’s used by clients to verify the SSL certificates sign by this CA. Such certificates is […]
MySQL HeatWave for AWS
Introduction MySQL HeatWave is the only MySQL based service that combines transaction processing, real-time analytics, and machine learning within one single database. MySQL HeatWave eliminates the need for complex, time-consuming ETL operations between separate databases and tools for OLTP, analytics, and machine learning use cases. Customers avoid the latency and security risks of data movement […]
Read replicas on MySQL Database Service
Introduction A read replica is a read-only copy of a DB system within the same region as the DB system. Read replicas provide you read scalability and you can offload all read-heavy workloads to the read replicas. Read replicas have the same shape and configuration as the associated DB system, and can exist only within […]
MySQL Enterprise Security 4 New Authentication Methods
Introduction Data is an organization’s most valuable asset. And for the CISO (Chief Information Security Officers), protecting that data is their primary concern and responsibility. MySQL Enterprise Edition provides powerful security capabilities for: • Increased protection against database attackers • Regulatory Compliance (GDPR, PCI, HIPAA, etc.) • Simplified and improved user authentication • Lower […]
Intersect and Except in MySQL 8.0
With the latest MySQL release (8.0.31), MySQL adds support for the SQL standard INTERSECT and EXCEPT table operators: Let’s have a look how to use them. We will use the following table: CREATE TABLE `new` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, `tacos` int DEFAULT NULL, `sushis` int DEFAULT NULL, PRIMARY […]
Achieve Real-Time Marketing Analytics with MySQL HeatWave
Whether we’re talking about music, movies, or other digital services, real-time access has become an expectation for most of us, something we take for granted, and we easily get irritated when that expectation can’t be fulfilled. Yet, real-time analysis of marketing/advertising campaign performance is far from being a given for too many marketers. While they […]
Hello TypeScript
tl;dr In retrospect, it was inevitable. Formal support for TypeScript applications has landed in Connector/Node.js. Type definitions for the entire public API are now available to ensure developers are able to leverage some goodies unlocked by traditional statically-typed languages such as autocompletion, integrated refactoring, visual type-related hints and compile-time errors. How to TypeScript? TypeScript is a […]
MySQL Connector/J has new Maven Coordinates
For a very long time MySQL Connector/J has been published under the Maven coordinates group ID ‘mysql’ and artifact ID ‘mysql-connector-java’. Neither was fully compliant or been officially ratified. While a group ID mysql was originally possible, nowadays it would be very difficult to obtain approval to use a single word group ID. Those who […]
Indexing Data in MySQL Document Store
MySQL Document Store is a JSON document storage solution built on top of MySQL. One feature of MySQL Document Store that can help speed up searches is the ability to create indexes of data contained within our JSON documents. In this post, we will demonstrate creating an index and look at the changes made to […]
Importing a MongoDB Into MySQL Document Store with MySQL Shell
MySQL Document Store is a “NoSQL” database built on top of MySQL. The X Dev API provides basic CRUD operations that allow developers to manage JSON document collections. In this post, we will talk about how we can import an existing MongoDB into MySQL Document Store using MySQL Shell. Before We Get Started To follow along with the examples, you […]