Setting up a LAMP server is a common task for systems administrators, and FreeBSD is one of the most reliable and stable operating systems available. Why not combine both LAMP and FreeBSD to build a fast and reliable Web server?
Read more at Linux.com
Posted by suvi under
Database
Over time, organizations replicate, migrate, or add complexity within database systems, often times losing control of the quality of their data. When applications begin to fail because of invalid, corrupted, or out-of-date data, the free, GPL-licensed Talend Open Profiler can give data analysts, database administrators (DBA), and business users the ability to research data structures [...]
Posted by suvi under
Database,
Linux,
Security
Databases are the key repository for critical data. If you are storing information that needs to be kept secure from prying eyes, especially credit card or personally identifiable information (PII) you might be required to control access using two-factor authentication. This tutorial demonstrates how to secure Postgresql with two-factor authentication from WiKID.
Read more [...]
Posted by suvi under
Database,
MySQL
MySQL Workbench is a visual database design tool recently released by MySQL AB. The tool is specifically for designing MySQL database.
MySQL Workbench has many functions and features; this article by Djoni Darmawikarta shows some of them by way of an example. We’ll build a physical data model [...]
Posted by suvi under
Database,
MySQL,
Server
MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries.
Read more at Ubuntu Geek
Posted by suvi under
Database
SqlSync lets you compare two databases to see which tuples have been added, removed, and changed. You can also use SqlSync to make one database a clone of another and maintain its contents to be that way. One benefit of using SqlSync to perform synchronization is that you can perform heterogeneous syncs — for example, [...]
Posted by suvi under
Database,
OpenOffice.org
The ability to import and export data is crucial to any database management system, and OpenOffice.org Base is no exception. While you may be surprised to discover that OpenOffice.org lacks a dedicated import/export feature, it does allow you to get data into and out of a database in a variety of ways.
Let’s start with the [...]
Posted by suvi under
Backup,
Database,
Debian,
MySQL
Zmanda Recovery Manager (ZRM) for MySQL
simplifies life of a database administrator who needs an easy to use
yet flexible and robust backup and recovery solution for MySQL server.
Read more at HowtoForge
Posted by suvi under
Database,
PostgreSQL,
Server
PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), [...]