Last week's podcast, containing an overview of replication
This week we have Robert Hodges, CEO of Continuent, talking about the Tungsten replicator, which has an open source component with global transaction id's and can be used for many features, including high availability and replication to systems other than MySQL. Tungsten Replicator won Application of the Year award at the 2011 O'Reilly MySQL Conference.
In a recent blog post, I wrote about four fundamental metrics for system performance analysis. These are throughput, residence time, “weighted time” (the sum of all residence times in the observation period — the terminology is mine for lack of a better name), and concurrency.
I derived all of these metrics from two “even more fundamental” performance metrics, which I’ll call the “basic” metrics. That’s what this post is about. But it doesn’t stop there, because my list of four fundamental metrics isn’t the only thing you can derive from the two basic metrics. In fact, these two basic metrics encode a tremendous amount of information, from which you can compute lots of other things. And by the way, it’s a good thing the two basic metrics really are basic, because beyond “fundamental” and …
[Read more]
Percona is organizing another Percona Live event, this time a
one-day MySQL summit in New York.
This is a 100% technical conference with no marketing allowed,
perfect for those that are only interested in the real stuff or
those that want to get answers to problems they have *right
now*.
The previous summit, held in San Francisco, was very well
attended and I have heard a lot of good things about it from
people that were there.
In San Francisco we had one of the MariaDB optimizer gurus
holding a talk about all the advanced optimization we have
added to MariaDB 5.3.
In NYC we have Kurt von Finck giving a
talk about …
Listening to the OurSQL podcast: Repli-cans and Repli-can’ts got me thinking,
what are the issues with MySQL replication that Sarah
and Sheeri didn’t have the time to include in their
episode. Here’s my list:
Replication Capacity Index This is a concept introduced by
Percona in last year’s post: Estimating Replication Capacity which I
revisited briefly during my presentation at this year’s MySQL Users
Conference. Why is this important? Very …
Oracle will shut down blogs.mysql.com/peterg in a few days. I don’t have an address for a new blog yet, but google in a few months for site:.ca peter gulutzan’s blog.
Permalink: http://bit.ly/UZY7xT
Skip to part 2 to go straight to the code
snippet.
See also a similar generator: Truly Random and Complex Password
Generator
Database names and table names have certain restrictions in
MySQL:
It is possible to create a table or database with a dot
(.) in its name, however this is not recommended as it will
cause some of MySQL's built-in functions to not work as …
[caption id="attachment_209" align="alignright" width="240"
caption="Photo by Stéfan under a CC by NC SA 2.0
license"][/caption]
If you have been reading Planet MySQL over April you will have seen many
blog posts on the new features in the MySQL 5.6 (currently a
development release). I developed several patches that are
in 5.6 including the 'Slave_last_heartbeat' status variable to
show the time of the last replication heartbeat received.
One of the cool new features I developed which I am most
proud of is the option to remotely backup …
If you have been reading Planet MySQL over April you will have seen many blog posts on the new features in the MySQL 5.6 (currently a development release). I developed several patches that are in 5.6 including the ‘Slave_last_heartbeat’ status variableto show the time of the last replication heartbeat received. One of the cool new features I developed which I am most proud of is the option to remotely backup your binary logs without a MySQL slave:
Remote Binlog Back-up
Enhances …
[Read more]
In my previous blog posting, I explained how I was able to
get more stable query execution times by increasing the amount of
sampling used to by InnoDB to calculate statistics. However, for
my example query, Query 8 of the DBT-3 benchmark, the MySQL
Optimizer still toggled between three different indexes to use
when accessing one of the 8 tables.
I decided to try out InnoDB Persistent Statistics that is one of
the new features in the recent MySQL 5.6.2 Development Milestone Release.
According to the advertisement, this should give both more
accurate and more stable statistics. The improved accuracy is …
Hi Folks,
This is just a quick update to let you know that, after much
cursing and frustration with my lack of Solaris experience, I
have managed to make XtraBackup Manager work on Nexenta
(NCP3).
So why would you care?
The answer is because Nexenta is OpenSolaris based and therefore
has support for ZFS. I think ZFS is an awesome filesystem to
combine with XtraBackup Manager, because you can benefit from
transparent compression at the filesystem level.
This means you can store a whole lot more on less disk and you
don't have to deal with compressing and uncompressing your
backups all the time.
Sure, you could always use Nexenta Community or Enterprise
appliances as a NFS mounted filer, but why would you want to
stream all of your backup data into one Linux based server to run
XtraBackup Manager just so that it all goes out an interface via
NFS to the real storage?
…
