Showing entries 31 to 40 of 59
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: MySQL Enterprise (reset)
My Oracle Support 6.5: Key new features

If you are a MySQL support customer, the recent release of My Oracle Support (MOS) 6.5 has some features which may interest you (if you’re not a customer, this post likely won’t interest you). MOS 6.5 was introduced on 06 April, and with it came the ability to opt in to receive service request (SR) update details via email. This was a feature some MySQL Support customers missed after the migration to MOS. Thanks to feedback from MySQL Support customers and others with similar needs, this feature has now been implemented. Because email is an inherently insecure delivery mechanism, not all customers will wan this, and the feature requires customers to explicitly opt in before SR update content is sent via email.  Coupled with the MOS Mobile interface, Support customers have a number of flexible ways to access and manage SRs.

The second major enhancement is the ability to …

[Read more]
MySQL PAM/LDAP authentication module configuration

MySQL Enterprise 5.5 (trial version available here) includes MySQL PAM authentication plugin. In this post I will show how to configure it with the OpenLDAP and Active Directory.

MySQL PAM authentication uses Linux pam_ldap library to send the calls. To configure MySQL LDAP authentication we will need to configure pam_ldap on linux.

OpenLDAP Linux configuration

  • Make sure that libpam-ldap/openldap is installed. If not, on RedHat/CentOS use commands:

# yum install openldap openldap-clients

  • Configure /etc/ldap.conf. Sample configuration:

debug 10 # set debug level only during the initial configuration
base dc=corp,dc=company_name,dc=com
binddn cn=service_account,OU=Service Accounts,OU=US Security,DC=corp,DC=company_name,DC=com
bindpw <password>
timelimit 120 …

[Read more]
Successful Dallas Tech Tour

Benjamin Wood talks at the Dallas MySQL Tech tour on the history of MySQL

The first MySQL Tech Tour in Dallas is over. A capacity crowd filled the room. Only a few had never had ‘hands on’ with the MySQL database and very few were comfortable source code readers. The majority came to hear about embedding MySQL, how to tun systems for better performance, and some new features in the product.

Benjamin Wood started with a presentation on the history of MySQL and the changes in the product over the last few releases. Craig Sylvester showed how to use embedded MySQL. Then Benjamin capped off the event with a presentation on database monitoring and performance tuning. The event did go slightly over scheduled time due to an extended question and answer period following the presentations.

Thanks to all who attended.

[Read more]
MySQL Enterprise Monitor Part II

Last time, I installed the MySQL Enterprise Monitor and the Monitor Agent on an Ubuntu system. I was able to get both parts to talk to each other and get the graphs to display.

Two system being monitored with MySQL Enterprise Monitor

I installed the Agent on a Mac and had it displaying data in literally less time than it took to type this sentence.

I could information on both systems or dig down into each server. The dashboard has red, yellow, or green icons on various status items.

What — two alerts on my Ubuntu box?  I clicked on the link and found I had CPU Usage Excessive and CPU I/O Usage Excessive during a time I was bulk loading data.  I was able to mark those off the ‘to be worried about’ list.  There are other …

[Read more]
MySQL Enterprise Monitor

MySQL Enterprise Monitor or MEM is a tool to watch over one instance to a farm of MySQL servers, to warn you of problems, and can advise you on fixing problems.

The is the MySQL Enterprise Monitor Dashboard

But what does it take it get it running? How much can it show me about my server?

Start by downloading MEM from the Oracle Software Delivery Cloud (And it is still free for a 30 day trial). In addition to the monitor, make sure you download the monitor agent. For my 32-bit Ubuntu test box, there were named mysqlmonitor-2.3.7.2104-linux-x86-installer.bin and mysqlmonitoragent-2.3.7.2104-linux-x86-installer.bin.

Executing …

[Read more]
MySQL Enterprise Backup Part III

MySQL Enterprise Backup (MEB) provides an easy way to perform incremental backups. You do have to know the log sequence number or LSN1 of the previous backup. And you can find the LSN in the meta/backup_variables.txt file from the previous backup.

MEB saves all the changes from the specified previous backup, see the mysqlbackup: INFO: Backup contains changes from lsn 14652513 to lsn 14659161 line from the following:


$ ./mysqlbackup --incremental -u root -p --incremental-backup-dir=/home/dstokes/foo2 --with-timestamp --start-lsn=14652512 backup

MySQL Enterprise Backup version 3.6.0 [2011/07/01]
Copyright (c) 2003, 2011, Oracle and/or its affiliates. All Rights Reserved.

INFO: Starting with following command line ...
./mysqlbackup --incremental -u root -p
--incremental-backup-dir=/home/dstokes/foo2 …

[Read more]
MySQL Enterprise Backup Part II

Last time I used MySQL Enterprise Backup to save an entire database. Now it is time to test that backup. The first step is to shutdown the MySQL server using mysqladmin.

bin# ./mysqlbackup --defaults-file=/etc/mysql/my.cnf --backup-dir=/home/dstokes/foo2 copy-back
MySQL Enterprise Backup version 3.6.0 [2011/07/01]
Copyright (c) 2003, 2011, Oracle and/or its affiliates. All Rights Reserved.

INFO: Starting with following command line ...
./mysqlbackup --defaults-file=/etc/mysql/my.cnf
--backup-dir=/home/dstokes/foo2 copy-back

IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'copy-back' run mysqlbackup
prints "mysqlbackup completed OK!".

mysqlbackup: INFO: Server repository configuration:
datadir = /usr/local/mysql/data
innodb_data_home_dir = /usr/local/mysql/data
innodb_data_file_path = …

[Read more]
MySQL Enterprise Backup Part I

This is the first in a series of postings on the MySQL Enterprise tools. I know most of you reading are dedicated community server users but you may have wondered ‘What do you get when you buy MySQL Enterprise server?’

Well, first of all, you can try the Enterprise Server for free for thirty days. Point your browser to Oracle Software Delivery Cloud and download. Hopefully you can following along with me as I try the various Enterprise tools starting with MySQL Enterprise Backup.

Data backups have long been a part of my professional life. My ‘first real’ job was backing up data on a DEC Tops-10 system that ran the University of San Diego. Much of my working time at night was spent loading, unloading, and monitoring reel tapes as the data from the washing machine sized disk drives was spread over magnetic oxide bonded to plastic …

[Read more]
Aloha – MySQL Dives into the Thread Pool

By now you have probably heard about the MySQL thread pool plugin and API, but you may not have fully processed the details. Here’s the quick summary:  With the new thread pool plugin, there is now an alternative way to handle connection threads in MySQL Enterprise Edition.  With the plugin, MySQL connection threads are shared like an extraordinarily well managed timeshare in Hawaii.  When one connection is “idle”, asking nothing of and expecting nothing from the database, another connection can use that same thread for its database requests.  Threads are released by each connection as soon as the request is completed and  go back into the pool for re-use – just like the theoretical timeshare is up for grabs on the weeks you are not there.

In the older, and still default connection thread model, threads are dedicated to a single client  for the life of the connection and there are as many …

[Read more]
MySQL at the core of commercial open source

Oracle last week quietely announced the addition of new extended capabilities in MySQL Enterprise Edition, confirming the adoption of the open core licensing strategy, as we reported last November.

The news was both welcomed and derided. Rather than re-hashing previous arguments about open core licensing, what interests me more about the move is how it illustrates the different strategies adopted by Sun and Oracle for driving revenue from MySQL, and how a single project can be used to describe most of the major strategies …

[Read more]
Showing entries 31 to 40 of 59
« 10 Newer Entries | 10 Older Entries »