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]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]
@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.
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]
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.
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 …
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
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 …
The Percona Live MySQL Conference and Expo 2012 is over. Together with the SkySQL solutions day, it has kept me occupied for 4 full days, from early morning to late at night.
I have to say that I am pleased. The quality of the organization was very high, with a very good lineup of speakers and an excellent technical support.
As usual, I have learned a lot during this week, either directly, by attending talks, or indirectly, by meeting people who told me what was juicy at the talks that I had missed. And I have met new interesting people, and caught up with the people that I know already.
This conference was particularly intense also because I got myself involved in 5 talks, which was probably more than I should have. How did I end up with such a task? It's a long story. …
[Read more]MySQL Cluster Performance Tuning
-------------------------------------------
In this session we will look at different tuning aspects of MySQL Cluster.
As well as going through performance tuning basics in MySQL Cluster, we will look closely at the new parameters and status variables of MySQL Cluster 7.2 to determine issues with e.g disk data performance and query (join) performance.
This was the last session I attend, and for me is alway a great pleasure to be at Johan presentations, for many reasons:
- he is probably the best cluster expert (in service delivery)
- he knows a lot of distinctiveness and insight that no one else knows
--------------------------------------------------------------------------
Speech taken by Johan "my Viking" Andersson
MySQL/Oracle has released a new version of MySQL cluster recently, and I had the opportunity to …
[Read more]