June 19, 2013

Post: linux.conf.au 2012 roundup

to open hardware, to repurposing existing hardware to upcoming challenges for the kernel to howto be a better sysadmin. In fact… for those whois going to be the default filesystem in a number of places over the next few years, time to

Comment: New MySQL Community Release Policies published

…these comments, it seems to me that nobody seems to understand the simplicity of a stable branches being truly …next development version (5.1? 6.0?) No way should such a change be applied to 5.0, which is… of people I know who‘ve now done the same. The sloppy approach to patching stable versions, and …

Post: High Availability Deep Dive tutorial at PLMCE

… be co-presenting next Tuesday a tutorial on the topic. It is never too late to register! For the ones who are already registered, here’s advance information which you will find useful. As our tutorial is going to be highly interactive, every attendee will have the opportunity to follow along with Florian and me as we walk…

Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

… code again next week, maybe it’ll get more clear to me, .. for me to understand it a bit more, can you answer me these questions… readerOK and writerOK? readerOK = 0 means that a server is not allowed to run a reader_vip or that it doesn’t have a reader_vip? (same for writer i assume) Where is decided on who get’s to have the writerVIP?

Comment: Disaster: MySQL 5.5 Flushing

… has a support group for people who tell me things that I then forget. But this stall is really bad regardless. And suggestion…. Each time this search restarts it has to scan more of the list to find the next dirty page. Comments in buf_flush_batch match my understanding: /* Note that after finding a single flushable page, we try to

Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

… the use of a private network for replication if needed. Next is the mysql primitive resource declaration. This primitive defines the mysql… I’ll skip detailed description. The next interesting element is the master-slave “ms” declaration. This is how Pacemaker defines an asymmetrical resource… the VIPs is the truly new thing in the resource agent. I am grateful to Florian Haas who told me to use node attributes to avoid…

Post: Data mart or data warehouse?

…(ETL), and schema management tools. To me, the definition of data warehouse is “A relational database schema which … first methodology was popularized by Bill Inmon, who is considered by many to be the “father” of the data… features to MySQL as well, but that is a topic for a later post. In the next

Post: Sphinx 0.9.8 is released just in time for OSCON 2008

to Be the Next $1B Acquisition) which is pretty cool. At Percona we actively support Sphinx as in our opinion it is great complement towho 700663 1250ms 664ms Extended2 mode also offers choice of “ranking modes” – if you would like to use BM25 ranking (similar to

Post: Choosing innodb_buffer_pool_size

…bit too much, so let me write a bit better description. Innodb Buffer Pool is by far the most …make sure to leave space for other MySQL needs while factoring this in. The next step would be to decide … people think – who cares if some of buffer pool is swapped out, I would have one IO to fetch page if…

Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete

… Live London is raging in the UK, I thought it fitting to remind everyone about the next big Percona Live…, and I don’t have time to laud them all, so let me give you a few (highly biased… colleagues: Liz, Fred, and Kenny: who are fantastic presenters and trainers. This is one of 3 tutorials that …