This week we kick off a multi-part series on monitoring. In this episode we discuss the MySQL Enterprise Monitor offering from Oracle and the MONyog offering from Webyog.
News
The Independent Oracle User Group is looking for nominations to the MySQL Council.
The next OTN Developer Day for MySQL will be Thursday, February 9th, 2012 in Frankfurt, Germany. Registration is free.
We still have a few seats left for our MySQL Cluster training in Washington DC January 24 - 26. If you're interested in learning about MySQL Cluster, the architecture, how to install it, administer it and troubleshoot it this is the course for you. The course will also cover replication and optimization and we will also discuss the exciting new features coming in version 7.2 of MySQL Cluster. For more information about the course contents visit http://www.skysql.com/services/training/courses/administering-mysql-cluster and to sign up to the course go to http://www.skysql.com/services/training/schedule/administering-mysql-cluster-1.
See you there!
After having party and festive time during holidays, bloggers are returning with reinvigorated zest and with uplifted zeal and the blogs are sprouting energy and promise. The new year is already here and the blogs across the database rainbow are oozing colors of all kinds. This Log Buffer Edition depicts some of them in Log [...]
Upcoming MySQL Training - join the MySQL trainig at Oracle
University!
MySQL for Database Administrators:
6 Februari, 19 Februari, 27 Februari, 12 Mars, 19 Mars, 16
April
MySQL Performance Tuning:
24 Januari, 14 Februari, 27 Mars, 29 May, 26 June
Click here to register!!
I'm starting the first leg of a literal `round-the-world business
trip.
I'm flying from my home in Seattle, via LAX, to Melbourne
Australia. There I will meet up with my friend Stewart
Smith, the Director of Engineering at Percona. He is fellow
survivor of MySQL & Sun, and a fellow contributor to Drizzle.
Other good friends of mine who are converging on Australia for
LCA 2012 are Sarah Novotny, Monty
Tayler, and Jacob Applebaum.
Why am I going to Australia? Geeks into open source who are
"in the know" know the Linux.conf.au conference to be one of the …
I understand that the new technology can be scaring and this
makes entry barriers to try and get familiar with it.
That’s why I created simple set of scripts which setup N nodes
cluster on running EC2 instances.
The script assumes that you have running N EC2 instances (in the
same availability zone) running RedHat Enterprise Linux 6.2 64bit
(I use m1.xlarge size).
You put hostnames of the instances into ec2hosts.txt
file and run install.nodes.sh script.
You also should have your private key to access to your instances
(test-cluster.pem in my case).
For my box installing and starting 3 nodes took exactly
time install.nodes.sh ... real 2m51.257s
In fact you can deploy as many nodes as you want, I made also running 20 nodes cluster.
After that you have the cluster deployed and ready to accept queries!
The scripts are …
[Read more]You can pre-order the new edition of High Performance MySQL now on Amazon or via O’Reilly’s website. Eric Bergen called the second edition “the best MySQL book on the planet”. What will the third edition be called? The best in the solar system? This reminds me of a joke, supposed to be a true story: three pizza restaurants next to each other had signs saying “best pizza in town,” “best pizza in the world,” and “best pizza on this block.
A customer recently asked if I could help clarify the
relationship between rows_examined (in the slow
query log) and the Handler% variables (in SHOW STATUS output) for
a simple UNION. I didn't know the answer off the top of my head,
but I didn't think it would be too terribly difficult to find it.
Several days and many hours of work later, I think I finally have
some idea of how this all works.
Let's first set up some sample data and get some information about it. (I'm using MariaDB 5.2.4 for these tests because that's the version the customer was using. This should basically all apply to other versions/vendors, except specific changes I refer to in MariaDB 5.3.)
maria 5.2.4> create table t1 (id int, key(id)); Query OK, 0 rows affected (0.01 sec) maria 5.2.4> \! seq -f '(%.0f)' -s, 1 10 (1),(2),(3),(4),(5),(6),(7),(8),(9),(10) maria 5.2.4> insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10); Query OK, 10 …[Read more]
New in the PHP manual: a mysqli quickstart. You are new to PHP but you know how to code, you know SQL, you know relational databases and MySQL? Then, I hope, this is for you. All you need is a quick overview on the concepts? The rest is in the reference section! Here you go.
The quickstart contains:
The collaboration is good and the information was useful!!!!!!!!!