Posts Categorized: Pythian

Liveblogging: Cassandra Internals

Cassandra Internals by Gary Dusbabek of Rackspace Questions? What’s the best way to access data if you’re running a program in the same JVM as Cassandra? — will talk about it during StorageProxy section of the talk Performance characteristics of using MMAP vs. not using it? – won’t cover it. When does repair happen?  will…

The Chronicles of Yanick: Rise of the Perlmongers

As it was my very first YAPC, I stuffed my schedule as if I were a child left alone in a bakery and the talks were cakes. Consequently, I ended up booked solid from 10am to 6pm for all of the three days of the conference. Next time, I will probably go a little easier on the talks and give myself more room to attend hackatons, BOFs and whatnots. But for a first time? Walking the talks was the way to go, both to get a feeling of the conference and to take advantage of the occasion and connect all the Perl big names with their wetware implementations.

Log Buffer #228, A Carnival of the Vanities for DBAs

un is shining and the warm wind is blowing and bringing in new and novel ideas for the technology blogs and database are no exception. From the SQL Server to MySQL and up to Oracle, blogs are bubbling with warm and cool blog posts and we present you the pick of the week in this Log Buffer #228 edition of Log Buffer.

The Chronicles of Yanick: Pitch Black

Boys and girls, please make yourself comfortable. Sit back, clip your seatbelt, and relax as we ready ourselves to take the scenic route to YAPC. I’ll try to stick to a semi-chronological order, which means that I will begin at the beginning. Maybe not the beginning beginning — my youth was a fairly uneventful and boring one — but a beginning that provides both scope and a springboard to this odyssey.

You can’t turn Query Cache Off before MySQL 5.5

… or at least, not completely! It often happens to see and hear of replication SQL thread almost always in state “invalidating query cache entries (table)” . The classic tip is “set global query_cache_size=0″ . While sometime this works, others don’t; the query cache is “disabled” and you still see the SQL thread in state…

PalominoDB’s Proactive Support

I’m rather passionate about what we do here at PalominoDB.  When I tell people about what makes us different from the competition, I often discuss the proactive work we do.  We are not a reactive company.  We know that proactive reviews are what keep a database up and running smoothly, and we definitely want to…

Log Buffer #227, A Carnival of the Vanities for DBAs

An ideal summer day is when the sun is shining, the warm sunshine refreshes your body, the light breeze becomes naught with your hair, the birds sitting on intoxicated leaves smile at you, and you to top all of that you get the latest hot issue of the Log Buffer. Yes to put cherry on your cake, Log Buffer #227 is here.

Replication and EC2 gotcha

Tonight a client restarted some instances on EC2 and they got different IPs. This broke replication because the slaves were trying to connect to the masters using IPs that weren’t existing any more. To solve the task is easy: just CHANGE MASTER TO using the new IP (or the hostname).   Although there is a…

Page 90 of 230« First Page...10...8889909192...100...Last Page »