…DBD:: MySQL package for server communication instead of spawning the MySQL command line client introduced a regression which caused innobackupex -galera-info option to fail. Bug fixed # 1180672 .
The format of xtrabackup_galera_info was missing the ‘:' separator between the values of wsrep_local_state_uuid and wsrep_last_committed . Bug fixed # 1181222 .
innobackupex automatic version detection did not work correctly for latest Percona Server and MySQL…
- Engine Yard Developer Blog: MySQL 5.5 and 5.1 Support in Alpha
- New Relic: Percona Bundles New Relic to Provide Gold and Platinum Support Customers with Comprehensive Application Visibility
- till's blog: Hosted MySQL: Amazon RDS (and backups)
- omgbloglol: Recruiters: why I'm kind of rude to them, why they deserve it, and how to fix it (IMHO)
- Eddorre.com: Rails Ultimate Install Guide on OS X Lion (using RVM, Homebrew, and Pow)
- James on Software: Moving On
…of date or are known bad versions. For example, there are two versions of the DBD:: mysql Perl module that have problems. And there are certain versions of MySQL that have critical bugs. Version check will warn you about these if your system is running them.
What's new in 2.2 is that, whereas this feature (specifically, the option in tools: -version-check) was off by default, now it's on by default. If the IO::Socket:: SSL Perl module is installed (easily available through …
- Engine Yard Developer Blog: Common Custom Chef Solutions
- till's blog: Hosted MySQL: Amazon RDS (and backups)
- The Real Adam: Twitter's optimizations
- JJinuxLand: Trip to "reflections projections|2012"
- Phusion Corporate Blog: The right way to deal with frozen processes on Unix
- carpeaqua by Justin Williams: My Ultimate Developer and Power Users Tool List for Mac OS X (2011 Edition)
vCache vs. vCache - MySQL parameter testing
The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters. For example, given that the front-end device is a very fast PCIe SSD, would it make more sense to configure MySQL as if it were using SSD storage or to just use an optimized HDD storage configuration? After creating a vCache device with the default configuration, I started with a baseline HDD configuration for MySQL…
…for each of the following database platforms that you have used in a live production environment: mySQL, Postgres, Redis, Mongo,
Score +2 if you have created an API for a production environment,
Score +2 if you have used Chef or Puppet or other deployment automation tools,
Score - 5 if you generally use ftp to deploy applications,
Score +2 if you have excellent HTML and css skills, and add a bonus +1 if you can show us something significant that you coded in HTML5,
Score …
It's back! Join the MySQL Community at the annual Percona Live MySQL Conference and Expo in Santa Clara , April 22-25. This year's conference features an outstanding lineup of 92 speakers delivering 112 breakout sessions over three days!
Cool Products and Services
Install Aerospike Community Edition in 10 Minutes! To help you get up and running with our Community Edition as quickly as possible, we've created a tutorial video on AerospikeTV…
- Merbist: Designing for scalability
- New Relic: Check out NetworkedHelpDesk.org, a new initiative for sharing business-critical data across your company
- MySQL Performance Blog: DotOrg Pavilion and MySQL Community Awards at Percona Live MySQL Conference and Expo 2013
- terrbear.org: Peeping Tom: A free (open source) site pinger
- carpeaqua by Justin Williams: My Ultimate Developer and Power Users Tool List for Mac OS X (2011 Edition)
…proving the bottleneck. In surfing I found that MariaDB had "spun" out of mysql. MariaDB is a drop-in replacement for mysql, and is totally open source. My test bed is a mac-mini, and sure I can throw hardware at the problem, but its far more interesting to look at optimizing. So I used brew, a open-source package manager for osx, I installed MariaDb. I had a existing 20Gig database, and it picked it up, and used it just fine. The surprising thing is I saw a 30% increase in performance …
- MySQL Performance Blog: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !
- Sphinx search engine news: Partner Page Live!
…and every one has 4 processes which every one has 25 workers. As we are all on EC2, we use spot instances for part of the cluster so we can add more workers as needed, so it could grow up from 400 to 800 or more.
The technology is nothing special but solid, Rails + Redis + Sharded MySQL.
Thanks Libin and everyone else who entered. I hope Sidekiq Pro makes your system even better!
- Ruby Inside: The Last 2 Weeks in Ruby: Rails 3.2.6, Savon 1.0, RailsInstaller for OS X, Pow 0.4.0, Rails 2 Asset Pipeline
- New Relic: Thread Safe APIs and Sidekiq Support for Your Threading
- A Fresh Cup: Double Shot #999
- RailsCasts: #366 Sidekiq
…for each of the following database platforms that you have used in a live production environment: mySQL, Postgres, Redis.
Score +2 if you've used a distributed message queue ( ZeroMQ, RabbitMQ, Beanstalk, Kafka)
Score +2 if you are familiar with RFC 2822.
Score -2 if you didn't know what an RFC was.
Score +2 for any mail generating library you have worked extensively with.
Score +2 if you have Postfix or Qmail or Exim or Sendmail administration experience. …
- Rails Rumble: More Sponsors, More Awesome
- A Fresh Cup: Double Shot #632
Michael Widenius : There is no reason at all to use MySQL
@ steveloughran : Whenever someone says "unlimited scalability", ask if that exceeds the berkenstein bound
@ nationofminds : "I have infinite MIPS. Unlimited scalability. And zero effing patience."
Endowing cells with logic and memory : Genetic circuits that process and permanently store information are created with recombinases that flip the orientation of DNA …
- Opscode Blog: Chef 11 Released!
- New Relic: Why I Love Working at New Relic: Chris Kelly, Developer/Evangelist
- James on Software: Introducing The Real Talk Podcast
- Engine Yard Developer Blog: Using Chef for DevOps Innovations
…results showing the QPS over 5 second periods with the new DROP TABLE implementation ( MysQL version >= 5.5.23) and DROP TABLE running in the background:
Finally comes the benchmark results showing the QPS over 5 second periods with the Lazy Drop Table implementation in Percona Server and DROP TABLE running in the background:
So we can compare the graphs above, and see that there are dips in QPS whenever table is dropped, MySQL 5.5.23 does show an improvement over MySQL version …
- Engine Yard Developer Blog: MySQL 5.5 and 5.1 Support in Alpha
- Pixellated Visions: Fixing MySQL and rubygem errors on a new rails 2.3.8 install
- BenCurtis.com: Auto-spawning Delayed Job Workers
- Binary Code: Raw SQL queries and Rails
- Phusion Corporate Blog: Union Station beta is back online, and here's what we have been up to
- Falling Leaves - Home: Fixing Local MySQL problems