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 107 Next 30 Older Entries

Displaying posts with tag: Database Management (reset)

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...]
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...]
    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...]
    Ten things to remember about MySQL backups
    +0 Vote Up -1Vote Down

    Read the original article at Ten things to remember about MySQL backups

  • Use Hot Backups
  • Hot backups are an excellent way to backup MySQL.  They can run without blocking your application, and save tons on restore time.  Percona’s xtrabackup tool is a great way to do this.  We wrote a how-to on using xtrabackup for hotbackups.

  • Use Logical Backups
  • Just because we love hot backups using xtrabackup doesn’t mean mysqldump isn’t useful.  Want to load data into Amazon RDS?  Want to isolate and load only one schema, or just

      [Read more...]
    New Monitis MySQL Monitoring Tool’s Video
    +0 Vote Up -0Vote Down

    MySQL is the world’s most popular open-source database and platform for millions of web applications – it’s critical but cumbersome to monitor.

    Monitis’ MySQL monitoring provides three key benefits:

    » 246 potential monitoring variables
    » 21 aggregated, percentage-based metrics
    » Adjustable thresholds to separate real issues from false alarms


    » Monitor entire IT universe from one dashboard
    » Quick diagnosis & root cause detection

    » Cloud-based means no need to install, update or maintain it
    » Leaves you time to focus on more important things

    For a FREE trial, go to:


    New! Cloud-based MySQL Database Monitoring from Monitis
    +0 Vote Up -0Vote Down

    New feature provides significantly faster insight and root cause analysis

    SAN JOSE, Calif., February, 15, 2012Monitis, the leading cloud and web application monitoring software provider, today announces that it has added comprehensive MySQL database monitoring to its award-winning Application Performance Management & Monitoring platform. The robust Software-as-a-Service (SaaS) tool enables users to gain significantly faster insight when conducting root cause analysis.

    The MySQL monitoring feature includes 246 monitoring variables and more than 21 different metrics to provide one of the easiest to use, yet comprehensive database monitoring tools

      [Read more...]
    M3 code refactor & DBI support
    +0 Vote Up -2Vote Down

    Pluggable M3 (Monitis Monitor Manager) Framework

    Who needs an introduction about M3? – Perhaps no one!
    After gaining some reputation with M3, providing extra-easy integration of any monitor into Monitis it was time to take it to the next level.

    Generally speaking, the work flow of M3 was described in detail in this article.

    After some thought and design, we’ve decided it’d be best if M3 was pluggable. Pluggable in

      [Read more...]
    The Mythical MySQL DBA
    +2 Vote Up -0Vote Down

    Read the original article at The Mythical MySQL DBA

    I’ve  been getting more than my fair share of calls from recruiters of late. Even in this depressed economic climate where jobs are rarer than a cab at rush-hour, it’s heartening to know that tech engineers are in great demand. And it’s even more heartening to think that demand for MySQL DBAs has never been better.

    My reckoning was confirmed by a Bloomberg news report about stalwart retailers suffering from a dearth of talented engineers. Bloomberg cited Target’s outage-prone e-commerce site as a symptom of, among other things the market’s shortage. One of the challenges old-timers like Target face is having to compete with Silicon Valley startups

      [Read more...]
    Book Review – Effective MySQL
    +3 Vote Up -0Vote Down

    Read the original article at Book Review – Effective MySQL

    Effective MySQL: Optimizing SQL Statements by Ronald Bradford No Nonsense, Readable, Practical, and Compact I like that this book is small; 150 pages means you can carry it easily.  It’s also very no nonsense.  It does not dig too deeply into theory unless it directly relates to your day-to-day needs.  And those needs probably cluster [...]

    For more articles like these go to iHeavy, Inc +1-212-533-6828

    18 LAMP Security Tips for MySQL
    +0 Vote Up -0Vote Down

    Linux, Apache, MySQL and PHP — altogether they mean LAMP. I’m not talking about watts and bulbs.

    And if you desire is for a comprehensive, robust server, your IT infrastructure has to include all of these systems.

    Monitis has put together a checklist of 101 actions you can take to maximize security around LAMP.  Hopefully we’re shedding a little light around this issue for you to give you some new ideas on how to make

      [Read more...]
    Webinar: NoSQL, NewSQL, Hadoop and the future of Big Data management
    +0 Vote Up -0Vote Down

    Join me for a webinar where I discuss how the recent changes and trends in big data management effect the enterprise.  This event is sponsored by Red Rock and RockSolid.


    It is an exciting and interesting time to be involved in data. More change of influence has occurred in the database management in the last 18 months than has occurred in the last 18 years. New technologies such as NoSQL & Hadoop and radical redesigns of existing technologies, like NewSQL , will change dramatically how we manage data moving forward. 

    These technologies bring with them possibilities both in terms of the scale of data

      [Read more...]
    Got open source cloud storage? Red Hat buys Gluster
    +0 Vote Up -0Vote Down

    Red Hat’s $136m acquisition of open source storage vendor Gluster marks Red Hat’s biggest buy since JBoss and starts the fourth quarter with a very intersting deal. The acquisition is definitely good for Red Hat since it bolsters its Cloud Forms IaaS and OpenShift PaaS technology and strategy with storage, which is often the starting point for enterprise and service provider cloud computing deployments. The acquisition also gives Red Hat another weapon in its fight against VMware, Microsoft and others, including OpenStack, of which Gluster is a member (more on that further down). The deal is also good for Gluster given the sizeable price Red Hat is paying for the provider of open source, software-based, scale-out storage for unstructured data and also as validation of both open source and software in

      [Read more...]
    iHeavy Newsletter 84 – Restaurant Scalability
    +0 Vote Up -0Vote Down

    Restaurant Scalability

    Could pro-waitering serve up some lessons on web scalability? Observing peak hour dining at a New York restaurant gave us some insight.

    I was dining at a restaurant the other day with friends. It was a warm and cozy place, nicely decorated with a long, narrow dining room.  The food was scrumptious, yet we were getting increasingly frustrated by the service as the night went along.

    With some waiting experience behind me, I could immediately see the problem. The waiters, probably through lack of experience, were making the mistake of doing one thing at a time.  They would go to a table, respond to one

      [Read more...]
    What is the biggest challenge for Big Data?
    +0 Vote Up -0Vote Down

    Often I think about challenges that organizations face with “Big Data”.  While Big Data is a generic and over used term, what I am really referring to is an organizations ability to disseminate, understand and ultimately benefit from increasing volumes of data.  It is almost without question that in the future customers will be won/lost, competitive advantage will be gained/forfeited and businesses will succeed/fail based on their ability to leverage their data assets.

    It may be surprising what I think are the near term challenges.  Largely I don’t think these are purely technical.  There are enough wheels in motion now to almost guarantee that data accessibility will continue to improve at pace in-line with the increase in data volume.  Sure, there will continue to be lots of interesting innovation with technology, but

      [Read more...]
    NSA, Accumulo & Hadoop
    +0 Vote Up -0Vote Down

    Reading yesterday that the NSA has submitted a proposal to Apache to incubate their Accumulo platform.  This, according to the description, is a key/value store built over Hadoop which appears to provide similar function to HBase except it provides “cell level access labels” to allow fine grained access control.  This is something you would expect as a requirement for many applications built at government agencies like the NSA.  But this also is very important for organizations in health care and law enforcement etc where strict control is required to large volumes of privacy sensitive data.

    An interesting part of this is how it highlights the acceptance of Hadoop.

      [Read more...]
    Apache and MySQL Logging with Syslog-ng
    +0 Vote Up -0Vote Down

    Apache and syslog-ng

    While logging to a database back-end has its benefits, the setup as it stands leaves us wanting. Some applications, such as Apache, do not log via syslog-ng by default. The good news is that this can be easily remedied, and there are a couple of different ways of doing this. First, the less good way:

    Method #1: Changing the Apache configuration file.

    First, we need to setup syslog-ng appropriately by creating a new source for apache, such as the following:

    source s_apache {
      [Read more...]
    MySQL Database Management Expert – Database Management Consultant – Database Management Services
    +0 Vote Up -0Vote Down

    Database Administration and Management is as important under MySQL as it is under other enterprise database platforms such as Oracle or SQL Server.  Be proactive with your database operations, and avoid outage or loss of your most crucial data.

    • MySQL Management and administration
    • MySQL Performance, Optimization & tuning
    • Remote Database Management
    • Database monitoring & metrics collection
    • MySQL Security Auditing
    • Migrating applications and data to MySQL
    • Migrating MySQL to the Amazon cloud
    • Migrating MySQL to Amazon RDS
    • Amazon RDS management & administration
    • MySQL scalability
    • Amazon RDS scalability
    • MySQL High Availability
    • MySQL Disaster Recovery
    • Database Management & replication for highly available architectures
    • Database security in the cloud

    Skype or call us in NYC at +1-212-533-6828

    Basic Apache and MySQL Performance Tuning: Part 2: MySQL
    +0 Vote Up -0Vote Down

    MySQL Tuning

    This is another section that is broader than one would first imagine.  There’s a reason that many large organizations employ dedicated database administrators.  That said, this doesn’t prevent the average sysadmin from making some changes to enhance performance on their database.

    The easiest way to start on this is to utilize a script to automatically check your configuration options and make suggestions based on status variables MySQL sets.  I’ve had good luck with a script called mysqltuner.pl.  You can

      [Read more...]
    5 Tips for Better Database Change Management
    +0 Vote Up -0Vote Down

    Read the original article at 5 Tips for Better Database Change Management

    Deploying new code that includes changes to your database schema doesn't have to be a process fraught with stress and burned fingers. Follow these five tips and enjoy a good nights sleep.

    1. Deploy with Roll Forward & Rollback Scripts

    When developers check-in code that requires schema changes, that release should also require two scripts to perform database changes. One script will apply those changes, alter tables to add columns, change data types, seed data, clean data, create new tables, views, stored procedures, functions, triggers and so forth. A release should also include a rollback script, which would return tables to their previous state.

    This idea of

      [Read more...]
    Top 3 Questions From Clients
    +0 Vote Up -0Vote Down

    1. This page or area of the website is very slow, why?

    There are a lot of components that make up modern internet websites, and a lot of places to get stuck in the mud.  Website performance starts with the browser, what caching it is doing, their bandwidth to your server, what the webserver is doing (caching or not and how), if the webserver has sufficient memory, and then what the application code is doing and lastly how it is interacting with the backend database.

    With all this complexity, it's no wonder so many sites struggle.  Typically these types of analysis start with some load testing, to stress test your setup, so you can watch for leaks.  Then

      [Read more...]
    Specialty Technology Consultant – New York Scalability Consultant – MySQL & EC2 Scalability
    +0 Vote Up -0Vote Down

    Amazon EC2 and cloud computing offer great promise for startups to ramp up their online presence quickly.  Navigate those challenges with an strong partner.  We bring 20 years experience to the table with each new client.

    • Scaling Web Applications
    • MySQL High Availability in Amazon EC2
    • Amazon Multi-AZ Deployments
    • Amazon RDS Deployments
    • Migrating to Amazon EC2
    • Migrating to MySQL
    • Managing Backups and Disaster Recovery in the Cloud
    • Horizontal Scalability of MySQL on EC2
    • Horizontal Scalability on Cloud Hosted Servers
    • Evaluating Cloud Providers
    • Evaluating MySQL
      [Read more...]
    Reply to The Future of the NoSQL, SQL, and RDBMS Markets
    +0 Vote Up -0Vote Down

    Conor O'Mahony over at IBM wrote a good post on a favorite topic of mine “The Future of the NoSQL, SQL, and RDBMS Markets”.  If this is of interest to you then I suggest you read his original post.  I replied in the comments but thought I would also repost my reply here.


    Hi Connor, I wish it was as simple as SQL & RDBMS is good for this and NoSQL is good for that.  For me at least, the waters are much muddier than that.

    The benefit of SQL & RDBMS is

      [Read more...]
    IA Ventures - Jobs shout out
    +0 Vote Up -0Vote Down

    My friends over at IA Ventures are looking both for an Analyst and for an Associate to their team.  If Big Data, New York and start-ups is in your blood then I can’t think of a better VC to be involved in. 

    From the IA blog:

    "IA Ventures funds early-stage Big Data companies creating competitive advantage through data and we’re looking for two start-up junkies to join our team – one full-time associate / community manager and one full time analyst. Because there are only four of us (we’re a start-up ourselves, in fact), we’ll need you to help us investigate companies, learn about industries, develop investment theses, perform internal operations, organize

      [Read more...]
    Realtime Data Pipelines
    +0 Vote Up -0Vote Down

    In life there are really two major types of data analytics.  Firstly, we don’t know what we want to know – so we need analytics to tell us what is interesting.  This is broadly called discovery.  Secondly, we already know what we want to know – we just need analytics to tell us this information, often repeatedly and as quickly as possible.  This is called anything from reporting or dashboarding through more general data transformation and so on.

    Typically we are using the same techniques to achieve this.  We shove lots of data into a repository of some from (SQL, MPP SQL, NoSQL, HDFS etc) then run queries/ jobs/ processes across that data to retrieve the information we care about.  

    Now this makes sense for data discovery.  If we don’t know what we want to know, having lots of data in a big pile that we can slice and dice

      [Read more...]
    What Scales Best?
    +0 Vote Up -0Vote Down

    It is a constant, yet interesting debate in the world of big data.  What scales best?  OldSQL, NoSQL, NewSQL?

    I have a longer post coming on this soon.  But for now, let me make the following comments.  Generally, most data technologies can be made to scale - somehow.  Scaling up tends not to be too much of an issue, scaling out is where the difficulties begin.  Yet, most data technologies can be scaled in one form or another to meet a data challenge even if the result isn’t pretty. 

    What is best?  Well that comes down to the resulting complexity, cost, performance and other trade-offs.  Trade-offs are key as there are almost always significant concessions to be made as you scale up.

    A recent example of mine, I was looking at scalability aspects of MySQL.  In particular, MySQL Cluster

      [Read more...]
    MySQL Database Monitoring Best Practices
    +0 Vote Up -0Vote Down

    The MySQL database is a crucial part of a wide variety of products, particularly web applications. Naturally, it is very important to monitor the health status of MySQL.  However, there is constant disagreement on which of the many MySQL status variables provide the best overview on MySQL health status and indicate that something is not right with a server.

    It certainly depends on what your application does – tuning read performance is different than optimizing write operations and everything changes when you have a cluster. The average user can use small subset of variables while advanced user want to get more detailed picture of the situation. So there cannot be one set of “magic variables” to quietly optimize every situation. However, it is possible to have

      [Read more...]
    101 Tips to MySQL Tuning and Optimization
    +0 Vote Up -0Vote Down


    MySQL is a powerful open-source database.  With more and more database driven applications, people have been pushing MySQL to its limits.  Here are 101 tips for tuning and optimizing your MySQL install.  Some tips are specific to the environment they are installed on, but the concepts are universal.   I have divided them up into several categories to help you with getting the most out of MySQL:


    MySQL Server Hardware and OS Tuning:


      [Read more...]
    Who/What to acquire next
    +1 Vote Up -0Vote Down

    Well as predicted, with Aster Data recently being picked up by Teradata most of the key new generation MPP distributed analytics vendors have been acquired (Aster Data, Vertica, Netezza & Greenplum).  This had to happen and was expected to happen.  The MPP Analytics startup “revolution” is over and these technologies will now be integrated into the mainstream.

    So what’s next?  As we now, if you are a massive multi-national software company it is a lot less risky to incrementally innovate and leave the development of “game changing” technologies to startups that can be acquired after

      [Read more...]
    What’s hot in Big Data startups?
    +0 Vote Up -0Vote Down

    There are so, so many big data platforms in play at the moment it can be confusing for developers to know where to start.  For startups it used to be simple, MySQL, but dust clouds were created when all the NoSQL platforms started to crash the party 18 months or so ago.  But I do see the dust begin to settle and we are starting to see some market “leaders” appear.  A very unscientific approach is to list the technologies I hear about in the “big data startup” world on a daily basis.  These are, in no particular order:

    • MySQL - yes it is still very much hanging in there despite the Oracle acquisition.  MySQL has been helped by technologies such as AWS RDS and Xeround making it more digestible for big data startups who want
      [Read more...]
    Some NoSQL Myths
    +6 Vote Up -0Vote Down

    I have been busy travelling recently but thought I would jot down a couple of NoSQL myths that are fresh in my head from my recent discussions.

    • Twitter use Cassandra internally but have not migrated their tweet store, despite their earlier plans to.  For now tweets are still stored in MySQL.
    • Despite the widely accepted view that the use of Cassandra led to Diggs issues a couple of Digg engineers have apparently discounted this.
    • Despite the widely accepted view that NoSQL databases all use eventual consistency this is not so.  HBase, for example, offers full consistency.
    • Despite the widely accepted view that NoSQL is only
      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 107 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.