MySQL offers a wide array of options to configure replication, but with all of those options, how can you be sure you are doing it right? Replication is the first step to providing a higher level of availability to your MySQL database. A well configured replication architecture can be the difference between your data being highly available, or your MySQL setup becoming a management nightmare. At PlanetScale, we support hundreds of thousands of database clusters, all using replication to provide high availability, so we have a little bit of experience in this arena! In this article, we’re going to explore some of the best practices when it comes to replication, both locally and across longer distances. Use an active/passive configuration When replicating with active/passive mode, one MySQL server acts as the source and all other servers are read-only replicas from that source. In this configuration, the replicas can be used to serve up read-only …
[Read more]Long-time WordPress and Vue.js software engineer Przemysław Hernik shares a fantastic developer interview with the OpenLampTech readers.
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.
Be sure you’re subscribed to the OpenLampTech newsletter so you …
[Read more]We’ve seen in previous articles what Transparent Read/Write Splitting is with MySQL 8.2 and how to use it with MySQL Connector/Python.
I love this new feature, but I was wondering if it was really worth it.
Will the application benefit from offloading reads to another node, and won’t using the MySQL Router and parsing the request slow down connections?
These are the kinds of questions I’d like to cover and answer in this article.
The environment
To perform the test, I use the following environment:
- Linux Kernel 5.15.0 – aarch64
- MySQL Community Server 8.2.0
- MySQL Router 8.2.0
- sysbench 1.1.0 using LuaJIT 2.1.0-beta3 …
Navigating the security landscape of cloud services can be complex, but AWS IAM provides a robust framework for secure access management. In this article, we'll explore what AWS Identity and Access Management (IAM) is and how it enhances security.
The post What Is AWS IAM? How to Connect to Amazon RDS Using IAM Database Authentication appeared first on Devart Blog.
After 12 consecutive years of MySQL presence at FOSDEM, the MySQL Devroom has been rejected of the 2024 edition. The MySQL & Friends Devroom has been always very popular, almost full for each sessions and maybe the room with the most received submissions. This is also the reason why since 2017, MySQL was proposing a […]
Register for the MySQL Belgian Days 2024, 2 days of exclusive MySQL content from engineers, customers and community.
EXPLAIN INTO The INTO clause for EXPLAIN introduced in MySQL 8.1 allows storing the output of an EXPLAIN query in a user variable, instead of returning it to the client. It is currently only supported for the JSON format, but that should be sufficient for most use cases. With the EXPLAIN output stored in a […]
MySQL NDB Cluster 8.3.0 introduces the use of TLS to secure the network protocols used inside MySQL NDB Cluster. NDB Cluster is a distributed database system that provides very high availability and real-time performance, and this important change makes it possible to deploy cluster nodes not just on trusted, private networks, but also on untrusted networks […]
In this article, we'll briefly review some advantages of SQL Azure, a Microsoft cloud-based SQL database service, and explore how to export and import data between Azure SQL and MySQL server using a universal ODBC driver for SQL Azure and a powerful MySQL tool - dbForge Studio for MySQL.
The post How to Import/Export MySQL Data to SQL Azure: Using ODBC Driver for Data Migration appeared first on Devart Blog.
52 + 52 = 104. A letter from Josh. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack.
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.
Maybe you have guessed already. Or used your incredible math skills and surmised that OpenLampTech issue #104 is a historic event for me and this newsletter.
Be sure and grab your free subscription to OpenLampTech so you don’t miss out on anything!
More ways I can help
- Need hosting for your …