It feels like every minute a PHP developer somewhere on this planet starts implementing something aching to a CMS from scratch. Some do it because their project is "so big" it that it "obviously needs" a custom solution. Some do it because their project is "so small" it "obviously needs" just a few days of hacking .. to build a custom solution. Let me briefly focus on the later group. Working in a company with less than 10 people building websites for customers a project needs a bit of a CMS to manage those 10 "semi static" pages seems to be the poster child example of this group. The devs whip up a DB table, slap an ORM in front, maybe even use some generator for the admin UI. Done. Later the clients also wants versioning and luckily many ORMs provide some solution for that. Easy. Permissions? Most frameworks provide some ACL system. Child pages? ORM has some tree algorithm supported. Fulltext search? Integrate ElasticSearch. Custom page types? Uhm …
[Read more]
MySQL 5.6 Replication - Global Transaction IDs
On Wednesday (16th May 2012), Mat Keep and I will be presenting the new replication features that are previewed as part of the latest MySQL 5.6 Development Release. If you’d like to attend then register here.
MySQL 5.6 delivers new replication capabilities which we will discuss in the webinar:
- High performance with Multi-Threaded Slaves and Optimized Row Based Replication
- High availability with Global Transaction Identifiers, Failover Utilities and Crash Safe Slaves & Binlog
- Data integrity with Replication Event Checksums
- Dev/Ops agility with new Replication Utilities, Time Delayed Replication and more
In class today, we reviewed pass-by-value
(IN-only mode) parameters and pass-by-reference
(INOUT and OUT mode) parameters for
stored procedures. The analogy that finally seemed to hit home
for the students was linking the modes to the story of Alice in
Wonderland.
Here’s the analogy and below is the code to support it:
“A pass-by-value parameter in a procedure is like sending an immutable copy of Alice into the rabbit hole, which means she can’t shrink, grow, or learn throughout the story; whereas, a pass-by-reference parameter in a procedure is like sending Alice into the rabbit hole where she can shrink, grow, fight the Jabberwocky, and learn things that make her life better when she exits the …
[Read more]
Sysbench has three distribution for random numbers: uniform,
special and gaussian. I mostly use uniform and special, and I
feel that both do not fully reflect my needs when I run
benchmarks. Uniform is stupidly simple: for a table with 1 mln
rows, each row gets equal amount of hits. This barely reflects
real system, it also does not allow effectively test caching
solution, each row can be equally put into cache or removed.
That’s why there is special distribution, which is better, but to
other extreme – it is skewed to very small percentage of rows,
which makes this distribution good to test cache, but it is hard
to emulate high IO load.
That’s why I was looking for alternatives, and Zipfian
distribution seems decent one. This distribution has a
parameter θ (theta), which defines how skewed the distribution
is. A physical sense of this parameter, if to apply …
Recent news that Microsoft and Barnes & Noble agreed to partner on the Nook e-reader line rather than keep fighting over intellectual property suggests the prospect of more settlement and fewer IP suits in the industry. However, the deal further obscures the blurry IP and patent landscape currently impacting both enterprise IT and consumer technology.
It is good to see settlement — something I’ve been calling for, while also warning against patent and IP aggression. However, this settlment comes from the one conflict in this ongoing war that was actually shedding some light on the matter, rather than further complicating it.
See the full article at TechNewsWorld.
WordPress on S3: run a beautiful website on Amazon S3 cloud storage
OblakSoft is proud to introduce the 1st ever dynamic WordPress site running on top of Amazon S3: Yapixx. Now you too can launch your own beautiful website on Amazon S3.
While Yapixx stands for Yet Another Picture Sharing Site, it is actually one of a kind. Yapixx is WordPress that was moved to run on top of Amazon S3 storage without changing a line of code in the WordPress core engine.
[Read more]Waiting Room Solutions (WRS) is an award-winning web-based Electronic Medical Records (EMR) and Practice Management System for physicians’ offices. Based in Goshen, NY, WRS serves almost 3,000 users for their needs in charting, medical record filing, payment tracking, prescription and reporting via the SaaS (Software as a Service) model, and WRS has sent over 20,000 electronic prescriptions a month over its secure network.
The Business Challenge
WRS was looking for a robust database for enterprise-class web-based applications with the following features:
1. Security
Medical records and health information are highly confidential, and WRS expected to be fully incompliance with privacy regulations such as the HIPAA Privacy Rule.
2. Data Integrity
It is important to minimize data corruption and inconsistency for medical records, because they directly impact …
[Read more]OblakSoft is pleased to showcase how simple it is to run LAMP applications on the cloud storage. OblakSoft configured the WordPress web publishing platform to run on Amazon S3 storage and made the recipe available for anyone to replicate. A ready-to-run WordPress site (configured as Yapixx) – is available for public use for FREE. Yapixx is WordPress configured as a picture sharing website that runs on top of Amazon S3 (Yapixx stands for Yet Another Picture Sharing Site).
…
[Read more]High availability is about more than just making sure that applications can get to your data, even if there is a failure:
How about when you are upgrading your database schema What if you need to add memory to a database server or reconfigure/restart MySQL If your apps want to read data from a MySQL slave, how can you be sure they are not reading stale data without re-coding your apps What
A common problem with storing counters in a table is that every time your application update your counter, a row lock needs to be set on the row the table. If your application has a need for storing counters you can use this package which contains the scripts for a table and some stored procedures to handle managing the counters.