<-- Instant Pages for Google Chrome -->
Tagged with:  

Linux下5大最佳关系数据库管理系统

On 2011年03月2日, in database, linux, by netoearth

A Database Management System (DBMS) is described as a set of computer programs that manages the creation, maintenance, and administration of a database. It is a system software package that supports the use of unified collection of data records and files known as databases. A DBMS could utilize any of a variety of database models, such as the network model or relational model.

Continue reading »

Tagged with:  

Installing LCMP stack on CentOS 5.5

On 2010年10月27日, in linux, by netoearth

LCMP is an acronym for a stack of free, open source software from the first letters of Linux (operating system), Cherokee HTTP Server, MySQL and Perl/PHP/Python. These are the principal components to build a viable general purpose web server.

Continue reading »

Tagged with:  

注:原文已发表于《程序员》杂志关系型数据库60周年特刊

随着信息量飞涨,信息的存储成为了这个时代至关重要的一项技术。如何来保证数据存储技术能够适应信息量的增长速度和我们对信息的高度依赖,成为一个 非常重要的课题。本文将从数据库架构的层面,通过以开源的数据存储软件来构建分布式数据层的思路,期望实现一个低成本的高可用可扩展的数据层架构。

Continue reading »

Tagged with:  

MySQL quick commands for Oracle DBAs

On 2010年08月30日, in database, by netoearth

How to connect to mysql?

[root@vmxdb01 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.

Continue reading »

Tagged with:  

MySQL安全配置文档

On 2010年07月6日, in database, by netoearth

转载:http://hi.baidu.com/zheng918/blog/item/e1af9d3d1879c10abba1677c.html

MySQL 是一个真正的多用户、多线程SQL数据库服务器,它是一个客户机/服务器结构的实现。MySQL是现 在流行的关系数据库中其中的一种,相比其它的数据库管理系统(DBMS)来说,MySQL具有小巧、功能齐全、查询迅捷等优点。MySQL 主要目标是快速、健壮和易用。目前,在大中型企业中已经得到了较好的运用,但是由于它是多平台的数据库,不可避免的默认配置也是适合多种情况的需求,因此 需要用户需要在自定义的环境下对MySQL的使用进行加固。

Continue reading »

Tagged with:  

Configuring InnoDB

On 2010年07月6日, in database, by netoearth

How are transactions organized physically

When InnoDB creates a new transaction it is not yet committed. The database has not yet made any promises to the application and so we do not really have to make anything persistent so far.

Continue reading »

Tagged with: