MySQL and its Distinguishing Features

MySQL is a relational database management system which is better known as RDBMS, it runs as a server providing multi-user access to a number of databases. MySQL is officially named for original developer Michael Widenius’s daughter My. MySQL works on many different system platforms, including AIX, BSDi, FreeBSD, HP-UX, i5/OS, Linux, Mac OS X etc just to name a few. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. It was owned and sponsored by a single firm, the Swedish company MySQL AB which is now owned by Oracle Corporation.

Free-software projects that require a full-featured database management system often use MySQL. MySQL is also used in many high-profile, large-scale World Wide Web products. The “M” in the acronym of the popular LAMP software stack refers to MySQL. Its popularity for use with web applications is closely tied to the popularity of PHP. MySQL is primarily an RDBMS and therefore ships with no GUI tools to administer MySQL databases or manage data contained within. The MySQL community has created several forks such as Drizzle, OurDelta, Percona Server, and MariaDB. All of these forks were in progress before the Oracle acquisition.

MySQL has many features which sets it apart from other RDBMS systems. Let have a look at these features.

Multiple storage engines, allows one to choose the one that is most effective for each table in the application (in MySQL 5.0, storage engines must be compiled in; in MySQL 5.1, storage engines can be dynamically loaded).
Customized storage engines.
Native storage engines like Falcon, Merge, Memory, CSV, Blackhole, Cluster etc.
Partner-developed storage engines.
Community-developed storage engines.
Commit grouping, gathering multiple transactions from multiple connections together to increase the number of commits per second.

MySQL has many versions of it that has hit the market since its advent. MySQL Server 6.0.11-alpha was announced 22 May 2009 as the last release of the 6.0 line. Future MySQL Server development uses a New Release Model. Features developed for 6.0 are being incorporated into future releases.

 

The author of this article is an expert in custom software development and has also written various articles on web development and web design India in the last five years.

How to Measure Anything in Cybersecurity Risk


Product Description
A ground shaking exposé on the failure of popular cyber risk management methods

How to Measure Anything in Cybersecurity Risk exposes the shortcomings of current "risk management" practices, and offers a series of improvement techniques that help you fill the holes and ramp up security. In his bestselling book How to Measure Anything, author Douglas W. Hubbard opened the business world's eyes to the critical need for better measurement. This book expands upon that premise and draws from The Failure of Risk Management to sound the alarm in the cybersecurity realm. Some of the field's premier risk management approaches actually create more risk than they mitigate, and questionable methods have been duplicated across industries and embedded in the products accepted as gospel. This book sheds light on these blatant risks, and provides alternate techniques that can help improve your current situation. You'll also learn which approaches are too risky to save, and are actually more damaging than a total lack of any security. 

Dangerous risk management methods abound; there is no industry more critically in need of solutions than cybersecurity. This book provides solutions where they exist, and advises when to change tracks entirely.

  • Discover the shortcomings of cybersecurity's "best practices"
  • Learn which risk management approaches actually create risk
  • Improve your current practices with practical alterations
  • Learn which methods are beyond saving, and worse than doing nothing

Insightful and enlightening, this book will inspire a closer examination of your company's own risk management practices in the context of cybersecurity. The end goal is airtight data protection, so finding cracks in the vault is a positive thing—as long as you get there before the bad guys do. How to Measure Anything in Cybersecurity Risk is your guide to more robust protection through better quantitative processes, approaches, and techniques.

Price: $37.20
  • John Wiley Sons Inc

Server Engineer II

Server Engineer II

About Kirkland & Ellis Kirkland & Ellis LLP is a preeminent, full-service law firm with offices around the world and a staff as diverse as the practice areas…

Kirkland & Ellis LLP
Chicago, IL 60654

From Kirkland & Ellis LLP 6 days ago