(Alexander Rubin) In this blog post, we’ll discuss how to improve the performance of slow MySQL queries using Apache Spark.
Tag: Open Source
Trying out MySQL in Docker Swarm Mode
(Trond Humborstad) Orchestration tools are often used when scaling out an application stack. In a Docker environment, tools like Kubernetes, Mesos and Docker Swarm have typically been used for this purpose. Docker has brought significant updates to their orchestration offering with their latest rele
Context aware MySQL pools via HAProxy
(shlomi-noach) At GitHub we use MySQL as our main datastore. While repository data lies in git , metadata is stored in MySQL. This includes Issues, Pull Requests, Comments etc. We also auth against MySQL via a custom git proxy (babeld).
Maximizing Database Performance – MySQL Tuning Best Practices
(Janis Griffin) With the added complexity of growing data volumes and ever changing workloads, database performance tuning is now necessary to maximize resource utilizations and system performance. However, performance tuning is often easier said than done.
Use the index, JSON! Aggregation performance (Elastic, MySQL, MongoDB)
(Ulf Wendel) 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.
Moving data from MongoDB to MySQL’s JSON Document Store
(Dave Stokes) 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?”
Vagrant environment to test MySQL Group Replication 0.8
(Frederic Descamps) Vadim Tkachenko recently released Docker images for Group Replication (thank you for that 😉 ).
MySQL Group Replication: securing the perimeter!
(Nuno Carvalho) 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.
MySQL vs. PostgreSQL, gh-ost perspective
(Shlomi Noach) 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.
Tracker: Ingesting MySQL data at scale – Part 1
(Henry Cai) 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.
