Fedora 29 was released earlier today, and we congratulate the Fedora community on the latest iteration of many people’s favourite Linux distro. Following our tradition of rapidly adding support for new Linux distro versions, we have added the following MySQL products to our official MySQL yum repos: MySQL Server (8.0.13 and 5.7.24) Connector C++ 8.0.13 Connector […]

Cluster management, a common software infrastructure among technology companies, aggregates compute resources from a collection of physical hosts into a shared resource pool, amplifying compute power and allowing for the flexible use of data center hardware. At Uber, cluster management …

The post Peloton: Uber’s Unified Resource Scheduler for Diverse Cluster Workloads appeared first on Uber Engineering Blog.

As MongoDB® has changed their license from AGPL to SSPL many are concerned by this change, and by how sudden it has been. Will SSPL be protective enough for MongoDB, or will the next change be to go to an altogether proprietary license? According to our poll, many are going to explore MongoDB alternatives. This blog post provides a brief outline of technologies to consider.

Open Source Data Stores

• PostgreSQL is the darling of the open source database community. Especially if your concern is the license,  PostgreSQL’s permissive licence is hard to beat. PostgreSQL has …

As announced in on October 18, we are ready for being part of following shows this week. Please come to find MySQL staff there and talk to us about MySQL.

• Madison PHP, Madison, US, November 2-3, 2018: We are Community sponsor. 
• MOPCON 2018, Taipei, Taiwan, November 3-4, 2018: Do not forget to attend our sponsored MySQL talk given by Ivan Tu, the MySQL Principal Consultant Manger. Ivan will be talking about "The Mobile application supported by new generation MySQL 8.0" (scheduled for Nov 4, at 11:05-11:45am in Big Data track). Ivan will be available before and after the talk to answer your questions about MySQL. Please do not miss Ivan's talk and the …

A well-known performance booster in MySQL is to set sync_binlog to 0.  However, this configuration alone comes with serious consequences on consistency and on durability (the C and D of ACID); I explore those in this series.  In this post, I give some background on the sync_binlog parameter and I explain part of the problem with setting it to 0 (or to a value different from 1).  The other

When running distributed database clusters, it is quite common to front them with load balancers. The advantages are clear - load balancing, connection failover and decoupling of the application tier from the underlying database topologies. For more intelligent load balancing, a database-aware proxy like ProxySQL or MaxScale would be the way to go. In our previous blog, we showed you how to run ProxySQL as a helper container in Kubernetes. In this blog post, we’ll show you how to deploy ProxySQL as a Kubernetes service. We’ll use Wordpress as an example application and the database backend is running on a two-node MySQL Replication deployed using ClusterControl. The following diagram illustrates our infrastructure:

Since we are going to deploy a similar setup as in …

We’ll look into how Clickhouse allows us to ingest a large amount of data and run complex analytical interactive queries at MessageBird,. We also present the business needs that brought ClickHouse to our attention and detail the journey to its deployment. We cover the problems we faced, and how we dealt with them. We talk about our current Cloud production setup and how we deployed and use it.

We are really enthusiastic to share a use case of Clickhouse, how it helped us to scale our analytics stack with the good, the bad and the ugly.

The talk could be useful to newcomers and everyone wondering if Clickhouse could be useful to them.

What we’re looking forward to…

There are many talks, but these are among the top ones we’re looking forward to in particular:

• …

The new release 8.0.13 for MySQL is available since last week.
Concerning security, this comes with a new feature already announced: the Password Verification Policy.
Let’s have a look…

This aim of this feature is to secure the attempts to change a password by specifying the old one to be replaced.
It is turned off by default:

mysql> show variables like 'password_require_current';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| password_require_current | OFF   |
+--------------------------+-------+

and we can activate it by several ways (as for some other password features):
1. Globally, at the server level:

mysql> set persist password_require_current='ON';
mysql> show variables like 'password_require_current';
+--------------------------+-------+
| Variable_name            | Value | …

Presented at the JSFoo conference for the first time.

The slides are uploaded here https://www.slideshare.net/SanjayManwani/mysql-8-loves-javascript via @SlideShare

Quick impression on the conference:

1. Very buzzy you could see the high energy levels.  Lots to learn about javascript and the speakers were also enthusiastic to speak. 700 attendees.

2. The focus was spot on. Security is something that everyone is worried about.

3. Staff was always on the spot and helpful. The organization looked great with the big video boards announcing the next talk etc.

4. It was also informal communication between the speakers with there being a whatsapp group for speaker to interact with one another.

5. A few things that I did point out to organizers e.g. the banners on the road outside were …

It’s almost here! One week until the Percona Live Europe Open Source Database Conference 2018 in Frankfurt, Germany! Are you ready?

This year’s theme is “Connect. Accelerate. Innovate.” We want to live these words by making sure that the conference allows you to connect with others in the open source community, accelerate your ideas and solutions and innovate when you get back to your projects and companies.

• There is one day of tutorials (Monday) and two days of sessions (Tuesday and Wednesday). We have multiple tracks: MySQL 8.0, Using MySQL, MongoDB, PostgreSQL, …