Jump to content
Latest News: (loading..)


  • Content count

  • Joined

  • Last visited

  • Days Won


clustersolutions last won the day on July 25

clustersolutions had the most liked content!


Profile Information

Recent Profile Visitors

22,396 profile views
  1. Import Reviews from other sites

    Yes, but I hate to say it, it may be more economical to just pay someone to write your reviews. It happens everyday on Amazon...and those sellers kick butt.
  2. Email Deliverability

    Gmail compliance became super strict early this year, and as far as I concern it was their way to keeping more ad $$$ to themselves. The affiliate email marketers were hit hard, and I think most have given up on Gmail for now. I think using Mailchimp and etc helps as you email should meet the compliance, unless you send domain has a very low quality score. Some good read if you want to mail using your own mailer to ensure compliance. https://support.google.com/mail/answer/81126?hl=en As for pixel firing, I know pixel firing can work with Gmail, but I also have seen a pixel being cache by Gmail because they want to, meaning you won't be able to see the hit...fighting this kinda reminded me of fight Panda...F#$%# Google! Oh, here you go... https://sendgrid.com/blog/5-ways-check-sending-reputation/
  3. Build a LAMP Stack for OSC

    @bruyndoncx, well, I'm id10t. I have no idea what's a RPI so I looked it up and now I am with you. I am kinda hungry, I guess. @John W, you know, I think it could be misleading that if you use a hosting company then it must be secure. I think if you run an eCommerce site, it would be your responsibility to make sure that your site is secure. I think most of the posts I had read in the past regarding a site being hacked or hi-jacked were hosted at some hosting company. So learn we must I guess, and you may be surprised how some of the vanilla install of these latest Linux distros are reasonably secured. Also, as much as we are concerned with "bad guys," I tend to keep nothing to be desired by "bad guys" in my sites. I think most eCommerce sites are if they are PCI compliance. I am not "encouraging" everyone to run out and host their own LAMP stack, I think I was just hoping to show how simple it is to bring up a LAMP instance at a very reasonable cost. I also do agree with you that running your own dedicated server/instance can give you more flexibility in managing its security and etc. Yes, but it would be required to also learn how to use ssh, rsa keys and command line and etc. Lastly, AWS or DO, you are still not technically the hosting company, you r just getting a hosted instance without cPanel and the LAMP stack....
  4. Build a LAMP Stack for OSC

    Well, @bruyndoncx, LAMP stack is no comparison to a raspberry pi, I would triple firewall that pi so it'd be all mine!!!
  5. Build a LAMP Stack for OSC

    Ah, @MrPhil, nothing's being encouraged at all, I think it's more like not being discouraged from utilizing some of these awesome technologies. You know for what it use to take a senior guy to manage it can now be done by my 13 yr old snapping and spawning and moving instances across data centers or adding CPUs and RAMs with just a few clicks.
  6. Build a LAMP Stack for OSC

    Just had to bring up another Centos 7 LAMP stack DO Droplet. I extracted these notes from my bash and mysql history. I have done these on both the AWS and DO and they are the same...hope this can be useful...I always start with the $5 instance as they can be scaled easily. Takes less than 30mins. # add swap space & disable SElinux sudo dd if=/dev/zero of=/swapfile count=2000 bs=1MiB mkswap /swapfile swapon /swapfile echo "/swapfile swap swap sw 0 0" >> /etc/fstab sed -i -e 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config #reboot server reboot # Configure yum repos. yum install -y epel-release yum install -y wget wget http://rpms.remirepo.net/enterprise/remi-release-7.rpm rpm -Uvh remi-release-7.rpm yum-config-manager --enable remi-php70 yum install -y http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm # install LAMP stack. PHP 7, Apache 2.4, and MySql/Percona 5.7 yum install -y httpd yum install -y php yum install -y php-mysqlnd yum install -y Percona-Server-server-57 yum install -y python-certbot-apache # setup Apache document root. useradd abc.com mkdir /home/abc.com/public_html cat << EOF > /etc/httpd/conf.d/abc.com.conf <VirtualHost *:80> ServerAdmin admin@abc.com DocumentRoot /home/abc.com/public_html ServerName abc.com ServerAlias www.abc.com ErrorLog "/var/log/abc.com-error_log" CustomLog "/var/log/abc.com-access_log" combined LogLevel error </VirtualHost> EOF # Start Apache systemctl start httpd # Set you DNS for abc.com, then install Let's Encrypt's free SSL. certbot --apache -d abc.com -d www.abc.com # Init MySQL systemctl start mysqld # Get MySQl root password. grep password /var/log/mysqld.log # Login to MySQL mysql -p # Run in MySQL client, change root password and create a mysql user ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'; CREATE USER 'mysql'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'mysql'@'localhost'; # Back to Bash shell. Restart and enable boot startup of Apache and MySQL systemctl enable httpd systemctl enable mysqld systemctl restart httpd systemctl restart mysqld
  7. Networking databases?

    I meant that by you move your whole stack out of your current hosting provider. I can't see how you could survive an DoS attack with them. I personally prefer Centos, but Ubuntu works too. $5 LAMP stack: https://www.digitalocean.com/products/one-click-apps/lamp/ It should be more than enough to power your OSC site, and with the $5 instance, you will need to setup an 1-2G swap...or just pay for the $10 or $20 instance. https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-16-04 Oh, I also had started using this free SSL cert...real nice and you can set it up for auto renewal. https://www.digitalocean.com/community/tutorials/how-to-secure-apache-with-let-s-encrypt-on-ubuntu-14-04 Now, the hard way would be to run the DB over the network. You can secure the DB connection using SSL, but why drive a new car with a beater engine? Plus you will have more forms to fill out for PCI compliance.
  8. Networking databases?

    Wow, it sounds like you have perfected your standby DB switchover procedure. Me, I say either a $5 Digital Ocean droplet, an AWS EC2 instance, or anything similar to these will save you boat loads of headaches...I second go find a new hosting provider.
  9. A 2 CPUs Digital Ocean Droplet runs 2 instances of OSC comfortably. A 4 CPUs Droplet sux wind big time running Magento2. What a hog!

    1. clustersolutions


      Ok. 8 CPUs made it bearable for dev.

  10. Custom.css and User.css

    @frankl, the template feature. I don't seem to have the "public/Sites/Shop/Templates" path in my BS repo. Thx! Tim
  11. Custom.css and User.css

    exactly what I was looking for, @frankl, but the current BS version doesn't seem to have this feature yet. So how is anyone making changes to the layout without touching the core codes, and any thoughts on the transition when it's time to go to the template system. I am trying to figure out how I can avoid redoing the codes again once we have the next release. Thx! tim
  12. All of the above, plus make sure that you can connect to I sometime just setup for localhost only. If you have DBA privilege, select * from mysql.user, should tell you the user setup. Also, have your php write out the database engine status at error: show engine innodb status; Look for contention as I had just recently encountered locks wait that causing connections to reach it max allowed. Fixed the locks wait and no more connection errors. I also found out MySQL's transaction isolation level defaults to Repeatable Read, it can be problematic on large insert, update, delete. I think Oracle and Informix are both Read Committed. It seems overkill to me. Something doesn't seem right, with the max connected at 85 but the max connection were set at 100. Was the DB rebooted since the error? I think with shared hosting you would have other shared hosts also connecting to the DB. I had never increased the max connections to fix any issues, it is probably a good idea to address the root cause before doing that. But may be if 85 connection is your normal load it would be a good idea to plan some surge capacity in it. Hey, for $5 a month on the cloud you can have your own LAMP stack and access to all your logs. Its a good deal...
  13. SMS marketing

    In the US, look up TCPA. I think marketing thru emails had led and gotten way out of hands so the rules and regulations are a lot more prepared this time to address phone marketing. On the other front though there are a lot more technologies for real-time opt-in tracking. The fine is hefty, I think that's why...
  14. Broke down and went to Digital Ocean. It's better than I'd expected.

    1. burt


      I have an account with them, with credit on it.  I jsut could not understand how to make it work, so I gave up!

    2. clustersolutions


      Feel free to shoot any questions about making it work. I found it easier to use than AWS, and has plenty of enterprise features that are great for shop owners, and not to mention the performance smokes the old dedicated server. The $5 droplet is plenty to start, just add a 1 G swap space to run MySQL, and go with the LAMP stack instance so less packages to install. You can always size up the instance. Also, be sure to use a datacenter that has additional data volume feature as not all datacenter yet allows a disk volume being added. This is something for sure will become necessary. We are using G Suite to handle emails.

  15. Mailchimp is good. I just started using thenewsletterplugin from WP as when setup right it is free (kinda when you run your own instance). I just import the listing to WP. I am probably just gonna use it to get the clicker/openers...Mailchimp has better reporting for now...