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 22

Displaying posts with tag: Database Operations (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 […]
No tools to reconcile MySQL with two masters
+0 Vote Up -0Vote Down
Here’s the last nail in the coffin. We hope this convinces you not to write to multiple masters with MySQL replication. Reason 10 – No tools to reconcile inconsistent masters For all the endless reasons we’ve already outlined MySQL replication is prone to failure. We know it’s going to happen, you now know too. When [...]
Temp tables can break replication
+0 Vote Up -0Vote Down
If you’re not convinced yet that writing to dual masters is a bad idea, we have a couple more reasons. 9. Temp tables break replication after restart MySQL’s replication is sensitive to temporary tables. You shouldn’t use them. If your queries create them to work against, and a node crashes, the temp tables will be [...]
Crashed nodes corrupt your MySQL cluster
+0 Vote Up -0Vote Down

Read the original article at Crashed nodes corrupt your MySQL cluster

Writing to two masters is like walking around with a loaded shotgun. Eventually one of your instances will fail and when it does, replications position & synchronization information could easily become corrupt! Reason 8 – Crashed nodes cause big problems MySQL instances, unfortunately can crash. When that happens, they don’t always sync the replication position [...]

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

Related posts:
  • MySQL Cluster In The Cloud – Managers Guide
  •   [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...]
    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...]
    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...]
    A History lesson for Cloud Detractors
    +0 Vote Up -0Vote Down

    Read the original article at A History lesson for Cloud Detractors

     

     

     

     

     

     

     

    We've all seen cloud computing discussed ad nauseam on blogs, on Twitter, Quora, Stack Exchange, your mom’s Facebook page... you get the idea. The tech bloggers and performance experts often pipe in with their graphs and statistics showing clearly that dollar-for-dollar, cloud hosted virtual servers can’t compete with physical servers in performance, so why is everyone pushing them? It's just foolhardy, they say.

    On the other end, management and their bean counters would

      [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

    Oracle Announces Paid MySQL Add-ons
    +0 Vote Up -0Vote Down
     Oracle starts charging for MySQL Add-ons

    Exciting news, Oracle just announced commercial MySQL extensions that they'll be offering paid extensions to the core MySQL free product.

    To be sure, this has raised waves of concern among the community, but on the whole I suspect it will be a good thing for MySQL.  This brings more commercial addons to the table, which only increases the options for customers.  Many will continue to use the core database product only, and avoid license hassles while others will surely embark on a hybrid approach if it solves their everyday business problems.

    Speaking of licensing, back in May, Amazon announced that it's RDS or Relational Database Service would now offer Oracle as an option.

      [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

    3 Biggest MySQL Migration Surprises
    +0 Vote Up -0Vote Down
    3 ways your MySQL migration project can shake you up

    Once a development or operations team gets over the hurdle of open-source, and start to feel comfortable with the way software works outside of the enterprise world, they will likely start to settle in and feel comfortable.  Best not to get too cushy though for there are more surprises hiding around the corner.  Here are a few of the biggest ones.

    1. Replication Is Not Perfect

    Yes, you've installed MySQL, setup a slave, and got it replicating properly.  You check the slave and it's 0 seconds behind the master.  What's more you monitor the error log file, and have a check in place to alert you if something happens there.  Job completed, good job!

    Not so fast.  Unfortunately this is not the end of the story.  Many MySQL replication slaves are not consistent with their masters, but they

      [Read more...]
    5 Things That Are Toxic to Scalability
    +0 Vote Up -0Vote Down
    Scalability is about application, architecture and infrastructure design, and careful management of server components.

    1. Object Relational Mappers

    ORMs are popular among developers but not among performance experts.  Why is that?  Primarily these two engineers experience a web application from entirely different perspectives.  One is building functionality, delivering features, and results are measured on fitting business requirements.  Performance and scalability are often low priorities at this stage.  ORMs allow developers to be much more productive, abstracting away the SQL difficulties of interacting with the backend datastore, and allowing them to concentrate on building the features and functionality.

    On the performance side the picture is a bit different.  By leaving SQL query writing to an ORM, you are faced with complex queries that

      [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...]
    8 Questions to ask an AWS Expert
    +0 Vote Up -0Vote Down

    If you're headhunting a cloud computing expert, specifically someone who knows Amazon Web Services (AWS) and EC2, you'll want to have a battery of questions to ask them to assess their knowledge.  As with any technical interview focus on concepts and big picture.  As the 37Signals folks like to say "hire for attitude, train for skill".  Absolutely!

    1. Explain Elastic Block Storage?  What type of performance can you expect?  How do you back it up?  How do you improve performance?

    EBS is a virtualized SAN or storage area network.  That means it is RAID storage to start with so it's redundant and fault tolerant.  If disks die in that RAID you don't lose data.  Great!  It is also virtualized, so you can provision and allocate storage, and attach it to your server with various API

      [Read more...]
    7 Ways to Troubleshoot MySQL
    +0 Vote Up -0Vote Down

    MySQL databases are great work horses of the internet.  They back tons of modern websites, from blogs and checkout carts, to huge sites like Facebook.  But these technologies don't run themselves.  When you're faced with a system that is slowing down, you'll need the right tools to diagnose and troubleshoot the problem.  MySQL has a huge community following and that means scores of great tools for your toolbox. Here are 7 ways to troubleshoot MySQL.

    1. Use innotop

    Innotop is a great tool for MySQL which despite the name monitors MySQL generally as well as InnoDB usage.  It's fairly easy to install, just download the perl script. Be sure to include a [client] section to your local users .my.cnf file (you have one don't you?).  Inside that section, place one line with "user=xyz" and one line with "password=abc".

    If you're concerned that

      [Read more...]
    MySQL Consulting – MySQL Services – MySQL Expert
    +0 Vote Up -0Vote Down

    Call or SKYPE us in New York City: +1-212-533-6828

    MySQL in the Cloud

    • Deploying MySQL in the Cloud
    • Cloud Security considerations for databases
    • Deploying in multiple Availability Zones
    • Deploying in multiple regions
    • Deploying MySQL with multi-az
    • Horizontal scalability in the cloud
    • MySQL spinup scripts
    • Deploying Amazon RDS
    • Evaluating RDS
    • Evaluating MySQL in the cloud
    • EBS Performance considerations
    • Tuning MySQL parameters in the cloud
    • Backup types & options
    • Mitigating against cloud server failure
    • Vertical scalability & MySQL on EC2

    MySQL Consulting and Services

    • Backup & recovery
    • MySQL master master replication
    • MySQL replication & horizontal
      [Read more...]
    3 Ways to Boost Cloud Scalability
    +0 Vote Up -0Vote Down

    Deploying in the Amazon cloud is touted as a great way to achieve high scalability while paying only for the computing power you use. How do you get the best scalability from the technology?

    1. Use Auto-scaling

    Auto-scaling is a unique feature of cloud computing and Amazon's EC2 offering. Setup a load balancer and a couple of webservers for your application as you normally would. Design your webserver based on a template AMI that you'll reuse over and over. Then setup auto-scaling and set thresholds based on the traffic you forecast. When a threshold is passed, AWS will spinup a new instance of your webserver, and roll it into the load balancer pool

      [Read more...]
    5 Ways to Boost MySQL Scalability
    +0 Vote Up -0Vote Down

    There are a lot of scalability challenges we see with clients over and over. The list could easily include 20, 50 or even 100 items, but we shortened it down to the biggest five issues we see.

    1. Tune those queries

    By far the biggest bang for your buck is query optimization. Queries can be functionally correct and meet business requirements without being stress tested for high traffic and high load. This is why we often see clients with growing pains, and scalability challenges as their site becomes more popular. This also makes sense. It wouldn't necessarily be a good use of time to tune a query for some page off in a remote corner of your site, that didn't receive

      [Read more...]
    Showing entries 1 to 22

    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.