Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 66 Next 30 Older Entries

Displaying posts with tag: All (reset)

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 […]
If you use MySQL in the Amazon cloud, you need to ask yourself this question
+0 Vote Up -0Vote Down
Join 25,000 others and follow Sean Hull on twitter @hullsean. Are you serious about backups? If you’re just using Amazon EBS snapshots, that may not be sufficient. There’s a good chance it won’t protect you against your next data loss. That’s why I like to have a few different types of backups Also: 5 more […]
Connect to MySQL in the Amazon Public Cloud
+0 Vote Up -0Vote Down
Troubleshooting MySQL on Amazon can be a real test of patience. There are quite a few different things to watch out for in terms of connectivity & networking. Sometimes a checklist can help. Join 16,000 others and follow Sean Hull on twitter @hullsean. Here’s my exhaustive list of things that can block you. 1. Be […]
Are SQL Databases Dead?
+1 Vote Up -0Vote Down
I like the image of this city of Mesa Verde. It’s fascinating to see how ancient cities were built, especially as an inhabitant of one of the worlds largest cities today, New York. I’m a long time relational database guy. I worked at scores of dot-coms in the 90′s as an old-guard Oracle DBA, and […]
5 great things about Markus Winand’s book SQL Performance Explained
+0 Vote Up -0Vote Down
Join 12,100 others and follow Sean Hull on twitter @hullsean. 1. Covers databases broadly You may not have noticed, but there’s a whole spectrum of relational databases on offer. Of course in the database world, most get infatuated with one, and that becomes their bread & butter before long. Their life, their passion, their devotion. […]
Why Oracle won’t kill MySQL
+1 Vote Up -0Vote Down
Join 15,000 others and follow Sean Hull on twitter @hullsean. 1. MySQL does not compete with Oracle It’s a myth that MySQL somehow poses a threat to Oracle. Oracle’s customers tend to be large enterprises running apps like e-business suite. These are certified to run on Oracle, and further they sit close to finance. MySQL […]
Why I don't work with recruiters, but I learn from them
+0 Vote Up -0Vote Down

Join 11,000 others and follow Sean Hull on twitter @hullsean.

Bring me clients, please… pretty please!

When you first start out as a freelancer, your network is small. Without a steady stream of projects, the tendency is to reach for whatever you can find. Head shops & agencies build a brand, and ongoing relationships with firms. However a project with a middleman is a relationship with him or her, not the client directly. You lose control of a few very key things, such as fees, testimonials and payment terms.

Read: NYC technology startups are

  [Read more...]
Understand the High Cost of Technical Debt by Ward Cunningham (Video)
+0 Vote Up -0Vote Down

A week or two ago, I got into a conversation on Twitter about technical debt, and someone shared this superb video by Ward Cunningham (youtube). Here is Ward’s Interview website.

Join 10,000 others and follow Sean Hull on twitter @hullsean.

Waterfall, agile, developer or operations, devops, managers, CTOs… everyone should watch this video, for it cuts to the heart of the challenges we face doing modern software development, in a fast paced and always changing environment.

  [Read more...]
5 Reasons Devops Should Blog
+0 Vote Up -0Vote Down

Join 9500 others and follow Sean Hull on twitter @hullsean.

1. Stand up and be heard

Years ago I was sitting on an online forum chatting with an Oracle buddy of mine. This was circa 1998. We were working on an open source tool to interface with Oracle. There were all these libraries, for PHP & Perl, and a lot of developers starting to build tools. We hatched this hair brained idea to write a book about all of this, and pitched it to O’Reilly. They loved it and thus was born the book Oracle & Open Source in 2001.

Writing a book was, is and always will be a lot of work. It was a great learning

  [Read more...]
Scalability Tips & Greatest Hits
+0 Vote Up -0Vote Down

Join 8000 others and follow Sean Hull on twitter @hullsean. In the past two years we’ve written a ton of material on scalability. Here’s the greatest hits… Why Generalists Are Better at Scaling the Web The internet stack is a complex infrastructure of interlocking components. An scalability engineer must be adept at Linux, plus webservers, […]

The post Scalability Tips & Greatest Hits appeared first on Scalable Startups.

3 Simple Patterns for Tighter MySQL Code
+0 Vote Up -0Vote Down

Join 8000 others and follow Sean Hull on twitter @hullsean. SQL is derided by many and for good reason. It’s key to scalability yet terribly difficult to write good code. Here’s a few quick tips to write tighter queries in MySQL 1. Get rid of those Subqueries! Subqueries are a standard part of SQL, unfortunately […]

The post 3 Simple Patterns for Tighter MySQL Code appeared first on Scalable Startups.

Scalability Happiness – A Quiet Query Log
+0 Vote Up -0Vote Down

Join 7500 others and follow Sean Hull on twitter @hullsean.

There’s a lot of talk on the web about scalability. Making web applications scale is not easy. The modern web architecture has so many moving parts. How can we grapple with the underlying problem?

Also: Why Are MySQL DBAs So Hard to Find?

The LAMP stack scales well

The truth that is half right. True there are a lot of moving parts, and a lot to setup. The internet stack made up of Linux, Apache, MySQL & PHP. LAMP as it’s called, was built to be resilient, dynamic, and scalable.

  [Read more...]
MySQL Subquery Optimization
+0 Vote Up -0Vote Down
Join 7000 others and follow Sean Hull on twitter @hullsean. MySQL’s optimizer can do a lot of things, but subqueries are not always handled well. Take a look at the IN subquery below. If you see the DEPENDENT SUBQUERY in your explain plan, you may want to take a second look. This will run slow [...]
3 Ways to Optimize for Paging in MySQL
+0 Vote Up -0Vote Down
Join 6100 others and follow Sean Hull on twitter @hullsean. Lots and lots of web applications need to page through information. From customer records, to the albums in your itunes collection. So as web developers and architects, it’s important that we do all this efficiently. Start by looking at how you’re fetching information from your [...]
MySQL for Devs, DBAs and Debutantes
+0 Vote Up -2Vote Down
Join 6500 others and follow Sean Hull on twitter @hullsean. I just received my copy of the 5th Edition of Paul DuBois’ MySQL tomb. Weighing in at 1153 pages, it’s a solid text, with a very thorough introduction to the topic of administering MySQL databases. Buy the book here: MySQL 5th Edition by Paul Dubois [...]
How to Optimize MySQL UNION For High Speed
+0 Vote Up -1Vote Down
Join 6100 others and follow Sean Hull on twitter @hullsean. There are two ways to speedup UNIONs in a MySQL database. First use UNION ALL if at all possible, and second try to push down your conditions. [mytweetlinks] 1. UNION ALL is much faster than UNION How does a UNION work? Imagine you have two [...]
The Most Important AWS Feature for Performance and Scalability
+0 Vote Up -3Vote Down
Join 6100 others and follow Sean Hull on twitter @hullsean. The Foundation of Speed All servers use disk to store files. Operating system libraries, webserver & application code, and most importantly databases all use disk constantly. So disk speed is crucial to server speed. [mytweetlinks] [quote] Disk speed is crucial for MySQL databases. It has [...]
Five More Things Deadly to Scalability
+0 Vote Up -0Vote Down

Read the original article at Five More Things Deadly to Scalability

Join 6000 others and follow Sean Hull on twitter @hullsean. 1. Slow Disk I/O – RAID 5 – Multi-tenant EBS Disk is the grounding of all your servers, and the base of their performance. True with larger and larger main memory, much is available in cache, a server still needs to constantly read from disk [...]

For more articles like these go to Sean Hull's Scalable Startups

Related posts:
  • Mobile Scalability – What is it and why is it important?
  • 3 Ways to Boost Cloud
  •   [Read more...]
    The Needle in Big Data Noise
    +0 Vote Up -0Vote Down

    Read the original article at The Needle in Big Data Noise

    Join 5500 others and follow Sean Hull on twitter @hullsean. Also take a look at: I hacked Disqus Digests to discover new blogs Who the heck is Bayes Thomas Bayes was a scientist & thinker, Fellow of the Royal Society, and back in 1763 author of “An Essay toward Solving a Problem in the Doctrine [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • Big Data – What is it and why is it important?
  • NYC Tech Firms Are Hiring – Map
  •   [Read more...]
    Make MySQL clustering work for you
    +0 Vote Up -1Vote Down
    We’ve told you all about MySQL mult-master replication’s limitations. If you write to two masters it is bound to fail for myriad reasons. Now what? Do what the pros do that’s what. A. Don’t write to both masters Using multi-master replication works great as long as you do so in active-passive mode. Never write to [...]
    Transaction isolation breaks when writing two masters
    +0 Vote Up -0Vote Down

    Read the original article at Transaction isolation breaks when writing two masters

    Continuing our discussion of multi-master replication, we hit on five more reasons why writing to two masters aka active-active replication is very dangerous. Click through to the end for multi-master solutions that work with MySQL. Reason 6 – You lose transaction isolation This may sound like a theoretical point to some. But hopefully we can [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • MySQL needs single master to check data integrity
  •   [Read more...]
    10 reaons active-active is hard and how to solve it
    +0 Vote Up -0Vote Down

    Read the original article at 10 reaons active-active is hard and how to solve it

    Multi-master replication provides redundant copies of your most important business assets. What’s more it allows applications to scale out, which is perfect for cloud hosting solutions like Amazon Web Services. But when you decide you need to scale your write capacity, you may be considering active-active setup. This is dangerous, messy and prone to failure. [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • Why does MySQL replication fail?
  •   [Read more...]
    Don’t Miss Percona Live 2013
    +0 Vote Up -0Vote Down

    Read the original article at Don’t Miss Percona Live 2013

    The biggest event on the MySQL calendar is the yearly Percona Live and it’s just around the corner. This year you’ll be able to pick from a whopping 110 technical sessions by 90 different speakers from companies like Facebook, Amazon, Google and Linkedin. Learn what’s happening at the cutting edge of open source database deployments. [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • Why you should attend Percona Live 2012
  • Hacking Job Search – Three Meaty Ideas
  • Why your cloud is speeding for a scalability cliff
    +0 Vote Up -0Vote Down

    Read the original article at Why your cloud is speeding for a scalability cliff

    Also find Sean Hull’s ramblings on twitter @hullsean. Don’t believe me that you’re headed for the cliff? A startup scales up to no avail Towards the end of 2012 I worked with an internet startup in the online education space. Their web application was not unusual, built in PHP and using Linux, Apache & Mysql [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • 3 Ways to Boost Cloud Scalability
  • Cloud Operations Interview
  •   [Read more...]
    Cloud DBA and Management Interview
    +1 Vote Up -0Vote Down

    Read the original article at Cloud DBA and Management Interview

    What does a cloud computing expert need to know? This is the last of a three part guide to interviewing for a cloud operations position. You can find them here – part one Operations Interview and part two Deployment Interview. Here’s my guide to do just that. 1. Database administration experience Although in some shops [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • Oracle DBA Interview Questions
  • Cloud Operations Interview
  •   [Read more...]
    Crisis Management in the Crosshairs – Sandy
    +0 Vote Up -1Vote Down

    Read the original article at Crisis Management in the Crosshairs – Sandy

    Crisis Management During Sandy

    The news this past week has brought endless images of devastation. All metropolitan region, the damage is apparent.

    More than once in conversation I’ve commented “That’s similar to what I do.” The response is often one of confusion. So I go on to clarify. Web operations is every bit about disaster recovery and crisis management in the datacenter. If you saw Con Edison down in the trenches you might not know how that power gets to your building, or what all those

      [Read more...]
    Cloud Deployment Interview
    +2 Vote Up -1Vote Down

    Read the original article at Cloud Deployment Interview

    What does a cloud computing expert need to know? In part one of the cloud interview guide we covered some basic unix & Linux systems administration skills, and cloud computing and infrastructure concepts. Those are key starting points. You might also want to jump to part 3 cloud dba, architecture and management interview questions.

    In this second part, let’s dig into deploying applications in the cloud, and day to

      [Read more...]
    Real Disaster Recovery Lessons from Sandy
    +0 Vote Up -1Vote Down

    Read the original article at Real Disaster Recovery Lessons from Sandy

    Also find Sean Hull’s ramblings on twitter @hullsean. Having just spent the last 24 hours in lower manhattan, while Hurricane Sandy rolled through, it’s offered some first hand lessons on disaster recovery. Watching the city and state officials, Con Edison, first responders and hospitals deal with the disaster brings some salient insights. 1. What are [...]

    For more articles like these go to Sean Hull's Scalable Startups

    Related posts:
  • What is disaster recovery and why is it important?
  • MySQL
  •   [Read more...]
    Cloud Operations Interview
    +1 Vote Up -0Vote Down

    Read the original article at Cloud Operations Interview

    What does a cloud computing expert need to know? How do you hire a cloud computing expert? Competition for operations & DBAs is fierce, so you’ll want to know how to find the best.

    If you’re a systems administrator or ops guy, you may want to prepare for an interview for such a position. Meanwhile, if you’re a director of it or operations, a recruiter or manager in HR, you’ll want to have some idea how to find the right candidate.

    Here’s my guide to do just that. You may

      [Read more...]
    AirBNB didn’t have to fail
    +0 Vote Up -0Vote Down

    Read the original article at AirBNB didn’t have to fail

    Today part of Amazon Web Services failed, taking down with it a slew of startups that all run on Amazon’s Cloud infrastructure. AirBNB was one of the biggest, but also Heroku, Reddit, Minecraft, Flipboard & Coursera down with it. Its not the first time. What the heck happened, and why should we care?

    1. Root Cause

    The AWS service allows companies like AirBNB to build web applications, and host them on servers owned and managed by Amazon.

      [Read more...]
    Showing entries 1 to 30 of 66 Next 30 Older Entries

    Planet MySQL © 1995, 2014, 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.