Sunday, August 28, 2011

Good night, Good morning, Goodbye... Irene

Bad news:  Due to Hurricane Irene, we lost power to the homegrown server overnight sometime before 6 AM Eastern on 8/28/2011.

Good news:  Fortunately, we have already been working on a migration of the server over to a hosted solution.  We successfully cut over from the homegrown server to the hosted solution as of ~8:45 AM Eastern on 8/28/2011.  The site appears to be functioning normally, although there may be some minor issues with the stats because the cutover was forced due to weather conditions, rather than elegant/planned.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Sunday, August 14, 2011

BlogPatrol back online

August 14th  @ 5:39 PM is back online and counting stats again.  Due to changes in schedules and availability, I have very limited access to server administration support, so I needed to overcome a steep learning curve in order to fix the issues that caused the site to be down since last Thursday.

You may have seen the prominent banner ad showing that BlogPatrol is now listed FOR SALE on  Hopefully, the new owner will have both the technical chops and the business savvy to move BlogPatrol forward to better performance than I've been able to do lately.

August 14th  @ 1:52 AM
I'm sorry everyone.  I've had to work through numerous issues with the server and also the database.  I'm almost done with the fixes, and will post another update soon.

August 12th @ 11:01 AM
The BlogPatrol service is currently down due to maintenance on the site.  I'll post an update when the maintenance is complete.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Tuesday, May 3, 2011

Power backup, website backup, but just started fixing database

One step at a time I guess.  We've got power back on site, which means the server is back online.  However, the database tables crashed because the server shutdown was due to a power outage.  Initiating the database repair now.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Good News (Relatively)

The website outage is due to a power blackout where the server is located, not due to a hard disk failure. What this means is that we will be able to get BlogPatrol online sooner rather later, soon after the power comes back on.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

BlogPatrol Returning May 8, 2011

Murphy's Law has taken its diredct aim on BlogPatrol.  In addition to the database issues that we have been dealing with over the last week, we are now affected by a failure of the primary hard disk, which is a solid state drive (SSD).  These SSDs are known for their speed, performance -- and burnout rate.

Due to scheduling constraints, the earliest that we will be able to fix this hardware issue is approximately between May 6-8, 2011. I understand that these kinds of down times are unforgivable in today's Internet.  All I can do at this point is I apologize for the ongoing let down from BlogPatrol.  This failure is a primary example as to why BlogPatrol is looking for a buyer / partner with appropriate resources and expertise.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Monday, May 2, 2011

BlogPatrol Server Being Worked On

Been having a run of bad luck with the server and database.  We are working on the issue and hope to have the site up again soon.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Thursday, April 28, 2011

BlogPatrol Back Online

I'm sorry folks.  One of the disks on our server crashed and, due to limited schedules, it took us a while to get the site back online.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Saturday, April 23, 2011

Database Maintenance on April 23

4/23/11 @ 3:23 PM
Currently fixing database so that it renders stats reports properly again.  I expect to be done with maintenance activities within a few hours.

4/24/11 @ 10:20 PM
I'm sorry folks, but due to some scheduling issues, I'm only able to get part of the database back online right now.  You should be able to read your stats again finally, but the system may be responding slowly.  Once the system is fully back online, I'll post another update.

4/26/11 @ 7:59 AM
The database appears to be stable again, as it looks like users are able to view their stats reports.  If anything changes, I'll post an update here.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Friday, April 22, 2011

FOR SALE: in Summer 2011

Dear BlogPatrol Users:

After eight years of the once-in-my-lifetime experience of owning, learning, developing, managing, committing to, and enjoying (and most importantly serving all of you as BlogPatrol's users), I'm announcing that BlogPatrol is undergoing preparations for sale to the right buyer/partner in Summer 2011.

The following reasons are driving this decision:

  • Significant opportunities in my full-time career now require all of my work/business focus.  In recent months this shift in my career has lead to my inability to respond, as a one-person support team, to your requests for user support.
  • As part of a conscious effort to balance my life/family/work priorities, the realization and acceptance (both professionally and personally) that, after eight years, I've taken BlogPatrol as far as I can.
  • The knowledge and belief that can continue to grow and expand under the leadership and vision of an owner/team with sufficient experience and resources.
  • The desire to have BlogPatrol users continue to experience the high level of support they deserve and have come to expect.
I am looking for a buyer/partner who demonstrates the following qualities, either as a corporate entity or as a dedicated web entrepreneur/professional:
  • Professional standards and commitment to providing an excellent customer/user experience.
  • A belief in the power of blogging and the usefulness of metrics/analytics to inform bloggers of their impact on the world.
  • Technical capabilities to manage, operate, and further develop a data-intensive website using a LAMP architecture that runs a multi-master, multi-slave, multi-terabyte database which collects over 70 GB of data every month in MySQL. The PHP code includes substantial modifications of the software from to enable scalability via archiving of BlogPatrol stats into manageable data partitions. The unique BlogPatrol stats display is implemented using Fusion Maps (Flash).
  • Financial resources and technical acumen to drive BlogPatrol's growth in the evolving environments of blogging and web analytics.
  • Sales and business development experience to leverage and maximize BlogPatrol's international reach, popularity, and position in the blogosphere.
If you have a serious interest in discussing this opportunity, please reach me directly at s a l e s {a t} b l o g p a t r o l . c o m .  For the protection of buyer and seller, the site valuation and transaction will be managed by a well respected brokerage firm.

This is the first in a series of blog posts concerning the sale and eventual transition of It is only appropriate that I close this announcement with a word of thanks and appreciation to you, the users of the BlogPatrol service. Thanks to all of you, I've enjoyed the unique experience and challenge of building in support of thousands of bloggers all over the world.

Tony Nguyen

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Wednesday, February 2, 2011

BlogPatrol back online...

BlogPatrol is back online following some issues with our Internet Service Provider and subsequent problems with the database. Stats are now available for all days (except for January 28).  I'm sorry for the extended delay and downtime.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Saturday, October 16, 2010

Issues, Fixes & Enhancements

Updated October 16, 2010:

Thanks to everyone for your feedback on BlogPatrol issues and enhancements. We're operating BlogPatrol with part-time resources, so we rely on your active support to help us provide you the best service within our means:
  • DEPLOYED as of August 23, 2010:  Display your blog's Top Blogs ranking under the Account Settings portion of your Account Login and Control Panel.
  • DEPLOYED as of August 18, 2010:  Improved presentation and organization of the data in the Detailed Visitors Logs report. 
  • DEPLOYED as of July 10, 2010:  A search functionality on the Top Blogs page that allows anyone to search publicly listed blogs.  If a blog is found, then the search will display the blog's rank, hit counts, and stats (if public).
  • DEPLOYED as of July 5, 2010:  Improved the Clear Stats functionality.  BlogPatrol users are now able to clear visitor counts/details, clear hit counts, or clear all.  One warning though is that all clear functions are permanent and therefore cannot be reversed.
  •  DEPLOYED as of May 25, 2010:  Upgraded and updated the database table that holds the reference IP addresses and corresponding country names.  (A user reported that the country counter is not working for Russia (.ru) and Turkey (.tr).)
  • DEPLOYED as of May 21, 2010:  Synchronized time / time zone on classic stats reporting with regular stats reporting.
  • DEPLOYED as of May 17, 2010:  Corrected formatting errors that were causing error messages to display in Internet Explorer for the BlogPatrol homepage. 
  • DEPLOYED as of December 30, 2009:  Improvements that have made the "Custom Upload" function, and the "Account Settings" form, easier to use.
  • DEPLOYED on December 19, 2009: Finally, after nearly five (part-time) months of design, development and testing, we are ready to deploy the new customizable features for the BlogPatrol counter widget icons. The new features will allow users to [1] create invisible/camouflaged icons, [2] upload and design custom visible/stealth icons, and [3] design their own visible icons, in addition to the [4] system icons currently available.

  • TURNED OFF CO-REGISTRATION ADS as of November 7, 2009: Thanks to a tip from a new user, I discovered that the advertiser I was working with to provide co-registration offers during the new user sign-up process was spamming new users with way too many ads and even pop-up ads. I have terminated the relationship with that advertiser and disabled the co-registration ads until I can do this in a way that does not spam BlogPatrol users.
  • ANALYZED as of August 3, 2009: Analyzing feasibility and cost/benefit of future enhancements, including placing an upper limit on daily number of visitors tracked, implementing an HTML-only counter code, providing a new set of BlogPatrol counter icons, and also allowing for the upload of custom icons by users.
  • CLOSED as of July 28, 2009: A couple of users reported that the "Ban IP" function was not working properly. We tested this issue, but were unable to find any errors with the system. If you continue to find otherwise, please post a comment.
  • COMPLETED as of July 24, 2009: Made sure that the revamped Top Blogs pages displays only those accounts which have opted-in to the "Include my site in the BlogPatrol Top Blogs List" option.
  • COMPLETED as of July 22, 2009: Fixed a bug in the recently added "Blog Name" data field, which was not correctly saving phrases that contain apostrophes (') or quotations ("").
  • COMPLETED as of July 20, 2009: Updated BlogPatrol signup instructions and screen shots. Updated directions and screen shots for installing BlogPatrol on Blogger Blogspot blogs.
  • COMPLETED as of July 19, 2009: In testing round two of customizing the TITLE TAG of the Top Blogs pages so they correspond to the settings of each BlogPatrol user account. Expecting to have this feature live by July 20.
  • COMPLETED as of July 15, 2009: Customized the TITLE TAG of all stats page types (1, 2, 3, 4, and 5) so they correspond to the public/private settings and blog name or Blog URL of each BlogPatrol user account.
  • COMPLETED as of July 11, 2009: Released further refinements to the "Retrieve Counter Code" form. We have made it easier for users to copy the BlogPatrol code so that they can paste it into their blog.
  • COMPLETED as of July 5, 2009: Created a new data field that allows users to name their blog as part of their BlogPatrol account. For example, the address of this blog is, but the name or title of it is The Patrol Blog.
  • COMPLETED as of June 30, 2009: Expanded the amount of data provided in BlogPatrol reports. For example, increasing the display from 25 to 50 visitors in the Detailed Analysis of the Last 25 Visitors report.
  • COMPLETED as of June 23, 2009: Expanded the functionality of the Top Blogs page. Instead of listing only the Top 100 blogs, the page will provide links to scroll through all blogs that have opted to be ranked by their number of hits. We will be implementing the changes within the next 48 hours.
  • COMPLETED as of June 11, 2009: Improving the format of extra long usernames as they are displayed in the left navigation pane.
  • COMPLETED as of June 10, 2009: Improvements to the Retrieve Counter Code page that will make it easier for users to view and copy the code for their BlogPatrol accounts.
  • COMPLETED as of May 25, 2009: Implemented new bug fixes to make sure that the BlogPatrol reports are consistent in relation to each other regarding the number of unique visitors being reported by each report (e.g., data in the "Details of Last 25 Visitors" versus data in the "Hourly Visitors for Today" and the "Today's Visitors").
  • COMPLETED as of May 25, 2009: Implemented additional bug fixes on the hourly stats reports to ensure that the time stamps match correctly to the time of day in relation to the time zone of each user's account. We'd also like to recognize the author of Authentic Designer Items For LESS for her help in reporting and testing this issue.
  • COMPLETED as of May 23, 2009: The URL validation script on the signup form was not accepting a trailing slash at the end of corrrect addresses.
  • COMPLETED as of May 12, 2009: Implemented enhancements that make the BlogPatrol contact form easier to understand and use.
  • COMPLETED as of May 2, 2009: We have completed upgrades that doubled the RAM on our Dell PowerEdge 2900 server from 24 GB to 48 GB RAM.
  • COMPLETED as of April 20, 2009: The CAPTCHA that was formerly installed on our signup, contact and lost password forms received many complaints. We have implemented a new CAPTCHA, which we expect to perform very well. Please let us know if you find otherwise.
  • COMPLETED as of April 7, 2009: Made enhancements to the new user signup process that will require new users to validate the spelling of their username, blog URL and email address. These improvements will help to ensure that BlogPatrol account information is entered correctly. Ensured that default value of "Starting Counter Value" is equal to zero. Updated signup instructions to reflect these changes.
  • COMPLETED as of March 16, 2009: Fixed distortion in formatting of stats reports that would occur when the URL of a BlogPatrol user's blog site was greater than 44 characters in length.
  • ADDED as of March 13, 2009: Co-registration offers and discounts to the new user signup process. New users can choose to skip the co-registration process entirely, or to select those offers which appeal to them.
  • RESOLVED as of March 13, 2009: BlogPatrol accounts are sometimes increasing their visitor counters with NON-UNIQUE PAGEVIEWS (i.e., HITS), instead of UNIQUE VISITORS based on IP address of the visitor's computer. BlogPatrol counters are intended to count each IP address as a unique visitor during a given 24-hour period.
  • COMPLETED as of March 13, 2009: Visitors using the Chrome browser by Google are being reported as using the Apple Safari browser. We need to update our code to recognize new browsers such as Chrome, Flock and others.
  • COMPLETED as of December 22, 2008: We have rebuilt the operating system on the BlogPatrol server. This work caused BlogPatrol to be down for about 36 hours. We are operational again, however, as of December 21. Thank you for your patience.
  • COMPLETED as of November 25, 2008: Full Server Audit: I have terminated the contract with my previous server administration company, SeeksAdmin. I am glad to announce that I have contracted with the excellent company named Red Audit, which has initiated a full audit and hardening of the server. Red Audit has already found and corrected numerous problems.
  • RESOLVED as of November 2, 2008: At least some of the cities in time zones such as UTC+1, UTC+2 and UTC+3 are to a large extent wrong. As examples, Athens and Instanbul are listed as UTC+2, but they are actually in UTC+3. A detailed code review is required to determine if such cities are being affected by Daylight Savings Time changes, etcetera. Thank you, Νεκατομένος ο ερχόμενος, for calling this to our attention!
  • FIXED as of October 17, 2008: We have resolved the issues (a) pertaining to the "keyword" data not appearing in all reports and (b) relating to the "Self-referring/Bookmarker" result being displayed so frequently for reports containing referrer information. I will need to write a blog post explaining this.
  • RESUMING BUG FIXES, September 22, 2008: I'm sorry for the work stoppage on my end. I've had a number of issues outside of BlogPatrol that I had to resolve. I am, however, resuming the analysis and bug fixing this week with my contractor and will post another update soon.
  • FIXED as of August 21, 2008: We have resolved the database slow response times which made it difficult for users to login and view their stats. The problem was the bug fix that was installed to get the Details of Last 25 Visitors report to coincide with the other reports.
  • CLOSED as of July 20, 2008: Open call to our users to send web traffic to our test blog from our BlogPatrol users to help us to gather, analyze and fix the issues/bugs listed above.
  • FIXED as of July 18, 2008: The "Weekly, Daily, and Hourly" reports were missing data for the current day and its hours.
  • COMPLETED as of July 12, 2008: We have configured the development and test web site on the new server, which will allow us to proceed with bug fixing of issues found on the main site.
  • FIXED as of July 7, 2008: For some users, especially accounts newly created as of July 3rd, the BlogPatrol counter image was not displaying properly on users' blogs (only a "broken X image" appears). For these accounts, BlogPatrol was not counting visits/hits. To obtain the fix for your account: Remove the BlogPatrol counter code presently installed on your blog, and then add the new version of the code using our install instructions.
  • COMPLETED on July 3, 2008: An activity in the works since June 6, the migration of to the new server is complete. We had a number of challenges which delayed the process, but, at last, we've reached the goal of migrating the site to a better machine. Thanks to everyone for your patience, especially during the challenging parts of the migration.
  • COMPLETED on June 10, 2008: We have updated the instructions and screenshots for BlogPatrol Signup Instructions and How do I change the time zone of my BlogPatrol account? to match the new look and feel of BlogPatrol.
  • COMPLETED on June 8, 2008: We have updated the How to add BlogPatrol to a Blogger blog instructions with screenshots that match the new look and feel of BlogPatrol.
  • IMPLEMENTED on June 3, 2008: We have added the ability for you to ignore, or ban, up to four different IP addresses (home, work, wireless and other). In addition, we have enabled the ability to ignore (ban) dynamic IP addresses using the * and ? wildcard characters.
  • FIXED on MAY 22, 2008: User gets logged out if s/he changes password. In order to resume activity in their account, then the user has to click logout and then login with the username and new password. Resolving this issue required some intensive redesign of our scripts, but all for the better for BlogPatrol users!
  • FIXED on May 20, 2008: Bug fixing was delayed for a few days because of firewall issues that prevented our web developer's access to the BlogPatrol server. Issue has been resolved and we are resuming our work to fix bugs and provide enhancements.
  • IMPLEMENTED on May 15, 2008: Amidst the bug fixing, we are working on a cross-promotional agreement with a company doing exciting things on the Web. This cross-promotion required us to develop some new graphics, so we decided to develop and install a BlogPatrol favicon as part of that graphics development project. Enjoy!
  • FIXED on May 13, 2008: We think we have resolved the problem with logging in or staying logged into their account. Please let us know if you find otherwise!
  • FIXED on May 13, 2008: We think we have also fixed the password reset function. Please let us know if you find otherwise.
  • FIXED on May 9, 2008: Review all reports to make sure stats data match from report to report. Correct any errors found as a result of analysis For example, verify data for search engine and keyword search reports.
  • FIXED on April 21, 2008: The "Daily Visitors for the Week of MMM DD to MMM DD" still needs to display the current day when that day has zero (0) visitors. Otherwise, it looks like the report is malfunctioning and not tracking visitors for the current day.
  • FIXED on April 21, 2008: Formatting of URLs in the reports named "Top 10 Pages" and "Last 10 Pages".
  • FIXED on April 18, 2008: In the Stats Dashboard, the display of the time zone's UTC code needs to change with the user's time zone selection.
  • FIXED on April 17, 2008: Made sure that the start and end dates in the title bar of the “Daily Visitors” report correspond exactly to the start and dates of the bar graph data for that report.
  • FIXED on April 17, 2008: Improved formatting of the BlogPatrol reports that contain URL links so that the links no longer line break too early, which left too much empty space on the right side of those reports.
  • FIXED on April 17, 2008: On the BlogPatrol signup form, corrected the username validation routine so that it works properly in Internet Explorer v6+ to notify a new user that they have selected a username that already exists.
  • FIXED on April 17, 2008: Centering of new "Account Settings View Stats Change Password etc." links and placement as one row of data.
  • FIXED on April 17, 2008: The Demo Stats reports were not rendering unless a user was logged into their BlogPatrol account.
  • FIXED on April 16, 2008: The "Top Blogs" list is not rendering in some web browsers such as Mozilla Firefox.
  • FIXED on April 16, 2008: Homepage and other pages become unavailable due to other bug fixes.
  • FIXED on April 14, 2008: "Today's Visits" has a different value than the current day of the "Daily Visitors for Week of MMM DD to MMM DD". When displaying correctly, these two report elements should display the exact same value.
  • FIXED on April 11, 2008: Another issue with the "Details of Last 25 Visitors" is the multiple counting of unique IP addresses. (BlogPatrol is designed to count any given IP address as being a unique visitor over a 24-hour period.)
  • FIXED on April 10, 2008: Many of the web pages are displaying the text in a red font, which when fixed will be a standard black font.
  • FIXED on April 9, 2008: Removal of the display of the User ID # at the top of the login.php once that user has logged into their BlogPatrol account.
  • FIXED on April 9, 2008: On the My Account Settings page, the "Ignore my Computer" (formerly called "Ban my IP") function is not working because it will not save any data in its corresponding data field. Also the "my IP address is..." button is not working.
We will continue to post regular updates as we resolve the above-mentioned issues and/or identify new ones. We're also excited to bring you as many enhancements and improvements as our part-time budget and resources allow.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Monday, May 24, 2010

System Down - Database Repair Underway

May 21, 2010, 10:57 AM UTC-4 America/New York
BlogPatrol is currently down.  Repairs are currently underway for the BlogPatrol database.  I will post an update when the repair is complete.

May 25, 2010, 7:32 AM
The system is functional, but not optimal at this time.  The website and database may respond slowly until the database issues can be resolved, hopefully by the end of this week.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Monday, May 10, 2010

Server Issues, Part 2

May 8, 2010 at ~6 PM
It turns I had not fixed the problems as I'd originally thought.  The database and server were down from around six o'clock Saturday evening through around mid-day Sunday afternoon as a result.

May 9, 2010 at ~2 PM
The system should be back online and functioning correctly this time (really).  I'm very sorry!

May 10, 2010 at 4:39 PM
Please let me know if you find that the system is down again.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Friday, May 7, 2010

Stats Being Tracked, but Reports Unavailable

May 7, 2010 at 7:12 PM
BlogPatrol is currently tracking stats for users, but an issue is preventing the stats reports from displaying properly.  We are looking into this issue and will post an update as soon as possible.

10:50 PM
BlogPatrol is functionally again.  I apologize for the inconvenience that this downtime caused everyone.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Sunday, March 21, 2010

Problem with Stats and Workaround

We have discovered that there is a problem with the stats, as of:

March 20, 2010 @ ~10 PM
The regular stats reports are not working properly, but you will find your stats using the classic stats reports. 

March 21, 2010 @ ~9:30 AM
We have reported this issue to our technical team, who will work on correcting this problem.  Updates will be posted when new info is available.

March 21, 2010 @ ~11:50 AM
We have made some adjustments and restarted the system.  All reports are rendering now, although some of the values of the regular stats reports are not synchronized with the values of the  classic stats reports.  We will investigate further and get everything synchronized.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Tuesday, March 16, 2010

Users have reported stats issues as of early March 14

March 14, 2010 @ 11:06 PM
BlogPatrol users have reported that stats are not being counted and/or that discrepancies are being shown among their stats reports.  We are looking into this issue as of this blog post and will provide an update soon.

March 15, 2010 @ 9:18 AM
After much troubleshooting and problem solving, we have been able to resolve the issues affecting the system.  Everyone's BlogPatrol accounts should be functioning properly again.

March 15, 2010 @ 4:55 PM
We've received additional feedback that there are still problems happening with the stats reports.  We are investigating the issues further and will post additional information when it is available.

March 16, 2010 @ 4:36 PM
The system appears to be working correctly now.  The bad news is that:

  • BlogPatrol was not able to record any stats from ~19:30 PM (UTC-4) on March 13 until ~01:15 AM (UTC-4) on March 15.
  • Also, new accounts created during this time period will need to be recreated because the system was not functioning properly.
We are still monitoring the server closely to see if any other problems arise.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Monday, February 15, 2010

BlogPatrol Reconstruction Complete!

February 15, 2010: I'm very pleased to announce that our project is complete and 100% successful!  Not only are all the features of your BlogPatrol account functioning fully for you now, but we have released major upgrades to the service, including:

  • A new architecture that allows us to do system maintenance with minimum downtime.
  • The new architecture includes new hardware that provides a faster website for you.
  • The ability for us to partition your historical data so that we no longer have to purge (delete) it from your account.  Using the Previous and Next links on your stats reports, you can scroll through your data and go back as early as December 27, 2009.  We anticipate being able to store at least twelve months of data using our current system design and hardware.
  • The Detailed Analysis of the Last 50 Visitors report has been upgraded dramatically to the Detailed Visitor Logs.  The upgraded reports allow you to view the details of any visitor that we have recorded in our database.  You can scroll through all your detailed logs using the Previous Day and Next Day links.  The detailed logs are displayed using pages that list up to 50 visitors per page.  Pagination links allow you to scroll through the details of the day.
February 7, 2010: The BlogPatrol reconstruction project is nearly complete... We have successfully achieved our goals of reconstructing the server architecture for faster performance and, more importantly, partitioning historical stats.  This means that you now have a longer history of stats available to you and that you will be able to view your stats more quickly .  We are monitoring our system to see if any final tweaks are needed to further optimize performance.

January 30, 2010: Most major tasks have been completed in the reconfiguration of the server for speed and reliability.  We are starting to work on the part of the project that, hopefully, will allow us to provide historical stats.  (We currently have to purge stats forever after about 4 weeks. Otherwise, the database would grow too large and cause the system to operate too slowly.)  The partitioning project is very complex, and we cannot guarantee that it will be achieved.  We will, however, give it our best shot!

January 25, 2010: As of January 24, we have resumed the reconstruction project.  Please expect down times, both intermittent in frequency and extended in duration, until we are able to post an update on the next milestones completed.

January 19, 2010:  We are expecting the project to resume after January 21, when the schedule for our project team becomes available again.

January 18, 2010:  BlogPatrol is currently, intermittently back online.  Please expect slow site performance from time to time until the reconstruction project resumes.

January 17, 2010:  The site is currently down.

 January 8-21, 2010:  Due to scheduling constraints, there will be a break in the reconstruction project until after January 21.  At this time BlogPatrol is online, running a fast SSD drive, and benefiting from a database redesign that offers a single master for recording stats and a single slave for generating stats reports.  Until the reconstruction project is finalized, however, the site may still function slowly at times.

January 7, 2010:  The stats reports were unavailable this morning.  As of 2:30 PM Eastern, the system and stats are now back online.

January 5, 2010:  Completed upgrade to MySQL 5.1.  Completed some configurations needed for multi-master/slaves design.  Undergoing testing to make sure system changes are functioning properly.

January 4, 2010:  The reconstruction project is still in progress throughout this week.  The website and stats reports may at times perform more slowly than normal -- or be unavailable for extended periods -- while the project is being completed.  We will continue to post updates as project tasks are completed.

January 3, 2010:  Had problems with stats reports between Jan 1-3. To resolve the problems, backed up December 2009 data, purged the database, and resynced master/slave databases.

January 1, 2010:  Happy New Year 2010!  We have completed the reconstruction's first tasks: initial conversion to a virtual server environment and deployment of the first of multiple slave databases.  Slave databases are intended for the purpose of displaying your stats more quickly.  The second phase will occur next week, which will include the deployment of additional slave databases and an upgrade from MySQL 5.0 to 5.1.

December 31, 2009:  BlogPatrol currently is offline while we are reconstructing the server for better performance in 2010.

December 30, 2009:  We've started the reconstruction process for BlogPatrol.  We will be performing major upgrades on that will allow for greatly improved speed and functionality in 2010.  We apologize for the down-time that will occur as a result of this work, but it's short-term pain for what will be long-term, worthwhile improvements.

  • We will be upgrading our hard disks to include several solid-state drives, which operate faster than SATA, SAS, or SCSI drives.
  • We will be going from a single instance database to a multi-master/slave database design.  Having a multi-master design means that it will be easier to keep BlogPatrol online and tracking your stats -- even when maintenance is being done on the system.  In a single instance database, maintenance usually required going offline completely.
  • Having multiple slave instances of databases means that BlogPatrol means that you will be able to access your stats reports more quickly.
  • We will be upgrading to MySQL 5.1 which will provide the basis for segmenting data into historical partitions.  If we were able to utilize this capability, then BlogPatrol would be able to retain your stats as archives that you can access, instead of having to purge (delete) them from the system.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Monday, November 9, 2009

Database Maintenance

November 9, 2009 will be down and not recording any stats during this maintenance period.
2:50 PM UTC-4 (America/New York) - Performing maintenance to verify database integrity and optimize database performance. Purging records down to 14 days to help website and database perform faster for users.
4:59 PM - Doing a second round of purging to get data down to 8 days to help website and database perform faster for users.

5:25 PM - Completed database maintenance activities.  BlogPatrol is online and recording stats again.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Tuesday, November 3, 2009

Database issue preventing BlogPatrol logins

November 3, 2009
7:35 AM UTC-5 America/New York: We are aware of a database issue that is preventing users from being able to log into their BlogPatrol accounts. We are working to fix the problem and will post an update when the fix is complete.
12:48 PM: We have resolved the issue. BlogPatrol is online and functioning normally again.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Sunday, November 1, 2009

Anikin's Blog

The writer at Anikin's Blog is a loyal and dedicated user of's services. I just wanted to take a moment to recognize him as a friend of BlogPatrol and to thank him for his wonderful support!

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Saturday, October 10, 2009

Scheduled Hardware Upgrade

October 10, 2009 will be offline and therefore not recording any stats during this upgrade.
11:37 AM UTC-4 (America/New York) - The BlogPatrol server will be offline later today in order to complete a hardware upgrade. The purpose of the upgrade is to replace a 15-month old 10,000 RPM, 300 GB SATA Hard Drive with a brand new 15,000 RPM, 300 GB Serial Attached SCSI (SAS) Hard Drive. The new SAS drive will help BlogPatrol to operate faster than the older SATA drive.
4:09 PM - The upgrade is presently underway. We will post an update when the activity is verified as complete and successful.
7:48 PM - The upgrade completed and successful. BlogPatrol is improved and back online.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Friday, October 9, 2009

Database Maintenance

October 8, 2009 will be down and not recording any stats during this maintenance period.
11:50 AM UTC-4 (America/New York) - Performing maintenance to verify database integrity and optimize database performance.
12:35 PM - Initial database check completed. Purging records now down to 8 days to help website and database perform faster for users.
4:36 PM - Completed a partial database purge earlier this afternoon. Resuming purge now.
8:45 PM - Cleanup from the purge is still underway. I'm sorry this is taking so long.

October 9, 2009
12:33 AM - Finally the maintenance is done. This was a tough day with the maintenance taking so long. We are back online though, and I'm glad for that.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Saturday, September 19, 2009

Database Maintenance

September 19, 2009 will be down and not recording any stats during this maintenance period.
5:54 PM - Performing maintenance to ensure database integrity.
8:40 PM - Database required repair, which has been completed. is online and counting stats again. We apologize for the inconvenience, and thank you for your patience.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Monday, August 31, 2009

Database Maintenance

August 31, 2009 will be down and not recording any stats during this maintenance period.
8:50 AM - Performing database maintenance script to purge detailed stats down to 8 days.
2:00 PM - Completed database maintenance. BlogPatrol is now back online and tracking stats.

If you like this article, then click on this link to "Digg It" and help promote Thanks!

Saturday, August 15, 2009

Bad Friday - Blackout, then Database crash

August 15, 2009 at 6:06 PM
The database is restored, and we're back online now. We did not track any stats from Friday evening (Aug. 14 circa 5 PM) through Saturday afternoon (Aug. 15, circa 6 PM).

I'm going to be making some changes so that I know what's going on right away when these disasters happen.

August 15, 2009 at 4:51 PM UTC-4 (America/New York)
I'm sorry folks. For a few hours on Friday evening, there was a blackout in the area where our server is located. The blackout caused a database crash which I only discovered this afternoon. I am currently working to restore the database.

If you like this article, then click on this link to "Digg It" and help promote Thanks!