Showing entries 1 to 10 of 37595
10 Older Entries »
MySQL for Visual Studio 2.0.5 has been released

The MySQL Windows Experience Team is proud to announce the release of  MySQL for Visual Studio 2.0.5 m4. Note that this is a development preview release and not intended for production usage.

MySQL for Visual Studio 2.0.5 m4 is the fourth development release of the MySQL for Visual Studio 2.0 series. This series adds support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax that does not assume previous experience writing traditional SQL.

To learn more about how to write applications using the X DevAPI, see http://dev.mysql.com/doc/x-devapi-userguide/en/. For more information about how the X DevAPI is implemented in …

[Read more]
No new options, no new commands… Just faster at full load, where it counts!

Starting on MySQL 8.0.1, a very updated replica server will be more efficient (and probably faster) than previous MySQL versions because of improvements in the relationship between the replication threads. Preliminary testing showed a benefit of up to 65% on Sysbench Update Index.…

Announcing ClusterControl 1.4.1 - the ProxySQL Edition

Today we are pleased to announce the 1.4.1 release of ClusterControl - the all-inclusive database management system that lets you easily deploy, monitor, manage and scale highly available open source databases - and load balancers - in any environment: on-premise or in the cloud.

This release contains key new management features for MySQL and MariaDB load balancing with ProxySQL, along with performance improvements and bug fixes.

Release Highlights

For ProxySQL

  • Support for:
    • MySQL Galera in addition to Replication clusters
    • Active-standby HA setup with Keepalived
    • Use the Query Monitor to view query digests
  • Management features:
    • Manage Query Rules (Query Caching, Query Rewrite)
[Read more]
Vitess releases version 2.1

The Vitess project is proud to announce the release of version 2.1. This version comes packed with new features that improve usability, availability and resilience of the overall system.
The release coincides with the Percona Live 2017 Conference, where project co-founder Sugu Sougoumarane will give the talk "Vitess beyond YouTube". He is joined by Robert Navarro from Stitch Labs  who is going to describe how Stitch Labs uses Vitess in production..

Version 2.0 introduced a sharding agnostic API to the world. This allowed clients to connect to Vitess and send queries as if it was a single database engine. However, questions remained about the atomicity of transactions that spanned multiple shards or keyspaces. With 2.1, you can now request such transactions go through …

[Read more]
Percona Live 2017 – MySQL 8.0: Major New Features

Breakout sessions are in full swing at the Percona Live Open Source Database Conference 2017. Check out what’s new in MySQL 8.0.

We’ve finished with this morning’s sessions, and this morning saw a lot of amazing open source talks. One of the most well-attended was MySQL 8.0: Major New Features given by Geir Høydalsvik, Senior Software Development Director at Oracle. MySQL is the next major version of the MySQL platform from Oracle, the open source community is expectantly waiting for the official release.

In this session, Geir described many of the new features announced for MySQL 8.0. In addition to Data Dictionary, CTEs and Windows functions, …

[Read more]
Percona Live 2017: Day One Keynotes

Welcome to the first day of the Percona Live Open Source Database Conference 2017, and the first set of Percona Live keynotes!

It’s a beautiful day in Santa Clara, but we don’t know because we’re inside the Hyatt Regency Convention Center listening to various rock stars in the open source database community talk about open source technologies. Day one of the conference kicked off with four keynote talks, all of which discussed issues and technologies that are addressed by open source solutions:

Percona Welcoming Keynote

Peter Zaitsev (Percona)

Peter Zaitsev, CEO of Percona, welcomed everyone to Percona Live Open Source …

[Read more]
How to Install MySQL 5.7 on Linux CentOS and Ubuntu

In this tutorial, I will guide you how to install and configure the new stable MySQL 5.7 version on CentOS 7 server and Ubuntu 16.04 server. MySQL is an open source relational database management system developed by Oracle corporation. The source code is released under GNU General Public License.

Percona Live 2017 Tutorials Day

Welcome to the first day of the Percona Live Open Source Database Conference: Percona Live 2017 tutorials day! While 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 4/25 at 9:00 am.

Some of the …

[Read more]
Improved wsrep-stages and related instrumentation in Percona XtraDB Cluster

In this blog post, we’ll look at how we’ve improved wsrep-stages and related instrumentation in Percona XtraDB Cluster.

Introduction

When you execute a workload and need to find out what the given thread is working on, “SHOW PROCESSLIST” comes to the top of your mind. It is an effective way to track the thread status. We decided to improve the stages in Percona XtraDB Cluster to make “SHOW PROCESSLIST” more meaningful.

In the blog below, we will check out the different wsrep-stages and the significance associated with them.

Loading of data

Running a simple insert/sysbench prepare workload. The state is stable as it mainly captures …

[Read more]
Open Source DBA Ethos

I’m in Santa Clara at the Percona Live Conference and Expo.  I have been here less than 24 hours, but I have already had conversations with many fellow DBAs, some that I have met and worked with before, and others whom I am meeting for the first time.  It has been three years since my last visit, but being here shows you that as an Open Source DBA, you’re in sort of a “big family” of like minded, top notch, professionals.

I am proud to be an open source DBA because of our apparent values, values you see in almost everyone when you come to an event like this.

Who are we as Open Source DBAs ?

  • We are system experts.  Open source DBAs know their operating system.  They are not only focused on the database.
  • We are developers.  We contribute to source code within …
[Read more]
Showing entries 1 to 10 of 37595
10 Older Entries »