Clint Byrum wrote:
Excerpts from Jon Foster's message of 2016-10-14 09:33:59 -0700:
I have a DB scenario that is very write intensive. Essentially its a
large scale hit counter of sorts. Currently we're running on a single
12core server with 6 SSDs in a RAID6 array. But we're looki
Sorry, I'm not ignoring you. I was not the one who designed the schema
so I'm going to have to go look at it. I will probably not be able to
get back to you today with my assessment.
THX - Jon
Justin Swanhart wrote:
I asked about schema and queries to determine which sharding framework mak
I asked about schema and queries to determine which sharding framework makes
the most sense to suggest.
Sent from my iPhone
> On Oct 14, 2016, at 1:05 PM, Clint Byrum wrote:
>
> Excerpts from Jon Foster's message of 2016-10-14 09:33:59 -0700:
>> I have a DB scenario that is very write intensiv
Excerpts from Jon Foster's message of 2016-10-14 09:33:59 -0700:
> I have a DB scenario that is very write intensive. Essentially its a
> large scale hit counter of sorts. Currently we're running on a single
> 12core server with 6 SSDs in a RAID6 array. But we're looking for a way
> to scale out wr
Can you describe your schema and typical queries please?
Sent from my iPhone
> On Oct 14, 2016, at 12:33 PM, Jon Foster wrote:
>
> I have a DB scenario that is very write intensive. Essentially its a
> large scale hit counter of sorts. Currently we're running on a single
> 12core server with 6
I have a DB scenario that is very write intensive. Essentially its a
large scale hit counter of sorts. Currently we're running on a single
12core server with 6 SSDs in a RAID6 array. But we're looking for a way
to scale out write volume by adding more servers, hopefully as
conveniently as I might a
Karthick:
You should post this in maxscale group as well.
Dipti
On Fri, Oct 14, 2016 at 6:34 PM, Kristian Nielsen
wrote:
> Karthick Subramanian writes:
>
> > Below when I try at Slave DB:
> >
> > MariaDB [dr_repl]> select * from test_dr_repl;
> > Empty set (0.00 sec)
> >
> > MariaDB [dr_repl]
Making Percona/MariaDB/MySQL better at sharding, and supporting complex
queries (with MPP capability, window functions, CTE,etc.) would really
compete with an enterprise DB, with RedShift, and with Fabric. Shard-Query
can greatly outperform both the enterprise MySQL Infobright (and MC
ColumnStore)
i read opnions about why choose mysql, and the common point is 'mysql runs
simple queries really fast' i think that's the main feature of mysql
2016-10-14 11:25 GMT-03:00 Reindl Harald :
>
>
> Am 14.10.2016 um 15:21 schrieb Richard Bensley:
>
>> Me and many others had hope that TokuDB would be th
Am 14.10.2016 um 15:21 schrieb Richard Bensley:
Me and many others had hope that TokuDB would be the death of InnoDB in
MariaDB, and the catalyst to a truly amazing open source database.
please fix that "many others" above by saying "some others" - if we
would like a "truly amazing open sour
>
> On Friday, 14 October 2016, Roberto Spadim wrote:
>
>> I don't think (most) guys must migrate from other RDBM, normally they
>> select mysql/mariadb/webscale/etcetc before starting the project, a
>> migration "in the middle" of a project is costly.
>> I agree, there's many open issue at jira/m
On Friday, 14 October 2016, Roberto Spadim wrote:
> I don't think (most) guys must migrate from other RDBM, normally they
> select mysql/mariadb/webscale/etcetc before starting the project, a
> migration "in the middle" of a project is costly.
> I agree, there's many open issue at jira/mysql bug
Karthick Subramanian writes:
> Below when I try at Slave DB:
>
> MariaDB [dr_repl]> select * from test_dr_repl;
> Empty set (0.00 sec)
>
> MariaDB [dr_repl]> commit;
> Query OK, 0 rows affected (0.00 sec)
>
> MariaDB [dr_repl]> select * from test_dr_repl;
> ++--+
> | id | val |
> ++-
I don't think (most) guys must migrate from other RDBM, normally they
select mysql/mariadb/webscale/etcetc before starting the project, a
migration "in the middle" of a project is costly.
I agree, there's many open issue at jira/mysql bug report/percona/etc/etc
and others issue tracker systems that
Is anyone surprised by the lack of TokuDB support? Percona is primarily an
Oracle MySQL fork . The InnoDB changes in MySQL 8 represent something
entirely different. Good, but different.
I don't think I am being too speculative when I say, I am sure Oracle are
in no hurry to make MySQL a serious co
I didn't expect that autocommit = OFF will affect the replication feature.
I thought replication will be handled irrespective what commit type is
enabled in the DB Server.
So whenever I promote any new master from a slave, I have to taken care
this auto commit accordingly. Is my understanding corr
Hi All,
I have the below topology:
Master -> Slave (using GTID replication)
Master -> Maxscale (Binlog Router)
Maxscale -> DR Site (via binlog router)
my.cnf is same across all sites:
lower-case-table-names=1
autocommit=0
#replication variables
log-bin=binlog
binlog-format=ROW
replicate_ann
Hi all!
On 10/14/2016 11:10 AM, jocelyn fournier wrote:
Hi!
Regarding the TokuDB bugs, they are so far fixed quite quickly by
Percona.
I want to clarify the source of the question (FUD) about Percona not
fixing TokuDB bugs, and hopefully bring it to an end. It apparently
comes from me, sayi
Hi!
Regarding the TokuDB bugs, they are so far fixed quite quickly by
Percona. For example
https://bugs.launchpad.net/percona-server/+bug/1607300 was investigated
and fixed in less than 10 days, and George answered the same day of the
bug report.
And hopefully, the latest remaining patch fr
Hi, MARK!
On Oct 13, MARK CALLAGHAN wrote:
> On Thu, Oct 13, 2016 at 4:00 PM, Sergei Golubchik wrote:
> >
> > There is development and support for TokuDB. The main reason for
> > dropping it could be RocksDB based engine covering all TokuDB use
> > cases, but better. I mean, *if* RocksDB will be
20 matches
Mail list logo