We are happy to announce our attendance at following conferences by end of May 2023 which should not be missed. Please find our MySQL team at three physical shows and one virtual one as follows: DOAG-DB, May 24- 25, 2023, Dusseldorf, Germany Find MySQL & Oracle at the Oracle booth at the DOAG-DB as well […]
Community journal
Follow the feed
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Showing entries 1876 to 1885 of 45354
« Previous |
Next »
May
16
2023
At the end of 2021, I pushed the first Docker image to hub.docker.com. This was the first official image and since then, we have been improving our testing and packaging procedures based on Docker, CircleCI, and GitHub Actions. However, when I’m coding, I’m not testing in Docker. But a couple of weeks ago, when I was reviewing an issue, I realized some interesting Docker use cases that I want to share.
Common use case
First, we are going to review how to take a simple backup with MyDumper to warm you up:
docker run --name mydumper
--rm
-v ${backups}:/backups
mydumper/mydumper:v0.14.4-7
sh -c "rm -rf /backups/data;
mydumper -h 172.17.0.5
-o /backups/data
-B test
-v 3
-r 1000
-L /backups/mydumper.log"
You will find the backup …
[Read more]PL, DOAG-DB & OSC Nagoya 2023
Historically MySQL is great in horizontal READ scale. The scaling, in that case, is offered by the different number of Replica nodes, no matter if using standard asynchronous replication or synchronous replication.
However, those solutions do not offer the same level of scaling for writes operation.
Why? Because the solutions still rely on writing in one single node that works as Primary. Also, in the case of multi-Primary, the writes will be distributed by transaction. In both cases, when using virtually-synchronous replication, the process will require certification from each node and local (by node) write; as such, the number of writes is NOT distributed across multiple nodes but duplicated.
The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS …
[Read more]
May
15
2023
I can’t express how grateful I am that you are here reading OpenLampTech each week. But, I’ll try anyway. Thank you! On to this week’s excellent content
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.
OpenLampTech issue #78 has content featuring:
- MySQL backup tools you might not have heard of …
Discover how to troubleshoot a MySQL replica IO thread stuck in a connecting state. Learn about the replication architecture, security group rules for AWS EC2 instances, and how to address common issues like network restrictions and bind address configuration.
MySQL is a powerful database management and a widely used cloud database service. One of its key features is the ability to create replicas of a master database to improve its availability and scalability. However, at times the IO thread in a MySQL replica may get stuck in a connecting state, which can cause replication issues and affect the overall data consistency …
[Read more]
May
12
2023
Amazon claims that Aurora has “Up to 5X the throughput of MySQL”. Is it true? It wasn’t easy to find the truth, but I kept digging until I found it. This is a long read; let’s chase the rabbit all the way down the hole.
May
12
2023
Amazon claims that Aurora has “Up to 5X the throughput of MySQL”. Is it true? It wasn’t easy to find the truth, but I kept digging until I found it. This is a long read; let’s chase the rabbit all the way down the hole.
May
12
2023
Amazon claims that Aurora has “Up to 5X the throughput of MySQL”. Is it true? It wasn’t easy to find the truth, but I kept digging until I found it. This is a long read; let’s chase the rabbit all the way down the hole.
May
12
2023
We see an increase in the demand for database migration from MariaDB to MySQL. This is likely due to recent news about MariaDB. [1][2][3][4][5][6][7][8] In this article, we will show you how to migrate from MariaDB to MySQL HeatWave in Oracle Cloud Infrastructure (OCI). If you plan to migrate from MariaDB to MySQL on-premise, please […]