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

Thu Mar 15 18:25:27 UTC 2012

Please post that on http://jobs.wordpress.net or contact people on http://codepoet.com

----
Mika A Epstein (aka Ipstenu)
http://ipstenu.org

On 15 Mar 2012, at 1:23:30PM, Iyanu Grace wrote:

> 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
> ******************************************
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers