Posted by Ron on 3rd August 2010
Over the weekend I updated SharDB to allow installs to upgrade from WordPress MU 2.9.2 to WordPress 3.0.1.
I also did an initial pass at support for new WordPress 3.0 -> WP network in SharDB. In this implementation the main site’s tables will be in the global database. You can easily set up a test install (to test your plugins, etc. with SharDB). Set up a fresh install that has the network enabled, create your database shards, then configure & install SharDB.
© Ron for WPMU Tutorials, 2010. |
Permalink |
5 comments |
Add to
del.icio.us
Post tags: database, multiple, network, shard, wordpress, wpmu
Need real genuine helpful support? MU Support.
Feed enhanced by Better Feed from Ozh
Posted in WordPress, database, multiple, network, plugins, shard, wpmu | Comments Off
Posted by Ron on 24th January 2010
I updated SharDB (Download) for WordPress MU 2.9.1.1 and added support for the comment meta table.
© ahome for WPMU Tutorials, 2010. |
Permalink |
4 comments |
Add to
del.icio.us
Post tags: database, multiple, shard, wordpressmu, wpmu
Need real genuine helpful support? MU Support.
Feed enhanced by Better Feed from Ozh
Posted in WordPressMU, database, multiple, plugins, shard, wpmu | Comments Off
Posted by Ron on 28th December 2009
Our larger WordPress MU install, Homeschool Journal has been running on multiple databases for about 3 years. Technically, it’s possible to have thousands of blogs in a single database install. Usually where people running MU start to have issues with the number of blogs is with getting complete backups of the database.
Upgrades with multiple databases have always been more work and many people running multiple databases typically did not upgrade until the .1 release of whatever version of MU. When I upgraded Homeschool Journal to MU 2.7.1, it was two weeks before I had found and repaired all of the database issues (via several plugins). I decided I wasn’t going to go through that again.
With the number of blogs at WordPress.com, Automattic must be using a database plugin that supports WordPress MU better. So, over a couple of weekends, I tweaked HyperDB to use the same MD5 hash based sharding structure that we were using.
I released SharDB (Download) last week as a beta release intended for larger WordPress MU installs using an existing 1-3 character MD5 hash (by blog id) based multi-database sharding structure. (Other structures will be added in early 2010.) The alpha testing of SharDB was carried out this fall with the help of a few people who I knew were using the same multi-database that we were. SharDB has been powering live sites since early October.
SharDB has been tested with over 50 plugins including BuddyPress 1.1 through 1.1.3, domain mapping (both Donncha’s and my version) and my multi-site plugin. I have not found any issues with any of the tested plugins. It should support any plugin that accesses data via the $wpdb object. It has been used to upgrade live sites from 2.7.1 through to 2.8.6 and I’ve upgraded a test site to the WordPress MU 2.9 release candidate tagged 2009/12/21. (Note: I used the plugin in this post to create the commentmeta tables before updating MU from 2.8.6 to 2.9RC.)
One of the features that I really like about SharDB is that I don’t need to edit the database config when adding plugins (a feature inherited from HyperDB). Also, I haven’t had issues with plugins failing to create tables. As an added bonus, I added a handy column to the site admin blog screen so that you can see which database a blog’s tables are in.
© ahome for WPMU Tutorials, 2009. |
Permalink |
19 comments |
Add to
del.icio.us
Post tags: database, multiple, shard, wordpressmu, wpmu
Need real genuine helpful support? MU Support.
Feed enhanced by Better Feed from Ozh
Posted in WordPressMU, database, multiple, plugins, shard, wpmu | Comments Off
Posted by Instructional Technology on 27th October 2009
Some of you may have noticed that your site is missing posts. Others of you may notice that your blog is completely gone. Both are the result of a very unfortunate accident that occurred when the Systems Group tried to restore the Voices site to its state at 6 AM this morning.
As you know we were upgrading the software this morning. This afternoon it was discovered by Dr. Hayward that some users could not post to their blogs and we began investigating the issue. In the process it was decided that a reversion might be necessary. When the Systems Group restored the database containing all the user and post information, they discovered it was corrupt. As they looked for a clean backup they discovered that all backups after Sept. 10 were corrupt and so the earliest version they could restore to is Sept 10.
We are aware that roughly 40 users and hence 40 blogs were lost in this incident. Unfortunately it looks like there is no way to recover the lost users and blogs. It also means that all posts written between Sept. 10 and this morning are gone. We know that this means that several class assignments that were written as blog entries are also gone. We will continue to work with the Systems Group to try to recover as much data as possible, but be aware that it is not likely any more data will be recovered.
In the coming days we will be working with the Systems Group to develop procedures to ensure that such an accident does not occur in the future. Once these procedures have been determined we will post them to this site for the community’s benefit.
Posted in Data, backup, blogs, courses, database, loss, site, users | Comments Off
Posted by Randy on 26th October 2009
The WordPress Exploit Scanner plugin scans system files, posts/comments and plug-ins for suspicious stuff. If you have a blog site that you think may have been compromised it can’t hurt to give it a try. I ran it on a couple of blogs I administer and I’m happy to report that everything looks fine. One of the things the plug-in looks for is hidden code in your site, especially hidden style elements. This is a way that spammers can insert code into your site — but there are lots of legitimate reasons for these elements too. So the report can look a little alarming or overwhelming at first, so run it when you have some time to scan over the output report. A good tool to keep handy for when needed.
WordPress Exploit Scanner
This plugin searches the files and database of your website for signs of suspicious activity. It will not stop someone hacking into your site, but it may help you find any uploaded or compromised files left by the hacker.
WordPress › Blog » WordPress 2.8.5: Hardening Release
We recommend that all sites are upgraded to this new version of WordPress to ensure that you have the best available protection…If you think your site may have been hit by one of the recent exploits and you would like to make sure that you have cleared out all traces of the exploit then we would recommend that you take a look at the WordPress Exploit Scanner.
Related Posts
Posted in Data, PLE, Technology, Web, WordPress, blog, database, plugin | Comments Off
Posted by Randy on 21st October 2009
What is OpenCalais, and what is this semantic web stuff all about? Sure I watched the video on their site, and read through the documentation. Somehow this all will make web content in general, and these blog posts in particular, easier to find and link with other relevant information. Which all sounds good, but I want to see it in action. So I installed their Tagaroo WordPress plug-in.
The most immediate change is the addtion of the tagaroo tag area, which suggest tags based on the post content. It is pretty cool too, as it dynamically updates and suggest new tags as you add content. It also has a Flickr image suggestion bar, which isn’t working at the moment, but also doesn’t hold any interest for me — I don’t see how random Flickr image additions enhance this content. I went back to a recently published post and added in all of the suggest semantic tags. When looking at the page mark-up I don’t see any indication of tagaroo/opencalais’ presence. Maybe it is posting information back to the OpenCalais servers? I did need to register for an API key. I’ll play with it a little more, but if it helps make this content more semantic, then why not?
How Does Calais Work? | OpenCalais
We want to make all the world’s content more accessible, interoperable and valuable. Some call it Web 2.0, Web 3.0, the Semantic Web or the Giant Global Graph – we call our piece of it Calais.
Oracle Database integrates OpenCalais | OpenCalais
Tight integration empowers Oracle Spatial 11g Release 2 users to deploy production-strength semantic solutions with unprecedented speed.
wordpress | OpenCalais
Tagaroo provides automated tag generation and image location for WordPress bloggers. We like Tagaroo so much that we gave him his own website. If you’re a WordPress blogger and would like to integrate Calais functionality directly within your blogging life then hop on over to Tagaroo.
Tagaroo » Make blogging better!
Tagaroo is designed to make your WordPress blog better for you, better for your readers and more accessible to search engines. As you’re writing, Tagaroo analyzes the text in your post and suggests intelligent tags for the things and events you’re writing about.
Related Posts
Posted in Data, Design, Technology, Web, Web 2.0, WordPress, access, blog, blogging, content, database | Comments Off
Posted by andrea on 24th September 2009
Sometimes this happens, you’ve built the site and have to or want to change the domain it’s on. Or you did dev work on a different domain and now it’s time to go live.
The domain name is actually stored in numerous places in the database, as well as one line in wp-config.php. Every single one of these will need to be changed.
Before you do anything, backup. Go to phpMyAdmin, select your database, and choose Export. Save it to your computer. We’ll be making a copy of this and working on the copy. This way, if anything goes wrong, we still have our backup.
The database information – table structure, content, everything really – is stored in a file with the extension .sql. This can be read and edited in a simple text editor. If you’re a Windows user, try NotePad++ instead of the default Notepad.
Simple do a find and replace on olddomain.com to newdomain.com. Save your copy.
Method #1:
- on the live site, verify you have that backup, then drop all the tables in the database.
- import your edited sql file with the new domain name in it. (phpMyAdmin -> Import tab.)
- edit wp-config.php with the new domain name
- change the DNS records for the domain so the new one points to the right spot on your server if you haven’t done it already.
Method #2:
- create an entirely new database. Use an existing db user & password, or create a new one – your choice, as long as they have ALL privileges on this database.
- import your edited sql file with the new domain name in it. (phpMyAdmin -> Import tab.)
- edit wp-config.php with the new domain name AND the new database name, plus the new db user & pass if you did this.
- make sure your new domain is pointing to the right spot.
Do whatever you like with the old domain. 
© andrea for WPMU Tutorials, 2009. |
Permalink |
No comment |
Add to
del.icio.us
Post tags: change, database, domain, edit, move, name, wordpressmu, wpmu
Need real genuine helpful support? MU Support.
Feed enhanced by Better Feed from Ozh
Posted in WordPressMU, change, database, domain, edit, how to, move, name, wpmu | Comments Off
