Profile

Cover photo
Open Query Pty Ltd
15 followers|29,835 views
AboutPostsPhotosVideos

Stream

Open Query Pty Ltd

Shared publicly  - 
 
Uber Engineering explains the technical reasoning behind its switch in database technologies, from Postgres to MySQL: https://eng.uber.com/mysql-migration/ These things are always an interesting read, because it looks at one company’s decision making…
At Open Query we're not a fan of migrations - it doesn't matter from what brand to what brand, migrations tend to be expensive and painful.
1
Add a comment...

Open Query Pty Ltd

Shared publicly  - 
 
You may not be aware that the mechanism used to fingerprint the SSL certificates that  keep your access to websites encrypted and secure is changing. The old method, known as SHA1 is being deprecated – meaning it will no longer be supported. As per…
1
Add a comment...

Open Query Pty Ltd

Shared publicly  - 
 
Some time ago, Peter Boros at Percona wrote this post: Rotating MySQL slow logs safely. It contains good info, such as that one should use the rename method for rotation (rather than copytruncate), and then connect to mysqld and issue a FLUSH LOGS (rather…
1
Add a comment...

Open Query Pty Ltd

Shared publicly  - 
 
ARIN is the American Registry for Internet Numbers, the organisation that hands out the blocks IP addresses. Each region has its own, for instance Australia/Pacific has APNIC. Naturally, they work very closely together. Open Query can assist you with…
ARIN is the American Registry for Internet Numbers, the organisation that hands out the blocks IP addresses. Each region has its own, for instance Australia/Pacific has APNIC. Naturally, they work …
1
Add a comment...

Open Query Pty Ltd

Shared publicly  - 
 
http://dom.as/2015/07/30/on-order-by-optimization/ An insightful exploration by Domas (Facebook) on how some of the MySQL optimiser’s decision logic is sometimes naive, in this case regarding ORDER BY optimisation. Quite often, “simple” logic can work…
1
Add a comment...

Open Query Pty Ltd

Shared publicly  - 
 
This is a little quiz (could be a discussion). I know what we tend to prefer (and why), but we’re interested in hearing additional and other opinions! Given the way MySQL/MariaDB is architected, what would you prefer to see in a new server, more cores or…
1
Add a comment...
Have them in circles
15 people
Damien Whaley's profile photo
Tribily's profile photo
Liz Quilty's profile photo
Arjen Lentz's profile photo
Walter Heck's profile photo
Joost Faassen's profile photo
What's On Bali's profile photo
lee 8state's profile photo
Geovanny F's profile photo

Open Query Pty Ltd

Shared publicly  - 
 
Sijmen writes: A few weeks ago I gave a guest lecture at the Windesheim University of Applied Sciences in The Netherlands. I graduated there and over the years I kept in contact with some of my teachers since then. One of the teachers told me recently…
Sijmen writes: A few weeks ago I gave a guest lecture at the Windesheim University of Applied Sciences in The Netherlands. I graduated there and over the years I kept in contact with some of my teachers since then. One of the teachers told me recently that a lot of students wanted to learn more about IT security and hacking and asked me to give a lecture about it. Of course! And to keep it a bit juicy, I built in a hacking demonstration in my lec...
1
Add a comment...

Open Query Pty Ltd

Shared publicly  - 
 
http://www.itnews.com/article/3004953/use-oracles-database-watch-out-for-this-dec-1-deadline.html Companies that use a standard edition of Oracle’s database software should be aware that a rapidly approaching deadline could mean increased licensing costs.…
1
Add a comment...

Open Query Pty Ltd

Shared publicly  - 
 
People at Intel started the pmem library project some time ago, it’s open to the broader community at GitHub and  other developers, including Linux kernel devs, are actively involved. While the library does allow interaction with an SSD using a…
1
Add a comment...

Open Query Pty Ltd

Shared publicly  - 
 
Job opportunity!
Are you based in AU/NZ, ace at sysadmin & good with MySQL/MariaDB ?
We'd like to talk with you!

http://openquery.com.au/company/jobs/mariadb-engineer
Job essentialsadvanced/guru level skills in system and network administration;intermediate/advanced/guru level practical skills in MySQL/MariaDB schema/query design, server tuning (decent DBA skills/experience), replication (MMM, Corosync/Pacemaker, Galera);expertise in common dev and deployment infrastructure (mainly RHEL/Debian based Linux);
1
1
Add a comment...

Open Query Pty Ltd

Shared publicly  - 
 
http://upstarta.com.au/post/copyright-apis-header-files [US] Supreme Court won’t weigh in on Oracle-Google API copyright battle (Ars Technica) – Lower court to decide if API utilization is copyright infringement or fair use.
1
Add a comment...

Open Query Pty Ltd

Shared publicly  - 
 
http://mysqlserverteam.com/removal-and-deprecation-in-mysql-5-7/ A useful overview of options, syntax and tools that have been deprecated or removed for the upcoming MySQL 5.7 release.
1
Add a comment...
People
Have them in circles
15 people
Damien Whaley's profile photo
Tribily's profile photo
Liz Quilty's profile photo
Arjen Lentz's profile photo
Walter Heck's profile photo
Joost Faassen's profile photo
What's On Bali's profile photo
lee 8state's profile photo
Geovanny F's profile photo
Contact Information
Contact info
Phone
07 3103 0809
Email
Story
Tagline
Your databases and online infrastructure. Managed.
Introduction

We are an Australian based company with specific expertise in MySQL and MariaDB. Our services include consulting, scalable architecture, proactive remote DBA, system administration, vendor neutral managed services with optional emergency support, mentoring, training, and security and code reviews.

Links