Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 618 10 Older Entries

Displaying posts with tag: database (reset)

A Brief Introduction to MySQL Fabric
Employee +2 Vote Up -0Vote Down

As you saw on the keynote, we are introducing an integrated framework for managing farms of MySQL servers with support for both high-availability and sharding. It should be noted that this is a very early alpha and that it at this point is not ready for production use.

MySQL Fabric is an integrated system for managing a collection of MySQL servers and is the framework on which high-availability and sharding is built. MySQL Fabric is open-source and is intended to be extensible, easy to use, and support procedure execution even in the presence of failure, an execution model we call resilient execution.

To …

  [Read more...]
Tips to Build a Fault-tolerant Database Application
Employee +0 Vote Up -0Vote Down

Applications should be written taking into account that errors will eventually happen and, in particular, database application developers usually consider this while writing their applications.

Although the concepts required to write such applications are commonly taught in database courses and to some extent are widely spread, building a reliable and fault-tolerant database application is still not an easy task and hides some pitfalls that we intend to highlight in this post with a set of suggestions or tips.

In what follows, we consider that the execution flow in a database application is characterized by …

  [Read more...]
Writing a Fault-tolerant Database Application using MySQL Fabric
Employee +0 Vote Up -0Vote Down

In this post, we are going to show how to develop fault-tolerant applications using MySQL Fabric, or simply Fabric, which is an approach to building high availability sharding solutions for MySQL and that has recently become available for download as a labs release ( We are going to focus on Fabric's high availability aspects but to find out more on sharding readers may check out the following blog post:

  [Read more...]
#DBHangOps 9/17/13 — Data Warehousing, MySQL-isms, and MySQLConnect!
+0 Vote Up -0Vote Down

And that’s a wrap! Check out the recording:


Coming up this Wednesday, September 18th, 2013 at 12:00pm pacific (19:00 GMT) come and join #DBHangOps to discuss:

  • Data warehousing in MySQL
    • Shipping large tables from production to your Data warehouse
    • Do you use Federated engine?
    • What other solutions do you use?
  • Answer some questions about MySQL-isms (requested by Tim Callaghan)
    • Why does MySQL have FRM files instead of storing them in a data …

  [Read more...]
#DBHangOps 9/4/13 — Data dictionary corruption, MySQL Utilities, Benchmarking, and MySQLConnect!
+0 Vote Up -0Vote Down

Check out the video!
Hey there everybody!

Coming up this Wednesday, September 4th, 2013 at 12:00pm pacific (19:00 GMT) take part in #DBHangOps to discuss:

  • Data Dictionary Corruption
    • What is it?
    • How does it happen?
    • How did you fix it?
    • What about FRM file corruption?
  • MySQL Utilities (requested by Sheeri Cabral!)
    • mysqlfrm — …

  [Read more...]
Announcing MySQL Utilities release-1.3.4 GA
Employee +3 Vote Up -0Vote Down

The MySQL Utilities Team is pleased to announce the latest GA release of
MySQL Utilities. This release marks a milestone of concentrated effort to
expand the use of utilities in more diverse installations through improved
robustness, error handling, and quality.

Many Improvements
There are number such enhancements in this release. In this post we will
highlight a few of the more significant improvements.

  • (new utility) MySQL .frm Reader (mysqlfrm) - read .frm files and generate CREATE statements with or without a server connection.
  • (revised) improved …

  [Read more...]
#DBHangOps 8/21/13 — Fractal indexes in TokuDB and Schema tracking
+0 Vote Up -0Vote Down

Hey all!

Coming up this Wednesday, August 21st, 2013 at 12:00pm pacific (19:00 GMT) join in to talk about:

  • Gerry from Tokutek to talk about B-Tree indexes in InnoDB and fractal indexes TokuDB!
  • Schema Versioning
    • How do you manage schema versions in your development pipeline?
    • How are your schema changes deployed? Is it automated?
    • Some automated schema management tools:
  [Read more...]
#DBHangOps 7/24/13 — Innobackupex, schema migrations, and more!
+1 Vote Up -0Vote Down

And all set. Check out the recording:

Hello everybody!

Coming up this Wednesday, July 23rd, 2013 at 12:00pm pacific (19:00 GMT) join in to hear:

  • Brandon Johnson from Mozilla talk about an issue he recently worked through with XtraBackup and the process he took to identify and resolve the issues.

And also take part in discussion around:

  • How do you apply production schema changes?
    • Do you use pt-online-schema-change?
      • Issues to watch out for
    • Just run …

  [Read more...]
SFTP virtual users with ProFTPD and Rails: Part 2
+0 Vote Up -0Vote Down

In Part 1 of "SFTP virtual users with ProFTPD and Rails", I introduced ProFTPD's virtual users and presented my annotated proftpd.conf that I used to integrate virtual users with a Rails application. Here in Part 2, I'll show how we generate virtual user credentials, how we display them to the user, as well as our SftpUser ActiveRecord model that does the heavy lifting.

Let's start at the top with the SFTP credentials UI. Our app's main workflow actually has users doing most of their …

  [Read more...]
#DBHangOps 7/10/13 — Plugins, Kernel Settings, and THP!
+1 Vote Up -0Vote Down

All set, here’s the recording!

Hey there everyone!

Another informative and fun-filled #DBHangOps coming up this Wednesday, July 10th, 2013 at 12:00pm pacific (19:00 GMT). Join the discussion and contribute your experience on the following topics!

  • Plugins for MySQL
    • Which do you use?
    • Are there plugins that you want?
  • Kernel Parameters in Linux for MySQL, specifically:
    • Linux VM settings

  [Read more...]
10 Newer Entries Showing entries 61 to 70 of 618 10 Older Entries

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