On 11/27/19 6:53 PM, Leon Vaks wrote:
Hello Tim,
I was given the same advice to convert to PostgreSQL because
PostgreSQL is Horizontally scalable.
I did some research:
Horizontal scaling means that you scale by adding more machines into
your pool of resources whereas Vertical scaling means that you scale
by adding more power (CPU, RAM) to an existing machine.
MySQL has many different storage engines:
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
<https://slack-redir.net/link?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fstorage-engines.html>
The most popular storage engine among developers is InnoDB. For MySQL
version 8, it can go up to 64 Terabytes per server.
However, storage engine - ndb allows unlimited horizontal scaling by
adding nodes. Ndb stands for network db and used by number of telcos
and gaming publishers. Ndb is super fast because it is in memory
database (similar to SAP Hana); however, it requires more knowledge to
setup and configure then Innodb storage engine. Innodb storage engine
is more popular among development teams because it is more simple to
configure and administer.
Both engines can handle transactions. In addition, both engines can
work with SQL data as well as NoSQL data i.e. you do not need to add
additional databases like Mongodb. For Big data, using Hadoop and
MySQL, use Hadoop Applier. MySQL team developedAnalytical Engine which
can do data analytics in the cloud; however, I am not sure if this
service will be officially available in this coming release.
I hope this helps,
Happy Holiday to Everyone.
Leon
On Wed, Nov 27, 2019 at 6:34 PM Tim Johnson <t...@akwebsoft.com
<mailto:t...@akwebsoft.com>> wrote:
Using python 3.7.2, Django 2.1.5 on Linux development workstation
with
deployment to Heroku.
I retired several ago, primarily coding in python and mostly
working in
legacy CGI systems with MySQL backends and still use mysql on my
workstation.
I am now essentially a hobbyist who wishes to use a django website to
publish articles, memoirs and essays.
Some have urged me to convert to PostGresql as it is "baked into"
heroku. However, my comfort level is with mysql.
Given my situation I'd welcome any reason why I should convert to
postgresgl. I am not interested in stirring up controversy. Should
there
be a pressing reason to convert to PG I'd sooner do it now than when
I've a couple of hundred articles published.
Any insights would be appreciated.
Thank you Leon.
Great analysis!
--
You received this message because you are subscribed to the Google Groups "Django
users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/3245d9a3-b09e-a6fa-87f7-3c01fd95e319%40akwebsoft.com.