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 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 67 Next 7 Older Entries

Displaying posts with tag: All (reset)

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...]
Why do people leave consulting?
+0 Vote Up -3Vote Down

Read the original article at Why do people leave consulting?

As a long time freelancer, it’s a question that’s intrigued me for some time. I do have some theories… First, definitions… I’m not talking about working for a large consulting firm. Although this role may be called “consultant”, my meaning is consultant as sole proprietor, entrepreneur, gun for hire or lone wolf. 1. Make more [...]

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

Related posts:
  • Consulting essentials: Getting the business
  • Hiring is a numbers
  •   [Read more...]
    Thoughts on Upcoming MySQL 5.6 Defaults
    +0 Vote Up -0Vote Down

    Read the original article at Thoughts on Upcoming MySQL 5.6 Defaults

    During Oracle Open World 2012 and the parallel MySQL Connect conference, the new 5.6 version was announced. It’s only release candidate right now, but that means the GA release is just around the corner. With that James Day has posted changes to various of the new parameter defaults. Many of them you may not run [...]

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

    Related posts:
  • 5 Ways to Boost MySQL Scalability
  • 5 Ways to fortify MySQL replication
  •   [Read more...]
    Anatomy of a Performance Review
    +0 Vote Up -0Vote Down

    Read the original article at Anatomy of a Performance Review

    A lot of firms come to us with a specific scalability problem. “Our user base is growing rapidly and the website is falling over!” Or they’re selling more widgets, “Our shopping cart is slowing down and we’re seeing users abandon their purchases”. These are real startup growing pains, so what to do?

    We like to take a measured approach with these types of challenges, so we thought it would be helpful to run through a hypothetical scenario and see how we work.

    Having trouble with scalability? Check out our

      [Read more...]
    10 ways I avoid trouble in database operations
    +0 Vote Up -1Vote Down

    Read the original article at 10 ways I avoid trouble in database operations

    1. Avoid destructive commands From time to time I’m working with new recruits and bringing them up to speed in operations. The first thing I emphasize is care with destructive commands. What do I mean here? Well there are all sorts of them. SQL commands such as DROP table & DROP database. But also TRUNCATE [...]

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

    Related posts:
  • 5 Ways to Avoid EC2 Outages
  • 7 Ways to Troubleshoot MySQL
  •   [Read more...]
    Hiring is a numbers game
    +1 Vote Up -2Vote Down

    Read the original article at Hiring is a numbers game


    On a recent twitter chat (#hfchat) I posted some comments about hiring. Some folks were complaining that they had applied to various jobs, and not heard back.

    I commented…

    Apply for a job and don’t hear back, it’s nothing personal

    In today’s market, there are hundreds of job applicants for every position. Sad to say, but that means things become a blur after a while. There’s less chance to sift each candidate and find out who they really are or what they really know. It’s more about keywords, and buzzwords if you must, to get your


      [Read more...]
    Why you should attend Percona Live 2012
    +1 Vote Up -1Vote Down

    Read the original article at Why you should attend Percona Live 2012

    What I loved about Percona Live 2011 Last year I was excited to go to Percona Live for the first time in NYC. I arrived just in time to hear Harrison Fisk from Facebook speak about some of the awesome tweaks they’re running with MySQL there. It’s not everyday that you get to hear from [...]

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

    No related posts.
    Upcoming for Scalable Startups
    +0 Vote Up -2Vote Down

    Read the original article at Upcoming for Scalable Startups

    Just back from the Labor Day holiday, and ready to dive back in.

    I thought this would be a great time to outline some of our upcoming topics so here goes…

    1. Why Oracle usability sucks

    - a rant about Oracle’s weak points

    In the meantime take a peek at our piece on why we wrote the book on Oracle & Open Source. We ruminate on trends in the datacenter and take a stab at Oracle’s future.

    2. Why relational databases don’t scale

    - Is there any such thing as automatic scalability?
    - What blocks scalability?
    - Are NoSQL databases magic?

    Also one of our articles that went viral –



      [Read more...]
    31 Essential Blogs for Startups & Scalability
    +0 Vote Up -0Vote Down

    Read the original article at 31 Essential Blogs for Startups & Scalability

    So many blogs, so little time! Here’s our list of the best we’ve found. Currently our favorite reader is Pulse pictured left. Starting to play around with flipboard too.

    Nuts & Bolts Technical

    Slashdot
    One of the original tech blogs, that still covers lots of breaking news, and difficult topics. Very technical, with probing commentary. Beware the actual comments though, as they’re often full of immature

      [Read more...]
    5 Things You Overlooked with MySQL Dumps
    +1 Vote Up -1Vote Down

    Read the original article at 5 Things You Overlooked with MySQL Dumps

    1. Point In Time Recovery If you’ve never done point in time recovery, it’s time to take a second look. With a standard mysqldump you restore your database to the time when the backup happened. Only do them once a day, then you can lose as much as 24 hours of data. Enter point-in-time recovery, [...]

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

    Related posts:
  • Ten things to remember about MySQL backups
  • Easy MySQL replication with hotbackups
  •   [Read more...]
    Beware the sales wolf in sheep suits
    +0 Vote Up -0Vote Down

    Read the original article at Beware the sales wolf in sheep suits

    Recently a colleague called me up to get my opinion. Therein lies the eternal drama in organizations, the push & pull between dollars and technology best practices. We had a similar experience with a MySQL deployment, and solution framed by Oracle sales. Battle lines are drawn Clearly the battle lines are drawn now. Between director [...]

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

    Related posts:
  • Beware the client
  • Open Insights 22 – Beware of Software Fashion
  •   [Read more...]
    Juggling apples & oranges in the datacenter
    +2 Vote Up -1Vote Down

    Read the original article at Juggling apples & oranges in the datacenter

    In which a few choice words become one serious accident… The Backstory More than five years ago now, I worked for a shop in the business of news & information around the legal and real estate sectors. It was a fairly large organization with a number of Oracle and MySQL backed applications. The whole place [...]

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

    Related posts:
  • Open Insights 02 – Consulting Apples and Oranges
  • Open Insights 16 – Success In Juggling
  • Opportunity a day – career risk at bay
    +0 Vote Up -1Vote Down

    Read the original article at Opportunity a day – career risk at bay

    Free Agent. Stress Test. Avoid Sameness

    As the globalization juggernaut rolls on, it continues to create more Detroits. Skills and perspectives quickly become obsolete.

    What to do in the face of such change?

    Small fires prevent the big burn

    So there’s your quick answer. Get the book if you want more!

    Some related material: why is it so hard to find a mysql dba?.

      [Read more...]
    Sometimes… let things break a little
    +0 Vote Up -0Vote Down

    Read the original article at Sometimes… let things break a little

    Have you ever started a new project, just into it you realize that maybe there aren’t technical problems to solve? It starts to dawn on you the real crux of the problem boils down to people & processes?

    It’s happened to me on a number of occasions, but once in particular really stands out for me.

    I was working for a firm in the education space, in particular around test preparations.

    Asked to automate a publish process

    The environment had a mix of relational databases, from SQL*Server to MySQL for some applications. The web facing database

      [Read more...]
    Oracle DBAs… You Know You Want MySQL!
    +1 Vote Up -1Vote Down

    Read the original article at Oracle DBAs… You Know You Want MySQL!

    If you’re an Oracle DBA or developer and considering migrating an application over to MySQL you probably have a lot of questions. Here’s a five minute summary of what you should know. Looking to hire a top flight MySQL DBA? Check out our MySQL interview guide. What is truly delicious o a command line that’s [...]

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

    Related posts:
  • Migrating MySQL to Oracle Guide
  • MySQL Cluster In The Cloud – Managers Guide
  •   [Read more...]
    Why I Wrote the Book – Oracle and Open Source
    +0 Vote Up -3Vote Down

    Read the original article at Why I Wrote the Book – Oracle and Open Source

    Back in the late 90′s New York City was deep in the dot-com boom. Silicon Alley was being born, and a thousand internet startups were sprouting. Everyone was hiring, it was an exciting time to work in technology!

    Trend Spotting Circa 2000

    As an independent consultant, I had the opportunity to work at quite a few startups. The technology stack was identical at almost all of them. Sun Microsystems hardware, Apache webservers, and Oracle on the backend. The database was always the sticking point, and developers

      [Read more...]
    A CTO Must Never Do This…
    +0 Vote Up -4Vote Down

    Read the original article at A CTO Must Never Do This…

    A couple years back I was contacted to look at a very strange problem.

    The firm ran flash sales. An email goes out at noon, the website traffic explodes for a couple of hours, then settles back down to a trickle.

    Of course you might imagine where this is going. During that peak, the MySQL database was brought to its knees. I was asked to do analysis during this peak load, and identify and fix problems. Make it go faster, please!

    First day on the job I’m working with a team of outsourced DBAs. I was also working

      [Read more...]
    Accidental DBA’s Guide to MySQL Management
    +0 Vote Up -1Vote Down

    Read the original article at Accidental DBA’s Guide to MySQL Management

    So you’ve been tasked with managing the MySQL databases in your environment, but you’re not sure where to start.  Here’s the quick & dirty guide. Oh yeah, and for those who love our stuff, take a look to your right. See that subscribe button? Grab our newsletter!

    1. Installation

    The “yum” tool is your friend.  If you’re using debian, you’ll use apt-get but it’s very similar. You can do a “yum list” to see what packages are available. We prefer to use the Percona distribution of

      [Read more...]
    The Art of Resistance
    +1 Vote Up -1Vote Down

    Read the original article at The Art of Resistance

    Sometimes, you have to be the bad guy. Be resistant to change. Here’s a story about how stubbornness pays off. As we’ve written about before A 4 letter word divides Dev & Ops.

    I had one experience working as the primary MySQL DBA for an internet startup. Turns out they had Oracle for some applications too. And another DBA just to handle the Oracle stuff.

    So it came time for Oracle guy to go on vacation. Suddenly these Oracle systems landed on my shoulders. We reviewed

      [Read more...]
    Road War Story – Hacking Inflight Solutions
    +0 Vote Up -0Vote Down

    Read the original article at Road War Story – Hacking Inflight Solutions

     

    The 2am phone call

    Last summer I got my call from the president at 2am.  Actually it was my former boss at Hollywood Reporter.  I had worked there three months previous, and they had since hired an outsourced DBA solution.  Big outsource, big chops.  And big fail.

     

     

    12 hours to liftoff

    I was scrambling to pack my luggage to go on summer vacation.  I was bound for SF at the moment and my flight was leaving in the morning.  I was trying to wrap up loose ends and my

      [Read more...]
    RDS or MySQL – Ten Use Cases
    +0 Vote Up -0Vote Down

    Read the original article at RDS or MySQL – Ten Use Cases

    Amazon’s Relational Database Service is based on MySQL under the hood.  So many colleagues and clients ask me – should I go with RDS or MySQL? As with every technology question, the answer is – it depends.

    Here are some scenarios to help you decide.

  • I’m replicating into Amazon from a physical datacenter
  • A: This setup is common if you’re using Amazon’s VPC or Virtual Private Cloud.  With a router dropped into your datacenter, VPC allows you to extend and spinup virtual instances from Amazon as if they’re sitting in your own existing datacenter.  Great stuff, but you won’t be able to replicate from your existing

      [Read more...]
    What Recession? – New York Tech Hiring Frenzy
    +0 Vote Up -0Vote Down

    Read the original article at What Recession? – New York Tech Hiring Frenzy

    According to Crains, New York is digital jobs central.  ZocDoc, Thrillist, Foursquare and 10gen are just a few of the hot shots located at 568 Broadway, a tech hub in Soho.  Each of these firms is looking to double their headcount in the coming year.  Not bad considering the rough shape much of the economy is in.

    Don’t Forget the Big Boys

    Let’s not forget the huge tech firms that are also on a hiring binge,  Google, Facebook, Zynga, Twitter & Skype are all hiring.  Bloomberg Businessweek describes it

      [Read more...]
    Best of Guide – Highlights of Our Popular Content
    +0 Vote Up -0Vote Down

    Read the original article at Best of Guide – Highlights of Our Popular Content

    We cherry pick the top 5 most popular posts of various topics we’ve covered in recent months.

      [Read more...]
    Consulting essentials: Building your business
    +0 Vote Up -0Vote Down

    Read the original article at Consulting essentials: Building your business

    In the last two posts on how to build a successful consulting business I shared advice and tips on closing deals and managing and completing your engagements.

    This post will look at where to focus your efforts in order to sustain your consulting business, and build skills.

    Focus on your subject matter expertise

    Being a subject matter expert takes years of education, and professional experience to build. It’s your

      [Read more...]
    Consulting essentials: Managing & Completing Engagements
    +0 Vote Up -0Vote Down

    Read the original article at Consulting essentials: Managing & Completing Engagements

    This is the second in a series of three articles on Consulting Essentials.
    Read the previous post, Consulting essentials: Getting the business

    Communicating well and knowing when to step in or stand back is the linchpin of successful consulting.
    Some people have natural charm. If you’re one of these people you’ll find consulting is definitely for you. You’ll use that skill all the time as each new client brings a half dozen or a dozen new people to interact with.

    If it doesn’t come easily, practice practice practice. Try to get out of your own head



      [Read more...]
    Consulting essentials: Getting the business
    +0 Vote Up -0Vote Down

    Read the original article at Consulting essentials: Getting the business

    Over the years, a lot of people have approached me asking how to become a tech consultant. What do I need to do to get started? How can I take my first step?

    I also hear from managers and CEOs that have asked how I got my start, and how I keep the business running. What lessons from consulting can be applied to startups and small businesses? Having worked independently for many years I’ve built up my own cache of strategies and methods which I hope can be helpful to anyone looking to strike it out on their own.

    This

      [Read more...]
    Tyranny of a Google vote
    +1 Vote Up -0Vote Down

    Read the original article at Tyranny of a Google vote

    Image by Hajo de Reijger, politicallyillustrated.com

    For the past year I’ve been seeing headline blogs analyzing the effect of Google’s last algorithm update, dubbed the Panda. There was much talk of unfair relegation from the first page of Google search results, and general indignance by the SEO community.

    As with any subject in which I only have cursory knowledge I didn’t think much of it. I thought that as long as I didn’t engage in link-buying and whatever is known as “black hat” tactics, the search engines would be fair. What I didn’t realise with Google was how

      [Read more...]
    Bulletproofing MySQL replication with checksums
    +0 Vote Up -0Vote Down

    Read the original article at Bulletproofing MySQL replication with checksums


    Your MySQL replications running well? You might not even know if they aren’t. One of the scariest things about MySQL replication is that it can drift out of sync with the master “silently”. No errors, no warnings.

  • What and Why?
  • MySQL’s replication solution evolved as a statement based technology. Instead of sending actual block changes, MySQL just has to log committed transactions, and reapply those on the slave side. This affords a wonderful array of topologies and different uses, but


      [Read more...]
    5 Ways to fortify MySQL replication
    +1 Vote Up -2Vote Down

    Read the original article at 5 Ways to fortify MySQL replication

    MySQL replication technology is powerful and flexible. But it doesn’t do everything perfectly all the time. You may experience trouble with the slaves falling behind the master, or want to scale horizontally by building new slaves automatically. Or you might need to build a slave without blocking the master database.

    All of these goals can be achieved using some powerful tools. Here’s a quick guide to those tools and how to use them.

  • Build new Replicas without Downtime
  • Something we’re sure you need to do quite often is to build new slaves. You can

      [Read more...]
    Easy MySQL replication with hotbackups
    +0 Vote Up -0Vote Down

    Read the original article at Easy MySQL replication with hotbackups

    Setting up replication in MySQL is something we need to do quite often. Slaves die, replication fails, or tables and data get out of sync. Whenever we build a slave, we must start with a snapshot of all the data from the master database.

    MySQLdump is the tried and true method of doing this, however it requires that we lock all the tables in the database. If we’re dumping a large database, this could be a significant period, where no writing can happen to our database for the duration of the backup. For many environments read-only is

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 67 Next 7 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.