In MySQL 8.2, a significant enhancement has been introduced to MySQL Router. This improvement enables MySQL Router to intelligently differentiate between read and write queries and efficiently route them based on their nature.

MySQL Server 8.2.0, 8.0.35 and 5.7.44 are now available for download.  These are the latest General Availability (GA) releases as of October 24, 2023.

Welcome to this amazing SQL programming test that will help anyone deeply interested in working with databases. This test will help you assess your strengths and find gaps in your SQL skills. Ultimately, you’ll know which part of the SQL you should focus on. Test Your SQL Programming Skills Before you delve into the questions […]

Source

Have you heard about MySQL replication but aren’t sure exactly why you should care? Having multiple servers for any workload is typically considered best practice. After all, a workload split across multiple servers helps balance out the performance of any application. When it comes to working with your database, though, the benefits may not be as clear. In this article, you’ll learn about five real-world use cases for implementing MySQL replication. What is MySQL replication? Before we get into its use cases, let us briefly describe what MySQL replication is. MySQL replication is a process that is used to keep multiple MySQL servers in sync. When you first set up a MySQL environment, it is typically with a single server to run your databases. One approach to scaling your database environment is to configure additional servers to contain copies of your database (replicas) that match the primary MySQL server (source). As data is updated, written …

As we already announced on Aug 15, below you can find the updated list of conferences and MySQL events where you can meet our team in November 2023. Find even more MySQL Events at MySQL.com!

MySQL in Nov23

Hi community,

I’m searching for developers interested in participating in text-based interviews for the OpenLampTech developer newsletter.

This consists of a round of 10 (or so) questions you would write responses to which I would publish in the newsletter as content.

You can promote your own products, services, and/or content links.

I’ve published many of these developer interviews so far (over the last year and a half) to the several hundred plus subscribers and I feel like the readers really enjoy learning about other developers. I know I learn a lot myself and enjoy these interviews.

It’s free to participate.

If you’re interested, email me at openlamptech@substack(dot)com with OpenLampTech Newsletter Interview – Your_Name_Here in the subject line.

Visit the newsletter archives at …

MySQL HeatWave is the only fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. MySQL HeatWave also includes MySQL HeatWave Lakehouse, allowing users to query data stored in object storage, MySQL databases, or a combination of both. Users can deploy MySQL HeatWave–powered apps on a choice of public clouds: […]

According to Fortune Business Insights, the global Software as a Service (SaaS) market is projected to grow from $273.55 billion in 2023 to $908.21 billion by 2030, at a CAGR of 18.7%. The COVID-19 pandemic accelerated the demand for cloud-based solutions, which allowed businesses to keep serving their customers and enabled remote working. For ISVs […]

For ISVs delivering SaaS applications, selecting the right cloud platform is crucial as it represents the foundation their applications are built on, and has a large impact on how well they can serve their customers. Let’s consider why four ISVs migrated to MySQL HeatWave, and the results they achieved.