Showing entries 1 to 10 of 37628
10 Older Entries »
From Percona Live 2017: Thank You, Attendees!

From everyone at Percona and Percona Live 2017, we’d like to send a big thank you to all our sponsors, exhibitors, and attendees at this year’s conference.

This year’s conference was an outstanding success! The event brought the open source database community together, with a technical emphasis on the core topics of MySQL, MariaDB, MongoDB, PostgreSQL, AWS, RocksDB, time series, monitoring and other open source database technologies.

We will be posting tutorial and session presentation slides at the Percona Live site, and all of them should be available shortly. 

Highlights This Year:

  • Informative tutorials on day one, including …
[Read more]
RDS vs Aurora vs EC2 benchmark

The goal of the benchmark is to compare performance and price/performance of Amazon RDS (Aurora) and MySQL server running on EC2 instance.

MySQL versions

  • MySQL 5.6 on RDS
  • Aurora on RDS
  • MySQL 5.6 community version on EC2
  • MySQL 5.7 community version on EC2

Sysbench test

  • Primary Key lookup queries
  • OLTP workload with mix of SELECT, UPDATE, DELETE and INSERT queries
  • IO and CPU bound workloads

Sysbench Benchmarks CPU bound

Dataset size – 76G

IO bound

Dataset size 375G

[Read more]
Get Started with MariaDB on Docker

Get Started with MariaDB on Docker MariaDB Team Fri, 04/28/2017 - 14:27

This week’s webinar with Alvin Richards on getting started with MariaDB on Docker was extremely popular but unfortunately we weren’t able to get to all the audience questions at the end. We sat down with Alvin after the webinar to review the questions and get his responses. Check out the conversation below.

If you missed the webinar or would like to watch it again, you can access the recording here and slide deck here.

Alvin Richards is Field CTO at MariaDB Corporation where he connects the dots between practitioners, innovators and MariaDB products. In his prior life, Alvin was vice president of product at Aerospike; ran engineering teams at Docker and MongoDB, leading the revolution of microservices and …

[Read more]
MySQL Connector/C 6.1.10 GA has been released

Dear MySQL Users,

A new GA (general availability) version of MySQL Connector/C has been
made available: MySQL Connector/C 6.1.10 GA. The MySQL Connector/C 6.1
implements the MySQL C API for connecting client applications to the
MySQL Server 5.5 or newer.

You can download the production release at:
http://dev.mysql.com/downloads/connector/c/6.1.html

MySQL Connector C (Commercial) will be available for download on the My
Oracle Support (MOS) website. This release will be available on
eDelivery (OSDC) in next month’s upload cycle.

Please see the documentation and the README file in the source distribution
for a detailed description of bugs that have been fixed.

Enjoy!

Changes in MySQL Connector/C 6.1.10 (2017-04-28, General
Availability) …

[Read more]
Proactive MySQL: Query Reviews (part 1, overview)

One task that can really help reduce future problems is to do a periodic query review. I’ve been using pt-query-digest to do this since 2010 (back when it was part of Ma’atkit, mk-query-digest!), and while I have presented the idea several times at conferences, I have never blogged about it.

I am going to share a secret with you – I blog not just to share information with YOU, but to share information with ME. Future me. This comes up because I am working on a query review at Salesforce.com for one of our busiest shards. I went to go look up a blog post on using pt-query-digest, because it’s a handy cheat sheet….and….I never did it. So, here goes!

This is the first blog post in what will be a series of blog posts, because it is a long topic and there are a few tools that can be used these days for analysis.

[Read more]
Everyone Talks About Big Data, But What Does That Actually Mean?

 

Back in March, I wrote a post that introduced Gartner’s hype cycle.  This hype cycle provides an actual graphical representation of the buzzword fatigue that we in the industry feel so acutely.  If you look back over the last few years, you won’t have a hard time thinking of examples.  In that earlier post, I talked about the term cloud.  But terms like internet of things, micro-services, and big data might also come to mind.

 

Today, I want to talk about this latter term, big data.  Unlike some of the other terms that wind their way along Gartner’s hype cycle, this one has maddening uncertainty cooked right into its name.  The word big offers so much vagueness that …

[Read more]
MySQL Connector/J 5.1.42 has been released

Dear MySQL Users,

MySQL Connector/J 5.1.42, a maintenance release of the production 5.1
branch has been released. Connector/J is the Type-IV pure-Java JDBC
driver for MySQL.

MySQL Connector Java is available in source and binary form from the
Connector/J download pages at
http://dev.mysql.com/downloads/connector/j/5.1.html
and mirror sites as well as Maven-2 repositories.

MySQL Connector Java (Commercial) is already available for download on the
My Oracle Support (MOS) website. This release will be available on eDelivery
(OSDC) in next month’s upload cycle.

As always, we recommend that you check the “CHANGES” file in the
download archive to be aware of changes in behavior that might affect
your application.

MySQL Connector/J 5.1.42 includes the …

[Read more]
Percona Live 2017: Hawkular Metrics, An Overview

The place is still frantic here at Percona Live 2017 as everybody tries to squeeze in a few more talks before the end of the day. One such talk was given by Red Hat’s Stefan Negrea on Hawkular Metrics.

Hawkular Metrics is a scalable, long-term, high-performance storage engine for metric data. The session was an overview of the project that includes the history of the project, an overview of the Hawkular ecosystem, technical details of the project, developer features and APIs and third party integrations.

Hawkular Metrics is backed by Cassandra for scalability. Hawkular Metrics is used and exposed by Hawkular Services.The API uses JSON to communicate with clients.

Users of Hawkular Metrics include: …

[Read more]
The SQL Standard is SQL:2016

Now the words "SQL Standard" mean ISO/IEC 9075 Information technology -- Database languages -- SQL ... 2016" or more briefly SQL:2016. I am no longer a member of the committee, I don't have the latest copy, but I believe these are the notable changes.

The LIST_AGG function

The example I've seen (credit to Markus Winand) is

SELECT grp, LIST_AGG(val, ',') WITHIN GROUP (ORDER BY val) FROM t ORDER BY grp;

and the result is supposed to be: take each "val" value and concatenate it with the previous one, separating by "," as specified.
Notice a similarity to GROUP_CONCAT() in MySQL/MariaDB

[Read more]
Percona Live 2017: Lessons Learned While Automating MySQL Deployments in the AWS Cloud

The last day of Percona Live 2017 is still going strong, with talks all the way until 4:00 pm (and closing remarks and a prize giveaway on the main stage then). I’m going to a few more sessions today, including one from Stephane Combaudon from Slice Technologies: Lessons learned while automating MySQL deployments in the AWS Cloud.

In this talk, Stephane discussed how automating deployments is a key success factor in the cloud. It is actually a great way to leverage the flexibility of the cloud. But often while automation is not too difficult for application code, it is much harder for databases. When Slice started automating their MySQL servers at Slice, they chose simple and production-proven …

[Read more]
Showing entries 1 to 10 of 37628
10 Older Entries »