Security is always a major concern in an application. But when an application attempts data communication over a network, it becomes even tougher ordeal to keep the connection secure. In this post we will discuss about Secure Shell (SSH) to add an extra security edge to your application when it communicates over a network.

What is SSH Tunnel?

SSH is an encrypted network protocol generally used for remote shell service, secure data communication, command execution etc. In SSH tunneling, a payload protocol is wrapped around the SSH protocol (the delivery protocol) and sent over the network.

When is SSH tunneling useful?

SSH tunneling is great if you don’t want any changes on the server, say when creating an agent-less monitoring tool or as a replacement for VPN. As SSH is the hub for remote system login, you can assume that a SSH daemon is running in the remote server, if not it can be easily installed …

Monitoring MySQL servers is no rocket science provided you know what to monitor. MySQL gives a comprehensive list of variables to check your server’s health and performance. Let me walk you through the crucial variables you should be monitoring. Lets assume that you have one or more MySQL servers, which have been setup and running fine. Here are the top 10 things to monitor on your MySQL.

1. MySQL availability

Yes, this is the first thing you should be looking at! It would not make sense to monitor your MySQL if its not even available. MySQL downtime is simply not acceptable in production. At the same time ensuring zero downtime does not guarantee maximum performance.
You can execute

-mysqladmin -h 192.168.1.95 -u root -p status

to know if MySQL is running or you can just ping MySQL using service mysqld status if you are using RedHat Linux.

2. Presence of insecure users and …

One of our users has published a “Quick Manual to SQLyog” to his blog.

Sometimes you do better writing about a subject as an ‘outsider’ than as an ‘insider’.  As an ‘insider’ you easily take things for granted that are actually not obvious for everyone.  This is a good example of this – and the writing is excellent. Enjoy!

Tweet

For the week of August 24th, 2012: Everybody’s Preparing for OpenWorld Dispelling the Rumors of MySQL’s Impending Doom On Piracy of Design IOUG Podcast 24-AUG-2012 Rumors of MySQL’s Doom by Oracle / Design Piracy Subscribe to this Podcast (RSS) or … Continue reading →

October 1-2, 2012 New York Discover the Power of MySQL » MySQL is the world’s most popular open-source database, powering web-scale applications such as Facebook, YouTube, and Twitter. MySQL continues to evolve rapidly, reaching more markets and powering more applications every day. Click here to register for the conference.  

The MySQL developer tools team announces the availability of version 5.2.41 of the MySQL Workbench GUI tool. This version has significant improvements in several parts of the tool and also includes the new Migration Wizard plugin.

The new Migration Wizard presents an easy to use GUI for migrating databases from third party products to MySQL. In this initial release, support for Microsoft SQL Server is included, in addition to other products that support ODBC, such as PostgreSQL.

Other improvements include:

• More than 100 bug fixes
• Code completion in the SQL Editor (beta)
• Better handling of schema synchronization in modeling

For a full list of issues fixed in this release, see  http://dev.mysql.com/doc/workbench/en/changes-5.2.x.html

Please get your copy from our Downloads …

Yes, it's true, Oracle CEO Larry Ellison has bought 98% of the Hawaiian Island of Lanai for $500m.  The island was previously owned by David Murdock who bought Dole in 1985.  The island has 3,200 residents, two luxury resorts, two golf courses and is 88,000 acres (141 square miles) in size. 

Here are some alternate headlines & subheads

Ellison Buys Island of Lanai
Declares Bill & Melinda Gates Marriage to be in Violation of Oracle Terms of Service

Says "What Island?  I only wanted a closed off veranda.  Doesn't anyone listen to me?"

Thanks Safra Catz for Really …

The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench, version 5.2.40.
This version contains more than 28 bug fixes applied over version 5.2.39.

MySQL Workbench 5.2 GA

• Data Modeling

• Query

• Administration

Please get your copy from our Download site.

Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

Workbench Documentation can be found here.

http://dev.mysql.com/doc/workbench/en/index.html

Utilities Documentation can be found here.
…

MySQL is receiving mainstream media attention this week with Twitter publicly deciding to open source work on its MySQL database. Of course, the problems we see every day are being called out. Per GigaOm’s article:

But it [MySQL] has its problems, among them scalability and performance under the pressure of high transaction rates.

Like Twitter, our customer AppDynamics, is working to better manage data at high availability rates, but they’re taking a slightly different tact. In a recent post on the AppSignal blog, Boris Livshutz, introduces what he calls a ‘Data Cloud’ and looks for common ground between SQL and NoSQL rather than calling out the differences. …

Hi,

Webyog and Percona are giving away free tickets to the Percona Live MySQL Conference and Expo, and you can win them! We’re also giving away copies of High Performance MySQL, 3rd Edition!

This year’s event is the best ever, with a better lineup of talks and speakers than ever before.  It’s the one event you should not miss if you’re at all interested in MySQL.  We really want you to be there — and that’s why we’re joining with Percona to give away free tickets! It’s easy to enter:

• Follow our Twitter feed, and …