WebScaleSQL is a modified MySQL Database developed by Engineers at Facebook, Google, LinkedIn, and Twitter for making kind of scalable SQL. Everyone knows about MySQL Database. Those who do not know what is MySQL, they can read our previously published article – What is MySQL, Why We Need MySQL. At the time of publishing this article; WebScaleSQL is on everyone’s lips. MySQL is great, but it is not intended to be Scalable when it was written, that is the basic reason why we try to make Scalable MySQL Database for CMS like WordPress in a kind of legacy mode. WebScaleSQL is kind of fork of MySQL.
WebScaleSQL : Basics Need for the Approach
Flexibility and Scalability are the Key Benefits of Cloud Computing. Again, Scalability and Service Continuity are Not equivalent. There is another a MySQL Improved Extension – MySQLi. There are reasons why NoSQL Movement was started.
Official website of WebScaleSQL is :
---
1 | http://webscalesql.org/ |
But, we do not need the official website, but the Github repository :
1 | https://github.com/webscalesql/webscalesql-5.6/tree/webscalesql-5.6.16 |
Do you know that, PostgreSQL; one of the most popular noSQL database actually can be used instead of MySQL for WordPress? MariaDB is constantly merged with MySQL community edition. Instead of writing vague collected data on WebScaleSQL, let us install WebScaleSQL.
WebScaleSQL : Installation
In order to test WebScaleSQL, we will need the following dependencies :
1 2 3 4 5 6 7 8 | + cmake + gcc + libaio-dev + libncurses5-dev + libreadline-dev + bison + git + perl |
I believe, WebScaleSQL is not intended for use on a VirtualBox as a Virtual Appliance. Install the dependencies first :
1 | sudo apt-get install cmake gcc libaio-dev libncurses5-dev libreadline-dev bison git perl |
or
1 2 3 | sudo install cmake gcc libaio-dev libncurses5-dev libreadline-dev bison git perl # can be homebrew, yast, yum etc. # sudo might not be required or be refused depending upon your setup |
WebScaleSQL has no binaries, cloning the git work out of the box :
1 2 | git clone https://github.com/webscalesql/webscalesql-5.6.git . # Note, there is a dot |
We are just mentioning the commands, these are quite basic :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 | # look at http://dev.mysql.com/doc/mysql-sourcebuild-excerpt/5.5/en/source-configuration-options.html # Add group users groupadd mysql useradd -r -g mysql mysql # cd and cmake with one command cd && cmake . # there might be errors, simply rm -r CmakeCache.txt # make and install make && sudo make install # cd to /usr/local/mysql/ to check whether things are nice cd /usr/local/mysql # change ownership sudo chown -R mysql . && sudo chgrp -R mysql . # grant sudo /usr/local/mysql/scripts/mysql_install_db “defaults-file=/usr/local/mysql/my.cnf --user=mysql # we need to edit the .cnf file nano /usr/local/mysql/my.cnf # add at the end of the file and save it [ ^ + O ] and exit [ ^ + X ] socket=/var/run/mysqld/mysqld.sock # add as daemon sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql.server # start the server sudo /usr/local/mysql/bin/mysqld_safe |
It is a pure fork of mysql, although the giants say — there are branches. So inferior quality copy-paste of MySQL Server 5.6 README.md as official README.md is difficult to find on Github Projects.
