≡ Menu

MySQL

Linux: Configure MySQL Database Server

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.
[click to continue…]

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.
[click to continue…]

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 that uses the prefork or similar (e.g. Apache web server) model will also benefit.

[click to continue…]

Oracle To Purchase Sun Microsystems for $7.4b

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.
[click to continue…]

trillr1: Build a Twitter-like Microblogging Website

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.
[click to continue…]

MySQL vs PostgreSQL

WikiVS has published detailed comparison between MySQL and PostgreSQL. From the pages:

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. MySQL has long been assumed to be the faster but featureless of the two database systems, while PostgreSQL was assumed to be a more densely featured database system often described as an open-source version of Oracle. MySQL has been popular among various software projects because of its speed and ease of use, while PostgreSQL has had a close following from developers who come from an Oracle or SQL Server background.

=> MySQL vs PostgreSQL from the open comparison website.

Download of The Day: WordPress 2.6

Wordpress Logo

WordPress 2.6 has been released and available for download almost a month ahead schedule. New
features in wordpress 2.6:

=> Wiki-like tracking of edits
=> Post from wherever you are on the web
=> Turbo-speed your blogging - Gears is an open source browser extension project started by Google that developers like us can use to give you features we wouldn’t normally be able to.
=> SSL login support
=> Theme Previews: See it before your audience does and much more

Download WordPress 2.6

=> Visit official download page.

Related: Upgrade wordpress quickly in 3 easy steps from UNIX shell prompt