Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Learn tips and tricks from the database replication and clustering stars:
Future-Proofing MySQL for the World-Wide Data Revolution, by Robert Hodges Why, What, and How of Data Warehouses for MySQL, by Robert Hodges Multi-master. Multi-site MySQL Databases Made Easy with Continuent Tungsten, by Robert Hodges and Giuseppe Maxia MySQL High Availability: Power, Magic and Usability, by Giuseppe
Continuent announced today its expansion in France. In a move to increase its presence in Europe and to strengthen relationships with existing and prospective contacts in France and Benelux, Axel Faux and Ludovic Launer have joined Continuent's team of database clustering and replication experts. The new sales office in Paris, France's largest economic center, is a continuation of Continuent's
Hot backups are important for high availability, they can run
without blocking the application. Percona Xtrabackup is a great
tool for backing up InnoDB data.
We have created a backup tool called s9s_backup that makes
Xtrabackup really easy to use, and is fully integrated with
ClusterControl, which means that you can schedule backups with
ease and view the backups that you have taken, and also restore
the backups with no pain.
s9s_backup is available in the lastest version of ClusterControl
or you can download it here.
Is mysqldump totally useless
then?
No. If you would like to isolate and load only one table,
mysqldump is great, or if you want to …
It's the time of the year again: You have 2 more weeks to submit a great proposal to the biggest and baddest MySQL Conference: Percona Live MySQL Conference and Expo 2013 (Santa Clara). Like many things in the MySQL community, this conference has also gone through a transformation over the past 3 years. But last year the growing pains and uncertainty ended with Percona putting up a great show. Attendance was up again (over 1000) and there was a sense of energy and excitement for the future of MySQL. If you are like me and like to dwell in nostalgia (so that you can get into the right mood for submitting great proposals) my coverage of last year's conference is found here: part 1, …
[Read more]If you missed Percona Live MySQL Conference in NYC, download these Continuent Tungsten talks!
FUTURE-PROOFING MYSQL FOR THE WORLD-WIDE DATA REVOLUTION by Robert Hodges SOLVING LARGE-SCALE DATABASE ADMINISTRATION WITH CONTINUENT TUNGSTEN by Robert Hodges and Neil Armitage CONSOLIDATE YOUR SHARDED DATABASE INDEXES IN REAL-TIME by Jeff Mace
We are sponsoring the upcoming Percona Live events in
- Future-Proofing MySQL for the World-Wide Data Revolution by Robert Hodges- Solving Large-Scale Database Administration with Continuent Tungsten by Robert Hodges and Neil Armitage - MySQL Backup and Recovery Essentials by Ronald Bradford - Consolidate Your Sharded Database Indexes in Real-time by Jeff Mace Get 10% discount from your conference pass by using discount code Continuent
So, what impact does enabling the slow query log have on MySQL?
I decided to run some numbers. I’m using my laptop, as we all know the currently most-deployed database servers have mulitple cores, SSDs and many GB of RAM. For the curious: Intel(R) Core(TM) i7-2620M CPU @ 2.70GHz
The benchmark is going to be:
mysqlslap -u root test -S var/tmp/mysqld.1.sock -q 'select
1;' --number-of-queries=1000000 --concurrency=64
--create-schema=test
Which is pretty much “run a whole bunch of nothing, excluding all the overhead of storage engines, optimizer… and focus on logging”.
My first run was going to be with the slow query log on. I’ll
start the server with mysql-test-run.pl as it’s just easy:
eatmydata ./mysql-test-run.pl --start-and-exit
--mysqld=--slow-query-log --mysqld=--long-query-time=0
The results? It took 18 seconds.
How long without …
[Read more]High availability is about more than just making sure that applications can get to your data, even if there is a failure:
How about when you are upgrading your database schema What if you need to add memory to a database server or reconfigure/restart MySQL If your apps want to read data from a MySQL slave, how can you be sure they are not reading stale data without re-coding your apps What
There has been a lot of talk about MySQL 5.6 replication improvements. With few exceptions, what I have seen was either marketing messages or hearsay. This means that few people have really tried out the new features to see whether they meet the users needs.
As usual, I did try the new version in my environment. I like to form my own opinion based on experiments, and so I have been trying out these features since they have appeared in early milestones.
What follows is a list of (potentially) surprising results that
you may get when using MySQL 5.6.
All the examples are made using MySQL 5.6.6.
Gotcha #1 : too much noise
I have already mentioned that MySQL 5.6 is too verbose when creating data directory. This also means that your error log may have way more information than you'd like to get. …
[Read more]I recently released a new version of the Bazaar plugin for Jenkins. This release was inspired by a problem we noticed at Percona. It is:
The update has already appeared in the Jenkins update centre, so you should already be able to upgrade to it.
