Other available proprietary MySQL front-ends include Aqua Data Studio, dbForge Studio for MySQL, Epictetus, Oracle SQL Developer, SchemaBank, SQLyog, SQLPro SQL Client, Toad, Toad Data Modeler, and Marshal SQLUtility.
MySQL can be built and installed manually from the source code, but this approach can be tedious so it is more commonly installed from a binary package unless special customizations are required. On most Linux distributions the package management system can download and install MySQL with minimal effort, though further configuration is often required to adjust the security and optimization settings.
Though MySQL began as a low-end alternative to the more powerful proprietary databases, it has gradually evolved to support higher-scale needs as well.
It is still most commonly used in small to medium scale single-server deployments, either as a component in a LAMP based web application or as a standalone database server. Much of MySQL’s appeal originates in its simplicity and ease of use, which is enabled by an ecosystem of open source tools such as phpMyAdmin.
In the medium range, MySQL can be scaled by deploying it on more powerful hardware, such as a multi-processor server with gigabytes of memory.
There are however limits to how far the performance can scale on a single server, so on larger scales, multi-server MySQL deployments are required to provide improved performance and reliability. A typical high-end configuration can include a powerful master database which handles data write operations and is replicated to multiple slaves that handle all the read operations. The master server synchronizes continuously with its slaves so that in the event of failure, a slave can be promoted to become the new master, thus minimizing the downtime. Further improvements in performance can be achieved by caching the results from database queries in memory using memcached, or breaking down a database into smaller chunks called ‘shards’ which can be spread across a number of distributed server clusters.
Click here to download CX310-811 test study guide and practice question.
