We’re on the move again. Come and join us on the 7th of November at the Oracle office in Barcelona. Find out more details about what was announced at MySQL Connect, as well as what’s next…
For more information about this event please visit the link below:
http://www.oracle.com/us/dm/29173-emeafm13045970mpp010-oem-2020763-es.html
Just a quick post to note that the content from my hands-on lab at MySQL Connect (“MySQL Enterprise Features in Practice”) has been uploaded to the content catalog, and can be found here. This includes the 36-page lab manual and example commands and programs (mostly in Java; the package includes both compiled and source code). For those who attended the lab, this is an opportunity to complete the exercises we didn’t get to in the 2.5 hours, and for those who missed it, an opportunity to learn more about the features and capabilities of key MySQL Enterprise products and features such as MySQL Enterprise Audit plugin, MySQL Enterprise Monitor and MySQL Enterprise Security (PAM plugin). I hope to expand on the lab content …
[Read more]Quite some time ago, I published scripts to implement password policies for MySQL, and promised to show how to expose violations of that policy via MySQL Enterprise Monitor (MEM). That stalled somewhat with other objectives, but I want to revisit it now that MEM 3.0 is GA. If you haven’t tried MEM 3.0 yet, consider doing so – it’s quick and easy to set up.
Many people don’t realize that MEM can be extended to monitor things beyond MySQL Server health, including visibility into application state as observed from the database. In part of the hands-on-lab I recently led at MySQL Connect, we …
[Read more]After a slight delay (travel and catching up with “real work”), I’ve now uploaded the talks that I gave at MySQL Connect and Oracle Open World.
They are available on my Presentations Page, and inline below for convenience. The “Introduction to MySQL Enterprise Monitor” talk was actually a full demo, but there are some screenshots of MEM 3.0 in there if you’re interested in seeing a high level picture of what it looks like now.
Thanks to all that attended my talks, I got a lot of good questions and feedback!
Performance Schema and ps_helper MySQL Administration and Monitoring …
[Read more]
I had to laugh (just a bit) at this on the exhibitor floor at
Oracle Open World 2013. There was a large MongoDB presence at the
Slot 301. There are a few reasons.
First, the identity crisis remains. There is no MongoDB in the
list of exhibitors, it’s 10gen, but where is the 10gen
representation in the sign. 99.99% of attendees would not know
this.
Second, the first and only slide I saw (as shown below), tries to
directly compare implementing a solution to Oracle. The speaker
made some comment but I really zoned out quickly. Having worked
with MongoDB, even on one of my own projects, contemplated the
ROI of being proficient in this for consulting, even discussing
at length with the CEO and CTO, and hearing only issues with
MongoDB with existing MySQL clients, I have come to the
conclusion that MongoDB is a niche product. It’s …
Ok, so after all the things that have been announced @MySQLConnect, I’ve got to play around with them. First stop: space (no.. not ‘the final frontier’).
I need more space on my f/s to get installing. I was a bit of a scrooge when I created my Oracle Linux virtual machine, so now I’m paying the price.
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_ol63uek01-LogVol01
7.1G 5.7G 1.1G 85% /
As I’m using Virtual Box, I’ve added a new SATA Controller vmdk of 10G, SATA Port 1 and then start it up.
fdisk -l
Will be able to identify the new & unused partition:
[root@ol63uek01 ~]# fdisk -l Disk /dev/sda: 8589 MB, 8589934592 bytes 255 heads, 63 sectors/track, 1044 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: …[Read more]
Ok, so after all the things that have been announced @MySQLConnect, I’ve got to play around with them. First stop: space (no.. not ‘the final frontier’).
I need more space on my f/s to get installing. I was a bit of a scrooge when I created my Oracle Linux virtual machine, so now I’m paying the price.
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_ol63uek01-LogVol01
7.1G 5.7G 1.1G 85% /
As I’m using Virtual Box, I’ve added a new SATA Controller vmdk of 10G, SATA Port 1 and then start it up.
fdisk -l
Will be able to identify the new & unused partition:
[root@ol63uek01 ~]# fdisk -l Disk /dev/sda: 8589 MB, 8589934592 bytes 255 heads, 63 sectors/track, 1044 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: …[Read more]
Later this week I’m traveling to San Francisco to attend MySQL Connect – which looks like an exciting event to be at. I’m going to deliver two talks at this show, both on Sunday – MySQL Indexing Best Practices for MySQL 5.6 and Optimizing MySQL Configuration for MySQL 5.6. I will also be there for a Percona Toolkit BoF on Saturday and at our Booth (6004) during select expo hall hours.
What I’m looking forward to at this event the most is an update on MySQL technology both from Oracle’s engineering team as well as MySQL users. People from Facebook, Twitter, LinkedIn, Paypal …
[Read more]Now with summer winding down and school back in session, we get into a very busy time with many great opportunities to discover more about MySQL with several excellent MySQL events.
At first I wanted to cover all autumn events here but if I did that this post would be far too long. So instead I’m focusing on a few wonderful MySQL events that I’m going to be involved with in September.
In a few short days we’re running Percona University at Washington, D.C. This free event on September 12 provides a great opportunity to learn about latest developments in the MySQL ecosystem as we at Percona see it. I personally will be speaking about …
[Read more]The MySQL Connect content catalog is published, and I’ll be leading a hands-on lab on MySQL Enterprise Features in Practice [HOL9787]. If you have wondered how to get the most out of the features of MySQL Enterprise subscriptions – whether you are an existing Enterprise customer or not – this lab is for you. We’ll help you understand the benefits of the various components of the MySQL Enterprise subscription as you install, configure, demonstrate and use the …
[Read more]