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.

Saturday Sep 08, 2012

From The OU Classrooms...

No excuses for not doing this systematically, and I'm trying my best to break this bad habit of bulk uploads of class photographs and do it regularly instead. But for the time being, please forgive my laziness and live by my mass introduction of all fun loving, yet talented folks whom I met in the OU classrooms during the last three months or so through these picture essay that follow. It's unfortunate, I don't get to do this for my Live Virtual Classes for obvious reason,but let me take a moment to thank them all as well for choosing OU programs on various products. Thanks again to each one for memorable moments in the OU classrooms:


Pillar Axiom MaxRep session at Bangkok. For detailed information on the OU course on Pillar Axiom Max Rep, access this page.


Pillar Axiom SAN Administration Session at Bangkok. Know more about the product here. Details on the Pillar Axiom training program from Oracle University can be found here.


Oracle Solaris ZFS Administration & Oracle Solaris Containers session at Hyderabad. Read more about ZFS here. Gain information on Solaris Containers by going here. Oracle University courses on Solaris 10 and its features can be viewed at this page.


Oracle Solaris Cluster program at Hyderabad. Here's the OU landing page for the training programs on Oracle Solaris Cluster.


Oracle Solaris 11 Administration Session at Bangalore. If you are interested to get trained on Solaris 11, get more details at this webpage.


Sun Identity Manager Deployment Fundamentals session at Bangalore. The product is n.k.a Oracle Waveset IDM. Click here to get detailed description on this fabulous hands on training program.


With Don Kawahigashi at Taipei for Pillar Axiom Storage training.

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:(

Saturday Dec 31, 2011

New Year Wishes - Year 2012

Dear friend,

Ha, finally it's concluding. Pardon me for starting this one on a very personal note. I've been wanting to spend a day harking back on some big changes in my life, both professional and personal. And I think there isn't a better day than today to do so, when the whole world would bring down the curtain on a twelve month long period and welcome the arrival of another dozen months, filled with immense potential to fulfill all resolutions that'd open up today. I am not a big fan of New Year Celebrations, coz just like you, I know it's only a calendar on the wall that gets replaced. All other things in life, almost, seems to stay the same. But this time around I was in need of a checkpoint to reflect and digest on some wondrous events in life that unfolded in the last several months. And so I am happy that an eventful Year 2011 is finally giving way to its successor.

I have had the taste of joy and sorrow, successes and failures, gains and losses, and many other dualities of existence in the year that's passing by. Tell me if you know someone who had a different pattern in their life. It'd be foolish of me to expect the coming year to offer me only roses all the way, but I would certainly wish to have a life filled with many positive moments in the New Year that's marching in. I wish and hope the same for you as well.

In the Year 2011 that's to become history in a few hours from now, if I've hit the Losada Line most part of the year, that's solely because of some wonderful human relationships. I don't believe I've any better asset than the people who have connected with me through one channel or the other. And so the main reason to show up, just like every year on this day, is to express my deep felt gratitude to you for being there for me and for helping me stay positive, one way or the other. Thank you .

Also, I wish you good luck with the list of resolutions that you've prepared yourself for the coming year and pray you don't fall prey to the events that'd fall on January 16 2012, Monday.

Wishing you a good Year 2012 ahead...

Solaris Administration Sessions

I've been lazy to show up on this site to update on what I've been up in the last couple of months. I wish to get over that before Year 2011 give way to 2012. So let me make it curt: I've been learning and teaching mostly Solaris.

Published below are the photographs of people whom I met up in the process of discussing Solaris, the most recent batch at the top and the oldest at the end:


Solaris 10 Administration Session @ Delhi

Transition to Solaris 11 Session in Bangalore

Solaris 11 Administration Session in Bangalore

Transition to Solaris 11 Session in Bangalore

Saturday Oct 29, 2011

Transition to Solaris 11 - Batch III

With just under a fortnight left for the official launch of Oracle Solaris 11, the elite club of OU trained Solaris 11 professionals has grown by a few additional numbers.



I've no doubt that their experience on transitioning to Solaris 11 have been enriching. So don't wait anymore, come join the Solaris 11 Club!

Well, if you aren't convinced on hearing this from an insignificant soul like me, I recommend you go here and register for the Oracle Solaris Launch webcast on November 09 2011, Wednesday (9:00 a.m. – 1:30 p.m. ET) and hear it straight from the people who matter. Again, don't miss this historic event. Register NOW!.

Tuesday Oct 18, 2011

Java SE 7 Certification

More details are here.

Friday Oct 14, 2011

Transition to Solaris 11 - Batch II

The prestigious Club of Solaris 11 is growing...



Now c'mon, don't be an antediluvian, get your hands on the future by subscribing for a content rich five day program from Oracle University.

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.

Friday Sep 23, 2011

First Global Teach on Transition to Solaris 11 in Bangalore

I'm a movie buff. I love watching paid preview shows of high profile movies. In doing so, there is something more than just satisfying my bloated ego. Perhaps, it's the pleasure of being a part of that small circle of audience who get to hear a great piece of story first. And so I don't blame those folks who spend a whole night in a queue to pick up the first delivery of an Apple product and I don't blame those children standing in a mile long human chain to grab the first prints of a Harry Potter book. They all seem to belong to a league so different.

Do you want to know how it feels to belong to such a prestige club? Someone in the picture can tell you that, coz they just managed to get a hands on exposure - the first of its kind globally - to what is expected to be the World's best Unix OS to be released. Don't read that line again, you heard it right: the OS is not out yet!





So if you'd love to find yourself in a club so special and not wait for the fancy release date of 11/11/'11 to get a feel of the best Unix flavour, come join a 2070 minute long training program from Oracle University.

In the meantime, download Solaris 11 going here and have a quick look at the complete set of documentation on Solaris 11 right here.

Sunday Sep 18, 2011

Two Virtualization Sessions

My last two programs in this part of the world have been around two very powerful and useful virtualization solution from Oracle. Published below are photographs from each of the session, the most recent on the top:


OU program on Oracle VDI in Bangalore.


OU session on Oracle VM Server for SPARC in Noida.

Read a comment on Oracle VDI OU course on this blog. Documentation on Oracle VM Server for SPARC is here and for the Oracle VDI information, check this out.

Saturday Aug 27, 2011

Directory Server 7.x Maintenance and Operations Session at Chennai

The binding factor between me and folks around me in the picture below is Directory Server (ODSEE). Thanks to 'em for showing up for a four day OU Course.

Saturday Aug 06, 2011

IDM Session in Pune

At the beautiful campus of a Client in Pune, we concluded a five day discussion on Identity Manager.



It is commendable that even after an energy sapping five day program from OU, folks still didn't turn down my request to perform teach back on the concluding day of the program. Thanks and good work.

I happened to stumble on this You Tube video on Installing Identity Manager 8.1, which I think is quite a useful one. Complete documentation on Sun Identity Manager 8.1 (n.k.a Oracle Waveset IDM) is available here.

Thanks also to all my good old friends who managed to find some time to catch up with me at Pune.

Saturday Jul 16, 2011

ODSEE Session in Bangalore

Met up with a dozen familiar faces again the bygone week for a discussion on ODSEE Maintenance and Operations. Thanks again to each of 'em for turning up for an Oracle University Course.



For those interested in knowing ways to get binaries of Directory Server Enterprise Edition, please visit this blog. Directory Server EE documentation are all available here. Click here to register for a webcast on Introduction to Unified Directory 11g on July 21 2011.

Saturday Jul 02, 2011

Identity Manager Session in Bangalore

Thanks to each one of the folks in the picture below for showing up for an OU Course on Identity Manager; more so for the free lunch on the concluding day of the session:-)



Entire set of Legacy Sun Identity Management Documentation can be found here. For information related to the Sun to Oracle Identity Management Upgrade, visit this page.

Good weekend!

Friday Jun 17, 2011

Solaris Cluster 3.2 Cluster Advanced Administration Session in Bangalore

This evening, I concluded an engaging five day session on Solaris Cluster 3.2 Advanced Administration. Thanks to each one in the photo below for showing up for an OU course on Solaris Cluster 3.2 Advanced Administration.



For complete set of documentation on Solaris Cluster 3.2, click here. Details on Solaris Cluster 3.2 certification is here. Good weekend, all. :-)

Monday Jun 13, 2011

Oracle VM for SPARC Training in Bangalore

Not long ago, Oracle announced the latest version of of Oracle VM Server for SPARC. For press release around the same, click right here. This new version now supports "live migration" details of which are neatly published on this blog.
Just around the same time, I was delivering a training program on Oracle VM for SPARC at Bangalore and in the photo below you'd see my new friends:



For complete set of documentation on Oracle VM for SPARC, go here.

Sunday Jun 12, 2011

May Engagements

This isn't exactly the way I want to be publishing my blogs, like a monthly newsletter briefing on my engagements in a month. For now though, I request my suffering readers to live by it, but I promise to be more regular than this on my blogging activities. Starting from the more recent assignment to the oldest one, please find a photo essay one below the other:


Access Manager Training at Bangalore.


Oracle Directory Server EE Training at Greater Noida.


SAM QFS Training at Hyderabad.


Finally, let me leave you with some photographs from the JavaOne conference held at Hyderabad in May this year.





Thursday Apr 28, 2011

With MySQL Batch on Birthday

The current MySQL training batch at Mumbai threw me a surprise on my DOB, today, and I'm so thankful to 'em for making my day. Many thanks to all friends for their wonderful b'day wishes.



Thank you, again

Wednesday Apr 27, 2011

Catching Up...

That I've been lazy is a monumental understatement. I show up now to quickly post an update on what I've been doing over the past couple of months. Well, I have been traveling and traveling a lot. While I had an opportunity to travel across the state of Gujarat, delivering various seminars on Java/JavaFX at locations like Anand, Bhuj, Jamnagar, I, unfortunately, don't have any photographic images from the trip. What I have is, as always, batch photographs from training programs, and here it is one after the other from the most recent to the oldest:


Administering Lustre Based Cluster @ Chennai during the third week of April 2011.


Solaris Cluster 3.2 u3 Administration Session @ Delhi during the last week for March 2011.


Solaris Cluster 3.2 u3 Administration Session @ Mumbai during the mid week of March 2011.


Sun Identity Manager Deployment Fundaments II program @ Hyderabad. (Look closely and you'll see one participant attending the program using video conferencing)

I'm leaving this space, hoping to post updates more promptly and regularly.

Monday Feb 28, 2011

Changes to Java and Oracle Solaris Certifications

Click here (Select the Country, if required) and get full details on some important changes to Java and Oracle Solaris Certifications.

Tuesday Feb 01, 2011

A Month at Hyderabad

Remember writing this New Year Wishes to my friends and associates, and already one month has passed in Year 2011. Time flies! And when a month is spent in company of some good human beings, the concept of time seems so meaningless. A Shreya Ghoshal Concert and an absorbing light and sound show at Golkonda Fort was an extra topping to go with four weeks of Solaris Cluster, Sun Fire Midrange and High End Server and M-Series Server teaching sessions while at Hyderabad, the whole of January 2011. Thanks to each of the thirteen training participants for giving me a good engaging start to the Year 2011.



Thanks also to them for not turning down my request to share their 'top ten take-back' from the whole program.

Systems Training, Hyderabad 01/02/11 8:01 AM


Thursday Dec 30, 2010

New Year Wishes - Year 2011

In just a few hours time, one beautiful desktop calendar that served me for the past twelve months would find its way to trash. Thankfully, my memories wouldn't go accompanying it.

For those who know me for over a year now perhaps know I show up on this 'special day' every year, where ever I'm, to remind you that you're in my thoughts and that I'm so grateful for your significant influence on my makeup. I call this a 'special day' not because any of us expect the world to be any different, when Sun rises tomorrow, but because at least some consider this to be a day to draw the curtain down on a year long episode of life and start a new one, a better one, with greater vigour. Like every year, let time tell us if we were smart enough to keep our resolutions realistic. But I do hope that we develop and maintain the will to achieve all noble goals we have in our mind for the Year 2011.

With some hours left in Year 2010, maybe, it isn't futile to quickly look back at it, cherish all great moments once again, try and absorb the events that invoked negative emotions in us and forgive ourselves for all mistakes made and figure out corrective measures to fix it. With a hope that we all turn mature enough to accept all events in life with equanimity and make necessary changes in life, if,when and wherever required, to keep ourselves reasonably happy at least most part of the year, let's get ready to welcome the Year 2011.

On a personal note, I'm grateful to have been able to maintain positive relationship with most of the people whom I knew before the beginning of Year 2010 and more so for being able to connect with some more wonderful human beings in the year that's passing by, and for the great lessons of life they made me pick up from them. Thank you! Sorry, if I didn't live up to the expectations of some. Next year, I hope to reduce the degree of separation with the world citizens even further.

Before I leave you to let you enjoy the New Year Celebrations in your own way, I want to thank you again for all your support and wish you and yours a New Year full of purpose and meaning.

Celebrate the arrival of Year 2011.

Wednesday Dec 22, 2010

Solaris Cluster 3.2 Session in Bangalore

Guys, thank you so much for such a great time together, and for the free\* lunch.



Rest of the world, for more details on the course around Solaris Cluster, navigate to this location. And for the Certification exam on Solaris Cluster, details are here.

Sunday Dec 19, 2010

Lustre File System & N1 Grid Engine Sessions in Dubai

That the Egyptian One Pound Coin carries the figure of Pharaoh Tutankhamun is something that I learned from one of the folks in the picture below. Not just that, the story of Sphinx is quite clearer to me than ever before, thanks to these fellows from Egypt. It felt great to interact with them, learn a lot about the geography of Egypt, its culture, and was also interesting to know of the grand library that they all work for. Well, my commitment to them was to conduct a teach on Lustre and Grid Engine. In a venue at Dubai whether my discussion was useful for them is for them to comment, but I found it a good learning experience to be with them for a week and learn some interesting things. Thanks to each one of them for showing up for a course on Lustre and on N1 Grid Engine and for their wonderful company.



Tuesday Nov 16, 2010

Oracle Solaris 11 Express 2010.11

By now, I hope all of you are aware of the announcement around Oracle Solaris 11 Express 10.11. If not, read the press release here. Check out what's new in Solaris 11 Express by downloading the 'What's new' PDF file from this link. Another PDF available here talks about what's new in Oracle Solaris 11 Express for System Administrators and one another file downloadable from this location helps Applications Developers know what's new in Oracle Solaris 11 Express.

For several videos on Solaris 11 Express, check out this page.

Well, if you are one of those, who doesn't have patience to go through the resources as mentioned above, but want to get started straight away, download Oracle Solaris 11 Express from here.

And do remember to join a webcast on Dec 07 2010 around the New Oracle Solaris 11 Express. Click here to register.

Sunday Oct 24, 2010

Sun Systems Fault Analysis Workshop

A week back, I met up with the folks on the picture below for the Sun System Fault Analysis Workshop:



Sunday Oct 10, 2010

Four Engaging Days of Session On Directory Server

Feels so satisfied to have gone through an engaging four day session on Directory Server. Thanks to each of 'em in the photo below for pushing themselves to stay late on most of the evenings, including the concluding day to perform a neat 'teach back' session.



Special thanks to Ashish Adyanthaya for taking up the responsibility of capturing the 'teach back' session (most of it).


Click here for the download location of Directory Server and other related Identity Management products.

Tuesday Oct 05, 2010

Access Manager Session in Bangalore

Below is the batch photograph taken on the concluding day of a five day session on Sun Java System Access Manager at Bangalore, which began on 27 August 2010. Thanks again to David Goldsmith for the wonderful course that he developed around this product, my job was rather easy and we had good fun and great learning (I hope so).



On the last day of the program, on my request, we had a thorough revision of the whole program, in the form of a good solid 'teach back' from each of the participant. May be, that was the highlight of the whole session and I thank each of them for putting in so much of effort to help me feel satisfied and proud.

For those who are looking for details about the evolved version of the above product, I suggest going here.

Search

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