www.bortolotto.eu

Newsfeeds
Planet MySQL
Planet MySQL - https://planet.mysql.com

  • Some MySQL Router 8.4.3 read-write splitting quips
    So, as you’ve noticed, I’ve been playing around with MySQL Router v8.4.3 and read-write splitting, and now I’ve come across some issues that my environment has generated and I’ve opened some bugs against the fiend: Bug 116950 – Router Read-Write splitting config causes PHP RSET_HEADER error Bug 116951 – mysqlrouter Error parsing stats_updates_frequency errors Bug 116952 – Router w/ RW split causes ERROR: 4501 if sql script contains comments lines (“– “) (Yup, I prepared each bug description, repeatable tasks and suggested fix beforehand, hence the numbers are consecutive) Some comments here: Bug 116950: I suspect that this is up to the application to buffer queries and use PDO::MYSQL_ATTR_USE_BUFFERED_QUERY but seeing as it was working fine without RW splitting, it would be nice for it to work with it. Hey-ho and, after all, Christmas is coming.. Bug 116951: This isn’t fair and I suspect it will be corrected in the next version. I bootstrap my router as always and now I have to specify a stats_updates_frequency value as the default generates tons of errors? That’s just not cricket is it? Correctable with: clusterset.setRoutingOption('web01::router01', 'stats_updates_frequency', 1) Bug 116952: This surprised me here. I was loading a mysqldump file and did so in all ways possible but they all errored via the RW split port with ERROR: 4501 (HY000) at line 2: Statement not allowed if access_mode is ‘auto’. Works fine on normal ports. And after stripping the dump file down to the bare minimum it has nothing to with the dumpfile itself. Check it out: vi /tmp/kh.sqlselect "1";-- Nothingselect "2" mysqlsh --login-path=admin -hweb01 --show-warnings=true --sql -D keith -A -e "source /tmp/kh.sql" 11Statement ID: 1300185ERROR: 4501 (HY000) at line 2: Statement not allowed if access_mode is 'auto' The Router RW split port doesn’t like ” – – ” (double dashed) comments in your scripts! So, in my scenario, it’s easily fixable by running my mysqldump with –compact and that gets ride of all of these comments and gives a router-rw-split-port-digestable file to run. <phew> But.. ¿really? Not even comments? C’mon Router.. at this stage of the game? Let’s see if the bugs get some work on them.

  • MySQL Shorts Revisited - Working with JSON
    For the 11th day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on making working with JSON easier.

  • America First Credit Union: Streamlining Member Onboarding with MySQL Enterprise Edition
    This blog covers how America First Credit Union adoption of MySQL Enterprise Edition has transformed its membership onboarding process, reducing complexity, improving system performance, and boosting member satisfaction.

  • Simplifying AI Development: A Practical Guide to HeatWave GenAI’s RAG & Vector Store Features
    This tutorial explores HeatWave GenAI, a cloud service that simplifies interacting with unstructured data using natural language. It combines large language models, vector stores, and SQL queries to enable tasks like content generation, chatbot, and retrieval-augmented generation (RAG). The focus is on RAG and how HeatWave GenAI’s architecture helps users gain insights from their data. The post Simplifying AI Development: A Practical Guide to HeatWave GenAI’s RAG & Vector Store Features first appeared on dasini.net - Diary of a MySQL expert.

  • MySQL Shorts Revisited - Functions Galore
    For the ninth day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on internal MySQL functions.