This week, we go through the "Modern Team Practices" part of the Operations Report Card, and how it applies to DBAs.
Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30
October
Bucharest Romania, Tuesday 13 November
Madrid, Tuesday 27 November
I just made MyQuery 3.5.0 available for download from sourceforge. If you do not know about this
program, this is my Windows based MySQL Query editor and database
monitor program. And yes, it is Windows only.
It was a long time since I updated MyQuery, but I have been been
at it for a long time, but slowly as I haven't had the bandwidth,
and I have collected a few things I wanted in this release, but
of all those things, many has to wait for now, as decided to add
a major feature which did require a fair bit of coding and
testing: autocomplete. When editing SQL statements,
autocomplete for names of tables, columns etc is really useful,
but it is not as easy as it sounds. What makes this a bit
complicated are things like the default database (which I need to
figure out for anything that is typed), table aliases and
separate name …
Developers and DBAs often compare and synchronize structures of
their database objects (Tables, Views, Triggers, Functions,
Events and Stored Procedures) from Development server to
Production server and vice-versa. One can use a schema comparison
/ synchronization tool to synchronize database (DB) objects.
SQLyog’s Schema synchronization tool is simple and intuitive to use for comparing and synchronizing database objects. It comes with new looks and a Filter feature. Database objects’ comparison is now 100x faster.
Using SQLyog, schema synchronization can be usually done in three easy steps:
Options provided …
[Read more]Just in case you missed this, last week I announced that my team is looking for an experienced technical writer. Now the job offer has gone live on the Oracle website. Have a look! That's the EMEA job site, but the position is actually available for Europe or North America. The job offer should appear on the American site soon, too.
If you want to join a great team, or if you know someone suitable
who does, don't hesitate
to contact me!
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
Read the original article at AirBNB didn’t have to fail
Today part of Amazon Web Services failed, taking down with it a slew of startups that all run on Amazon’s Cloud infrastructure. AirBNB was one of the biggest, but also Heroku, Reddit, Minecraft, Flipboard & Coursera down with it. Its not the first time. What the heck happened, and why should we care?
1. Root Cause
The AWS service allows companies like AirBNB to build web applications, and host them on servers owned and managed by Amazon. The so-called raw iron of this army of compute power sits in datacenters. Each datacenter is a …
[Read more]“For analytical things, eventual consistency is ok (as long as you can know after you have run them if they were consistent or not). For real world involving money or resources it’s not necessarily the case.” — Michael “Monty” Widenius. In a recent interview, I asked Justin Sheehy, Chief Technology Officer at Basho Technologies, maker [...]
“For analytical things, eventual consistency is ok (as long as you can know after you have run them if they were consistent or not). For real world involving money or resources it’s not necessarily the case.” — Michael “Monty” Widenius. In a recent interview, I asked Justin Sheehy, Chief Technology Officer at Basho Technologies, maker [...]
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 …
I have been asked many times to provide an easy way of deploying fan-in and star schema replication schemas. So far, I have been delayed by more pressing duties.
Now the time has come. Since we are about to release a new version of Tungsten Replicator, I made the effort of putting together the steps for an easy deployment.
Recipes
The package (with downloads and svn code available at Tungsten-Replicator Toolbox) includes some juicy goodies. There are recipes to install.
