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

Displaying posts with tag: Database Migrations (reset)

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...]
    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...]
    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...]
    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...]
    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...]
    Showing entries 1 to 5

    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.