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.
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; …[Read more]
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 …
[Read more]Get up-to-date on MariaDB, MySQL, Cloud Databases and SkySQL’s expertise: whitepapers and presentations now available on skysql.com
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.
UPDATE: Here’s the recording, enjoy!
Hello everybody!
#DBHangOps coming at you this week, Wednesday 1/30/12 at 12:00pm PST. Be sure to check out this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout.
This week’s topics were:
* bug fixes in recent versions
* Plugins
** authorization plugins (e.g. LDAP)
** audit plugin API —
http://dev.mysql.com/doc/refman/5.5/en/writing-audit-plugins.html
*** state transitions of records in MySQL with a plugin?
* InnoDB Status variables from twitter —
https://github.com/twitter/mysql/wiki/InnoDB-Status-Variables
* Table alters/schema changes
** Twitter patch for non-blocking alter table (throws a different
error than “lock_wait_timeout”) — …
With the MySQL 5.6 production-ready GA set for release in the
coming days, it’s good to re-cap the key features that make 5.6
the best release of the database ever. At a glance, MySQL
5.6 is simply a better MySQL with improvements that enhance every
functional area of the database kernel, including:
Update: Recording!
Finally, the end of year madness is over and we’re in a fresh new year. That must mean it’s time to get back into #DBHangops! Tune in on Wednesday, 1/16/13 at 5:00pm PST to get in on the fun and share your experiences.
Check back on this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout.
Topics for this weeks hangout include:
* triggers: maintenance, problems, etc.
* Oracle MySQL utilities (similar to Percona
toolkit)
** Slideshow of MySQL utilities
* Database caching and cache expiration
* InnoDB log file size
** …
The SkySQL and MariaDB Roadshow comes to Sweden:
Stockholm 7 February 2013, 16:30-19:30, Dramaten Restaurang Pauli
SkySQL and Monty Program are on the road with our joint - free - roadshow in Stockholm where Monty Widenius will unveil his vision of the future of the MySQL database via MariaDB.
In addition, we will have speakers from Codership/Galera, as well as SkySQL experts.