Author: Greg Baker

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…

Read More >

Blackbird TechTalks v2.0 – Eddie Garcia

In April, we welcomed Eddie Garcia, the VP of Information Security and ex-Architect at Gazzang.com to join us for a chat about Cassandra. In this talk, he starts the discussion with the AWS configurations he’s seen perform best in real…

Read More >

Cascade Replication and Delayed servers on PostgreSQL 9.2

Postgresql 9.2 will be released with a new replication feature: Cascade Replication. It will improve streaming between wide networks, shortening distances between the servers. For example: a master server in San Francisco, a slave in Chicago and a cascade server…

Read More >

Cascade Replication and Delayed servers on PostgreSQL 9.2

Postgresql 9.2 will be released with a new replication feature: Cascade Replication. It will improve streaming between wide networks, shortening distances between the servers. For example: a master server in San Francisco, a slave in Chicago and a cascade server…

Read More >

When is MongoDB the Right Choice for Your Business? We Explore Detailed Use Cases

As part of PalominoDB’s “Mongo Month”, we’re reviewing use cases for where we’d recommend choosing MongoDB and where we’d consider other technologies. Because every environment and architecture is different, and every business has unique needs, we work carefully with clients…

Read More >

Hashing Algorithm in MySQL PASSWORD()

Recently we had a question from a customer: What is the hashing algorithm implemented in PASSWORD() ?

Read More >

Change Views DEFINER Without ALTER VIEW: How to Fix Thousands of Views

Recently I faced an interesting challenge: modify over 26k views on a single mysqld instance. Altering the view one by one was far from an easy task, so a I had to look for an efficient way to do it….

Read More >

How I Find MySQL Fragmentation

Sarah Novotny recently posted InnoDB Tablespace Fragmentation – Find it and Fix it, so I thought I would share how I determine MySQL fragmentation. This works for MyISAM and InnoDB tables, and will work whether or not innodb_file_per_table is in…

Read More >
Page 2 of 212