The availability of MySQL HeatWave on Amazon Web Services (AWS) was announced on Monday, September 12, extending Oracle’s commitment to multi-cloud access. Many industry experts applaud this new platform support for MySQL HeatWave -- some of their quotes are included here.
Sep
15
2022
Sep
15
2022
Galera Load Balancer (GLB) is a scalable and performant, yet easy to use TCP/IP connection balancing proxy. It is the oldest, yet actively maintained load balancer in the MySQL ecosystem, with a wide array of customers using it in production.
Firstly, please request for binaries via contacting sales@galeracluster.com. Once you have access to the package repository, you’ll have access to RPMs. Installing the RPMs are straightforward, and you can also add it to your Yum repository. This blog presumes you already have access to the binaries.
You can start it up, really simply:
glbd --threads 6 127.0.0.1:3306 188.166.179.177:3306 165.22.50.152:3306 165.22.49.92:3306
…[Read more]
Sep
14
2022
Two weeks ago I was being drawn into the debug of artdb, the Replication hierarchy used by our Artifactory instance.
Artifactory overloaded the database. This was incident-handled by optimizing a number of slow queries using some covering index trickery, and by upgrading the hardware substantially.
Using the runway we bought, we found and partially fixed the following problems:
- Fixed: A number of very expensive reporting queries were sped up 16x to 20x using covering indexes, from 180s runtime to 8s-12s runtime.
- Fixed: We optimized our database and data size by completing the data lifecycle for several repo types, deleting old images.
- Fixed: Hardware upgrade lowered load even more, and sped up the queries even more.
- Fixed: …
Sep
14
2022
The INFORMATION_SCHEMA database is full of information and metadata about your database(s). Columns are a necessity and their definition ensures sound storage and data integrity. Learn all about them with the COLUMNS table.
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.
Image by Gerd Altmann from …
[Read more]
Sep
13
2022
As a Database Engineer, One of the biggest challenges in day-to-day activity is performing DDL on high-traffic and transaction-intensive tables. It will become overhead when handling a large number of servers/shards.
As a standard process, we will first deploy the changes in DEV and QA before deploying them in production.
In the sharded environment, It will become a heavy overhead to maintain the schema changes in DEV, QA, and PROD servers. Since we will have multiple servers in the sharding.
To overcome this deployment supervision, the Skeema tool will help to deploy the changes in QA, DEV, and PROD in a safe and parallel ( for Shards ) as well.
This blog focuses on the basic operation of Skeema, will have a series of blogs on Skeema
[Read more]
Sep
13
2022
MySQL HeatWave ML supports various scoring metrics. User needs to keep in mind the characteristics of these metrics, to use them effectively.
Sep
12
2022
This architecture is fine for development, but is somewhat lacking for production: There is no way to scale out the application tier or database tier to meet increasing load. The application server and database can only be scaled up by adding resource. Both the application server and database are single points of failure (SPOF). Further, there is no way maintenance can be performed on either the application server or database without affecting availability.
Sep
12
2022
This is one of the exciting troubleshooting related to XA transactions let’s dive in. Let me provide a few backgrounds.
For one of our clients, when we try to drop a table, it is waiting for metadata lock. On debugging it is one of the XA transactions is holding the shared write lock and causing metadata lock on all the other local transactions.
Let us view the metadata locks from the Performance Schema.
mysql> select OBJECT_TYPE,OBJECT_SCHEMA,OBJECT_NAME,
LOCK_TYPE,LOCK_STATUS,SOURCE from
performance_schema.metadata_locks\G |
Sep
12
2022
I can’t thank you all enough for making OpenLampTech a successful endeavor for me. We are continuing to publish great newsletters that get read and draw in new subscribers. This week’s issue is loaded with great content so enjoy those articles you like most. Please share with others…
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 #43 we have content on:
- The PHP Constructor
- WordPress needs writing
- MySQL Window Functions
- Managing 1,300 WordPress sites
- A list of great free …
Sep
12
2022
Introduction # MySQL group replication is a new replication mechanism that was released in 2016. Group replication involves establishing a group of nodes that are coordinated automatically via Group Communication System (GCS) protocols, an implementation of Paxos. For a transaction to commit, a majority of the group has to agree on the order of a given transaction in the global sequence of transactions. Deciding to commit or abort a transaction is done by each server individually, but all servers make the same decision.