Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 36521 10 Older Entries
Use the index, JSON! Aggregation performance (Elastic, MySQL, MongoDB)
Employee +0 Vote Up -0Vote Down

Use the index, Luke!? No: use the index, JSON! When hunting features the X DevAPI should consider I got shocked by some JSON query execution times. Sometimes the MySQL Document Store runs head-on-head with MongoDB, sometimes not. Sometimes the difference to …

  [Read more...]
Moving data from MongoDB to MySQL's JSON Document Store
Employee +1 Vote Up -0Vote Down

I had an interesting phone call from someone wanting to move from MongoDB to MySQL's new JSON Document Store. The big question was 'How do I export my Mongo data into something I can read into MySQL?"

The good news is that the folks at Mongo have given us the tools for the hard part of a simple process. For this example I am going to use some test data create previously in a database creatively named dave. The numbers are made up and I am using my name and the names of the canines residing in my home. So a quick peek at the data:


$ mongo
MongoDB shell version: 3.2.8
connecting to: test …


  [Read more...]
Vagrant environment to test MySQL Group Replication 0.8
Employee +1 Vote Up -0Vote Down

Vadim Tkachenko recently released  Docker images for Group Replication (thank you for that ).

As not everybody is already using Docker or just because having multiple choices is also nice (this is an OpenSource world isn’t it ?), I decided to share a Vagrant environment that you can use to evaluate Group Replication.

This environment provides also a module that can be used to deploy GR on any other environment managed by Puppet.

The repository is available on my github account: …

  [Read more...]
MySQL Group Replication: securing the perimeter!
Employee_Team +1 Vote Up -0Vote Down

Hi all, here is a new post following the blog series on the last MySQLvGroup Replication labs release which already presented: 1) the new features; 2) most asked questions; 3) summary of behaviour and configuration changes; and 4) the performance improvements.…

Percona XtraDB Cluster 5.7.12 RC1 is now available
+0 Vote Up -0Vote Down

Percona announces the first release candidate (RC1) in the Percona XtraDB Cluster 5.7 series on August 9, 2016. Binaries are available from the downloads area or our software repositories.

Percona XtraDB Cluster …

  [Read more...]
MySQL vs. PostgreSQL, gh-ost perspective
+1 Vote Up -0Vote Down

Last week we released gh-ost, GitHub's online schema migration tool for MySQL. As with other open source releases in the MySQL ecosystem, this release was echoed by several "Why not PostgreSQL?" comments. Having been active in open source since many years now, I'm familiar with these responses, and I find this is a good time to share my thoughts. Why? XKCD knows the answer:

…  [Read more...]
Tracker: Ingesting MySQL data at scale - Part 1
+0 Vote Up -0Vote Down

At Pinterest we’re building the world’s most comprehensive discovery engine, and part of achieving a highly personalized, relevant and fast service is running thousands of jobs on our Hadoop/Spark cluster. To feed the data for computation, we need to ingest a large volume of raw data from online data sources such as MySQL, Kafka and Redis. We’ve previously covered our logging pipeline and moving Kafka data onto S3. Here we’ll share lessons learned in moving data at scale from MySQL to S3, and our journey in implementing Tracker, a database …

  [Read more...]
Aggregation features, Elasticsearch vs. MySQL (vs. MongoDB)
Employee +0 Vote Up -0Vote Down

To make the MySQL Document Store primary programming interface, the X DevAPI, a success we should provide building blocks to solve common web development tasks, for example, faceted search. But is there any chance a relational database bend towards a document store can compete around aggregation …

  [Read more...]
Planets9s - Become a MySQL DBA, Polyglot Persistence Meetups, MySQL Query Tuning and more
+0 Vote Up -0Vote Down

Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.

Become a MySQL DBA at Percona Live this October

Whether you’re looking for monitoring and trending advice for your MySQL installation or how to diagnose issues with your MySQL setup; do backup and database upgrades; or tips and tricks for some of the common maintenance operations related to MySQL … This full-day tutorial, which we already …

  [Read more...]
MySQL Team at Percona Live Amsterdam
Employee +0 Vote Up -0Vote Down

From October 3rd to 5th, the MySQL Engineering and Community Team will be in Amsterdam to present MySQL 8.0 at Percona Live.

The Conference Committee has rated all the numerous submissions and I’m very proud to announce that we will deliver the following 11 sessions:

  [Read more...]
10 Newer Entries Showing entries 61 to 70 of 36521 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.