Here’s the recording!

Heyo!

March 13th at 12:00pm PDT (19:00 GMT) is the time to check in and hop online for #DBHangOps this week. Keep an ever watchful eye on the twitter search and hop on the google hangout to contribute some discussion! This week’s topics are:

• Monitoring
  • What do you consider to be “standard” nagios checks for MySQL
• Demos of Anemometer and MySQL Enterprise Monitor
• Daily pain MySQL Bugs and Gotchas (e.g. show table status being cached)
• MySQL 5.6

See all of ya on the google hangout!

Take 50% Off COLLABORATE 13 Now Through Wednesday But you’ve got to act fast! If you’re not already one of the many joining the IOUG at COLLABORATE 13 – IOUG Forum, sign up today for your chance at attending for … Continue reading →

EDIT: Video from today’s #DBHangOps!

Hey there peeps!

February 27th at 12:00pm PST it is! Check back here for more info and keep a watchful eye on the twitter search (and feel free to join the conversation!). The topics we’re looking to cover this week are:

• Day-to-day pain points (what takes more time than it should?)
  • rolling restarts and upgrades
  • Performing checksums on your data
    $ /usr/bin/pt-table-checksum \
--quiet \
--ignore-databases=mysql,percona,information_schema,per
formance_schema \
--lock-wait-time=50 \
--chunk-size-limit=0 \
--no-check-plan \
--no-check-binlog-format \
--max-lag=1 \
--replicate percona.checksums \
…

SkySQL and Monty Program are on the road with our joint Meetup in Amsterdam where Monty Widenius - the origninal creator of MySQL - will unveil his vision of the future of the MySQL database via MariaDB.

Seppo Jaakola from Codership will give a presentation about Galera Cluster for MySQL and MariaDB.

In addition we will have speakers from Booking.com as well as Anders Karlsson from SkySQL who will talk about Big Data.

read more

Le 27 mars de 14h à 19h à l'Atelier du France, Paris

SkySQL et Monty Program organisent une demie journée de conférences consacrées aux bonnes pratiques et retours d'expériences autour des bases de données MySQL®et MariaDB, l'objectif étant de répondre aux préoccupations actuelles des administrateurs de bases de données.

read more

My previous writings were mostly teoretical, so I wanted to give a more practical example, showing the actual state of the current code. I also wanted to show how I have tried to make the feature fit well into the existing replication features, without requiring the user to enable lots of options or understand lots of restrictions before being able to use it.

So let us start! We will build the code from lp:~maria-captains/maria/10.0-mdev26, which at the time of writing is at revision knielsen@knielsen-hq.org-20130214134205-403yjqvzva6xk52j.

First, we start a master server on port 3310 and put a bit of data into it:

    server1> use test; …

I’m pleased to announce that my first book, the InnoDB Quick Reference Guide, is now available from Packt Publishing and you can download it by clicking here. It covers the most common topics of InnoDB usage in the enterprise, including: general overview of its use and benefits, detailed explanation of seventeen static variables and seven dynamic variables, load testing methodology, maintenance and monitoring, as well as troubleshooting and useful analytics for the engine. The current version of MySQL ships with InnoDB as the default table engine, so whether you program your MySQL enabled applications with PHP, Python, Perl or otherwise, you’ll likely benefit from this concise but comprehensive reference guide for InnoDB databases.

Here are the chapter overviews …

Get up-to-date on MariaDB, MySQL, Cloud Databases and SkySQL’s expertise: whitepapers and presentations now available on skysql.com

read more

I'm not the only one to have noticed this, but I spent a sufficient amount of time banging my head against a wall finding this out that I thought it important to make more people aware of this.

While trying to validate new database hardware we were seeing some serious performance issues in production.  Most MySQL benchmarks using sysbench or pt-playback couldn't reproduce it, but a simple sysbench 16 threaded filio test on the mysql partition showed about 1/3 the throughput we would expect.   The fact that much of the hardware was new as well as the OS we were using made tracking down the cause difficult (changing from CentOS 5.5 to Scientific Linux 6.)

Finally some of our ops people working on different systems started noticing similar issues, and they uncovered the XFS issue.  Sure enough -- when took existing hardware, upgraded to SL6 and ran the same sysbench filio test we immediately saw a …

Tuesday, February 5th was an important day in the MySQL ecosystem due to the release by Oracle of the long-awaited MySQL 5.6 GA. Many MySQL users have been looking forward to this release in order to benefit from the improved performance and scalability. Features such as online operations/schema changes, NoSQL access from memcached to InnoDB, multi threaded-replication and Global Transaction ID significantly improve the competitiveness of MySQL.

read more