In part one of this post, I gave you a couple examples of how to backup your MySQL databases using mysqldump. In part two, I will show you how to use the MySQL Enterprise Backup (MEB) to create a full and partial backup.
MySQL Enterprise Backup provides
enterprise-grade backup and recovery for MySQL. It delivers hot,
online, non-blocking backups on multiple platforms including
Linux, Windows, Mac & Solaris. To learn more, you may download a
…
Thanks Anna.I was expecting this blog. Your blogs on InnoDB Internals are very good. If possible please write a book on the InnoDB internals.
Regards,
Karthik
I’ll be presenting the keynote for Wednesday’s
(31st July) MySQL Virtual Developer Day. The idea behind
this event is that you get half a day of on-line presentations as
well as live Q&A. My session focuses on what’s new in MySQL –
in particular MySQL 5.6 and MySQL Cluster 7.3. As you’ll come to
have expected, the event is free but you need to register here.
In the following agenda, all times are local to Singapore…
Percona is glad to announce the release of Percona Monitoring Plugins 1.0.4. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts.
Changelog:
* Added Galera/MySQL Monitoring Template for Cacti
* Added “Disk Read/Write Time per IO Request (ms)” graph
* Added “MySQL InnoDB Buffer Pool Efficiency” graph
* Switched ss_get_mysql_stats.php to PHP MySQLi extension and
made it working with SSL (bug 1193097)
* Added user info to the max_duration check of
pmp-check-mysql-innodb plugin (bug 1185513)
* ss_get_mysql_stats.php default values for ‘$status’ array were
null instead of 0 (bug 1070268)
* Introduction of innodb_read_views_memory overrode the InnoDB
total memory allocated …
Issue – the OpenStack instances hostnames are not resolved at the moment by their floating IPs.
Fast solution – use PowerDNS
Short story:
1. Boot an instance , assign it a floating IP, open tcp ports 22
8001 and udp port 53.
2. Install PowerDNS, the particular yum package is named
pdns.
3. install the mysql backend for PowerDNS, its available as yum
package as well.
4. Install MariaDB , set the proper configuration, the initialize
it at the default location.
5. Set the pdns user, create the pdns database and create the
tables needed.
6. Configure the pdns service to use the gmysql backend.
7. Create and user at the OpenStack MySQL able to connect from
the floating IP subnet.
8. Grant that user select permissions on all nova.* tables.
9. At the PowerDNS instance, set simple python / php / bash
script to query the nova database and to inject the hostnames and
the …
The MySQL Developer Tools team is pleased to announce the availability of the third beta release of MySQL Workbench 6.0. MySQL Workbench 6.0 is the new major update of the Development and Administration tool for MySQL. This release includes almost 200 bug fixes (~40 since 6.0.3), 30 new features and a new redesigned UI. As a beta, this release is not suitable for production use. Please test and file your bug reports at http://bugs.mysql.com
As always, MySQL Workbench is natively available on Windows, Mac, Linux.
Improvements in MySQL Workbench 6.0:
It was once said that “real artists ship.” In looking over the history of Percona software releases, we are currently shipping more software than ever before.
First, let’s look at Percona Server. Let’s look at all major versions: 5.1, 5.5 and 5.6 as well as the total for each year. The estimate for 2013 comes from assuming the second half of 2013 is similar to the first half.
Percona Server releases per year
In 2011, when Percona Server 5.5 came along, we see a sharp reduction in Percona Server 5.1 releases (remember that there’s at least one Percona Server 5.1 release for each Oracle MySQL 5.1 release, and this reduction is likely a reflection of the reduction of releases from Oracle). In 2011, 2012 and 2013 we see a pretty steady number of Percona Server 5.1 releases. It seems that 5.1 is not going anywhere yet.
For Percona Server 5.5, we see an increase in 2012, which likely mirrors an …
[Read more]
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:
And also take part in discussion around:
Make sure to follow the #DBHangops twitter search, the DBHangops Twitter Feed, or this blog …
[Read more]In MySQL a big portion of the problems you’re facing is different replication delays so there’s no surprise this is one of the most common interview questions on DBA interviews and I still found people having problems with explaining what they would do in a certain situation. This is why I decided to write a bit about the subject.
1. IO
99% of times the reason is IO. The slave cannot keep up with the amount of writes it gets from the binary logs while in parallel it has to return results of queries as well. In spite of the common belief in MySQL it’s much easier to saturate the disk subsystem (even a raid 10 with 8 SAS disk and cache) than the network.
In this situation all you can do is try to remove some pressure from the slaves.
One way to do this is setting innodb_flush_log_at_trx_commit to 2 if it used to be 1. Usually this is enough.
…[Read more]Every once in a while the Continuous Integration reminds me that the code I write isn't "that" portable. I develop on Linux, push to the SCM and the CI goes out and builds on several Unixes and Windows.
Fixing windows build issues through the CI takes quite a while. It is far easier to have a local windows build-environment around to do the build, testing before you push. You could make that quite efficient by installing Windows in a VM, use shared-folders, use cygwin+sshd to log into it from the command-line ...
... or you simplify it even more and just use wine.
The main reason for me to go this path:
