My students wanted an illustration of where MySQL Workbench fits within the MySQL database. So, I overlaid it in this drawing from my old book on comparative SQL syntax for Oracle and MySQL. Anybody else have a cool alternative illustration?
The idea is the lightening bolt transmits an interactive call and reading a script file submits a call paradigm.
As always, I hope this helps those looking to understand things.
Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.42 (release notes, download) and MySQL-wsrep 8.0.33 (release notes, download), with Galera replication library 4.15 (release notes, download) implementing wsrep API version …
[Read more]Yesterday, I published an article explaining how to easily deploy Apache Superset on OCI using MySQL HeatWave Database Service.
There are some people not using the automation or not using MySQL HeatWave Database Service on OCI but want to still use Superset with MySQL 8.0.
In this blog, we will see how to fix eventual errors when performing the installation manually.
SQL Alchemy Dialect Configuration
When using MySQL 8.0, in Superset’s config file, you need to specify the SQLAlchemy URI like this:
SQLALCHEMY_DATABASE_URI = 'mysql+mysqlconnector://<user>:<password>@<host>:<port>/<superset_schema>'
It is important to specify the database backend and dialect:
mysql+mysqlconnector.
Of course you need to install the MySQL …
[Read more]Here’s a quick catalog for my students of PowerShell, JavaScript, and Python examples connecting to MySQL:
We already saw how to deploy Apache Superset with MySQL HeatWave.
I just released a new version of the Terraform modules including some configuration parameters for a future development related to High Availability.
So let’s see the easiest way to deploy Superset on OCI using MySQL HeatWave.
Quick Deployment
The default deployment is the following:
The fastest and easiest way to deploy such architecture is to click on the button below:
When you click on the button, you will reach the following screen if you are …
[Read more]How to deploy Apache Superset with MySQL HeatWave and how to benefit from HeatWave's query accelerator.
One of the hidden gems in the MySQL documentation is this note in section 8.3.6: As an alternative to a composite index, you can introduce a column that is “hashed” based on information from other columns. If this column is short, reasonably unique, and indexed, it might be faster than a “wide” index on many columns. We will build on this idea by creating generated hash columns for indexed lookups on large values and enforcing uniqueness across many columns. Instead of creating huge composite indexes, we'll index the compact generated hashes for fast lookups. Before diving into generated hash columns, let's look at generated columns in general. Generated columns in MySQL A generated column can be considered a calculated, computed, or derived column. It is a column whose value results from an expression rather than direct data input. The expression can contain literal values, built-in functions, or references to other columns. The result of …
[Read more]Creating generated hash columns in MySQL for faster strict equality lookups.
Learn how Multi-Valued Indexing in MySQL 8.0 can enhance query performance by efficiently indexing and querying JSON arrays. Discover the benefits, implementation steps, and considerations for optimizing your MySQL database.
Thanks so much for reading OpenLampTech. Here is this week’s newsletter, full of great content all about PHP, MySQL, and the LAMP stack. Several WordPress and WooCommerce reads too.
Custom WooCommerce and Shopify Solutions
Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
In OpenLampTech issue #82, we have articles covering:
