In my heart, I'm a DBA, always was and always will be. People say
I'm a database guy by the way I think, keep my car, and file my
music and also bank statements... However I did great deal of
development, design, architecture on the apps side. I (hope to)
have some perspective.
Applications come and go. The second programming language I've
ever learned and worked on was COBOL, some still say most of
the world's lines of code are written in this language, maybe so,
but anyway I since then have known and written in dozens of
programming languages, from Assembly to Force.com, from Pascal to
Delphi, from functional C to Object
Oriented SmallTalk, C++, Java and , from compiled C/CGI
to interpreted Perl, ASP and Ruby back to compiled node.js... My
first applications ran on Main-Frame with green screen, later I
created beautiful graphic client-server applications, later I had
to create hideous white web applications …
What are your pet peeves about the tools? I have a lot. For example, pt-table-sync doesn’t let me do things I want it to do sometimes (and I know it could be made to do them). Another example: pt-query-digest’s tcpdump parser doesn’t pay attention to TCP sequence numbers, so sometimes it invents a really long-running query where there isn’t one. Post your gripes, big and small, in the comments!
(This blog post is an attempt to do a 37signals approach to prioritizing: the stuff people complain about repeatedly is what you should focus on. No promises about fixing the gripes — I just want to hear them!)
Further Reading:
[Read more]I’m happy to announce that version 1.0 of Percona Monitoring Plugins is now available. The Percona Monitoring Plugins are high-quality plugins, templates, and add-ons for Nagios and Cacti, so you can add world-class MySQL monitoring to your existing enterprise open-source monitoring products.
Version 1.0 fixes a variety of bugs that users found in version 0.9.0. Here are the usual links: changelog, documentation, downloads, source code, …
[Read more]
Things are going to be busy over the next few months. I look
forward to meeting many of you from the MySQL community over the
next few months. I would also like to pass along my thanks for
the MySQL Community Award, we (not just Dave and I
but everyone here) are just getting started...
April 22nd -26th - starts things off for the MySQL Community
Team. Dave Stokes and I will be presenting at different two
sessions and available in the demo grounds at Collaborate in
Vegas.
May 2nd -- MySQL heads to the big apple for an OTN Developer Day in NYC. Ronald Bradford as
well as Calvin Sun are among some of the speakers for this …
Last week was full of exciting news for all things MySQL.
However, SkySQL also had some great individual news in that it announced 2 new partners:
I just wanted to take a moment and officially welcome both to the SkySQL fold!
PalominoDB and hastexo, it’s great to be partnered with you!
And we’re looking forward to all the exciting things the future has to hold!
For those interested, you can read more about each partnership here:
[Read more]The SkySQL & MariaDB: Solutions Day for the MySQL Database (the first of its kind) took place last Friday (April 13th) in Santa Clara, and we’d like to thank everyone who attended, participated and generally helped make it the successful day that it was!
Well, as you or may not have heard, MariaDB 5.5 (5.5.23) was declared GA last week!
It was only about 6-ish weeks ago that MariaDB 5.5 had been released as alpha, so the fact it’s already GA is excellent news for all MariaDB users (and MySQL 5.5 users looking to migrate).
Some of the 5.5 enhancements include:
- Significantly more efficient thread pool, comparable in functionality to the closed source feature in MySQL Enterprise.
- Non-blocking client API Library (MWL#192)
- @@skip_replication option (MWL#234)
- SphinxSE updated to version 2.0.4.
- “extended keys” support for XtraDB and InnoDB
- New INSTALL SONAME statement
- New LIMIT ROWS EXAMINED optimization.
- mysql_real_connect() Changes
In MySQL, and in MariaDB versions before 5.5.21, mysql_real_connect() …
Read the original article at Easy MySQL replication with hotbackups
Setting up replication in MySQL is something we need to do quite often. Slaves die, replication fails, or tables and data get out of sync. Whenever we build a slave, we must start with a snapshot of all the data from the master database.
MySQLdump is the tried and true method of doing this, however it requires that we lock all the tables in the database. If we’re dumping a large database, this could be a significant period, where no writing can happen to our database for the duration of the backup. For many environments read-only is still an outage.
Enter hotbackups to the rescue. Percona comes with a tool that allows you to …
[Read more]
Hi Folks,
Just a quick note to let you know that I am planning to add
support to XtraBackup Manager to work with XtraBackup 2.0 series
releases fairly soon.
Using the XtraBackup 2.0 series will mean that XtraBackup Manager
will no longer need to stage the incremental backups to a
location on the remote host before copying them back to the
XtraBackup Manager storage.
This can be a remarkable efficiency saving for systems with a lot
of page changes between backups.
I will also be trying to address some of the feedback/requests
that I have received in the Google Code Issues section.
Please check out the project in Google Code here, if you have not
already. Feedback and contributions are welcomed!
http://code.google.com/p/xtrabackup-manager/
Cheers,
Lachlan
The journey to the Hotel in Santa Clara took me something like 16 hours. It was long, arduous and at times despairing, but was it worth it? Absolutely! I made the epic journey with my Pythian (and former Nokia) colleague Andrew Moore, and once at the conference we met up with more members of our [...]