MySQL for Database Administrators is the foundation of the authentic MySQL Curriculum. By taking this live 5-day instructor-led course, you find out how MySQL enhancements increase performance, scalability, reliability and manageability of your Web, Cloud and embedded application requirements.

You will learn to:

• Setup the server and databases
• Maintain and secure data
• Configure for performance and high availability
• Explore real-world problems and discover best practices

You can take this course as a:

• Live Virtual Event: Take this course from your own desk choosing from 15 events already on the schedule, delivered in English or Germany.
…

Hi everyone!

Here’s a video of this week’s #DBHangOps:

March 27th at 12:00pm PDT (19:00 GMT) is when the next #DBHangOps is gonna go down. Check out the twitter search and hop on the google hangout to contribute some discussion! This week’s topics are:

• MySQL and puppet
  • Sheeri Cabral shared a pastebin of a puppet manifest used at Mozilla: http://scabral.pastebin.mozilla.org/2251358
• MySQL “Gotchas” (round 2)
  • MySQL Bug on predicate deadlocks due to locking non-existent rows
• A shoutout for NWCNA 2013 from Sheeri. Submit …

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