Industry Leading Database Analyst Matt Aslett, MySQL Pioneer Doron Levari and Industry Veteran Paul Campaniello Host Webinar on The New World Order of NoSQL, NewSQL & MySQL BOSTON – November 7, 2012 — Picking the wrong database can result in slow performance or downtime, frustrated customers and lost revenue. But navigating the new world order of [...] Read More
We're excited to announce that Jet Profiler for MySQL will be
featured on BitsDuJour, a 'deal-of-the-day' website that offers
extensive, one-time discounts on a variety of great
Jet Profiler for MySQL will be featured at BitsDuJour on Friday, 26 October, at the dramatically reduced price of $249.50 (50% discount). The normal purchase price for Jet Profiler for MySQL is $499.00!
If you have any friends or colleagues who might be interested in Jet Profiler for MySQL, please let them know about this sale. We can't afford to offer this kind of discount often, and it will only be available on BitsDuJour for a single day.
Visit the promotion page on BitsDuJour on Friday 26 October to get Jet Profiler for MySQL for $249.50.
Choosing a Next-Gen Database: The new world order of NoSQL, NewSQL & MySQL Tuesday, November 13, 2012, 12:00 PM – 1:00 PM EST
The database market is becoming increasingly complex and is changing on an almost daily basis. Matt Aslett is the Research Manager for Data Management and Analytics at 451 Research. He has overall responsibility for the coverage [...] Read More
There’s a lot happening in the world of MySQL and it’s really vital to be up-to-date with the latest advancements in this field to stay ahead of the game. Reminds me of this quote by Albert Einstein “Once you stop learning, you start dying.” The easiest way to stay updated is by reading blogs. There are loads of blogs talking about MySQL, and even more for databases in general, so which of these really matter and are worth your time and attention?
We’ve handpicked the best MySQL community/ experts blogs and grouped them into various categories. You can also add these great blogs to your RSS reader to get all industry news, tips that you will ever need all in one place. If you prefer the micro blogging platform twitter for real time updates/ news can subscribe to all of them on our twitter list.
Industry’s First Unified Database Scalability & Replication Solution Now Available for MySQL Environments PERCONA LIVE – NEW YORK – October 1, 2012 — ScaleBase, the company enabling next generation applications that require big data transactional processing, and Codership, the market leader in synchronous multi-master replication, are teaming up to deliver the industry’s first unified database scalability and [...] Read More
While monitoring MySQL servers, managing their configuration becomes important. There could be a need of comparing configuration of one or more MySQL or a server’s running configuration with that of its own My.cnf. Let me explain this a little more.
If you are in a situation where a server ‘A’ is performing better than a server ‘B’ while both have the same resources and environment, then the first thing you might want to do is compare their configuration. Then, make the configuration changes in server ‘B’ looking into ‘A’. There by fine tuning ‘B’ to level up to ‘A’. Comparing MySQL configurations is the key here.
When you change a MySQL Global variable when the server is running, for reasons like – fine tuning your application or upgrading your MySQL or any other, the changes do not persist. In other words, these changes are lost forever when the server restarts and the old values are reverted …[Read more]
Will you be at MySQL Connect? Alfredo and Sergio will be presenting a couple of Workbench sessions in the MySQL event preceding Oracle OpenWorld in the weekend, 29 and 30 of September.
The sessions are:
Getting the Most out of MySQL with MySQL Workbench
Migrating from Microsoft SQL Server to MySQL: The New MySQL Migration Wizard – CON8560 The first one is an introductory session on using MySQL Workbench, which should be the fastest way to get familiar and productive with the tool. The second one will cover …
New home of the InnoDB team blog.
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 …[Read more]
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
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 …[Read more]