[wp-hackers] wp-hackers Digest, Vol 86, Issue 13

Thu Mar 15 18:23:30 UTC 2012

Hello.I have a offer for any hacker that has interest.I own a website where i sell cameras .I need someone that would be shopping on my mwebsite with cc and i will pay him 30% on each goods bought at the shop. shipping to the same billing address ..if any interest ,please write me through this email address or darin.cantrell at aol.com

________________________________
 From: "wp-hackers-request at lists.automattic.com" <wp-hackers-request at lists.automattic.com>
To: wp-hackers at lists.automattic.com 
Sent: Friday, March 9, 2012 10:41 PM
Subject: wp-hackers Digest, Vol 86, Issue 13

Send wp-hackers mailing list submissions to
    wp-hackers at lists.automattic.com

To subscribe or unsubscribe via the World Wide Web, visit
    http://lists.automattic.com/mailman/listinfo/wp-hackers
or, via email, send a message with subject or body 'help' to
    wp-hackers-request at lists.automattic.com

You can reach the person managing the list at
    wp-hackers-owner at lists.automattic.com

When replying, please edit your Subject line so it is more specific
than "Re: Contents of wp-hackers digest..."

Today's Topics:

   1. Re: Percona Server and WordPress (Jeremy Clarke)
   2. Re: Percona Server and WordPress (Brian Layman)
   3. Re: HyperDB - worth the trouble? (Baki Goxhaj)
   4. Re: Percona Server and WordPress (Kevinjohn Gallagher)
   5. Posting google news as blog posts (Pankaj Kumar Sharma)
   6. Posting google news as blog posts (Pankaj Kumar Sharma)
   7. Re: Percona Server and WordPress (Braydon)
   8. GSOC 2012 (Samiran Raj Boro)

----------------------------------------------------------------------

Message: 1
Date: Fri, 9 Mar 2012 10:29:08 -0500
From: Jeremy Clarke <jer at simianuprising.com>
Subject: Re: [wp-hackers] Percona Server and WordPress
To: wp-hackers at lists.automattic.com
Message-ID:
    <CAAHgzDOGAGr1jiUo3VxmrA-fnSe2beEBvouHSYW-rVp_Jvk1Tw at mail.gmail.com>
Content-Type: text/plain; charset=windows-1252

We switched to http://mariadb.org/ rather than Percona Server, but the
underlying software is almost entirely the same, both are packages of all
the wonderful open-source patches that just don't make it into the core
MySQL. In either case, the really mind-blowing performance gains come from
XtraDB, which is the replacement for the core InnoDB engine of MySQL.

Preparing and implementing the switch was time consuming and there was some
brief downtime while me and an expert figured out the config changes to
make (there are a couple of config variables that needed changing to make
it work right) but otherwise the transition was smooth. No WP related
issues as far as I can tell, it's pretty much totally compatible in terms
of actual SQL.

The performance gains I got were tremendous. Load went from static around 6
to more like 2 and stopped spiking the way it did before. Our upgrade was
from MySQL 5.0.x. to the 5.1.x branch of MariaDB, so the actual MySQL
upgrade could have also played a part, but the change was so drastic I
believe it was XtraDB making the difference (the same kind of improvements
are described for people just switching within a major MySQL branch).

IMHO this is the future of MySQL. I hope the hosts of the world start
switching :)

-- 
Jeremy Clarke ? jeremyclarke.org
Code and Design ? globalvoicesonline.org

------------------------------

Message: 2
Date: Fri, 09 Mar 2012 11:22:02 -0500
From: Brian Layman <wp-hackers at thecodecave.com>
Subject: Re: [wp-hackers] Percona Server and WordPress
To: wp-hackers at lists.automattic.com
Message-ID: <4F5A2E2A.10606 at thecodecave.com>
Content-Type: text/plain; charset=windows-1252; format=flowed

Oh interesting....

I'd not heard of MariaDB before...
"MariaDB is primarily driven by developers at Monty Program, a company 
founded by Michael "Monty" Widenius, the original author of MySQL"

It's curious why these changes aren't added to the MySQL core if they 
make such a significant difference...

Brian Layman

On 3/9/2012 10:29 AM, Jeremy Clarke wrote:
> We switched to http://mariadb.org/ rather than Percona Server, but the
> underlying software is almost entirely the same, both are packages of all
> the wonderful open-source patches that just don't make it into the core
> MySQL. In either case, the really mind-blowing performance gains come from
> XtraDB, which is the replacement for the core InnoDB engine of MySQL.
>
> Preparing and implementing the switch was time consuming and there was some
> brief downtime while me and an expert figured out the config changes to
> make (there are a couple of config variables that needed changing to make
> it work right) but otherwise the transition was smooth. No WP related
> issues as far as I can tell, it's pretty much totally compatible in terms
> of actual SQL.
>
> The performance gains I got were tremendous. Load went from static around 6
> to more like 2 and stopped spiking the way it did before. Our upgrade was
> from MySQL 5.0.x. to the 5.1.x branch of MariaDB, so the actual MySQL
> upgrade could have also played a part, but the change was so drastic I
> believe it was XtraDB making the difference (the same kind of improvements
> are described for people just switching within a major MySQL branch).
>
> IMHO this is the future of MySQL. I hope the hosts of the world start
> switching :)
>

------------------------------

Message: 3
Date: Fri, 9 Mar 2012 17:42:39 +0100
From: Baki Goxhaj <banago at gmail.com>
Subject: Re: [wp-hackers] HyperDB - worth the trouble?
To: wp-hackers at lists.automattic.com
Message-ID:
    <CAM_fM0pBqBz3Te+acj8u6AAU0szsOiujX-bCi96hg=5FErayAQ at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

That cool! And a little embarrassing. I could just have check the tables
myself.

Thanks guys - my questions are answered.

Kindly,

Baki Goxhaj
www.wplancer.com | proverbhunter.com | www.banago.info<http://proverbhunter.com>

On Thu, Mar 8, 2012 at 9:48 PM, Brian Layman <wp-hackers at thecodecave.com>wrote:

>
> On 3/8/2012 2:26 PM, Baki Goxhaj wrote:
>
>> The good news is in almost all cases WP Multisite already splits sites
>>> across tables
>>>
>> That would be cool then, but is this really the case? Otto? :)
>>
> Sure! Every site gets their own set of tables by default.  Posts would
> stored in a table with the blog ID as part of the name.  So you'd have
> things like: wp_2_posts or maybe wp_23_posts
>
> In my opinion, the long and short of it is that you should only move to a
> more complex configuration when you have outgrown your current
> configuration.  Don't anticipate.  Otherwise you are adding complexity (and
> possibly expense) when there is no need.
>
> Only add HyperDB if you know you are being slowed down by the database and
> can't do anything more with caching.   Add extra read servers only when you
> see your current server configuration maxed out and basic upgrades to the
> machine is not going to be cost effective.  Only add sharding when adding
> more machines is no longer cost effective.  Jumping ahead of the game and
> say going straight to a hyperdb configuration sharded across regions,
> because you know your site is going to be popular, would add only
> complexity and distract you from the things you need to do to keep your
> site popular - and it could even slow your site down.
>
> Start with memcache and a php accelerator like APC and something like
> w3tc.  Then when needed a separate DB server and then when needed hyperdb
> with a r/w master and a read slave. And read up about php-fpm and nginx
> along the way.
>
> Brian Layman
>
>
>
> ______________________________**_________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.**com <wp-hackers at lists.automattic.com>
> http://lists.automattic.com/**mailman/listinfo/wp-hackers<http://lists.automattic.com/mailman/listinfo/wp-hackers>
>

------------------------------

Message: 4
Date: Fri, 9 Mar 2012 17:22:39 +0000
From: Kevinjohn Gallagher <kevinjohngallagher at hotmail.com>
Subject: Re: [wp-hackers] Percona Server and WordPress
To: "wp-hackers at lists.automattic.com"
    <wp-hackers at lists.automattic.com>
Message-ID: <BLU150-W12CEC3C929AD200578908CC540 at phx.gbl>
Content-Type: text/plain; charset="iso-8859-1"

[people don't like it when i actually write things, so here's links with answer to your questions]

http://monty-says.blogspot.com/2009/02/time-to-move-on.html
http://www.theregister.co.uk/2009/12/29/save_mysql_campaign/
http://kb.askmonty.org/en/mariadb-versus-mysql
I also found this interesting:
http://www.odbms.org/blog/2011/09/mariadb-the-new-mysql-interview-with-michael-monty-widenius/

> Date: Fri, 9 Mar 2012 11:22:02 -0500
> From: wp-hackers at thecodecave.com
> To: wp-hackers at lists.automattic.com
> Subject: Re: [wp-hackers] Percona Server and WordPress
> 
> Oh interesting....
> 
> I'd not heard of MariaDB before...
> "MariaDB is primarily driven by developers at Monty Program, a company 
> founded by Michael "Monty" Widenius, the original author of MySQL"
> 
> It's curious why these changes aren't added to the MySQL core if they 
> make such a significant difference...
> 
> Brian Layman
> 
> 
> On 3/9/2012 10:29 AM, Jeremy Clarke wrote:
> > We switched to http://mariadb.org/ rather than Percona Server, but the
> > underlying software is almost entirely the same, both are packages of all
> > the wonderful open-source patches that just don't make it into the core
> > MySQL. In either case, the really mind-blowing performance gains come from
> > XtraDB, which is the replacement for the core InnoDB engine of MySQL.
> >
> > Preparing and implementing the switch was time consuming and there was some
> > brief downtime while me and an expert figured out the config changes to
> > make (there are a couple of config variables that needed changing to make
> > it work right) but otherwise the transition was smooth. No WP related
> > issues as far as I can tell, it's pretty much totally compatible in terms
> > of actual SQL.
> >
> > The performance gains I got were tremendous. Load went from static around 6
> > to more like 2 and stopped spiking the way it did before. Our upgrade was
> > from MySQL 5.0.x. to the 5.1.x branch of MariaDB, so the actual MySQL
> > upgrade could have also played a part, but the change was so drastic I
> > believe it was XtraDB making the difference (the same kind of improvements
> > are described for people just switching within a major MySQL branch).
> >
> > IMHO this is the future of MySQL. I hope the hosts of the world start
> > switching :)
> >
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers

------------------------------

Message: 5
Date: Sat, 10 Mar 2012 00:49:31 +0530
From: Pankaj Kumar Sharma <sharmapankaj1992 at gmail.com>
Subject: [wp-hackers] Posting google news as blog posts
To: wp-hackers at lists.automattic.com
Message-ID:
    <CADEuSkfjN3Gp5pwRSDjsmkB4ra=-3oazyEXGVPTr7P4jixGuVw at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8

Hi
using google news search and wp apis I have made a plugin that allows
admins to post google news in their blogs without even logging inside the
admin panel.
The plugin is in initial stage. I welcome you all to test this and provide
me feedbacks.
Here it is: http://engineerinme.com/gnews-wordpress.zip
Regards,

-- 
Pankaj Kumar Sharma | ???? ????? ?????
Jamia Millia Islamia

------------------------------

Message: 6
Date: Sat, 10 Mar 2012 00:51:35 +0530
From: Pankaj Kumar Sharma <pankaj at engineerinme.com>
Subject: [wp-hackers] Posting google news as blog posts
To: wp-hackers at lists.automattic.com
Message-ID:
    <CADEuSkcp2MscwOFJTf+b7WU2XLkjNkddLrXO3Nsv153RpDqc-Q at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8

Hi
using google news search and wp apis I have made a plugin that allows
admins to post google news in their blogs without even logging inside the
admin panel.
The plugin is in initial stage. I welcome you all to test this and provide
me feedbacks.
Here it is: http://engineerinme.com/gnews-wordpress.zip
Regards,

-- 
Pankaj Kumar Sharma | ???? ????? ?????
Jamia Millia Islamia

-- 
Pankaj Kumar Sharma | ???? ????? ?????
   Co-Founder engineerinme.com
-------------------------------------------------
Facebook <http://www.facebook.com/engineerinme> |
Twitter<http://twitter.com/#%21/engineerinmine>|
Linkedin <http://in.linkedin.com/pub/pankaj-sharma/31/270/365> |
Google+<https://plus.google.com/111168421079080711164/about>

------------------------------

Message: 7
Date: Fri, 09 Mar 2012 11:37:03 -0800
From: Braydon <ronin at braydon.com>
Subject: Re: [wp-hackers] Percona Server and WordPress
To: wp-hackers at lists.automattic.com
Message-ID: <4F5A5BDF.3020604 at braydon.com>
Content-Type: text/plain; charset=windows-1252; format=flowed

There is also Drizzle, a MySQL fork for high concurrency: 
http://www.drizzle.org/

On 03/09/2012 07:29 AM, Jeremy Clarke wrote:
> We switched to http://mariadb.org/ rather than Percona Server, but the
> underlying software is almost entirely the same, both are packages of all
> the wonderful open-source patches that just don't make it into the core
> MySQL. In either case, the really mind-blowing performance gains come from
> XtraDB, which is the replacement for the core InnoDB engine of MySQL.
>
> Preparing and implementing the switch was time consuming and there was some
> brief downtime while me and an expert figured out the config changes to
> make (there are a couple of config variables that needed changing to make
> it work right) but otherwise the transition was smooth. No WP related
> issues as far as I can tell, it's pretty much totally compatible in terms
> of actual SQL.
>
> The performance gains I got were tremendous. Load went from static around 6
> to more like 2 and stopped spiking the way it did before. Our upgrade was
> from MySQL 5.0.x. to the 5.1.x branch of MariaDB, so the actual MySQL
> upgrade could have also played a part, but the change was so drastic I
> believe it was XtraDB making the difference (the same kind of improvements
> are described for people just switching within a major MySQL branch).
>
> IMHO this is the future of MySQL. I hope the hosts of the world start
> switching :)
>

-- 
Braydon Fuller
http://braydon.com/

------------------------------

Message: 8
Date: Sat, 10 Mar 2012 01:11:50 +0530
From: Samiran Raj Boro <srajbr at gmail.com>
Subject: [wp-hackers] GSOC 2012
To: wp-hackers at lists.automattic.com
Message-ID:
    <CAEJCmggQ9HywGGU+_AAxWROquonmB49UKnNG2h45wzd--m-ANQ at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Hi,
I am Samiran Raj Boro pursing BTech (CSE) in Gauhati University. I am
interested to submit proposal to WP this year in GSOC. I looked for this
year ideal page for GSOC, but could not find it. I can find the last year
idea list. Is the list yet to be published?

Any suggestions for me please.

Samiran

------------------------------

_______________________________________________
wp-hackers mailing list
wp-hackers at lists.automattic.com
http://lists.automattic.com/mailman/listinfo/wp-hackers

End of wp-hackers Digest, Vol 86, Issue 13
******************************************