MySQLBoy attends the annual MySQL Conference and Expo host by Percona. [part 1 of 2]
Apr
17
2012
Apr
17
2012
Day 1 is the first official day of the Percona Live MySQL Conference. It began with two mini keynotes by Peter Zaitev and Baron Schwarz of Percona talking about the history of MySQL and his beginnings in the open source movement, respectively. It was very nostalgic, and I’m sure it brought a tear to a few people’s eyes.
Following the dynamic duo was full keynotes by Mårten Mickos (Eucalyptus Systems) on “Making LAMP a Cloud” and Brian Aker (HP) on “The New MySQL Cloud Ecosystem”. To be honest, I found the full keynotes to be quite disappointing. For me, the keynotes speeches should be about a topic that is visionary or notable in some way. What I got from the keynotes were: MySQL is good, MySQL is growing, let me show you my product around MySQL, and buy/use my product. They felt far more like glorified sales pitches.
I remember that at the last conference I attended, SXSW Interactive, the keynotes by Ray …
[Read more]
Apr
17
2012
Day 0 of the MySQL Conference was a day unlike any other day. It was, in fact, tutorial day. While regular days of the Percona Live MySQL Conference feature 50 minute sessions, usually split into a 40 minute talk and a 5-10 minute question period, tutorials are 3-hour-long sessions (with a generous 10 minute break in the middle for those that wish to go to the WC) that provide an in-depth dive into some aspect of MySQL. Due to the length of the tutorials, they are more in-depth and technical than individual sessions can be, but at the same time, we are limited to 2 tutorials slots per day instead of the 5 for sessions.The tutorial schedule for the conference is located here, and with so many good ones, it was hard to choose which one(s) to go to.For the morning session, I attended Peter Zaitev’s tutorial entitled “InnoDB and XtraDB …
[Read more]
Apr
17
2012
Thanks to all of our sponsors, speakers, speaker selection committee, event staff, and especially the attendees for making last week’s conference a resounding success. With over a thousand people, the event made a good comeback after last year’s event, but more importantly, the mood was strongly optimistic. I think a lot of people arrived with some uncertainty about how it would turn out, but the doubts didn’t last long, and after a few hours I believe everyone felt the energy and enthusiasm.
The positive comments on the Internet certainly seem to point that direction: Florian Haas called it “awe-inspiring.” …
[Read more]
Apr
17
2012
@Anonymous,
this does not sound like a question that has anything todo with
this article. Simple write a servlet as you are used to, and add
code to execute SQL statements. You can send it whatever
statement you like so you should be able to generate a statement
that creates a table using some servlet parameter as name.
Apr
17
2012
If you have recently attended some Percona Live events or if you have checked some slides from Yves Trudeau, you may have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL.
PRM is an OCF Resource Agent for Corosync / …
[Read more]
Apr
17
2012
I blogged about duckduckgo previously, and here's another search
engine, I've just recently learned about: blekko.
Met their
CTO at Percona Live, running the CentOS (!) booth, to learn
they have their own 25 petabyte index and an own NoSQL database
to run it.
Their database (should I say petabase?) is written in C and Perl.
Apr
17
2012
You cannot use Yum to an unregistered Linux by
default after installation. As a workaround, you will have to
create a repo from your installation CD or ISO file.
1. Mount your DVD/CDROM. Run this command from shell.
mount /dev/cdrom /mnt
2. Or if you have no DVD/CDROM, you can copy your ISO file to the
server and mount like this.
mount -o loop -t iso9660 yourisofile.iso /mnt
3. Change directory to /mnt and run this command
yum clean all
5. Edit /etc/yum.repos.d/iso.repo. Use nano or vi.
nano /etc/yum.repos.d/iso.repo
6. Paste below and save.
[local]
name=Local CD Repo
baseurl=file:///mnt
gpgcheck=1
gpgkey=file:///mnt/RPM-GPG-KEY
Now try installing using …
Apr
17
2012
The MySQL Enterprise Backup is a very powerful backup tool from
MySQL. By using MEB, you can always take a hot and fast backup of
all your MySQL Databases. I've been using it in Oracle Linux
platform but just recently I have this need to use it in our
Ubuntu production servers. I've tried installing it to Ubuntu
11.04 and have no problem at all. Here's what you need to do to
get this done.
1. Download the files from http://edelivery.oracle.com. You need
to have an account to download one.
2. Transfer it to the server using SCP or WinSCP if you are using
windows or any other type of file transfer client.
3. SSH to your server and login as root.
4. Unzip the file to your preferred location. I recommend to use
the default location the MEB is using at /opt/mysql/
directory.
5. Edit ~/.bashrc and add below lines
export PATH=/opt/mysql/meb-3.7:$PATH
Apr
17
2012
MySQL 5.1 or newer can sometimes start throwing a strange message into an error log. The message states that a query was unsafe for binary logging along with some additional information. What does it mean? Is it a problem?
From time to time you might spot MySQL error log filling with the following warning:
“[Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted. Statement: DELETE FROM score WHERE user_id = 12345 AND created = ’2012-04-15′ LIMIT 1″
If binary logging is enabled and the log format is set to
STATEMENT, MySQL generates such message when it
considers that a query is ambiguous and could behave differently
each time it executes against the same data set. Such situation
could happen, for example, on a …