MySQL

Benchmark: TokuDB vs. MariaDB / MySQL InnoDB Compression

As the amount of data companies are interested in collecting grows, life becomes all the more difficult for IT staff at all levels within an organization. SAS Enterprise storage devices that were once considered giants are now being phased out in favor of SSD Arrays with features such as de-duplication, tape storage has pretty much been abandoned and…

Building a MariaDB Galera Cluster with Docker

There’s been a lot of talk about Docker for running processes in isolated userspace (or the cloud for that matter) lately. Virtualization is a great way to compartmentalise applications  and processes however the overhead of virtualization isn’t always worth it – in fact, without directly attached storage IO degradation can seriously impact performance. The solution?…

Critical MySQL 5.6 bug: GRANTs and replication

Critical MySQL 5.6 bug: any user with GRANT privileges can unwillingly cause all replicas to break The latest major release of MySQL brought us a lot of new and exciting features. As always, new features come with brand new bugs waiting to bite you in the least expected way. I was implementing a monitoring system…

Microsecond Precision with MySQL on Amazon RDS

Running MySQL in the cloud offers many benefits, including extremely fast provisioning and deployment, managed security, and (mostly) easy operations. But nothing comes for free, and as with all things on this wonderful planet, those benefits come with certain limitations.

Life at Pythian as a MySQL DBA

Several people have asked me in the last year what it is like to work for Pythian. There are many reasons for a question like this, depending on who is asking.   Some people are concerned about the fact I am working for a Canadian-based company. This typically comes from some of my xenophobic North…

Advanced Search with Sphinx and MySQL

Vlad Fedorkov and the creator of Sphinx Search speaking at Percona Live 2014. They cover the basics of Sphinx, as well as faceted search, auto-correction, searching with ranges, geo spatial search, non-full-text search (filtering, grouping, sorting), and about some of Sphinx’s full-text search operators (ie. field-limit operator and quorum operator). https://www.youtube.com/watch?v=-ybnxq149hA A talk at Percona…

Blackbird at Percona Live – Scaling MySQL in AWS

Laine explains the options for running MySQL at high volumes at Amazon Web Services, exploring options around database as a service, hosted instances/storages and all appropriate availability, performance and provisioning considerations using real-world examples from Call of Duty, Obama for America and many more. Laine will show how to build highly available, manageable and performant…

MySQL Community Dinner at Pedro’s

Pythian organizing an event that by now may be considered a tradition: The MySQL community dinner at Pedro’s! This dinner is open to all MySQL community members as many of you will be in town for the MySQL Conference that week. Here are the details..

Page 3 of 8512345...10...Last Page »