Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 35702 10 Older Entries
February 23rd: how CloudStats.me moved from MySQL to clustered MariaDB for high availability
+0 Vote Up -0Vote Down

On Tuesday, February 23, please join us and the WooServers team for a webinar on the scalable, open source database infrastructure behind CloudStats.me.

CloudStats.me is a fast growing cloud-based server and website monitoring service. The rapid growth of the CloudStats user base and the number of services being monitored created a significant load on its MySQL infrastructure. The system ingests large amounts of incoming metrics/event data collected by thousands of agents. The backend systems …

  [Read more...]
Videos of FOSDEM MySQL & Friends Devroom are available !
+0 Vote Up -0Vote Down

After the pictures (see the galleries on top ^), the videos of the MySQL & Friends Devroom are available !

You can find them on http://video.fosdem.org/2016/h1308/

Enjoy them !

MySQL Performance: Scalability on OLTP_RW Benchmark with MySQL 5.7
Employee +0 Vote Up -0Vote Down

Next article from the MySQL 5.7 Performance stories, now about OLTP_RW scalability (if you missed any previous ones, see 1.6M SQL Query/sec (QPS) with MySQL 5.7, 1M SQL Query/sec on mixed OLTP_RO / …

  [Read more...]
Feedback Request: Enforcing SQL Mode
Employee_Team +0 Vote Up -0Vote Down

MySQL Server has an extensive collection of SQL modes which control a range of behavior ranging from compatibility modes for other RDBMS dialects (ANSI_QUOTES, PIPES_AS_CONCAT) to security (NO_AUTO_CREATE_USER) to explicit storage engine selection ( …

  [Read more...]
Log Buffer #459: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This Log Buffer Edition arranges few tips and tricks from the blogs of Oracle, SQL Server and MySQL.

Oracle:

Oracle ® Solaris innovation is due in part to the UNIX® the standard (1), the test suites (2) and the certification (3). By conforming to the standard, using the test suites and driving to certification, Oracle ® Solaris software engineers can rely on stable interfaces and an assurance that any regressions will be found quickly given more than 50,000 test cases.

Building on the program established …

  [Read more...]
Percona Server 5.7.10-2 second RC available
+0 Vote Up -0Vote Down

Percona is glad to announce the second release candidate of Percona Server 5.7.10-2 on February 8, 2016. Download the latest version from the Percona web site or from the Percona Software …

  [Read more...]
Percona XtraBackup 2.4.0-rc1 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the first release candidate of Percona XtraBackup 2.4.0-rc1 on February 8th 2016. Downloads are available from our download site and from apt and yum repositories.

  [Read more...]
Concurrent inserts and the RocksDB memtable
+0 Vote Up -0Vote Down

RocksDB started as a fork of LevelDB. While it will always be a fork, we describe it as derived from LevelDB given how much code has changed. It inherited a memtable that did not allow concurrent inserts courtesy of a mutex - readers ignored the mutex, writers must lock it. Writers waiting for the mutex linked their updates together and the thread at the head of the convoy applied all of their changes after getting the mutex.

Insert performance for RocksDB and LevelDB did not improve beyond one thread when sync on commit was disabled because of contention on the mutex. It could improve with more threads when sync on commit was …

  [Read more...]
MySQL 5.7: Introduction for Operational DBAs
+0 Vote Up -0Vote Down

Join us Tuesday, February 16, 2016 9:00am PST (UTC-8) for a webinar on the operational and monitoring features of MySQL 5.7 with Percona CEO Peter Zaitsev.

MySQL 5.7 is a great release, providing valuable features for both daily operations and ongoing development. In this, part two of our ongoing 5.7 webinar series, we will look into the new MySQL 5.7 features and enhancements that improve operations, with …

  [Read more...]
High availability read-write splitting with php-mysqlnd, MySQL Replication and HAProxy
+0 Vote Up -0Vote Down

MySQL Replication is used in a variety of use cases - scale out read workloads, provide high availability and geographic redundancy, offload backups and reporting/analytic jobs. However it has a big drawback - the application needs to be able to send writes to the master only. Updating more than one master in a replication setup can result in data inconsistency and cause replication to break.

An SQL-aware load balancer like …

  [Read more...]
Showing entries 1 to 10 of 35702 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.