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. [continue reading…]
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. [continue reading…]
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.
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. [continue reading…]
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. [continue reading…]
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.
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
Thanks to the support of the always amazing Mozilla community, we now hold a Guinness World Record for the most software downloaded in 24 hours. From 18:16 UTC on June 17, 2008 to 18:16 UTC on June 18, 2008, 8,002,530 people downloaded Firefox 3 and are now enjoying a safer, smarter and better Web.
MySQL’s new owner, Sun Microsystems is planning to release new version by the end of the second quarter and will include new partitioning, replication, and event scheduling features. Also the new release will be supplemented with MySQL Workbench, a database design tool built from the open source DBDesigner4 project.
=> MySQL 5.1 Coming In June, Adds Partitioning, Replication