Inventory: Free database software for open source community

Many business owners with only more than 10 to dozens of employees ask if they don't want to spend thousands or even million to buy a database software and ask if there are any free database software available. In fact, there are a lot of small business owners in this type of enterprise, their company needs a small database software to statistics the company's some product data and the information of the storage, the amount of data is really small. As I've seen before, some small businesses use office-brought access small databases, but still feel less convenient. Here, the editor recommends several open source database software for small business use.

Open source database MySQL

MySQL is an open source small relational database management system, developers for the Swedish MySQL AB company. MySQL is currently widely used in small and medium Web sites on the Internet. Because of its small size, speed, the total cost of ownership is low, especially the characteristics of open source, many small and medium-sized Web sites in order to reduce the total cost of ownership of the site to choose MySQL as a Web site database.

MySQL provides APIs for a variety of programming languages, including C, C + +, C #, Delphi, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl. And its own is written in C and C + +, using a variety of compilers for testing, so, MySQL can ensure that the source code has a very strong portability. Such a database would naturally support virtually all operating systems, from UNIX, Linux to Windows, including AIX, BSDI, FreeBSD, HP-UX, Linux, Mac OS, Novell Netware, NetBSD, OpenBSD, powering Wrap, Solaris, SunOS, Windows, and many other operating systems. Most importantly, it is a large database that can handle thousands records.

At the same time, MySQL also produced a number of branched versions of the database is also highly recommended.

The first is mariadb, a MySQL branch version of the Maria storage Engine, a free Open-source database server developed by a company founded by the original MySQL author Michael Widenius. Compared to MySQL, the mariadb is stronger because it has more engines, including the Maria storage Engine, the PBXT storage engine, the XTRADB storage engine, the Federatedx storage engine, which enables faster replication of query processing, faster running, Better functional testing and support for sorting Unicode.

The second is Rcona, which has improved the MySQL database server and has a significant improvement in functionality and performance over MySQL. This release improves the performance of InnoDB in high load situations, and it provides DBAs with some very useful performance diagnostics tools and provides many parameters and commands to control server behavior.

The third is Percona Server, which uses such things as google-mysql-tools, Proven scaling, and Open query to transform MySQL. And, it contains only the MySQL server version, does not provide the corresponding to MySQL connector and GUI tools to improve.

Non-relational database NoSQL

From NoSQL's literal understanding, NoSQL is not just SQL, is considered by the industry is a new database revolutionary movement, early on some people suggested that the trend of development to the 2009 has become increasingly high. NoSQL advocates of the use of non relational data storage, compared to the current overwhelming use of relational databases, this concept is undoubtedly a new thinking of the injection.

Of course, NoSQL also with the rise of Internet Web2.0 Web site can make great strides. The key requirement is that the traditional relational database in dealing with Web2.0 Web sites, especially the super large-scale and high concurrent SNS type of web2.0 pure Dynamic Web site appears powerless, exposing a lot of difficult to overcome problems, but not relational database because of its own characteristics has been very rapid development.

The first recommendation is Oracle NoSQL Database, a community edition. Oracle's NoSQL Database, one of the components of the Big Data appliance, released on the Oracle Global Encyclopedia on October 4, is a big data appliance that integrates Hadoop, NoSQL Database, Oracle database Hadoop adapters, Oracle database Hadoop loaders, and R language systems.

The second recommendation is membase. Membase is a new heavyweight member of the NoSQL family. Membase is an open source project and the source code uses the Apache2.0 license. The project is hosted on the Github.source Tarballs and is currently available to download a beta version of the Linux binary package. The product was developed mainly by Memcached core team members from North scale, including Zynga and NHN, the two major contributors to the network, both of which are large online gaming and community web space providers.

Moreover, Membase is easy to install and operate, it can be easily extended from single node to cluster, and Plug and Play is implemented for memcached (compatibility of Wired Protocol), which provides a low threshold for developers and operators in application. As a caching solution, memcached has been widely used in different types of domains, especially large-capacity Web applications, where some of the underlying code for memcached is directly applied to the front-end of the Membase server. Membase has a good reusability by being compatible with a variety of programming languages and frameworks. In terms of installation and configuration, Membase provides an effective graphical interface and programming interface, including configurable alarm information.

The goal of Membase is to provide external linear scalability, including the ability to replicate for a unified node in order to increase the capacity of the cluster. In addition, redistribution of stored data is still necessary.

(Responsible editor: The good of the Legacy)