(Mike Hillyer) In my last article I created a series of classes to separate my application code from the storage used for its data. Now that I have my abstraction working I am going to implement a project hierarchy using stored procedures.
Tag: Open Source
Setting limits to slave numbers in MySQL 5.0
(Mike Hillyer) How many slaves can be set with MySQL 5.0? We plan to set a configuration with a single master on many boxes serving as slaves, but we have to know tha maximum number of slaves that can be set to avoiding troubles on the master side. (R)
Using Excel to analyze MySQL data
(W. Jason Gilmore) Even in this age of powerful reporting tools like Crystal Reports and flexible customer management applications like SugarCRM, Microsoft Excel remains the most commonly used tool for analyzing information such as contact demographics, sales statistics and revenue projections. This
Working with the MySQL Access Privilege System
(Paul Dubois) MySQL has an advanced but non-standard security/privilege system. This section describes how it works.
Glom, the point-and-click database tool
(Nathan Willis) I am by no means a database wizard. I know a bit of SQL, but primarily my interaction with databases is secondhand, through either PHP or desktop applications that work on top of MySQL or PostgreSQL. But like a lot of you, I occasionally need to build a small database for my own priv
Multiple MySQL Vulnerabilities
(Sophos) Several vulnerabilities have been reported in the MySQL database manager, which could be exploited by attackers to compromise a vulnerable system or obtain sensitive information.
Alternatives to LAMP
(David Chisnall) Most Free Software users are familiar with the Linux/Apache/MySQL/PHP stack—the LAMP configuration—a widely deployed set of software used for a large number of Internet and intranet applications. Although the LAMP configuration is the most frequently used, it’s not always the best t
MySQL Database Administration
(Paul Dubois) This chapter covers topics that deal with administering a MySQL installation, such as configuring the server, managing user accounts, and performing backups.
MaxDB series: Transactions
(Ulf Wendel) In this issue of the MaxDB series we will introduce you to some selected aspects of transactions. The topic of transactions seems pretty boring. But in fact it depends very much on the point of view you take. We have tried to put a light on the subject that shows some rather advanced as
Security and More in MySQL Databases
(Paul Dubois) Starting from MySQL 4.0.3, we provide better access to a lot of system and connection variables. Many variables can be changed dynamically while the server is running. This allows you to modify server operation without having to stop and restart it.