If you're one of those that thinks that HA is all about MySQL® Replication, or if you've tried to alter your tables to NDB to drink at the holy grail of shared nothing architectures, SkySQL has got a meet-up for you!
For many years I was using tcsh, with lots of useful customizations, that were created during these years. Now I have bash on my laptop and slowly adding what I've got used to.
The information here was adapted from the AskMonty Knowledgebase.
There are two main parts to MariaDB and MySQL: The mysqld server and whatever client you use to interact with the server.
SkySQL executives and a number of its partners have been invited to share their insight and expertise on MySQL® technologies and trends during the Percona Live UK conference speaking program, including:
SkySQL today announced that it will begin reselling Severalnines' ClusterControl™ product, which enables customers to set-up a production-ready, MySQL® Cluster configuration. The latest addition to the SkySQL™ Reference Architecture - SkySQL's framework for reducing the cost and complexity of deploying some of the most common MySQL data infrastructure applications - ClusterControl™ provides a virtual DBA assistant that frees the developer from the complexity and typical learning curves associated with database clusters, and provides assistance throughout the database lifecycle.
SkySQL today announced rapid growth and success in its first year of operations, fueled by new customers, partnerships and corporate growth. Highlights of the company's first year include:
Whenever I start a new project with MySQL or MariaDB I am tempted to jump in and start creating my schema and tables with nothing more than a basic outline of the requirements. Often the justification I give myself is that the sooner
One issue that developers often run into is needing or wanting to run a development version of MariaDB or MySQL on their desktop when there is already a production version installed. You may want to try out a new feature, or experiment with a patch, or maybe you're developing a new storage engine, or just having fun hacking on the code.
A common error in SQL is with quotes. Luckily, compared to other databases, MariaDB and MySQL are very forgiving.
For example, suppose I have a "products" table for an online store. If I want to look up every product which has a price of 5.99 or more I might use the following query: