There will not be a May meeting of the North Texas MySQL Users
Group but I am scrambling to get us a great location for the
June meeting. I have left my Job with MySQL/Sun/Oracle and am no
longer responsible for MySQL Certifications. That means my access
to the Sun office were we have been meeting is ended also.
I am now the Customer Service Manager for Calpont and the
InfiniDB storage engine. InfiniDB is column based, multi-threaded, and the
community edition is open source. If you run intensive reports
against InnoDB or MyIsam databases, you need to investigate this
product. And if you regularly run massive queries in data
warehousing or business analytic operation that you need to see
how the massively parallel process architecture of the enterprise
product can make life easier.
Let me premise this post with the statement I think the MySQL documentation is an excellent and highly accurate resource. I think the MySQL docs team do a great job, however like software and people, documentation is not perfect.
As members of the MySQL community you can always contribute to improve the process by reading the documentation and logging any issues as Documentation Bugs.
Some time ago in a discussion with a friend and colleague, we were talking about changes in historical defaults that had been improved finally in MySQL 5.4 The specific discussion was on the new default innodb_buffer_pool_size and we both agreed it increased significantly. One said 1GB, the other said 128MB. Who was right? Well we both were, and we were both inaccurate depending on versions.
Referencing the 5.4 Manual in …
[Read more]Let's take quick look at the performance of the new InfiniDB Subquery processing available with the 1.1.1 Alpha. The arrow was added to be sure our timings weren't confused with the axis.
This was against a relatively small dataset, the Star Schema Benchmark with 6 million rows in the fact table. A base query was run where the outer query...
This post is Part Two of my State of the Internet
Operating System. If you haven't read Part One, you should do so before reading this
piece.
As I wrote last month, it is becoming increasingly clear that the
internet is becoming not just a platform, but an operating
system, an operating system that manages access by devices such
as personal computers, phones, and other personal electronics to
cloud subsystems ranging from computation, storage, and
communications to location, identity, social graph, search, and
payment. The question is whether a single company will put
together a single, vertically-integrated platform that is
sufficiently compelling to developers to enable the kind of
lock-in we saw during the personal computer era, or whether,
Internet-style, we will instead see services from …
Whether you’re working with MySQL, MySQL Cluster, or any other RDBMS, every database with a requirement for persistent data should always have a backup. As a Production DBA you’re the insurance policy to safeguard the data. Bad things do happen. Backups are your safety net to ensure you always have a way to recover should the worst happen and the database becomes irreparable.
There are many ways to produce a consistent backup of MySQL, I have listed a few of the options available below; Remember backups are your safety net, failing to retrieve a consistent backup when you need it most can be a very career limiting move, so no matter what backup method you choose always test your backups!
Logical Backups
The ever popular mysqldump is a backup and export utility
provided with the MySQL binaries …
A couple of things:
- There is now a Monty Program Group Blog. Its brand new, and in a company where most people spend time on writing tonnes of code, expect posts to be sporadic, but of great technical nature. We’ll also cover things like events, conferences, etc. i.e. where can you meet a Monty Program person. Do subscribe to our RSS or ATOM feed.
- At the MySQL Conference recently, Monty announced the rename the Maria engine contest. The competition is still running, and the winner gets a System76 Meerkat NetTop. Some interesting names have already shown up. …
Percona wants to upgrade our documentation to improve its
readability
and to make it more useful for you, our clients and partners. We
are
so busy developing software and handling your needs that we
have
trouble finishing all the documentation! We think you can help.
Helping us will give you a chance to interact closely with lead
Perona
developers and learn more about Percona's products as well as
our
development process.
Tasks include talking to developers, writing text, and
interacting
with an editor. (Andy Oram, our O'Reilly editor on the book
High
Performance MySQL, will take on the volunteer role.) You should
have
some understanding of MySQL and Percona's extensions, and of
way
XtraDB and XtraBackup work.
Documents we want to start with include:
* Product features (we made a …
[Read more]
It is with interest that I read Kristian's three blogs on the binary log group commit. In the
article, he mentions InnoDB's prepare_commit_mutex
as the main hindrance to accomplish group commits—which it indeed
is—and proposes to remove it with the motivation that FLUSH
TABLES WITH READ LOCK can be used to get a good binlog
position instead. That is a solution—but not really a good
solution—as Kristian points out in the last post.
The prepare_commit_mutex is used to ensure that the
order of transactions in the binary log is the same as the order
of transactions in the InnoDB log—and keeping the same order in
the logs is critical for getting a true …
A now-famous quote that I probably don’t need to attribute: “First they ignore you, then they laugh at you, then they fight you, then you win.”
Where is Drizzle in this lifecycle? I’ve been hearing and reading some comments to the tune of “those Drizzle guys think it’s easy to rip MySQL stuff out and start over, wait till they see how hard it’s going to get when the real world sinks in.” Maybe, maybe. But maybe not, too. Maybe not.
I’ve seen more than one software project that was belittled as “never gonna amount to anything, save your time” and went on to do quite well. Never underestimate the power of a handful of passionate and talented people. I personally feel that Drizzle has a bright future.
Related posts:
- Please re-license the MySQL documentation In the pas …
This is part two of an ongoing series about my experiences while writing the MySQL Admin Cookbook for Packt Publishing. All previous parts can be found under the mysql-admin-cookbook label.
While last time I focused on the initial contact with the publishing company (just referred to as "Packt" from now on), this issue is about the process of putting together an outline proposal and coming up with things to write about in the first place. As from this point on in the process Udo was involved with everything, I will be referring to "us" and write "we" most of the time from now on.
The Publisher's Expectations
The only thing we knew about the …
[Read more]