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 (http://labs.mysql.com/). 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:

•  http://vnwrites.blogspot.com/2013/09/mysqlfabric-sharding-introduction.html

Servers managed by Fabric are registered in a MySQL Server instance, called backing store, and are …

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

Hello!

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 dictionary table?
  • Why doesn’t InnoDB support other page sizes?
  • Why do we store data in a master.info file?
• What are you excited to see at MySQLConnect?

As always, take …

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 — http://dev.mysql.com/doc/workbench/en/mysqlfrm.html
    • Read about it at Chuck Bell’s blog http://drcharlesbell.blogspot.com/2013/04/mysql-utilities-new-frm-reader-utility.html
    …

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 documentation including a section on example administrative tasks - see http://dev.mysql.com/doc/workbench/en/mysql-utilities.html
• MySQL Utilities is packaged for .msi, .rpl, .deb platforms and source .tar/.zip
…

In my recent SQL work for a large Swiss bank, I have maintained nested database view monsters whose unnested SQL code amounted up to 5k lines of code, joining the same table over and over again in separate subselects combined via UNION operations. This monster performed in way under 50ms, no matter how we queried … Continue reading The Myth About Slow SQL JOIN Operations →

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:
    • South — http://south.aeracode.org/ — a DJango (python) friendly migration tool
    • Flyway — http://flywaydb.org/ — A database migration framework for java
    • Liquibase — …

This is MySQL's Bad Idea #573 (after #384, which I've blogged about before) I've just had a terrible experience with a bug report from the jOOQ User Group, related to escaping of backslashes in string literals in MySQL. First, I thought to myself, whatever. SQL doesn't escape backslashes. The only escape character within a string … Continue reading MySQL Bad Idea #573 →

This article is part of a series. You might also like: 10 More Common Mistakes Java Developers Make when Writing SQLYet Another 10 Common Mistakes Java Developers Make When Writing SQL Java developers mix object-oriented thinking with imperative thinking, depending on their levels of: Skill (anyone can code imperatively)Dogma (some use the "Pattern-Pattern", i.e. the … Continue reading 10 Common Mistakes Java Developers Make when Writing SQL →

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 the alter!
  • Pull from a pool and apply

Make sure to follow the #DBHangops twitter search, the DBHangops Twitter Feed, or this blog …

So far, I have been blogging about curious RDBMS caveats mostly related to Oracle and MySQL databases. Some examples: You never stop learning about Oracle features NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: MySQL SQL incompatibilities: NOT IN and NULL values MySQL Bad Idea #384 But there are also other databases, … Continue reading 10 Things in SQL Server Which Don’t Work as Expected →