Here’s the behind-the-scenes story about how Uber Engineering’s Driver Team continues to develop our virtual onboarding funnel to get hundreds of thousands of driver-partners on the road earning money with Uber.
The Consequences of Scale for Driver-Partners
Our team cares …
The post How Uber Engineering Massively Scaled Global Driver Onboarding appeared first on Uber Engineering Blog.
Welcome to a new Percona Live Europe featured talk with Percona Live Europe 2016: Amsterdam speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference. We’ll also discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special Percona Live Europe registration bonus!
In this Percona Live Europe featured talk, we’ll meet Manyi Lu, Director Software Development at Oracle. Her talk will be on MySQL 8.0: what’s new in Optimizer. There are substantial improvements in the optimizer in MySQL 5.7 and MySQL 8.0. Most noticeably, users can now combine …
[Read more]The MariaDB project is pleased to announce the immediate availability of MariaDB Connector/J 1.5.2 Stable (GA). This is the first stable release in the MariaDB Connector/J 1.5 series and includes several new features including a native SSPI Windows implementation, support for TLSv1.1 and TLSv1.2, Aurora host auto-discovery, “LOAD DATA INFILE” interceptors, performance improvements, bug fixes, […]
The post MariaDB Connector/J 1.5.2 now available appeared first on MariaDB.org.
Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.
|
MySQL Query Tuning: Process & Tools - watch the replay
You can now watch the replay of this week’s webinar on MySQL Query Tuning: Process & Tools. Many thanks to everyone who participated. We looked at the query tuning process for MySQL from building, collecting, analysing, through to tuning and testing. And we discussed some of the main tools involved in this process, such as tcpdump and Pt-query-digest. |
|
| MySQL on Docker: Introduction to Docker … |
Many thanks to everyone who participated in this week’s first part of our webinar trilogy on MySQL Query Tuning. This time we looked at the process and tools to consider when tuning MySQL queries. It was an interactive session with interesting feedback and questions, some of which we’d like to share in this blog.
The majority of this week’s participants currently use MySQL 5.6 or 5.7 (54%), followed by Percona Server 5.6 or 5.7. It was nice to see that many of our participants are on the most recent versions of their databases of choice. As we discussed query tuning, we also found that 100% of participants use slow log to collect their slow queries as well as other tools, such as tcpdump or performance schema. And everyone seems to run full query reviews, whether it’d be monthly, quarterly or yearly …
You can view the detail of the polls we ran during the webinar below in this blog or by watching the replay.
…
[Read more]Deploying MyRocks to a database tier in one of our data center regions enabled a 50 percent reduction in storage requirements.
After having played with MySQL Group Replication and HAProxy, it’s time to show you how easy it’s to setup MySQL HA with ProxySQL.
ProxySQL is a high performance open source proxy for MySQL. It has many features that invite you to discover on proxysql.com and on github.
If you remember, I wrote in my last post that it is recommended to use Group Replication with only one WRITER group member. As it is the preferred architecture, I will show you how to achieve this using ProxySQL. With ProxySQL, you don’t need to have two different interfaces to split reads and writes.
In fact, when you use ProxySQL, you have a much larger amount of options to route your queries. In production, the smart DBA, will identify …
[Read more]“Isn’t it ironic that in 2016 a non-skilled user can find a web page from Google’s untold petabytes of data in millisecond time, but a highly trained SQL expert can’t do the same thing in a relational database one billionth the size?.–Jim Starkey.
I have interviewed Jim Starkey. A database legend, Jim’s career as an entrepreneur, architect, and innovator spans more than three decades of database history.
RVZ
Q1. In your opinion, what are the most significant advances in databases in the last few years?
Jim Starkey: I’d have to say the “atom programming model” where a database is layered on a substrate of peer-to-peer replicating distributed objects rather than disk files. The atom programming model enables scalability, redundancy, high availability, and distribution not available in traditional, disk-based database …
[Read more]This article demonstrates how MySQL sharding with ProxySQL works.
Recently a colleague of mine asked me to provide a simple example on how ProxySQL performs sharding.
In response, I’m writing this short tutorial in the hope it will illustrate ProxySQL’s sharding functionalities, and help people out there better understand how to use it.
ProxySQL is a very powerful platform that allows us to manipulate and manage our connections and queries in a simple but effective way. This article shows you how.
Before starting let’s clarify some basic concepts.
Get your Percona Live Europe discounted tickets now, and sign up for the community dinner.
The countdown is on for the annual Percona Live Europe Open Source Database Conference! This year the conference will be taking place in the great city of Amsterdam October 3-5. This three-day conference will focus on the latest trends, news and best practices in the MySQL, MongoDB, PostgreSQL and other open source databases, while tackling subjects such as analytics, architecture and design, security, operations, scalability and performance. Percona Live provides in-depth discussions for your high-availability, IoT, cloud, big data and other changing business needs.
With breakout sessions, tutorial sessions and keynote speakers, there will …
[Read more]
