MySQL Cluser Server is a fault-tolerant, redundant, scalable database architecture built on the open-source MySQL application, and capable of delivering 99.999% reliability. In this paper we describe the process we used to setup, configure, and test a three-node mySQL cluster server in a test enviro
Tag: Open Source
Cultured Perl: Embedding Perl in database tables
(Teodor Zlatanov) In this installment, the author looks at Perl and databases. Specifically, he works with the Class::DBI CPAN module and MySQL to introduce you to embedding Perl in database tables.
What’s New In MySQL 4.1 Part One: Overview and Subqueries
(David Fells) The current release of MySQL, version 4.1.10, offers significant improvements over version 4. While it still has some room for improvement, its new features and capabilities should silence the critics who have up until now regarded it as little more than a toy. In this article, the fir
Backing Up Databases Using ADSMPIPE and the TSM API: Examples Using Linux
This IBM Redpaper describes how you can use the IBM Tivoli Storage Manager (TSM) application programming interface (API) with the ADSMPIPE utility to perform online backups of various databases. This process eliminates dumping data to a file (and consuming disk space) so that the TSM backup and arch
MySQL Network — All-in-one Enterprise-grade Database, Support and Services
Achieving the highest levels of database reliability, security and uptime are the primary requirements for successfully running business critical applications. Now, MySQL Network gives you everything you need in a single, unified offering so you can cost-effectively develop and deploy enterprise dat
Open Source Helps Architects Deliver SOA
(Murray White) Before we can discuss the technologies and Best Practices that will improve business software in 2005, architects and developers need to recognize a simple, often painful truth: Software development creates negative value. It’s only when software is put into production that it can
Fulltext Search for Firebird SQL
(Dan Letecky) In this article, we will talk about searching the data in a Firebird database using DotLucene full-text search engine. We will focus on storing the index directly in the database (the source code of the solution is attached).
Navigating Open Source Licensing
(Blane Warrene) The decision to choose an open source license can mean different things to different people. Those considering the issue from an end-user perspective may feel that the decision is irrelevant: the equivalent of a commercial click-wrap license that generally also goes unread. For this
Using MySQL from PHP, Part 2
(John Coggeshall) Hello again, welcome back to PHP Foundations. In my last column, I introduced some of the basic functions used when accessing a MySQL database from PHP. With what you have learned so far, you should now be able to perform queries and access the result sets from within your PHP scri
Open Source Databases: A brief look at the Berkeley DB, Derby, Firebird, Ingres, MySQL and PostgreSQL DBMS’
(Ian Gilfillan) This month I take a brief look at Open Source Database Management Systems. I do not aim to find the ‘best’ one, or perform an in-depth feature-by-feature analysis, but rather a introduce you to the variety of solutions out there. I am presuming readers of my columns by now already ha