This interview of two members of the MySQL Community Team, Scott Stroz and Frédéric Descamps (AKA lefred) was previously published on odbms.org. Q: Can you tell us a little about your background? Fred: I’ve worked in the Open-Source world for over 20 years. First, as a Linux developer and consultant. Then, I opted for the […]
Dec
18
2023
Dec
18
2023
The Oracle ACE Program is a community advocacy program that recognizes and rewards individuals for their expertise, leadership, and contributions to Oracle technologies. Within this program, there exists a specialized category for the MySQL experts and contributors. To become recognized as an Oracle ACE for MySQL, individuals must demonstrate a deep comprehension of MySQL, make […]
Dec
16
2023
Since the release of MySQL 8.0, the MySQL X Dev API has provided users with the convenient ability to utilize MySQL without the need to write a single line of SQL ! MySQL X Dev API brings the support for CRUD operations on JSON documents that are stored in MySQL. MySQL Document Store is ACID […]
Dec
16
2023
Since the release of MySQL 8.0, the MySQL X Dev API has provided users with the convenient ability to utilize MySQL without the need to write a single line of SQL!
MySQL X Dev API brings the support for CRUD operations on JSON documents that are stored in MySQL. MySQL Document Store is ACID compliant and is compatible with everything MySQL like replication, InnoDB Cluster, …
The MySQL X Dev API is available using the MySQL X Protocol, listening by default on port 33060.
If you are interested in learning more about MySQL Document Store, please refer to the these presentations [1], [2], [ …
[Read more]
Dec
13
2023
Error logging is a critical aspect of database administration, providing insights into issues, warnings, and errors that may affect the system’s stability and performance. MySQL 8 introduces Error Log Filtering as a mechanism to fine-tune the error log, allowing administrators to focus on the most critical issues. By assigning priorities to different error types, administrators […]
Dec
13
2023
Long-time web developer Christian Olear shares an insightful developer interview with the OpenLampTech newsletter readers.
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.
Spanning two-plus decades, Christian Olear has programmed using Laravel, the Zend framework, and Symfony to name just a few, in addition to vanilla PHP.
Head on over and grab your free subscription to OpenLampTech to read this developer interview and more.
Thank you for reading this post. Please share it with someone else …
[Read more]
Dec
13
2023
Some time ago, we saw how we could deploy WordPress on OCI using MySQL HeatWave Database Service with Read Replicas. We had to modify WordPress to use a specific plugin that configures the Read/Write Splitting on the application (WordPress): LudicrousDB.
Today, we will not modify WordPress to split the Read and Write operations, but we will use MySQL Router 8.2.0 (see [1], [2], [3]).
Architecture
The …
[Read more]
Dec
12
2023
Some time ago, we saw how we could deploy WordPress on OCI using MySQL HeatWave Database Service with Read Replicas. We had to modify WordPress to use a specific plugin that configures the Read/Write Splitting on the application (WordPress): LudicrousDB. Today, we will not modify WordPress to split the Read and Write operations, but we […]
Dec
12
2023
In Percona Managed Services, we manage Percona for MySQL, Community MySQL, and MariaDB. Sometimes, the replica server might have replication errors, and the replica might be out of sync with the primary. In this case, we can use Percona Toolkit’s pt-table-checksum and pt-table-sync to check the data drift between primary and replica servers and make […]
Dec
11
2023
In a recent podcast on Mastering EOL Migrations: Lessons learned from MySQL 5.7 to 8.0 I discuss with my colleague Adam North not only the technical issues that become a major migration but also key business and management requirements with having a well-articulated strategy that covers:
- Planning
- Testing
- Be Prepared
- Proactiveness
Having a plan is key to any significant task including data migrations. You should heed the warnings and the deprecations and consider all potential downstream product impacts such as connector upgrades. The plan includes a timeline but also needs to define all the stakeholders both technical and business, the definition of a successful migration, and most importantly the decision tree for a non-successful migration that would …
[Read more]