Discover Centmin Mod today
Register Now

Backup files and database script [off topic]

Discussion in 'System Administration' started by pamamolf, Jun 18, 2014.

Thread Status:
Not open for further replies.
  1. pamamolf

    pamamolf Premium Member Premium Member

    4,070
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    5:15 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    Can i buy the script from you? :)

     
    Last edited: Jun 18, 2014
  2. eva2000

    eva2000 Administrator Staff Member

    53,554
    12,135
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,678
    Local Time:
    12:15 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    FYI, my custom backup scripts start at mid 3 figure $$$ dollar amounts. So if you're still interested could start a private conversation with me https://community.centminmod.com/conversations/add?to=eva2000.

    Otherwise, might wait to see what other members here are using :)
     
  3. rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:15 AM
    Mainline
    10.2
    So your paid server optimization cost $$$$? :muted:
     
  4. eva2000

    eva2000 Administrator Staff Member

    53,554
    12,135
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,678
    Local Time:
    12:15 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Hence why it's called paid :) Been doing paid server optimisation for forums since 2002/2003 for 100s and 1000s of forums (mainly vBulletin) - some are the largest forums online 60+ million posts and 20,000 to 60,000 current users online with millions of registered members :D

    FYI, I've pured quite alot of my experience and tuning from years of optimising servers into Centmin Mod ;)
     
  5. rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:15 AM
    Mainline
    10.2
    $$$$ is 44,000 to 440,000 Philippine Pesos already that I can't afford :(
     
  6. pamamolf

    pamamolf Premium Member Premium Member

    4,070
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    5:15 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    The 3 $$$ means more than 100$ ? :)
     
  7. rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:15 AM
    Mainline
    10.2
    He stated mid, so maybe $500 :(
     
  8. eva2000

    eva2000 Administrator Staff Member

    53,554
    12,135
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,678
    Local Time:
    12:15 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Yes more than US$100. Unfortunately, with server optimisation work for me it's already constantly booked and paid up weeks and even months in advanced already with existing clients on a waiting list. So time is money.

    But Centmin Mod's base configuration and setup for Nginx, PHP-FPM and MariaDB are optimised better than any other setup alternative out of the box already, so you're already a few steps ahead of the game ;)
     
  9. pamamolf

    pamamolf Premium Member Premium Member

    4,070
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    5:15 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    Ok thanks anyway George.

    You deserve any $ for your great job, don't take me wrong i just can't afford it and i hope another user post anything that help.

    If not i will do it manually :)
     
  10. rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:15 AM
    Mainline
    10.2
    That's why we LOVE you and your script being FREE (y)
     
  11. eva2000

    eva2000 Administrator Staff Member

    53,554
    12,135
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,678
    Local Time:
    12:15 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    No worries, I just cater to different scale and size of clients for optimisation work. FYI, optimisation work covers a full 5 days of work, monitoring, analysis and tuning and re-tuning. And I only take on 1 or 2 clients per week max.

    Indeed, actually some of my paid clients also moved to using Centmin Mod on their multi server forum setups too. Some even before I even told them about Centmin Mod :)
     
  12. rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:15 AM
    Mainline
    10.2
    I hope someday I learn how to setup Haproxy if my site grows.
    Thanks!
     
  13. pamamolf

    pamamolf Premium Member Premium Member

    4,070
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    5:15 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    One day i will buy you alot of beers so you will get drunk and post as a sample a php-fpm config for much bigger servers with dual xeon and 24 or 32 gb ram so i can get an idea on how are the values are on such servers :) lol
     
  14. eva2000

    eva2000 Administrator Staff Member

    53,554
    12,135
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,678
    Local Time:
    12:15 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Yup Haproxy is on my to do list for installation at least https://community.centminmod.com/threads/centmin-mod-to-do-list.7/. Configuration is left up to the end user to do though :)

    very hard to do, never in my life have I drunk alcohol or smoked cigs. I am a water and milk guy :D

    @pamamolf well Vivek's mysql backup script at http://bash.cyberciti.biz/backup/backup-mysql-database-server-2/ is a good start for mysql backups.
     
  15. rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:15 AM
    Mainline
    10.2
    Ahahaha and me copying it also :devil:
     
  16. pamamolf

    pamamolf Premium Member Premium Member

    4,070
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    5:15 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    @RoldanLT let me know when you need help for HAproxy :)
     
  17. rdan

    rdan Well-Known Member

    5,439
    1,398
    113
    May 25, 2014
    Ratings:
    +2,187
    Local Time:
    10:15 AM
    Mainline
    10.2
    Not for now, as my server is very capable to handle my site traffic. :)
     
  18. pamamolf

    pamamolf Premium Member Premium Member

    4,070
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    5:15 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    I don't want to copy it as each config is unique in general on each server but just to get an idea.....
     
  19. eva2000

    eva2000 Administrator Staff Member

    53,554
    12,135
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,678
    Local Time:
    12:15 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    FYI, proper server optimisation can only be done after days of server monitoring and analysis of stats and usage for each particular site/forum. No one size/config fits all ;)

    If you don't mind, I'll split the posts after post #2 in this thread to a separate thread so folks can contribute their backup strategies etc ?
     
  20. pamamolf

    pamamolf Premium Member Premium Member

    4,070
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    5:15 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    Yes ok split it :)
     
Thread Status:
Not open for further replies.