Category: Column Stores

Feed: MemSQL Blog. Author: Nicole Nearhood. Join Conference in San Francisco brings together thousands of companies across the globe that build their businesses with Looker. The developers responsible for this revolution need a place to share their experiences on this journey. This year, Join will offer even more breakout sessions led by Looker subject matter experts and top customers. This informative mixture of lectures, demonstrations, and guest speakers is geared towards keeping attendees informed on technical content, customer stories, and new launch announcements. MemSQL is exhibiting in the Sponsor Expo, so stop by our kiosk #2 to view a demo ... Read More

Feed: MemSQL Blog. Author: Gary Orenstein. The Current Organizational Data Dilemma Today, many companies have years of investment in traditional databases from Oracle, SAP, IBM, Microsoft and others. Frequently these databases and data warehouses have long outlived their ability to cost-effectively perform and scale. These solutions also offer mixed options when it comes to cloud deployments. Over the past decade, data-driven organizations looked to new methods such as Hadoop and NoSQL to solve data challenges. Hadoop has proven to be a good place to store data, but a challenging place for production data workflows. Gartner noted at a recent conference ... Read More

Feed: MemSQL Blog. Author: Gary Orenstein. We are enchanted by the possibility of digital disruption. New computing approaches, from cloud to artificial intelligence and machine learning, promise new business models and untold efficiencies. We are closing the gap between science fiction and business operations. A Quick Look Back Let’s take a quick look back at data processing, and then come back to the industry frontier. It started with data and the place to put it, which became the database. Then came a desire to understand the data through analytics, and that spawned the introduction of data warehouses. Data warehouses are ... Read More

Feed: MemSQL Blog. Author: Nicole Nearhood. Kafka Summit San Francisco brings together thousands of companies across the globe that build their businesses on top of Apache Kafka. The developers responsible for this revolution need a place to share their experiences on this journey. This year, Kafka Summit San Francisco will offer even more breakout sessions led by Kafka subject matter experts and top Kafka customers. This informative mixture of lectures, demonstrations, and guest speakers is geared towards keeping attendees informed on technical content, customer stories, and new launch announcements. MemSQL is exhibiting in the Sponsor Expo, so stop by our ... Read More

Feed: MemSQL Blog. Author: Gene Miguel. We regularly host meetups at MemSQL headquarters as a way to share what we have been working on, connect with the community, and get in-person feedback from people like you. We also invite partners and customers to join us as well. Recently, we had the pleasure of hosting a meetup with Zoomdata, where we shared two presentations on real-time streaming, analytics, and visualization using MemSQL and Zoomdata. The first presentation “Streaming in the Enterprise with MemSQL” is presented by MemSQL engineer, Neil Dahlke. Neil builds analytical and operational tools for MemSQL and our customers ... Read More

Feed: MemSQL Blog. Author: Mike Mohler. Data today moves in extremely large volumes at light speed all while requiring high levels of protection on the content. Traditional database and data warehouse technologies are unable to handle these workloads without the need for expensive hardware appliances. The NoSQL and Hadoop-based systems are very complex and unable to support real-time analysis. A new way to process fast-moving, structured content is needed to achieve this level of scale and security. Why not a highly secure and extreme scalable SQL-based approach? Imagine the volume of telemetry data that is required for processing a swarm ... Read More

Feed: MemSQL Blog. Author: Seth Luersen. Experience teaches us that when loading data into a database, in whatever form ― normalized, denormalized, schema-less, hierarchical, key-value, document, etc ― the devil is always in the data load. For enterprise companies in the real-time economy, every second saved means improved efficiency, productivity, and profitability. Thankfully, MemSQL Cloud makes your enterprise data fast to load and easy to access. You can spin up a cluster in MemSQL Cloud in minutes and load data very quickly using MemSQL Pipelines. MemSQL scales out for fast parallel processing of very large data sets. MemSQL Pipelines deliver ... Read More

Feed: MemSQL Blog. Author: Rodrigo Gomes. At MemSQL, we are out to build awesome software and we’re always trying to solve hard problems. A few days ago, I uncovered a cool Linux mystery with some colleagues and fixed it. We thought sharing that experience might benefit others. The scene of the crimeWhile developing an internal tool to get stack traces, we decided to use the SYS_tgkill Linux system call to send signals to specific threads. The tgkill syscall sends a signal to a specific thread based on its “thread group” identifier (tgid) and thread identifier (tid). We store the thread identifier ... Read More

Feed: MemSQL Blog. Author: Carl Sverre. One of the main themes at DockerCon 2017 was the challenge of migrating legacy applications to containers. At MemSQL, we’re early adopters. We are already into our third year of running Docker at scale in production for our distributed software testing regime, where the performance, isolation, and cost benefits of containers are very attractive. The Challenge Before I take you through our journey to containers, let me start by outlining some of the general challenges of testing a distributed database like MemSQL. Our solutions are built for real-time data warehousing. Databases are really difficult ... Read More

Feed: MemSQL Blog. Author: Rodrigo Gomes. At MemSQL, we are out to build awesome software and we’re always trying to solve hard problems. A few days ago, I uncovered a cool Linux mystery with some colleagues and fixed it. We thought sharing that experience might benefit others. The scene of the crimeWhile developing an internal tool to get stack traces, we decided to use the SYS_tgkill Linux system call to send signals to specific threads. The tgkill syscall sends a signal to a specific thread based on its “thread group” identifier (tgid) and thread identifier (tid). We store the thread identifier ... Read More