MySQL Workbench: How to get and use it

The most frequent information about MySQL Workbench releases is available at the Developer Central Site. MySQL Workbench is available in two editions, the GPL “Community Edition” and the commercial “Standard Edition”. The first one is free and can be downloaded from the previous link. MySQL Workbench Standard Edition is part of MySQL Enterprise Edition.

If you are looking at MySQL Workbench old versions, archived files can be found at the official archive site where you can get Windows, Linux, MacOS binaries or the source code. After downloading the MySQL Workbench package that suits your needs and before attempting to install it, make sure that it is intact and has not been tampered with. There are three means of integrity checking:

  • MD5 checksums
  • Cryptographic signatures using GnuPG, the GNU Privacy Guard
  • For RPM packages, the built-in RPM integrity verification mechanism

If you notice that the MD5 checksum or GPG signatures do not match, first try to download the respective package one more time, perhaps from another mirror site.

Easy way to install MySQL Workbench

The easiest way for installing MySQL Workbench is Continue reading MySQL Workbench: How to get and use it

Share

Using MySQL for Business Intelligence (MySQL BI)

MySQL is particularly powerful when it comes to Web applications, but companies are putting the open source database to plenty of other uses as well. Take, for example, the Los Angeles, California-based global online ad sales firm Gorilla Nation Media.

Gorilla Nation relied on MySQL to power its advertising network business intelligence platform.

MySQL Business Intelligence

Gorilla Nation, part of Evolve Media, provides integrated media and promotional programs to Fortune 500 brand advertisers, including clients such as Fox Television, Best Buy, and more. Its customers demand advanced business intelligence (BI) and targeting methods to reach the perfect online audience for their advertising or brand campaigns. Reaching more than 66 million unique visitors per month— as Gorilla Nation does— requires Websites and an infrastructure that can scale effectively and efficiently.

That’s why Gorilla Nation chose MySQL as the foundation of its BI platform. The organization has more than 500 servers running MySQL, 20 of which are replicated. Its sites get approximately a quarter-billion page views per month, and MySQL manages more than 1TB of data for Gorilla Nation while providing near-real-time traffic and advertising campaign performance information to Gorilla Nation’s publishers and advertisers. In addition, Gorilla Nation uses MySQL to capture all the clickstream data and transactions required for back-office accounting and billing functions.

“One of the great beauties of MySQL BI is that it’s backed by an amazing company like Oracle, which has deep pockets and basically wrote the book on databases, ” says Veronika Burnett, manager of database engineering at Gorilla Nation. “Also, unlike other open source databases, MySQLis highly scalable. That allows us to do things in our business that are absolutely critical, such as having the same database running on multiple physical servers in multiple geographic regions and having near-real-time replication. ”
Continue reading Using MySQL for Business Intelligence (MySQL BI)

Share

Oracle and MySQL Comparison – Migration and Differences

This guide is intended for anyone who is involved in converting a MySQL database to Oracle using SQL Developer. You should be familiar with relational database concepts and with the operating system environments under which you are running Oracle and MySQL.

“Oracle Database SQL Developer Supplementary Information for MySQL Migrations” describes several differences between MySQL and Oracle. It also outlines how those differences are dealt with by SQL Developer during the migration process.

Download the Oracle and MySQL Comparison PDF below.

Continue reading Oracle and MySQL Comparison – Migration and Differences

Share

Scaling Web Databases with MySQL Cluster – Guide

Why 9 of the top 10 most trafficked web sites are powered by MySQL?

MySQL Scalability with MySQL Cluster

User loads and data volumes are exploding – driven by increasing Internet penetration rates, social networking, high-speed mobile broadband connecting ever-smarter devices, new Machine to Machine (M2M) interactions, and more. MySQL Cluster allows users to overcome database challenges in the next generation web, cloud, and communications services while guaranteeing scalability, uptime and agility. MySQL Cluster is a technology providing shared-nothing clustering and auto-sharding for the MySQL database management system. It is designed to provide high availability and high throughput with low latency, while allowing for near linear scalability.

Alternatives to MySQL Scalability without MySQL Cluster

Continue reading Scaling Web Databases with MySQL Cluster – Guide

Share