New Addition: Why you need a Part-time Remote MySQL
Expert
I have a friend who works as a MySQL recruiter. He recently told
me that he cannot find any more MySQL DBAs in the UK or in the
neighbouring countries. His words were "I've exhausted the
market".
I myself know that there is a shortage of MySQL DBAs and that a
lot of recruitment agencies are looking for them. So I
started to wonder how come the situation is the way it is?
Experience curve
Usually what I see in companies, is that they start out with the
developers taking care of the databases along side their usual
coding duties. At some point, they complain to management that
they need a professional DBA to handle the database. When the
complaints get loud enough, management looks for a …
If you’re new to the MySQL DBA role, you’ll be excited to learn about the Maatkit toolset. It provides a whole host of valuable functionality and fills many of the DBAs day-to-day needs.
When you are importing large amounts of data from other sources
LOAD DATA is a common method of inserting data
into a table.
It is one of the old commands implemented in MySQL. As such it is
very fast, and it has been optimized for both MyISAM and
InnoDB.
All is well when you are loading data into a standalone server.
All is almost well when you are using replication. LOAD DATA used
to be a problem in old versions of MYSQL, prior to 4.1. With
recent versions of MySQL, it is replicated correctly, and
sometimes efficiently.
The trouble starts when the data file is big. The
definition of big and the amount of trouble that you can
get depends on many factors. That's why users may not realize
that this problem exists, even with fairly large files, and then
being hit by this disaster when the file is only a little larger
than the previous …
As everyone knows, I am a command line guy. I am very much
comfortable with the shell prompt and the command line SQL
client. I do most of my work that way, and I am very much
productive.
However, there comes a time when even for a command line
enthusiast a GUI can be helpful.
Here comes the latest MySQL Workbench 5.2.
There are two areas where I feel that WB can give me a
hand:
The first is when looking at tables that contain BLOB columns.
Sure I can deal with them at the command line, but this editor
makes my life easier.
When a column contains a BLOB, you can open the field
viewer.
…
So, we can have a look at this improvement, which I am sure will
make DBAs quite happy. The new feature is an instantaneous exchange between a partition and a
table with the same structure. Using this feature, you can
transfer the contents of one partition to one table, and vice
versa. Since the transition is done only in the attribution of
the data, there is no copy involved. The data …
Welcome to my new Production DBA blog, through this blog I aim to fully explore and understand some of the common tasks undertaken when administering MySQL in a production environment. I’ll be looking at options for backups, high availability, scalability, and monitoring, as well as various other general administration tasks in between.
To whom it may concern,
in response to a query from André Simões (also known as ITXpander),
I slapped together a MySQL script that outputs mysqldump commands for backing up
individual partitions of the tables in the current schema.
The script is maintained as a
snippet at MySQL Forge. How it worksThe script works by
querying the information_schema.PARTITIONS system
view to …
At work we have been looking for tools to monitor MySQL and at
the same time provide as much diagnosis information as possible
upfront when an alarm is triggered. After looking around at
different options, I decided to test MONyog from Webyog, the makers of
the better known SQLyog. Before we go on, the customary
disclaimer: This review reflects my own opinion and in
no way represents any decision that my current employer may or
may not make in regards of this product.
First ImpressionYou know what they say about the first
impression, and in this where MONyog started with the right foot.
Since it is an agent-less system, it only requires to install the
RPM or untar the tarball in the server where you're going to run
the monitor and launch the daemon to get started. How much faster
or simpler can it be? But in order to start monitoring a server
you need to do some …
My proposal has been accepted, yay!
I'll be speaking on a topic that I feel passionate about:
MySQL Server Diagnostics Beyond Monitoring.
MySQL has limitations when it comes to monitoring and diagnosing
as it has been widely documented in several blogs.
My goal is to share my experience from the last few years and,
hopefully, learn from what others have done. If you have a
pressing issue, feel free to comment on this blog and I'll do my
best to include the case in my talk and/or post a reply if the
time allows.
I will also be discussing my future plans on sarsql. I've
been silent about this utility mostly because I've been
implementing it actively at work. I'll post a road map shortly
based on my latest experience.
I'm excited about meeting many old friends (and most now fellow
MySQL alumni) …
At the recent FOSDEM 2010 event, I presented in my keynote Dolphins, now and beyond a option which I termed the “Blue Pill” or the “Red Pill”. The following slide produced noticed interest in a packed room, and subsequent conversation.
While the ownership of MySQL has changed, the option between MySQL and Oracle as a product for use still remains. While MySQL is the most popular for modern online applications, Oracle continues to have the widely used enterprise database product and has a large number of Oracle DBAs in the IT marketplace.
Over the past 5 years I have presented a number of topics on MySQL for Oracle DBA’s. At the upcoming MySQL Users Conference 2010 I will be presenting …
[Read more]