Severalnines is pleased to announce the launch of our new tutorial Database Load Balancing for MySQL and MariaDB with ProxySQL.

ProxySQL is a lightweight yet complex protocol-aware proxy that sits between the MySQL clients and servers. It is a gate, which basically separates clients from databases, and is therefore an entry point used to access all the database servers.

Included in this new tutorial….

• Introduction to ProxySQL
• Deep dive into ProxySQL concepts
• How to install ProxySQL using ClusterControl
• How to manage ProxySQL using ClusterControl
• Managing multiple ProxySQL instances
• ProxySQL failover handling
…

A regression was discovered after the release of MariaDB 10.1.27. It has been pulled from the downloads system, but some mirrors may still have it. Do not download or install this version. Stay with MariaDB 10.1.26 until 10.1.28 is released The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.27. See the […]

The post MariaDB 10.1.27 now available appeared first on MariaDB.org.

Percona announces the release of Percona Monitoring and Management 1.3.0 on September 26, 2017.

Percona Monitoring and Management 1.3.0 introduces basic support for the MyRocks storage engine. There is a special dashboard in Metrics Monitor that presents the essential metrics of MyRocks as separate graphs. Also, Metrics Monitor graphs now feature on-demand descriptions that remain visible as long as hover over them.

For example, this graph helps you visualize MyRocks database operations of Next and Seek attributes:

There are many improvements to QAN (Query Analytics) both in the user interface design and in …

In this blog post, we’ll look at how to avoid shared locks from subqueries.

I’m pretty sure most of you have seen an UPDATE statement matching rows returned from a SELECT query:

update ibreg set k=1 where id in (select id from ibcmp where id > 90000);

This query, when executed with

autocommit=1

, is normally harmless. However, this can have bad effects when combined with other statements in the same transaction that result in holding the shared locks from the SELECT query. But first, let me explain why the SELECT query would hold locks in the first place.

Due to InnoDB’s ACID properties, to make sure that the outer UPDATE statement has a consistent view of the matching rows from the SELECT query the server has to acquire a shared lock on those rows. No other thread should modify …

Welcome to the first day of the Percona Live Open Source Database Conference Europe 2017: Tutorials day! Technically the first day of the conference, this day focused on provided hands-on tutorials for people interested in learning directly how to use open source tools and technologies.

Today attendees went to training sessions taught by open source database experts and got first-hand experience configuring, working with, and experimenting with various open source technologies and software.

The first full day (which includes opening keynote speakers and breakout sessions) starts Tuesday 9/26 at 9:15 am.

Some of the tutorial topics covered today were:

…

Moving one of Facebook's main databases to MyRocks cut storage usage in half.

The long awaited first release candidate of MySQL 8.0 is now available. The theme of this release is “making MySQL better for modern apps”. What does that mean exactly?

• A modern application is mobile first. Mobile-first is not just a theme applied to an existing app, it is about using context about the user (such as their location) and reducing the clicks required for a transaction.

…

We are happy to invite you to the first MySQL Meetup of the MySQL UAE User Group! Please find more details below:

• Date: Wednesday, October 4th, 2018
• Time: 6-8pm
• Agenda: MySQL Overview or Welcome to MySQL Ecosystem
  • Abstract: MySQL is the most popular open-source database in the world and has been downloaded and/or distributed by MySQL sites over 100 million times. With its outstanding speed, reliability, and ease of use, MySQL has become the preferred choice for Web, SaaS, ISV, and telecom companies like Facebook, Uber, Paypal and many others. In this short overview we will highlight some of the MySQL use cases and will look at how booking.com use MySQL today. 
• Presenter: Carsten Thalheimer …

As we already announced in the previous blog post from September 15, 2017 we (MySQL) are part of the very unique and special event in Australia, BuzzConf 2017. This is the first time MySQL Community team in cooperation with local Australian MySQL team is part of such event as BuzzConf is. Generally it's described in short as Conference / Festival, however it's really not only this... BuzzConf is a family-friendly technology festival with a really unique atmosphere. All participants and presenters are going to spend the weekend together in country of Victoria (Phoenix Park, Australia), learning and playing with tech during the day and being entertained by live music all night!

We are very happy that we can help organizers to run such event full of technologists, people with …

MySQL will have Windowing functions and CTEs which will mean it will be easier to do data analysis with MySQL. You can now make calculations on data from each row in a query plus rows related to that row. Windows will make it easier to group items when GROUP BY does not meet needs. This is a great breakthrough but the new documentation has a steep learning curve if you are starting from zero. Hopefully this and following blogs will make it easier to get started with Windowing Functions. OVER & WINDOW as a keywords Let's start with the world_x sample database. The sample below orders the city table by the CountryCode but notice the window w as (order by CountryCode) phrase. This sets up a group for analysis, or a window on the data. For this example we will get the row number, rank, and dense rank of the data in that group. So for CountryCode of ABW we get a row number of 1, rank of 1, and …