Category: MySQL & MariaDB

Feed: Planet MySQL; Author: Keith Larson; So when it comes to routing your MySQL traffic several options exist.HAproxy MariaDB MaxScale NGINX MySQL Router ProxySQL You can even still get MySQL Proxy if you wanted it but it is EOF.  Now I have seen HAproxy used more often with clients, it is pretty straight forward to set up. Percona has an example for those interested:  https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/haproxy.html Personally I like ProxySQL. Percona also has  few blogs on this as well https://github.com/sysown/proxysql/wiki/ProxySQL-Configuration https://www.percona.com/blog/2017/01/19/setup-proxysql-for-high-availability-not-single-point-failure/ https://www.percona.com/blog/2017/01/25/proxysql-admin-configuration/ https://www.percona.com/blog/2016/09/15/proxysql-percona-cluster-galera-integration/ Percona also has ProxySQL version available  https://www.percona.com/downloads/proxysql/ I was thinking I would write up some examples but overall ... Read More

Feed: Planet MySQL; Author: MariaDB; When we are talking about a database auditing concept, what we are focused on is tracking the use of database records, and the monitoring of each operation on the data. The auditing activities goal is to provide a clear and reliable answer to the typical 4 W questions: Who accessed the database, When did this happen, What was touched, Where this access came from. Auditing should also help the security team answer the 5th W: Why this happened? Auditing is also a very important task when we want to monitor the database activity to collect ... Read More

Feed: Planet MySQL; Author: Keith Larson; Happy Birthday MySQL  ! Turned 23 today ! ... Read More

Feed: Planet MySQL; Author: The Pythian Group; In recent weeks I’ve been focusing on Docker in order to get a much better understanding of the containerized world that is materializing in front of us. Containers aren’t just for stateless applications anymore and we’re seeing more cases where MySQL and other databases are being launched in a containerized fashion, so it’s important to know how to configure your MySQL container! In docker hub, you will see an option for this by doing a volume mount from the docker host to the container on /etc/mysql/conf.d. But the problem is that the container ... Read More

Feed: Planet MySQL; Author: Dave Stokes; There was an interesting question on Stackoverflow.com on extracting values from a JSON data type column in a MySQL database.  What caught my eye was the the keys for the key/value pairs were numeric. In particular the author of the question only wanted values for the key named 74.  The sample data was fairly simple.{ "70" : "Apple", "71" : "Peach", "74" : "Kiwi" }I thought SELECT JSON_EXTRACT(column, '$.74') FROM table; should work but it did not. There was a complaint about an invalid path expression.It turns out that you need to make the ... Read More

Feed: Planet MySQL; Author: VividCortex; If you’re someone who keeps up with the Go development cycle, then you’ll know that a couple of weeks ago Go entered its feature-freeze for the Go 1.11 release. One of the changes for this upcoming release that caught my eye was to the database/sql package. Daniel Theophanes contributed a change that introduces several new counters available via the DB.Stats() method ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; In this article, I’ll explain about the multi version concurrency control (MVCC) of large objects (LOBs) design in the MySQL InnoDB storage engine.  MySQL 8.0 has a new feature that allows users to partially update large objects, including the JSON documents.  With this partial update  feature the way MVCC works for LOBs has changed when there are partial updates to LOBs.  For normal updates (the full update), MVCC will work as it did in previous versions. Lets look at  how MVCC works when partial update is not involved, and then consider the use ... Read More

Feed: Planet MySQL; Author: Shlomi Noach; May 22, 2018 This is the sixth in a series of posts reviewing methods for MySQL master discovery: the means by which an application connects to the master of a replication tree. Moreover, the means by which, upon master failover, it identifies and connects to the newly promoted master. These posts are not concerned with the manner by which the replication failure detection and recovery take place. I will share orchestrator specific configuration/advice, and point out where cross DC orchestrator/raft setup plays part in discovery itself, but for the most part any recovery tool ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; In the Replication QA team, we have been continuing to improve test coverage for Replication and Group Replication primarily to ensure that we support the newest and latest offerings of MySQL Server 8.0 such as Generated Columns, Set Persist, User Roles, and User Management DDLs that are now atomic. As a rule, we include tests for both MySQL Replication (master/slave, asynchronous replication) and Group Replication (group membership) topologies to ensure everything works out of the box with defaults. In this blog, we discuss several additions to the MySQL QA testing suite (MTR). These ... Read More

Feed: Planet MySQL; Author: Sveta Smirnova; Sveta Smirnova | May 21, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Technical Webinars PREVIOUS POST Please join Percona’s Principal Support Escalation Specialist, Sveta Smirnova, as she presents Troubleshooting MySQL Concurrency Issues with Load Testing Tools on Wednesday, May 23, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Normally, we use benchmarking tools when we are developing applications. When applications are deployed, benchmarks tests are usually too late to help. This webinar doesn’t cover actual benchmarks, but it does look at how you can use benchmarking tools for troubleshooting. When you need ... Read More