I thought I’d share a quick addition to the MySQL Router bootstrap command and hope it helps others, as always.

First of all, you all know the MySQL Router documentation, and have probably looked into a specific option when executing commands, but I’ve found one quite handy that allows me to add in certain parametrization for my routers: –conf-set-option

It’s simple to use, so I’ll just share what I used as a reference and let you play away.

mysqlrouter --bootstrap icadmin:'MyP4ssword!'@node01:3306 \
--name="router_node1" --account=routerAdmin \
--conf-base-port=3306 --report-host=rtnode01 --conf-use-gr-notifications \ …

Hytera Communications Corporation Limited is a global leader in providing innovative communications technologies and solutions. Specializing in voice, video, and data capabilities, Hytera helps businesses and mission-critical users stay connected quickly, securely, and reliably. Their solutions are designed to meet the demands of both daily operations and emergency response, making the world a safer and […]

Modern cloud databases need to offer flexibility in workload management, security and cross-region availability. To address these evolving demands, we have introduced new capabilities in HeatWave MySQL that improves operational efficiency and enables even more sophisticated deployment patterns. Key enhancements include: DB System Read Endpoint The new DB System Read Endpoint enhances read scalability by […]

Modern cloud databases need to offer flexibility in workload management, security and cross-region availability. To address these evolving demands, we have introduced new capabilities in HeatWave MySQL that improves operational efficiency and enables even more sophisticated deployment patterns.

This blog is the first of a two-part series that guides you through setting up and managing on-premises (External) MySQL DB systems in OCI, ensuring optimal performance and operational insights. In this part, we will cover the prerequisite steps before registering and managing External MySQL DB systems. To use Database Management features for External MySQL, […]

Take a look at the most convenient and user-friendly MySQL GUI tools (clients) that help you tackle a variety of database development, management, and administration tasks on macOS.

The post 16 Best MySQL GUI Clients for macOS appeared first on Devart Blog.

This post was originally published in June 2020 and was updated in February 2025. While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over […]

The Oracle HeatWave MySQL service offers users the flexibility to modify DB system shapes and configuration, enabling them to adapt to changing workloads and enhance performance.

In this blog post we'll share insights into the latest changes related to DB system shape and configuration changes, mostly focusing on the high availability and read replicas support.

OCI Database Management and OCI Ops Insights services deliver advanced capabilities to simplify the monitoring of External MySQL databases, offer detailed granular insights, and reduce the burden of managing infrastructure resources. Additionally, as a cloud-native, managed solution, these services eliminate the need to maintain the monitoring solution itself.

Explore how to connect it to a Linux-based MySQL server and read table data directly within SSMS with the help of ODBC driver.

The post How to Configure a SQL Server Linked Server to Connect to MySQL appeared first on Devart Blog.