Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 115 10 Older Entries

Displaying posts with tag: Database Management (reset)

Should we be muddying the relational waters? Use cases for MySQL & Mongodb
+0 Vote Up -0Vote Down

Many of you know I publish a newsletter monthly. One thing I love about it is that after almost a decade of writing it regularly, the list has grown considerably. And I’m always surprised at how many former colleagues are actually reading it. So that is a really gratifying thing. Thanks to those who are, … …

  [Read more...]
Are software benchmarks to blame for Volkswagens woes?
+0 Vote Up -0Vote Down

With the recent media attention Volkswagen has gotten, a lot of folks are wondering, how could that happen? Aren’t there checks & balances? Join 32,000 others and follow Sean Hull on twitter @hullsean. Then I ran across this observation on Todd Hoff’s brilliant blog High Scalability Is what Volkswagen did really any different that what … Continue reading Are software benchmarks to blame for Volkswagens woes? →

When hosting data on Amazon turns bloodsport
+0 Vote Up -0Vote Down

There’s a strong trend to automation across the cloud. That’s a great thing for startups because it reduces operational headaches & lets them focus on building products. Join 31,000 others and follow Sean Hull on twitter @hullsean. But as that trend begins to touch the database tier, all sorts of complications emerge. Let’s take a … Continue reading When hosting data on Amazon turns bloodsport →

Replicate MySQL to Amazon Redshift with Tungsten: The good, the bad & the ugly
+1 Vote Up -0Vote Down

Heterogenous replication involves moving data from one database platform to another. This is a complicated endevour because datatypes, date & time formats, and a whole lot more tend to differ across platforms. In fact it’s so complex many enterprises simply employ a commercial solution to take away the drudgery. Join 31,000 others and follow Sean … Continue reading Replicate MySQL to Amazon Redshift with Tungsten: The good, the bad & the ugly →

Wrestling with bears or how I tamed Tungsten replicator
+2 Vote Up -1Vote Down

I just dove into Tungsten replicator very recently as I need to replicate from Amazon RDS to Redshift. I’d heard a lot of great things about Tungsten, but had yet to really dig my heels in. Join 28,000 others and follow Sean Hull on twitter @hullsean. I fetched the binary and began to dig through … Continue reading Wrestling with bears or how I tamed Tungsten replicator →

The cost of not properly managing your databases
+0 Vote Up -2Vote Down

Every day hundreds of millions of dollars are wasted by allowing improperly tuned or misconfigured systems, misunderstood infrastructure, and inefficient IT operations to live and thrive in data centers around the globe. There are both direct and indirect costs associated with allowing these unhealthy systems to continue to exist. Let’s look at some.

The setup:

Let us start by using a small example. We will start by looking at a small database setup. This setup will have a single master-slave, with a database size of lets say 500GB. Traffic is steady and let’s say this translates into 500 IOPS on the master. You have chosen …

  [Read more...]
Is upgrading RDS like a shit-storm that will not end?
+0 Vote Up -1Vote Down

Join 29,000 others and follow Sean Hull on twitter @hullsean. Can RDS worsen an outage ?? That’s another way to think about this question. In my experience, it very clearly increases outages, by tying one or both hands behind your back. Believe me when I say, that is terribly frustrating when you’re putting out fires! […]

Is Zero downtime even possible on RDS?
+0 Vote Up -0Vote Down

Join 29,000 others and follow Sean Hull on twitter @hullsean. Oh RDS, you offer such promise, but damn it if the devil isn’t always buried in the details. Diving into a recent project, I’ve been looking at upgrading RDS MySQL. Major MySQL upgrades can be a bit messy. Since the entire engine is rebuilt, queries […]

Howto automate MySQL slow query analysis with amazon RDS
+0 Vote Up -0Vote Down

If you’ve used relational databases for more than ten minutes, I hope you’ve heard of slow queries. Those are those pesky little gremlins that are slowing down your startup, and preventing scalability you so desperately need. Luckily there’s a solution. What I’ve found is if I send a report to developers every week, it keeps […]

E-commerce – Uptime and Web apps are the keys
+0 Vote Up -0Vote Down

Since 2011 e-commerce has grown from $856,000,000.00 to closing out 2013 at more than $1,248,000,000,000.00 in global revenues, a nearly 41% growth rate over a two year span. The forecast for 2014  is targeted at $1,500,000,000,000.00, another 20% increase is gross revenues (see chart below). With trillions of dollars in play year on year now, and astounding revenue growth rates still ahead, it is critical that any e-commerce site be diligently monitoring not just their website uptime, but more importantly their Web applications. Obviously it …

  [Read more...]
Showing entries 1 to 10 of 115 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.