MySQL

This vm node stores your data in RDBMS such as mysql or postgresql. In this setup, I’m going to use MySQL database server. You need to type the following commandss on vm04 having an IP address 192.168.1.13 only.


This blog post is part in the “Run Different Linux Network Services on Separate Systems/VM” series.

{ 5 comments }

I already wrote about how to move or migrate user accounts from old Linux / UNIX server to a new server including mails and home directories. However, in reality you also need to move MySQL database which may host your blog, forum or just your data stored in MySQL database. The mysqldump command will only export the data and the table structure but it will not include a users grants and privileges. The main function of the MySQL privilege system (which is stored in mysql.user table) is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and DELETE.

{ 16 comments }

Applications that perform a lot of memory accesses (several GBs) may obtain performance improvements by using large pages due to reduced Translation Lookaside Buffer (TLB) misses. HugeTLBfs is memory management feature offered in Linux kernel, which is valuable for applications that use a large virtual address space. It is especially useful for database applications such as MySQL, Oracle and others. Other server software(s) that uses the prefork or similar (e.g. Apache web server) model will also benefit.

The CPU’s Translation Lookaside Buffer (TLB) is a small cache used for storing virtual-to-physical mapping information. By using the TLB, a translation can be performed without referencing the in-memory page table entry that maps the virtual address. However, to keep translations as fast as possible, the TLB is usually small. It is not uncommon for large memory applications to exceed the mapping capacity of the TLB. Users can use the huge page support in Linux kernel by either using the mmap system call or standard SYSv shared memory system calls (shmget, shmat).

{ 11 comments }

Look like combined company will give a tough time to both IBM and HP.

Sun Microsystems and Oracle Corporation announced yesterday that they have entered into a definitive agreement under which Oracle will acquire Sun common stock for a total of $7.4 billion or $5.6 billion net of Sun’s cash and debt.

{ 3 comments }

Twitter is a free social networking and micro-blogging service, that allows its users to send and read other users’ updates (also known as tweets). Now, you can build your own Twitter like service using trillr1.

{ 7 comments }

MySQL vs PostgreSQL

by on October 9, 2008 · 1 comment

Useful comparison of MySQL and PostgreSQL open source database software.

MySQL vs PostgreSQL is a decision many must make when approaching open-source relational databases management systems. Both are time-proven solutions that compete strongly with propriety database software.

{ 1 comment }

Wordpress 2.6 has been released and available for download almost a month ahead schedule.

{ 1 comment }