(Kai ‘Oswald’ Seidler) There are a lot of tutorial out there describing how to use PHP’s classic MySQL extension to store and retrieve blobs. There are also many tutorials how to use PHP’s MySQLi extension to use prepared statements to fight SQL injections in your web application. But there are no t
Tag: Open Source
Total security in a PostgreSQL database
(Robert Bernier) Database security is the single biggest concern with today’s Web-based applications. Without control, you risk exposing sensitive information about your company or, worse yet, your valuable customers. In this article, learn about security measures you can take to protect your Postgr
MySQL Cluster fault tolerance – impact of deployment decisions
(Andrew Morgan) MySQL Cluster is designed to be a High Availability, Fault Tolerant database where no single failure results in any loss of service.
Finding your MySQL High-Availability solution – Replication
(yves) In the last 2 blog posts about High Availability for MySQL we have introduced definitions and provided a list of ( questions that you need to ask yourself before choosing a HA solution. In this new post, we will cover what is the most popular HA solution for MySQL, replication.
MySQL Cluster Restarts Get Faster
(Andrew Morgan) MySQL Cluster 6.3.28b and 7.0.9b contain optmizations which can greatly reduce the time taken for data nodes to restart – this includes restarting a single node, performing a rolling restart or a full system restart.
Versioning MySQL data
(Arnold Daniels) As a developer you’re probably using a versioning control system, like subversion or git, to safeguard your data. Advantages of a VCS above a nightly backup are that you can walk to the individual changes for a document, see who made each change and revert back to specific revision
Performance analysis with mycheckpoint
(Shlomi Noach) mycheckpoint (see announcement) allows for both graph presentation and quick SQL access to monitored & analyzed data. I’d like to show the power of combining them both.
Gearman for MySQL
(Giuseppe Maxia) If you haven’t yet heard about Gearman, it’s time to have a look at it. Its distributed client server architecture are a perfect match for today’s cloud oriented applications.
Replication analysis with mycheckpoint
(Shlomi Noach) I would like to show how mycehckpoint can be put to use for analyzing various replication metrics.
Bigger and Better MySQL
(Sean Hull) Usually an article like this one will start out with a technical word “scaling”. Unfortunately like health care reform, everyone can’t always agree on what they mean by it, or even what the goal is. So, I deliberately chose not to use the word, and use the non-technical words that we c
