Monday Dec 23, 2013

Last Classroom Training of CY'13

To publish a class photo of CY'13 in CY'14 would signal the height of laziness. So before this year give way to the next one, let me put up the photograph of my last in class training of CY'13 on MySQL.

Sunday Sep 01, 2013

Before it's too late...

It has been quite a few weeks since I have been wanting to publish photographs of my recent classes, but laziness got better off me on all occasions. Let me put it up here with no further delay:


Oracle VM for SPARC session in Bangalore.


MySQL for DBA session in Bangalore.

Sunday Jul 14, 2013

Some Quick Updates

That I've been busy is an understatement. In the last four weeks or so, managed to do programs on technologies ranging from Operating platform to Database to Engineered Systems. In the process I met up with the following folks:


MySQL Training in Noida.


Exadata Training in Singapore.


Solaris 11 Training program at Chennai.

In addition, I had connected with many others, but don't have their 'faces' to show coz I met them on WebEx.

Sunday Apr 14, 2013

MySQL Cluster & MySQL HA Session in Kuala Lumpur

Class photograph from MySQL Cluster session in Kuala Lumpur.



Talking of another High Availability facility in MySQL named Replication, I invite you to read an interesting blog post on self healing recovery in MySQL 5.6 Replication here. For a detailed list of courses on MySQL database access this url.

Sunday Mar 10, 2013

MySQL HA and MySQL Cluster Sessions

Completed an OU program on MySQL Cluster and MySQL HA at Penang, Malaysia last week.



To know more on MySQL Cluster, visit the official webpage here. To know more about the MySQL Cluster Certification program,go here.

Sunday Sep 30, 2012

Last fortnight...

In the last fortnight, I had an opportunity to meet up with some very energetic folks, who actively participated in a couple of OU programs on Solaris 11 and MySQL. I thank them for their participation and hope all of 'em had a good learning experience showing up for Oracle University programs.

As always, I'm publishing below a moment from each of the aforesaid programs.


MySQL DBA session in Bangalore.
It's unfair if I don't express my heartfelt thanks to each of 'em for a serious teach back session through out the training program and I wish to do so by publishing moments from each one's teach back assignment:




Below is a class photograph from Solaris 11 Administration Session in Bangalore.


Wednesday Sep 26, 2012

MySQL Instance from Generic Binary on Linux

In a class happening on MySQL this week at Bangalore, someone asked me for steps to have MySQL installation and instance configuration on Linux using generic binary, and for more than one of it. Prepared some notes for 'em and with a hope that there may be others in need of it, I'm posting it here.

Friday Sep 14, 2012

MySQL DBA Session

With thanks to all people in the picture, the MySQL DBA session in Chennai came to a conclusion today.



Thanks to 'em also for the teach back sessions:

Visit here to see the course offerings on MySQL from Oracle University.

Friday Sep 07, 2012

Configuring Multiple Instances of MySQL in Solaris 11

Recently someone asked me for steps to configure multiple instances of MySQL database in an Operating Platform. Coz of my familiarity with Solaris OE, I prepared some notes on configuring multiple instances of MySQL database on Solaris 11. Maybe it's useful for some:

If you want to run Solaris Operating System (or any other OS of your choice) as a virtualized instance in desktop, consider using Virtual Box. To download Solaris Operating System, click here.

Once you have your Solaris Operating System (Version 11) up and running and have Internet connectivity to gain access to the Image Packaging System (IPS), please follow the steps as mentioned below to install MySQL and configure multiple instances:

1. Install MySQL Database in Solaris 11
$ sudo pkg install mysql-51
2. Verify if the mysql is installed:
$ svcs -a | grep mysql
Note: Service FMRI will look similar to the one here: svc:/application/database/mysql:version_51
3. Prepare data file system for MySQL Instance 1
zfs create rpool/mysql
zfs create rpool/mysql/data
zfs set mountpoint=/mysql/data rpool/mysql/data
4. Prepare data file system for MySQL Instance 2
zfs create rpool/mysql/data2
zfs set mountpoint=/mysql/data rpool/mysql/data2
5. Change the mysql/datadir of the MySQL Service (SMF) to point to /mysql/data
$ svcprop mysql:version_51 | grep mysql/data
$ svccfg -s mysql:version_51 setprop mysql/data=/mysql/data
6. Create a new instance of MySQL 5.1
(a) Copy the manifest of the default instance to temporary directory:
$ sudo cp /lib/svc/manifest/application/database/mysql_51.xml /var/tmp/mysql_51_2.xml
(b) Make appropriate modifications on the XML file
$ sudo vi /var/tmp/mysql_51_2.xml
-> Change the "instance name" section to a new value "version_51_2"
-> Change the value of property name "data" to point to the ZFS file system "/mysql/data2"
7. Import the manifest to the SMF repository:
$ sudo svccfg import /var/tmp/mysql_51_2.xml
8. Before starting the service, copy the file /etc/mysql/my.cnf to the data directories /mysql/data & /mysql/data2.
$ sudo cp /etc/mysql/my.cnf /mysql/data/
$ sudo cp /etc/mysql/my.cnf /mysql/data2/
9. Make modifications to the my.cnf in each of the data directories as required:
$ sudo vi /mysql/data/my.cnf
Under the [client] section
port=3306
socket=/tmp/mysql.sock
----
----
Under the [mysqld] section
port=3306
socket=/tmp/mysql.sock
datadir=/mysql/data
-----
-----
server-id=1
$ sudo vi /mysql/data2/my.cnf
Under the [client] section
port=3307
socket=/tmp/mysql2.sock
-----
-----
Under the [mysqld] section
port=3307
socket=/tmp/mysql2.sock
datadir=/mysql/data2
-----
-----
server-id=2
10. Make appropriate modification to the startup script of MySQL (managed by SMF) to point to the appropriate my.cnf for each instance:
$ sudo vi /lib/svc/method/mysql_51
Note: Search for all occurences of mysqld_safe command and modify it to include the --defaults-file option. An example entry would look as follows:
${MySQLBIN}/mysqld_safe --defaults-file=${MYSQLDATA}/my.cnf --user=mysql --datadir=${MYSQLDATA} --pid=file=${PIDFILE}
11. Start the service:
$ sudo svcadm enable mysql:version_51_2
$ sudo svcadm enable mysql:version_51
12. Verify that the two services are running by using:
$ svcs mysql
13. Verify the processes:
$ ps -ef | grep mysqld
14. Connect to each mysqld instance and verify:
$ mysql --defaults-file=/mysql/data/my.cnf -u root -p
$ mysql --defaults-file=/mysql/data2/my.cnf -u root -p


Some references for Solaris 11 newbies
Taking your first steps with Solaris 11
Introducing the basics of Image Packaging System
Service Management Facility How To Guide

For a detailed list of official educational modules available on Solaris 11, please visit here
For MySQL courses from Oracle University access this page.

Sunday Jun 10, 2012

Year 2012 So Far...

It's hard to seek excuses for not showing up in here for regular updates. I'm not venturing into it hence. Year 2012 has been very engaging, both professionally and personally, and I wish to present before you some wonderful people whom I met in the OU classrooms while delivering training programs on various Oracle technologies. While I went through a number of Oracle products in the last few months, two of 'em were more regular than others: Solaris 11 and MySQL. Not to forget the First Global Teach Live Virtual Class on Java ME.


Oracle Solaris 11 Training in Bangalore


Oracle Solaris 11 Training in Delhi


Oracle Solaris 11 Training in Hyderabad


Oracle VM for SPARC Training at OU Hong Kong


Oracle VM for SPARC Training at Bangalore


Oracle Solaris 11 Training in Bangalore


Oracle Solaris 10 Training in Bangalore


Oracle Solaris 11 Training in Delhi


MySQL training Programs at Kochi, Kerala.


Attending Ofir Leitner's Pilot teach on Java ME


Oracle Solaris 11 Training in Bangalore

Sad, I don't have photographs of some smart people whom I came across in my live virtual classes on various Oracle technologies:(

Friday Sep 30, 2011

MySQL DBA Session at Yahoo, Bangalore

Friends from Yahoo who showed up for an OU program around MySQL.


If there are people out there, who'd wish to know what OU has in offer for professionals well versed in MySQL Database Administration, please refer to the MySQL Performance Tuning and MySQL Cluster course description and schedule.

And for those interested to validate their skill on MySQL DBA, I recommend MySQL DBA Certification exam. Believe me, taming sakila is an experience in itself.

Monday Jun 08, 2009

Taming Sakila

Just under two months ago I decided to embark on a journey through the Certification roadmap of the Worlds most Popular Open Source Database. They say, Certification isn't a substitute for real world experience. Who says it is? But it certainly has the element to motivate someone to go after a new technology, just the way it occurred to me. This morning, the journey that I've mentioned above completed rather satisfactorily, leaving me in possession all possible titles from the MySQL Certification roadmap viz CMDEV, CMDBA and CMCDBA. I'm happy is an understatement.


My entry into the world of database has nothing to do with any recent announcement from Sun, but does have a connection with an announcement from our CEO, published well over a year ago. Since then, MySQL came up in all serious conversations at Sun and that perhaps is one main factor that encouraged me to go after a technology with such a massive installation base. I regret to have taken some time before finally going for it, but the learning curve was extremely smooth and exciting.

In general, I spend a lot of time reading books (not necessarily technical) and there are some books (read technical) that I value more than others which includes Practical Unix and Internet Security, Learning Perl, Mastering Regular Expressions, Perl Cookbook to name a few. The book MySQL 5.0 Certification Study Guide easily falls into the aforesaid category for its simplicity, clarity and richness in content. Thanks to Safari Books Online, I could thoroughly utilize an online copy of MySQL 5.0 Certification Study Guide to prepare for MySQL 5.0 DBA and Developer Exams. To make it curt, this one is strongly recommended.

A similar material is available for candidates preparing for the Certified MySQL 5.1 Cluster DBA exam and its details are available here.

So if any of you feel it's time for you to tame Sakila and then show up for a test to prove you have done so, please make use of the resources as mentioned above, or find a training program at a suitable time and location, read the faqs, create a VUE ID\* , register for an exam and GO FOR IT with no second thoughts. Oh yeah...don't forget to check out these sample Questions before the test. Good luck!

\*Beginning on July 31st, 2009 MySQL Exams will no longer be delivered by Pearson VUE. For more details click here.

Tuesday Mar 03, 2009

Integrating GlassFish Web Space Server with OpenSSO

Last week I was engaged in bringing up a demo set up at Sun Solution Center in Bangalore, employing a number of components from Sun Software Stack, including IDM (Sun's provisioning tool), OpenSSO (Sun's Access Management Solution), DSEE (User Data Store), MySQL (Sun's database), GlassFish (Sun's Application Server) and Glassfish Web Space Server (Sun's portal solution) installed in Solaris Containers.

For reference, the deployment scenario is depicted in the diagram below:



The phase I of implementation involved integrating Sun's IDM with OpenSSO. The following was the objective:

[\*] Configure OpenSSO Enterprise to protect Identity Manager, and to allow single sign-on login to the Identity Manager user and administrative interface.
[\*] Configure Identity Manager to provision users and roles to OpenSSO Enterprise.

To achieve the above,there is a neat documentation available here.

Once I got the above integration of IDM and OpenSSO functional in our set up, users could be provisioned from Sun Identity Manager to the 'idm' realm in OpenSSO (which finally gets stored in the DSEE 6.x configured as the User repository for OpenSSO).

The actual reason for adding an entry on my blogs around this set up is to express my excitement on discovering the ease of integrating GlassFish WebSpace Server with OpenSSO. I'd reiterate those steps performed to make the GlassFish Web Space Server (installed in one zone of Solaris 10 OS) contact OpenSSO (installed in another zone) for authentication. I presume, this exercise can be performed in a matter of few minutes. So set your stop watch and get going:

Acquire Glassfish v3 prelude. Then click here and download OpenSSO. For instructions on installation, read my friend David's blog. You would remember him to be the author of free training on OpenSSO. Create a realm, if needed (say 'idm').



Download Glassfish WebSpace Server 10.. To install WebSpace Server, you would also need Ant 1.7 or higher from here. Now follow the steps (the following example uses WebSpace Server bundled with Glassfish):

[1] Unzip Ant and GlassFish WebSpace Server.
[2] Set ANT_HOME variable to point to the directory location of new version of ANT.
[3] Goto webspace_dir/glassfishv2 directory and run the following command:
ant -f setup.xml
[4] Once the above step is completed, goto webspace_dir/glassfishv2/bin directory and start domain:
./asadmin start-domain
[5] Upon successful completion of above step, open a browser and access the following URL:
http://webspaceserver_host:8080

If any of the above steps seems ambiguous, please read the installation instructions here.

Once the GlassFish WebSpace Server page is up on the browser, login using the credentials of Administrator (admin@example.com/admin), click on the Control Panel -> Settings -> Authentication -> OpenSSO. Following page is what you would see on your browser.



On the page as displayed above, following is the information filled in to make the WebSpace Server contact the 'idm' realm in OpenSSO for authentication of users. Not only that, on successful authentication with OpenSSO, WebSpace Server populates the user information from OpenSSO in its database (HSQL by default)!

Login URL:
http://opensso.ssc-blr.co.in:8080/opensso/UI/Login?realm=idm&goto=http://webs.ssc-blr.co.in:8080/c/portal/login

Logout URL:
http://opensso.ssc-blr.co.in:8080/opensso/UI/Logout?realm=idm&goto=http://webs.ssc-blr.co.in:8080/web/guest/home

Service URL:
http://opensso.ssc-blr.co.in:8080/opensso

Glassfish WebSpace Server installation,configuration and integration with OpenSSO is such a pleasant experience that I invite you to try it and experience it for yourself.

Tuesday Dec 09, 2008

MySQL 5.1 Now Available

A new version of the worlds most popular opensource database is now available for download. Read about its features here or straightaway download it from here.

Tuesday Sep 09, 2008

Sun's Multi-Million Dollar Deal


Referring to the title of this post, read the whole story here. By the way all through the article in the aforesaid link, you would read about two major Open Source projects of Sun. Click on each of the image above and you would get enough information about both of it.

Thursday Feb 28, 2008

SELECT keynotes FROM suntechdays08 WHERE day=02



Doesn't the title sound really weird? The gentleman in picture would disagree. Neither would he tolerate someone pronouncing MySQL as "My-See-Kwel" . Didn't Rich Green in his keynote make it clear that MySQL is actually "My-Ess-Kyew-Ell" and NOT "My-See-Kwel"? Most of us are used to say it the 'wrong way' and now It's hard to change, I know. But for this man and his mate, who opened up immense opportunities in the field of database, can't we extend at least this small favour of twisting our tongue slightly differently? Let's try it.

David Axmark walked quite unhurriedly on to the dais. He spoke very calmly and with minimal body movements. It was indeed a charm to watch the co-founder of MySQL speak about its history, Innovation by different means, the decision to make it freely available and finally joining Sun on Tuesday, February 26 2008. The story that David told this morning was a pleasure trip for all of us on the evolution of a popular database, used by some big names in the market. Here is a humble attempt to produce the summary of his keynote today at Sun Tech Days 2008 :

I captured the first slide that David used, titled MySQL History and I think I can safely INSERT (God I'm already influenced this db) that in here, undistorted:

\* 1982: First database code is written
\* 1995: First pure MySQL code
\* 1996: Public release & over 1000 downloads
\* 2001: 'Real' company started. First investment CEO joins
\* 2008: Sun acquires MySQL for 1 Billion USD

David then continued his story telling us how adamant they were to stick on to the '15 minutes rule.' Now in case if you wonder what this 15 minutes rule is all about, this is what David would say about it: "So we worked hard to make the installation and the first use as easy as possible. We came up with the 15 minutes rule: we wanted a user to be able to have MySQL up and running 15 minutes after he finished downloading it." [Read about it in an interview with David Axmark here].

Another one slide that David displayed during his keynote talked about the fact that Innovation in OpenSource tends to be a lots of small but very useful ideas. As an example he mentioned about how the SELECT statement made its way into MySQL, an idea came from the founder of PHP, which now has spread to other databases.

David admitted that he didn't know much of Java and when there was need to develop a JDBC driver for mysql, they looked at various drivers developed by the University students, picked up the best one and hired the guy who created it! He went on to say how open sourcing a product helps to easily identify the right talent (may be for hiring) as against the traditional method of going through the CV, a process that would take longer time for obvious reasons.

He recalled how difficult it was to convince the market on the advantages of giving away the product for free and that too in an era when open source wasn't a very popular affair. I felt excitement in his voice when he mentioned, because it was open source and free, they could find a lot of people using their database in a very in a very short span of time. And when such a free and open stuff works, then why think of another.

One another advantage of open sourcing a product, he says, is to have the code scrutinized by a number of Security organizations rather than one company certifying a product as secured, get instant feedbacks about the security flaws and fix it immediately. He mentioned that a large amount of code in MySQL was written by the community.

When David listed a number of programming languages that could connect to MySQL, I wished I could think of one language that I knew or heard of, which wasn't in the list. But I doubt, coz just about any programming language on this planet can connect to this database.

David concluded his keynote telling us all how excited he was to join Sun, but at the same time didn't conceal his anxiety of moving from a smaller firm to organization with well over 30,000 people. David's presentation was such an informative one.

Vijay Anand, Vice President in the Server Technologies Division at Oracle Corporation, India was the next keynote speaker this morning. Tell you what, I was quite impressed with his flawless presentation and his in depth knowledge on the topic that he was handling. He had two Senior Product Managers from Oracle showcasing a demonstration of their Middleware Fusion components.

I have seen Vijay Anand speaking at last year Sun Tech Days as well. Last year, it was as if he was stuck to the podium and maintained very minimal eye contact with the audience. But this year, he walked around the stage, made proper eye contacts with the audience, paused at the right spot to induce curiosity among the audience. He had broken his presentation into several logical sections, which made really good sense and more than that he injected the right amount of information, with appropriate examples everywhere and illustrations. Thanks to Vijay Anand, I got a much better clarity on SOA.



The first few slides in Vijay Anand's keynote talked about the Web 2.0 experience. He then discussed Mashup and the need to employ something similar even in Enterprise, which he called Enterprise 2.0. I enjoyed the way he displayed a slide building one component after the another in such an architecture and that included an ESB, BPEL, and CEP.

A demonstration of the shopping cart experience summarized the whole discussion. One of the Managers who was assisting Vijay Anand in his keynote, demonstrated the Oracle WebCenter and how an Administrator could login to it, check his E-mails, detect credit card frauds, review policies and perform so many activities which are otherwise performed in isolation. A damn neat and convenient way of brining in data from various sources to a single browser space; just the way Web 2.0 magic works. I thoroughly enjoyed what Vijay Anand spoke for about 40 minutes or so.

'Java Jacket Give Away' is a fun event at Sun Tech Days. A handful of delegates are given an opportunity to perform their weird talents on the stage and the audience would choose the weirdest of talent among them and winner gets to take a leather Java Jacket. I don't think this years 'Java Jacket Give Away' event was as good as the one last year. The Java Jacket was given to a girl who sang a classical song. Let me reveal the pattern here: last year also it happened the same way. So make sure that you fine tune your throat before the next Sun Tech Days so that you could give yourself a good chance to carry a leather Java Jacket. This event was followed by cutting a cake, marking tenth anniversary of Sun Tech Days in India.

To all the Sun Tech Days 2008 absentees, if only you wouldn't feel depressed, let me share with you this: the Sun Tech Days celebration this evening had some gorgeous models taking the ramp and walking in tune to the music of a DJ. It was exotic, to say the least. I know your next question, "Where are the photos?" Not answering .

Wednesday Jan 16, 2008

Sun's Acquiring MySQL

The title says it all. This is a great news. I don't want to spoil the party by writing a lengthy note about it. So hear it from THE MAN.
Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
16
17
18
19
20
22
23
24
25
26
27
28
29
30
   
       
Today
Bookmarks