Different code behave different, what you need to do is to study your
business model, and find a best fit.
I'm going to talk about the nontechnique thing, and hope it can help.
Mysql is spliting, when saying Mysql, we always need to think about Mysql
of Oracle or Mariadb. both database have thei
On 3/12/19 3:19 PM, Christopher Browne wrote:
On Tue, 12 Mar 2019 at 12:53, Benedict Holland
wrote:
I am not saying it is not well documented. I am saying that it isn't ACID
compliant, which it isn't, as they document.
I *love* the notion of being able to roll back DDL, but it has long
been c
On Tue, 12 Mar 2019 at 12:53, Benedict Holland
wrote:
> I am not saying it is not well documented. I am saying that it isn't ACID
> compliant, which it isn't, as they document.
I *love* the notion of being able to roll back DDL, but it has long
been common for DDL to *not* be transactional even
Benedict:
On Tue, Mar 12, 2019 at 5:53 PM Benedict Holland
wrote:
> I am not saying it is not well documented. I am saying that it isn't ACID
> compliant, which it isn't, as they document.
You are using the term "ACID compliant". Could you please point me to
some definition of what this is ( no
I am not saying it is not well documented. I am saying that it isn't ACID
compliant, which it isn't, as they document.
It comes up far more often than I would like, particularly with migrations
and schema changes. It is one of the huge reasons I actively refuse to work
with MySQL. I have never upg
The MySQL manual says that INNODB 'adheres closely' to the ACID model,
though there are settings where you can trade some ACID compliance for
performance.
See https://dev.mysql.com/doc/refman/5.6/en/mysql-acid.html
I've been running PostgreSQL for a client since 2005, we're on our 5th
hardware pl
Benedict:
On Tue, Mar 12, 2019 at 4:56 PM Benedict Holland
wrote:
> When you create a table in a transaction, it will commit the transaction and
> prevent a rollback. MySQL is not ACID.
And when you call COMMIT in postgres it will commit and prevent a rollback.
This does not mean MySQL is not
When you create a table in a transaction, it will commit the transaction
and prevent a rollback. MySQL is not ACID.
Thanks,
~Ben
On Tue, Mar 12, 2019 at 11:44 AM Ron wrote:
> The Percona fork of MySQL makes active-active clustering very simple to
> set up.
>
> On 3/12/19 9:10 AM, Benedict Holla
The Percona fork of MySQL makes active-active clustering very simple to set up.
On 3/12/19 9:10 AM, Benedict Holland wrote:
MySQL isn't ACID. Postgresql is a full-featured database that doesn't
allow injection. It is very safe and secure. Also, the way that PostgreSQL
has a much better user man
Benedict:
On Tue, Mar 12, 2019 at 3:11 PM Benedict Holland
wrote:
> MySQL isn't ACID.
Are you sure of that? I mean, I stopped using it in the late nineties,
and it only had MyISAM then, certainly not ACID, but my understanding
is it's got some ACID storage backends and options ( I seem to recall
MySQL isn't ACID. Postgresql is a full-featured database that doesn't allow
injection. It is very safe and secure. Also, the way that PostgreSQL has a
much better user management system and database/table level access ACLs.
Basically, you just asked a bunch of people who have used PostgreSQL over
Laurenz Albe schrieb am 12.03.2019 um 10:05:
>> Also MySQL has a query cache that allows the results of very common queries
>> to be much faster.
>
> I have used that feature, and it has bitten me:
> https://stackoverflow.com/q/44244482/6464308
Note that the query cache was removed in MySQL 8.0
Chris Travers wrote:
> Also MySQL has a query cache that allows the results of very common queries
> to be much faster.
I have used that feature, and it has bitten me:
https://stackoverflow.com/q/44244482/6464308
I guess only some rather pathological workloads really benefit from that.
> For up
On Mon, Mar 11, 2019 at 7:32 PM Sonam Sharma wrote:
> Hi All,
>
> We are planning to migrate our database into any open source DB.
> Can someone please help me in knowing which one will be better among
> POSTGRESQL and MYSQL.
>
> In what terms postgres is better than MYSQL.
>
If course you will
On Mon, Mar 11, 2019 at 2:20 PM Gavin Flower
wrote:
> On 12/03/2019 05:35, Michael Nolan wrote:
> [...]
> > MySQL is better at isolating users from each other and requires less
> > expertise to administer.
>
> [...]
>
> I keep reading that MySQL is easier to administer, but never seen any
> evid
On 12/03/2019 09:40, Thiemo Kellner wrote:
Quoting Adrian Klaver :
On 3/11/19 9:31 AM, Sonam Sharma wrote:
Hi Adrian,
Ours is retail company and the DB size is Max 30gb, currently we are
using db2.
Things to consider:
1) Migration tools for DB2 --> MySQL/Postgresql. I have not done
this,
+1 for Postgres here. We moved to it from Oracle 15 years ago and have
never looked back for a second.
mySQL databases over the same period have needed occasional repairs that
Postgres never has. We couldn't possibly choose mySQL over Postgres now;
the feature list of mySQL is so inferior we'd nee
Quoting Adrian Klaver :
On 3/11/19 9:31 AM, Sonam Sharma wrote:
Hi Adrian,
Ours is retail company and the DB size is Max 30gb, currently we
are using db2.
Things to consider:
1) Migration tools for DB2 --> MySQL/Postgresql. I have not done
this, so someone else will have to comment.
Em 11/03/2019 16:20, Gavin Flower escreveu:
On 12/03/2019 05:35, Michael Nolan wrote:
[...]
MySQL is better at isolating users from each other and requires less
expertise to administer.
[...]
I keep reading that MySQL is easier to administer, but never seen any
evidence of that. And in m
On 12/03/2019 05:35, Michael Nolan wrote:
[...]
MySQL is better at isolating users from each other and requires less
expertise to administer.
[...]
I keep reading that MySQL is easier to administer, but never seen any
evidence of that. And in my very limited experience of both, I've found
On Tue 12 Mar, 2019, 1:58 AM Adrian Klaver,
wrote:
> On 3/11/19 9:31 AM, Sonam Sharma wrote:
> > Hi Adrian,
> > Ours is retail company and the DB size is Max 30gb, currently we are
> > using db2.
>
> Things to consider:
>
> 1) Migration tools for DB2 --> MySQL/Postgresql. I have not done this,
>
On 3/11/19 9:31 AM, Sonam Sharma wrote:
Hi Adrian,
Ours is retail company and the DB size is Max 30gb, currently we are
using db2.
Things to consider:
1) Migration tools for DB2 --> MySQL/Postgresql. I have not done this,
so someone else will have to comment.
2) The clients/frameworks/ORMs
On Mon, 11 Mar 2019 at 12:36, Michael Nolan wrote:
> There isn't a simple answer to this, it's like asking 'which is better for
> cooking: aluminum or stainless steel'. The answer is 'it depends on what
> you're trying to do'.i
Metaphors can be dangerous (especially when automotive ones get
c
On Mon, Mar 11, 2019 at 6:32 AM Sonam Sharma wrote:
> Hi All,
>
> We are planning to migrate our database into any open source DB.
> Can someone please help me in knowing which one will be better among
> POSTGRESQL and MYSQL.
>
> In what terms postgres is better than MYSQL.
>
> Regards,
> Sonam
>
Hi Adrian,
Ours is retail company and the DB size is Max 30gb, currently we are using
db2.
On Mon, Mar 11, 2019, 8:21 PM Adrian Klaver
wrote:
> On 3/11/19 4:31 AM, Sonam Sharma wrote:
> > Hi All,
> >
> > We are planning to migrate our database into any open source DB.
> > Can someone please help
On 3/11/19 4:31 AM, Sonam Sharma wrote:
Hi All,
We are planning to migrate our database into any open source DB.
Can someone please help me in knowing which one will be better among
POSTGRESQL and MYSQL.
In what terms postgres is better than MYSQL.
This cannot really be answered until more in
Sonam Sharma wrote:
> In what terms postgres is better than MYSQL.
It is easier to name the few things where MySQL might be better:
- If you need a key-value store that receives lots of updates.
- More widely used.
If I moved to an open source database, I wouldn't choose one that
is owned and con
Sonam Sharma schrieb am 11.03.2019 um 12:31:
> We are planning to migrate our database into any open source DB.
> Can someone please help me in knowing which one will be better among
> POSTGRESQL and MYSQL.
>
> In what terms postgres is better than MYSQL.
you might want to have a look at this:
Hi All,
We are planning to migrate our database into any open source DB.
Can someone please help me in knowing which one will be better among
POSTGRESQL and MYSQL.
In what terms postgres is better than MYSQL.
Regards,
Sonam
29 matches
Mail list logo
