Hubert Nguyen
Former video-games engineer turned media publisher. I co-founded Ubergizmo, a popular tech media website. Technical advisor and code-mentor.
24 contributions
68k contribution views
Skills
- Wordpress
- PHP
- Performance
Follow Me
Recognition
Posts
-
Published Answer
Advice on React application with Laravel API as a backend that uses MySQL for the database
If you can, I’d advise to try figuring out “why” the DB locks up to begin with. It might be the sheer concurrency, or there maybe c… -
Published Answer
Why connecting to Managed MySQL DB from local is very slow?
It’s because of network latency. When you are in the same datacenter as the MySQL instance, the latency is below one millisecond… -
Published Answer
When would you use Backups instead of Snapshots?
(server) backups are a form of snapshots. The main difference is that DO has rolling “backups” so you don’t need to worry about ser… -
Published Answer
Cross Region High Availability
Adding a reply to comment and follow this topic. I noticed that problem and from what I remember, pretty much all DO datacenters in… -
Published Answer
Load balancing between servers in different regions mainly for high availability
That said, if you can replicate the DB across datacenters, you can use DNS-based load-balancing and failover. You could also use a … -
Published Answer
Can we resize a standard Droplet to a High CPU Droplet?
Just noticed that, and DigitalOcean could have an error message other than “Something wrong happened”… -
Published Answer
Default wait_timeout set to 8 hours?!!!
I haven’t seen this specific setting, but after testing the managed database, I strongly recommended to DO to let us change some se… -
Published Answer
Will my DO droplet cache my website files?
@jakemeah how did you configure your web server? the Droplet comes blank by default, and even LAMP isn’t installed, so we need more… -
Published Answer
Managed Database or Droplet?
It depends on how much time/energy you want to dedicate to maintain/update/backup your DB server. If you’d rather focus on somethin…Accepted Answer: It depends on how much time/energy you want to dedicate to maintain/update/backup your DB server. If you’d rather focus on somethin… -
Published Answer
How to debug DO managed DB throughput/latency spikes?
Unfortunately, there are very limited profiling and debugging information available on managed DB. Unlike AWS RDS/Aurora, you canno… -
Published Answer
Best method to sync Managed MySQL to MySQL on a Droplet
Unfortunately, the managed DBs won’t have any such access or options. If we could change basic settings such as key buffers etc, we…Accepted Answer: Unfortunately, the managed DBs won’t have any such access or options. If we could change basic settings such as key buffers etc, we… -
Published Answer
Which SQL mode values to use for WordPress?
businessbcbdbe0eab0de5765a, thanks for the update. Much appreciated ^^ -
Published Answer
Tableau is unable to connect to Digital Ocean Managed Database
Are you trying to connect via PHP? Also with the private or public IP? -
Published Answer
Which SQL mode values to use for WordPress?
Oh yes! That’s right, I forgot about this. You have to change the auth method as your link says. -
Published Answer
Which SQL mode values to use for WordPress?
DO managed DBs do work with WP, I ran many tests with them. You might bump into a couple of issues: In the DO GUI DB settings, y…Accepted Answer: DO managed DBs do work with WP, I ran many tests with them. You might bump into a couple of issues: In the DO GUI DB settings, y… -
Published Answer
I'm trying to use a managed database but without success.
Can you recreate a db with utf8, re import and try again? Other fixes usually have to do with mysql config, but you don’t have a… -
Published Answer
Require more details regarding Managed MySQL services
So I spun a few Managed databases (1/2/4 GB RAM) to run some tests in the context of Wordpress, and noticed that it is currently no… -
Published Answer
Private connection to Managed DB not working from within same region droplet.
I’m having the same issue… solution is to use the public IP for now :/ -
Published Answer
How to change MySQL mode permanently in MySQL Managed Database?
It would be nice if DO could make it tweakable so we don’t need to create a ticket for this every time we spin a new Managed DB